Re: [WebERP-developers] Error 1064 on WorkOrderEntry.php

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

I think I've cracked it.
Thanks for reporting Ricard :-)

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 29/08/14 18:57, Pak Ricard wrote:
> Hi all:
>
> I've got this error when trying to add a non-existing stockid to a 
> work order.
>
> *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 '-20' at line 11
> *Database SQL Failure* : The SQL used to get the part selection was
> SELECT stockmaster.stockid, stockmaster.description, stockmaster.units 
> FROM stockmaster INNER JOIN stockcategory ON 
> stockmaster.categoryid=stockcategory.categoryid WHERE 
> (stockcategory.stocktype='F' OR stockcategory.stocktype='M') AND 
> stockmaster.stockid LIKE '%2341234%' AND stockmaster.discontinued=0 
> AND mbflag='M' ORDER BY stockmaster.stockid LIMIT 20 OFFSET -20
>
> To reproduce it : In WorkOrderEntry, just type in a funny stockid 
> which does not exists and this error shows up.
>
> Am I the first one to get it?
>
> Seems like the problem comes from the OFFSET -20. Why is it assigning 
> a negative value? Why it does work if the stockid exists, and script 
> works OK?
>
> Any help will be welcomed ;-)
>
> Regards,
> Ricard
>
>
> ------------------------------------------------------------------------------
> Slashdot TV.
> Video for Nerds.  Stuff that matters.
> http://tv.slashdot.org/
>
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers