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

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

Hi Gilberto,

I am not sure if this is related with the SELECT Error in Stocks.php and
StockClone.php. I am going to review the Spanish and French .po files.

Best regards, Rafael.


2014-04-05 12:25 GMT-06:00 gilberto dos santos alves <gs...@gm...>:

> please visuali confirme your .po for see characters that not have
> representative visual char, correct them and after that compile .mo and and
> make your tests.
>
>
> 2014-04-05 15:22 GMT-03:00 Rafael Chacón <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
>>>>
>>>
>>>
>>>