When placing an order, the following error appears:
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 '000000 where products_id = '1'' at line 1
in:
[update zen_products set products_ordered = products_ordered + 1,000000 where products_id = '1']
Solution:
Edit the language-file for your active language. For "english", it's english.php
You'll see a line that says:
@setlocale(LC_ALL, '<something-here>');
The problem is on LC_ALL
Change it to LC_TIME instead. Example for portuguese:
@setlocale(LC_TIME, 'pt_PT.ISO8859-15');
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 '000000 where products_id = '1'' at line 1 in: [update zen_products set products_ordered = products_ordered + 1,000000 where products_id = '1']
- 0 Users Found This Useful
