Page 1 of 2 12 LastLast
Results 1 to 10 of 11
  1. #1
    Join Date
    Jul 2010
    Posts
    33
    Plugin Contributions
    0

    Default Advanced Search Result error 1064 You have an error in your SQL syntax;

    When i search for something i get :

    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 ' cd.categories_description, cd.categories_id, c.parent_id from categories_descr' at line 1
    in:
    [SELECT DISTINCT c.categories_image, cd.categories_name, , cd.categories_description, cd.categories_id, c.parent_id from categories_description cd, categories c where cd.categories_id = c.categories_id and cd.language_id = '2' AND ((cd.categories_name LIKE '%aa%' OR cd.categories_description LIKE '%aa%') ) order by cd.categories_name]


    please help me....
    Last edited by baracudamax; 4 Oct 2010 at 07:57 PM. Reason: spelling

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,828
    Plugin Contributions
    9

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

    How about some additional info??

    http://www.zen-cart.com/forum/faq.php
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Jul 2010
    Posts
    33
    Plugin Contributions
    0

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

    Thank you for fast reply...

    ex. When i use advance search to find a product i get this error...

    see it your self please...

    http://www.e-matrix.gr

  4. #4
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,828
    Plugin Contributions
    9

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

    Still need much of the info outlined in the link
    Zen-Venom Get Bitten

  5. #5
    Join Date
    Jul 2010
    Posts
    33
    Plugin Contributions
    0

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


  6. #6
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,828
    Plugin Contributions
    9

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

    Can't you read?

    You should include answers to all of these questions:

    • What version of Zen Cart?
    • Is it a new install or an upgrade?
    • What the addons/contributions you have installed?
    • What customizations have you made?
    • What type of server are you using?
    • Are you installing locally?


    • What operating system?


    • What version of PHP is installed on the server?
    • What version of MYSQL is installed on the server?
    • What you were doing when your problem occurred?
    • What are the steps to reproduce the problem?
    • Have you attempted to fix the problem?


    • What steps have you taken?


    • Any other details that might be important, i.e. the port number
    Zen-Venom Get Bitten

  7. #7
    Join Date
    Jul 2010
    Posts
    33
    Plugin Contributions
    0

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

    Zen Cart 1.3.8a
    Patch: 1::
    Database Patch Level: 1.3.8
    v1.3.8 [2009-10-12 03:09:25] (Fresh Installation)

    Server OS: Linux 2.6.18-164.15.1.el5
    Database: MySQL 5.0.77
    average: 0.65, 0.35, 0.22
    HTTP Server: Apache/2.2.3 (CentOS)
    PHP Version: 5.1.6 (Zend: 2.1.0)

    installed modules:

    Google Analytics
    Printable Price-list
    Super Tracker
    Hints and Tips
    Fast and Easy Checkout
    Google Map
    Simple SEO URL 3.8.5
    Sitemap XML
    Quick Updates
    Super Orders
    Recover Cart Sales
    Advanced Cross-Sell
    Ty Package Tracker
    Auction Manager
    Simple Popup
    Restock Requests
    Products Gallery
    Add Customer from admin
    flat rate clone
    Recover Cart Sales
    Contest system
    STOCKINHAND Calculator
    Sales Report
    Real Stock Qty
    Poll Manager
    Quick Layout Box Controller
    Change Storage Engine
    Image Handler2
    Orders Export
    BackUp ZenCart
    UN Wishlists
    Click show hide categories
    Advanced search categories
    login box
    dg reviews
    best sellers reloaded
    main page categories

    the 3 last modules installed are:

    simple popup
    ssu 3.8.5 update
    click show hide cadegories

  8. #8
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,828
    Plugin Contributions
    9

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

    Too many addons....

    When did this begin?
    Was there any additions/changes in that time frame?
    What were they?

    What does Change Storage Engine do and what did you change it to?
    Zen-Venom Get Bitten

  9. #9
    Join Date
    Jul 2010
    Posts
    33
    Plugin Contributions
    0

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

    Everything's worked fine until i have installed simple popup , ssu 3.8.5 update and click show hide categories.
    The storage engine changer can mass change storage engine of your database.

    Innodb i'm using.

  10. #10
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,828
    Plugin Contributions
    9

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

    Everything's worked fine until i have installed simple popup , ssu 3.8.5 update and click show hide categories.
    Undo/remove these three
    Check
    Add back one at a time and check
    Zen-Venom Get Bitten

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. v151 PHP Fatal error: 1064:You have an error in your SQL syntax
    By chaptech in forum General Questions
    Replies: 2
    Last Post: 5 Mar 2015, 07:16 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