Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2009
    Posts
    157
    Plugin Contributions
    0

    Default MySQL Error 1064 You have an error in your SQL syntax;

    I am now getting the following error when I test my web pages and don't understand where the error is or how to fix it. This occurs when a user clicks on the music genre and then on the index "begins with". Can anyone please point me to the right direction to fix this?

    -----Cut and paste of error message-----
    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 ' dmm_product_music_extra pme on pme.music_genre_id = m.music_genre_id, dmm_produ' at line 2
    in:
    [select p.products_id, p.products_type, p.master_categories_id, m.music_genre_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status = 1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from dmm_products_description pd, dmm_products p left join dmm_music_genre m, dmm_product_music_extra pme on pme.music_genre_id = m.music_genre_id, dmm_products_to_categories p2c left join dmm_specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1']

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

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

    Try checking the similar posts at the bottom of this thread
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Feb 2009
    Posts
    157
    Plugin Contributions
    0

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

    I thnk it had to do with some data corruption in the SQL database. I reloaded my backup and it went away and then I looked at the CSV file I was trying to upload and cleaned up some garbage I found. This happend when I trised to use Easy Populate to upload music items to groups set to use the music data types. Easy Populate does not appear to work for that.

 

 

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. PHP Fatal error: 1064:You have an error in your SQL syntax
    By uswebworx in forum General Questions
    Replies: 11
    Last Post: 19 Apr 2012, 09:17 AM
  3. Replies: 1
    Last Post: 25 Aug 2011, 05:58 AM
  4. 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
  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