shayrgob Posted February 17, 2010 Share Posted February 17, 2010 I installed the Year, Make, Model contribution to my site and when I put in the years (e.g. 2001-2005) for a particular product the site gives me an error. IT happens after I update the product and go to the main page. Here is the 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 ') and p.products_id = p2c.products_id and p.products_status = '1' and p2c.categ' at line 1 select count(*) as total from products p, products_to_categories p2c where p.products_id in () and p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '21' My site is http://www.importwerks.com I have no clue when it comes to mysql so any help is appreciated! thanks! Link to comment Share on other sites More sharing options...
Jan Zonjee Posted February 17, 2010 Share Posted February 17, 2010 I have no clue when it comes to mysql so any help is appreciated! The problem is that there is nothing in between those brackets p.products_id in () Normally, this is a comma separated list of integers like (1, 4, 7, 8). Since this error is specific to that contribution nothing much can be said about it. Link to comment Share on other sites More sharing options...
shayrgob Posted February 18, 2010 Author Share Posted February 18, 2010 Thanks! I found out that it was a browser issue! I switched to Opera and it's fine now! lol Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.