Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2005
    Posts
    4
    Plugin Contributions
    0

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

  2. #2
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default 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
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #3
    Join Date
    Mar 2005
    Posts
    4
    Plugin Contributions
    0

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

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

 

 

Similar Threads

  1. v151 1064 - syntax to use near '*) as total FROM zen_products
    By devyani in forum General Questions
    Replies: 14
    Last Post: 18 Aug 2014, 02:27 PM
  2. Replies: 1
    Last Post: 2 Dec 2011, 07:22 AM
  3. Replies: 1
    Last Post: 25 Aug 2011, 05:58 AM
  4. Replies: 8
    Last Post: 28 Jun 2011, 08:42 AM
  5. Replies: 0
    Last Post: 13 Aug 2010, 06:24 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR