Thread: SQL error

Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2006
    Posts
    7
    Plugin Contributions
    0

    Default SQL error

    After selecting an item I go to check out and delete the only item in the cart. I get the following error message:
    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]


    V1.35
    PHP 5.03
    MYSQL 4.0.23
    Apache 2.052(win32)

  2. #2
    Join Date
    Jan 2005
    Location
    Tennessee
    Posts
    1,128
    Plugin Contributions
    0

    Default Re: SQL error

    Please post the lines of code.
    Containing this text SQL_SHOW_SHOPPING_CART_EMPTY

    They are at:
    includes\classes\db\mysql\define_queries.php
    and
    includes\templates\template_default\templates\tpl_shopping_cart_default.php
    or
    includes\templates\<your template>\templates\tpl_shopping_cart_default.php

  3. #3
    Join Date
    Dec 2006
    Posts
    7
    Plugin Contributions
    0

    Default Re: SQL error

    Thanks the following code was missing from test setserver 2

    DEFINE('SQL_SHOW_SHOPPING_CART_EMPTY',"select configuration_key, configuration_value from " . TABLE_CONFIGURATION . " where configuration_key RLIKE 'SHOW_SHOPPING_CART_EMPTY' and configuration_value > 0 order by configuration_value");

  4. #4
    Join Date
    Dec 2006
    Posts
    48
    Plugin Contributions
    0

    Default Re: SQL error

    Thanks penandpencils, I too had that line missing although I have no idea why or how!!

    It's working now anyway which is the main thing. Thanks for posting your findings back.

 

 

Similar Threads

  1. v139h DB/SQL Error when using SQL Patch for Add Pages More Info Sidebox addon
    By maperr55 in forum All Other Contributions/Addons
    Replies: 6
    Last Post: 5 Mar 2012, 09:32 PM
  2. Replies: 1
    Last Post: 25 Aug 2011, 05:58 AM
  3. Error message 1064 you have an error in your sql syntax
    By honrheart in forum General Questions
    Replies: 1
    Last Post: 11 Sep 2009, 02:38 AM
  4. MySQL Error 1064 You have an error in your SQL syntax;
    By dmm2020 in forum General Questions
    Replies: 2
    Last Post: 22 Feb 2009, 05:02 AM
  5. error message 1064 you have an error in your sql syntax
    By ngsl in forum General Questions
    Replies: 0
    Last Post: 22 Aug 2008, 06:44 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