Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Error in StockCheck.php (v 4.06.6)
01-18-2012, 02:59 PM, (This post was last modified: 01-18-2012, 05:25 PM by PakRicard.)
#1
Error in StockCheck.php (v 4.06.6)
Hi:

Testing webERP 4.06.6 found the following error at StockCheck.php:

ERROR Message Report : The demand for this product from cannot be retrieved because - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND stockmaster.mbflag='A'' at line 11

The SQL that failed was SELECT SUM((salesorderdetails.quantity-salesorderdetails.qtyinvoiced)*bom.quantity) AS dem FROM salesorderdetails INNER JOIN salesorders ON salesorders.orderno = salesorderdetails.orderno INNER JOIN bom ON salesorderdetails.stkcode=bom.parent INNER JOIN stockmaster ON stockmaster.stockid=bom.parent WHERE salesorders.fromstkloc='TOKUB' AND salesorderdetails.quantity-salesorderdetails.qtyinvoiced > 0 AND bom.component='ACCF01-BB' AND AND stockmaster.mbflag='A'

Probably a " or ' issue building the SQL sentence.

Line 11 of this file shows a different thing :-(

Probably this error was there before 4.06.6 (not sure), as it's the first time we tried to use the stock check options.
Regards,
Pak Ricard
Reply


Messages In This Thread
Error in StockCheck.php (v 4.06.6) - by PakRicard - 01-18-2012, 02:59 PM
RE: Error in StockCheck.php (v 4.06.6) - by opto - 01-18-2012, 06:06 PM
RE: Error in StockCheck.php (v 4.06.6) - by phil - 01-19-2012, 06:02 AM
RE: Error in StockCheck.php (v 4.06.6) - by phil - 01-19-2012, 06:03 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)