Database Error 1064 in PO_Items.php
I receive the following error when searching for an item by description, while creating a purchase order in PO_Items.php:
Database Error 1064 : There is a problem selecting the part records to display 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 '50 OFFSET 0' at line 16
Database SQL Failure : The SQL statement that failed was
SELECT stockmaster.stockid, stockmaster.description, stockmaster.units FROM stockmaster INNER JOIN stockcategory ON stockmaster.categoryid=stockcategory.categoryid INNER JOIN purchdata ON stockmaster.stockid=purchdata.stockid WHERE (stockmaster.mbflag<>'D' OR stockcategory.stocktype='L') AND stockmaster.mbflag<>'K' AND stockmaster.mbflag<>'A' AND stockmaster.mbflag<>'G' AND stockmaster.discontinued<>1 AND purchdata.supplierno='ALB01' AND stockmaster.description LIKE '%spring%' GROUP BY stockmaster.stockid ORDER BY stockmaster.stockidLIMIT 50 OFFSET 0
I am running webERP 4.13.1, with PO_Items.php version 4183 (standard).
PHP 5.6.30
MySQL Community Server (GPL) 5.5.54
Apache/2.4.23 (Unix)
Searching for an item by description in SelectProducts.php is successful and does not produce the same symptom.
Any ideas on what could be causing this?
Thanks in advance.
Andy.
https://www.linkedin.com/in/andrewcouling
|