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

[Pak R. <pak...@gm...>]

Thanks! Now it works OK.

Regards,
Ricard


2014-08-30 6:30 GMT+08:00 Phil Daintree <ph...@lo...>:

>  I think I've cracked it.
> Thanks for reporting Ricard :-)
>
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890http://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 lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
> ------------------------------------------------------------------------------
> 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
>
>