Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2009
    Posts
    2,123
    Plugin Contributions
    0

    Default 1064 You have an error in your SQL syntax;

    This is weird, when I search for things on my site search bar within apostrophes, for example:

    'low rise'

    I get this error:

    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 'low'&inc_subcat=0&sort=20a', exit_page_name='Advanced Search', num_clicks=num_cl' at line 1
    in:
    [UPDATE supertracker SET last_click = NOW(), exit_page='/index.php?main_page=advanced_search&search_in_description=1&keyword='low'&inc_su bcat=0&sort=20a', exit_page_name='Advanced Search', num_clicks=num_clicks+1, added_cart='false', categories_viewed='b:0;', products_viewed='*265?*453?*131?*157?', customer_id='0', completed_purchase='false', cart_contents='', cart_total = '0', order_id = '0' WHERE tracking_id='20976']


    Anyone got any idea why it does this or how to cure it?

  2. #2
    Join Date
    Jun 2005
    Location
    Cumbria, UK
    Posts
    10,262
    Plugin Contributions
    3

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

    In a standard install of ZC, if you were to search for 'sugar', for example, the search will work and ZC will automatically put slashes in front of the '.

    The returned search will show: \'sugar\'.

    It looks like one of your mods is interfering with this function. Your error says something about supertracker.

    Is this a SEO mod?

    If so, consider getting rid of it as it's no longer that important to use such SEO mods on dynamic content sites.
    19 years a Zencart User

  3. #3
    Join Date
    Jan 2009
    Posts
    2,123
    Plugin Contributions
    0

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

    Supertracker isn't a SEO mod... I don't use those... it's a brilliant mod for keeping track of site traffic.. I'd hate to have to ditch Supertracker.

    Are there any clues in the error above as to how I could modify the mod files so that it behaves the same way ZC does and inserts the // either side of the search?

  4. #4
    Join Date
    Jun 2005
    Location
    Cumbria, UK
    Posts
    10,262
    Plugin Contributions
    3

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

    Try getting in touch with the author of supertracker.
    19 years a Zencart User

  5. #5
    Join Date
    Aug 2006
    Location
    UK
    Posts
    449
    Plugin Contributions
    0

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

    In the forum thread for the supertracker mod, there is somethings about apostrophes and I beleive there is an alteration to the supertracker mod that may help...
    ~Steve~

  6. #6
    Join Date
    Jan 2009
    Posts
    2,123
    Plugin Contributions
    0

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

    Quote Originally Posted by s_t_e_v_e View Post
    In the forum thread for the supertracker mod, there is somethings about apostrophes and I beleive there is an alteration to the supertracker mod that may help...
    Hi Steve, thanks for the info.. I had a look earlier for a Supertracker support thread.... I couldn't find one but I'll take another look...

  7. #7
    Join Date
    Jan 2009
    Posts
    2,123
    Plugin Contributions
    0

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

    Quote Originally Posted by s_t_e_v_e View Post
    In the forum thread for the supertracker mod, there is somethings about apostrophes and I beleive there is an alteration to the supertracker mod that may help...
    Yes, you're right... there is a patch in the thread above that addresses a few little bugs so it's all fixed now.... Thanks Steve :-)

 

 

Similar Threads

  1. 1064 - You have an error in your SQL syntax
    By jason.b in forum Templates, Stylesheets, Page Layout
    Replies: 3
    Last Post: 27 Aug 2012, 05:50 PM
  2. 1064 You have an error in your SQL syntax
    By jencdesigns in forum General Questions
    Replies: 0
    Last Post: 23 Sep 2010, 01:46 AM
  3. 1064 You have an error in your SQL syntax;
    By ndr2010 in forum General Questions
    Replies: 10
    Last Post: 19 Apr 2010, 08:36 PM
  4. 1064 You have an error in your SQL syntax
    By techie in forum Basic Configuration
    Replies: 1
    Last Post: 13 May 2006, 03:53 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