• 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']

    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');
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR