Mysql syntax error

**NeoBlack** · 3 Oct 2006, 10:53 AM

I getting the error when after confirming the order

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 = '81'' at line 1
in:
[update products set products_ordered = products_ordered + 1,000000 where products_id = '81']

what can i do?

**Kim** · 3 Oct 2006, 02:14 PM

Have you made a change to the code?

**NeoBlack** · 3 Oct 2006, 02:18 PM

no i just changed the characyer set to romanian. if a changed back then worked but then comes another problem. The month names switches back to english.... Example: Octombrie for October

**BlindSide** · 3 Oct 2006, 03:59 PM

It's the comma in your number. You need to get rid of it in this section of your SQL statement:

Code:

products_ordered + 1,000000

Check out the number formatting in your language files and see what it's doing in the code where this SQL executes.

**DrByte** · 3 Oct 2006, 10:34 PM

in the orders class, around line 711, you have this:

Code:

      $db->Execute("update " . TABLE_PRODUCTS . " set products_ordered = products_ordered + " . sprintf('%f', $this->products[$i]['qty']) . " where products_id = '" . zen_get_prid($this->products[$i]['id']) . "'");

It would seem that the %f specifier is adding the comma in the 6th position, based on your locale settings.

What are your locale settings?

**NeoBlack** · 4 Oct 2006, 07:30 AM

i replaced the code at the bestseller in the order.php and works fine. i replaced the , to .

$db->Execute("update " . TABLE_PRODUCTS . " set products_ordered = products_ordered + " . str_replace(',','.',sprintf('%f', $this->products[$i]['qty']) ). " where products_id = '" . zen_get_prid($this->products[$i]['id']) . "'");

Thanks for replies