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

[Rafael C. <raf...@gm...>]

Hi, Gilberto:

I use utf-8 as usual. In which files there are some incorrect code page
chars?

Best regards, Rafael.




2014-04-05 12:10 GMT-06:00 gilberto dos santos alves <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
>
>
>
>
>
>
> ------------------------------------------------------------------------------
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>