Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Search Box Problem


Recommended Posts



I was working with my website today and tried to search for something-just to make sure it worked-and it didn't. I am getting this 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 'from products p left join manufacturers m using(manufacturers_id) left join spec' at line 1


from products p left join manufacturers m using(manufacturers_id) left join specials s on p.products_id = s.products_id, products_description pd, categories c, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%adenium%' or p.products_model like '%adenium%' or m.manufacturers_name like '%adenium%') ) order by pd.products_name limit 0, 20




I am going to leave the search box on the website if anyone wants to look at it. It has the same message if you use the normal or the advanced search. I am not very good at this and didn't find anything on the forums. If nothing else, I need to know what .php file is having problems and possibly get an original version of the .php to change my search back. If anyone can help it would be greatly appreciated. If any other info is needed let me know and I'll get it to you as soon as I can. Thanks




Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...