From: Rafael C. <raf...@gm...> - 2014-04-05 16:39:27
|
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, |