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
01-18-2012, 06:06 PM,
#2
RE: Error in StockCheck.php (v 4.06.6)
I don't think this is correct in sql: AND AND

Klaus
Reply
01-19-2012, 06:02 AM,
#3
RE: Error in StockCheck.php (v 4.06.6)
I've fixed this ... not committed to svn yet ... will do later today
Thanks Ricard
Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Reply
01-19-2012, 06:03 AM,
#4
RE: Error in StockCheck.php (v 4.06.6)
NB. Stock check does not work with serialised stocks...
Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Reply
01-19-2012, 09:09 AM,
#5
RE: Error in StockCheck.php (v 4.06.6)
Thanks Phil. Will test it and come back if any issue.
Regards,
Pak Ricard
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)