Re: [WebERP-developers] Stocks.php, StockClone.php: Error in SELECT

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

In Stocks.php - line 23

$ItemDescriptionLanguages = 
explode(',',$_SESSION['ItemDescriptionLanguages']);

So in SystemParameters.php - we set a 
confname='ItemDescriptionLanguages' to a comma separated list of locales 
that we wish to maintain language descriptions for our items.

Perhaps your configuration has been messed up and this config option not 
set for some reason.

Regards

Phil

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

On 06/04/14 04:39, Rafael Chacón wrote:
> Dear All:
>
> In Stocks.php and in StockClone.php, I got this error when I edit
> (Stocks.php) or clone (StockClone.php) a stock item, after I click the
> "Update" / "Insert New Item"  button (Stocks.php / StockClone.php):
>
> Database Error 1064 :
> 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 'AN)' at line 1
> Database SQL Failure : The SQL that failed was
> SELECT descriptiontranslation, language_id FROM
> stockdescriptiontranslations WHERE stockid='2000000300030' AN)
>
> The company has 3 languages (Spanish -default-) and
> ItemDescriptionLanguages = "en_US.utf8,fr_FR.utf8,".
>
> When I re-setup ItemDescriptionLanguages, I works,but in a second
> query the problem reappears.
>
> I think the problem is that the variable ItemDescriptionLanguages deletes.
>
> Any ideas to where to look for?
>
> Best regards,
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>