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

[gilberto d. s. a. <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
>>>
>>
>>
>>
>> --
>> 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
>>
>>
>
>
> ------------------------------------------------------------------------------
>
> _______________________________________________
> 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