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

[gilberto d. s. a. <gs...@gm...>]

do you use utf-8 or iso-8859-x . please confirm your translation (.po
files) and .mo files. in pt-br, before revise all translation file, there
are some incorrect code page chars.


2014-04-05 13:39 GMT-03:00 Rafael Chacón <raf...@gm...>:

> 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
>



-- 
gilberto dos santos alves
+55.11.98646-5049
sao paulo - sp - brasil