Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2006
    Posts
    9
    Plugin Contributions
    0

    Default 1064 You have an error in your SQL syntax when deleting from shopping cart

    Hi there,

    Please can you assist, I get the following error when trying to delete a product out of the shopping cart.

    Zen Cart 1.3.7 on a linux server, php 4.4.4

    Your Shopping Cart is empty.
    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 'SQL_SHOW_SHOPPING_CART_EMPTY' at line 1
    in:
    [SQL_SHOW_SHOPPING_CART_EMPTY]
    Thanks so much!

  2. #2
    Join Date
    Jan 2004
    Posts
    66,350
    Blog Entries
    7
    Plugin Contributions
    271

    Default Re: 1064 You have an error in your SQL syntax

    It appears that you are missing a file, or it failed to upload completely:
    You should re-upload this file:

    /includes/classes/db/mysql/define_queries.php
    .

    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
    Jul 2006
    Posts
    9
    Plugin Contributions
    0

    Default Re: 1064 You have an error in your SQL syntax

    The file was there, I deleted it and reuploaded it and it works now.
    Thanks so much

 

 

Similar Threads

  1. Replies: 1
    Last Post: 30 Jun 2010, 07:52 PM
  2. Replies: 2
    Last Post: 4 Jun 2010, 07:01 AM
  3. Replies: 7
    Last Post: 23 Jul 2009, 06:53 AM
  4. 1064 You have an error in your SQL syntax
    By phastings in forum General Questions
    Replies: 1
    Last Post: 18 Dec 2008, 06:12 AM
  5. Replies: 3
    Last Post: 21 Sep 2008, 12:45 AM

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