Forums / General Questions / SQL Syntax error: check for right syntax to use near '000000

SQL Syntax error: check for right syntax to use near '000000

Locked

Results 1 to 3 of 3

This thread is locked. New replies are disabled.

9 Feb 2008, 7:05 PM

gabyone

New Zenner

Join Date:: Mar 2005
Posts:: 4
Plugin Contributions:: 0

SQL Syntax error: check for right syntax to use near '000000

I have this error and I don't know why? This appear when I am at step 3 'Review order' and I click 'Confirm 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 = '2'' at line 1
in:
[update products set products_ordered = products_ordered + 6,000000 where products_id = '2']

9 Feb 2008, 7:09 PM

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,513
Plugin Contributions:: 177

Re: SQL Syntax error: check for right syntax to use near '000000

This appears to be the same issue:
http://www.zen-cart.com/forum/showthread.php?t=83220

9 Feb 2008, 7:23 PM

gabyone

New Zenner

Join Date:: Mar 2005
Posts:: 4
Plugin Contributions:: 0

Re: SQL Syntax error: check for right syntax to use near '000000

Man, how quick you are.........I am impresed. Thank you!