Re: [Web-erp-users] error with 0.2.0, missing SalesOrderDetails.frm

[Phil D. <ph...@du...>]

Hi Keith,

Will look at this and come back tomorrow. Thanks for reporting it.

Phil
----- Original Message -----
From: "Keith Brown" <km...@km...>
To: <web...@li...>
Sent: Wednesday, August 20, 2003 10:16 AM
Subject: [Web-erp-users] error with 0.2.0, missing SalesOrderDetails.frm


>
>
> 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
>