julinhu00 Posted January 16, 2009 Share Posted January 16, 2009 Hi, I'm troubled when I search for product in my store. the search does not find anything, and sometimes the error .. can someone help me? www.megasom.com.br 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 '(pd.products_name = 'ADVANCED_SEARCH_DEFAULT_OPERATOR' or p.prod select count(distinct p.products_id) as total 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_status = '1' and p.products_id = pd.products_id and pd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name = 'fds' or p.products_model = 'fds' or m.manufacturers_name = 'fds')(pd.products_name = 'ADVANCED_SEARCH_DEFAULT_OPERATOR' or p.products_model = 'ADVANCED_SEARCH_DEFAULT_OPERATOR' or m.manufacturers_name = 'ADVANCED_SEARCH_DEFAULT_OPERATOR')(pd.products_name = 'fdfsd' or p.products_model = 'fdfsd' or m.manufacturers_name = 'fdfsd') ) [TEP STOP] Link to comment Share on other sites More sharing options...
julinhu00 Posted January 16, 2009 Author Share Posted January 16, 2009 ... Link to comment Share on other sites More sharing options...
julinhu00 Posted January 17, 2009 Author Share Posted January 17, 2009 help me... please Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted January 17, 2009 Share Posted January 17, 2009 When you install the advanced search contribution you do not appear to have run the sql. Reread the installation instructions and ensure you followed all the steps. Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
Terry Mitchell Posted March 9, 2009 Share Posted March 9, 2009 When you install the advanced search contribution you do not appear to have run the sql. Reread the installation instructions and ensure you followed all the steps. Hi I seem to be having the same problem. Advanced search came with my version of oscommerce and therefore didn´t require installing or the running of any sql. Is there anyone out there who can give a little ore info on this error message please?? Many thanks in advance Terry 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.