Menu
▾
▴
Re: [Web-erp-users] error with 0.2.0, missing SalesOrderDetails.frm
|
From: Keith B. <km...@km...> - 2003-08-22 03:04:35
|
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 |
