Hi Chris -
I'm running Debian Linux version 3, kernel 2.2.20, MySQL version 3.23.49,
Apache 1.3, php 4.3.2.
You are right, the error 13 is typically a permissions problem. I beleive
the permission problem here is that the file "/weberp/SalesOrderDetails.frm"
doesn't seem to be in the distro. It seems to work OK on your test website.
Please show me I'm wrong.
Keith.
On Wednesday 20 August 2003 06:28 am, Chris Bice wrote:
> Normally error 13 is a permissions Problem within MySQL.
>
> root@chris root]# perror 13
> Error code 13: Permission denied
>
> Are you running it on Linux, or on Windows??
>
> Thanks
>
> Chris
> Return-Path: <web...@li...>
> Received: from sc8-sf-list2.sourceforge.net (lists.sourceforge.net
> [66.35.250.206]) by apoc.megavolt.com (8.12.5/8.12.5) with ESMTP id
> h7K1noWE027553 for <cb...@me...>; Tue, 19 Aug 2003 20:49:50 -0500
> Received: from sc8-sf-list1-b.sourceforge.net ([10.3.1.13]
> helo=sc8-sf-list1.sourceforge.net) by sc8-sf-list2.sourceforge.net with
> esmtp (Exim 3.31-VA-mm2 #1 (Debian)) id 19pHvl-0006sv-00; Tue, 19 Aug 2003
> 18:38:33 -0700
> Received: from bdsl.66.13.146.162.gte.net ([66.13.146.162] helo=km-orb
> ident=mail) by sc8-sf-list1.sourceforge.net with esmtp (Exim 3.31-VA-mm2 #1
> (Debian)) id 19pEml-0006Df-00 for <web...@li...>;
> Tue, 19 Aug 2003 15:17:03 -0700
> Received: from localhost ([127.0.0.1] helo=there ident=kmb) by km-orb with
> smtp (Exim 3.35 #1 (Debian)) id 19pEmG-00065r-00 for
> <web...@li...>; Tue, 19 Aug 2003 15:16:32 -0700
> Content-Type: text/plain; charset="iso-8859-1"
> From: Keith Brown <km...@km...>
> To: web...@li...
> X-Mailer: KMail [version 1.3.2]
> MIME-Version: 1.0
> Message-Id: <E19pEmG-00065r-00@km-orb>
> Subject: [Web-erp-users] error with 0.2.0, missing SalesOrderDetails.frm
> Sender: web...@li...
> Errors-To: web...@li...
> X-BeenThere: web...@li...
> X-Mailman-Version: 2.0.9-sf.net
> Precedence: bulk
> List-Help: <mailto:web...@li...?subject=help>
> List-Post: <mailto:web...@li...>
> List-Subscribe:
> <https://lists.sourceforge.net/lists/listinfo/web-erp-users>,
> <mailto:web...@li...?subject=subscribe>
> List-Id: For the general discussion of web-erp project
> <web-erp-users.lists.sourceforge.net>
> List-Unsubscribe:
> <https://lists.sourceforge.net/lists/listinfo/web-erp-users>,
> <mailto:web...@li...?subject=unsubscribe>
> List-Archive:
> <http://sourceforge.net/mailarchive/forum.php?forum=web-erp-users>
> Date: Tue, 19 Aug 2003 15:16:32 -0700
> Content-Transfer-Encoding: 7bit
> > Hi -
>
> I've been playing with this system on my home machine, actively looking for
> a replacement for our aging ERP system (Symix's SyteLine) for the place in
> which I work. I was entering some parts information today when I ran into
> this error message:
>
> The SQL to find the parts selected failed with the message: Can't find
> file: './weberp/SalesOrderDetails.frm' (errno: 13) The SQL statement was:
> SELECT StockMaster.StockID, StockMaster.Description, StockMaster.Units,
> Sum(SalesOrderDetails.Quantity- SalesOrderDetails.QtyInvoiced) AS Demand,
> Sum(LocStock.Quantity) AS TotalOnHand FROM StockMaster, LocStock LEFT JOIN
> SalesOrderDetails ON StockMaster.StockID=SalesOrderDetails.StkCode WHERE
> (SalesOrderDetails.Completed is NULL OR SalesOrderDetails.Completed=0) AND
> StockMaster.StockID = LocStock.StockID AND StockMaster.Description LIKE
> '%63-1218-63%' AND (StockMaster.MBflag='M' OR StockMaster.MBflag='K' OR
> StockMaster.MBflag='A') GROUP BY StockMaster.StockID,
> StockMaster.Description, StockMaster.Units ORDER BY StockMaster.StockID
>
> I got there by Manufacturing -> Bills of Material Maintance.
>
> I don't see the missing file " SalesOrderDetails.frm" anywhere on my system
> nor do I see it in the tar file I downloaded (version 0.2.0). Any ideas?
>
> Thanks in advance,
> Keith.
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by Dice.com.
> Did you know that Dice has over 25,000 tech jobs available today? From
> careers in IT to Engineering to Tech Sales, Dice has tech jobs from the
> best hiring companies. http://www.dice.com/index.epl?rel_code=104
> _______________________________________________
> Web-erp-users mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
|
