ursulab2 Posted February 17, 2004 Posted February 17, 2004 I installed the module Shop by Price on my site. Everything seemed to work find until I installed another module. Now I get this 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 '' at line 1 select count(p.products_id) as total from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id where p.products_status = '1' and Anyone have any ideas? Installed Modules: Paypal IPN, Site Map, Header Tags Controller, Advance Search, Login box, Purchase without Account, Support Ticket, OSC Affiliate, Testimonials, Guestbook , Printable Catalog, Shall I keep going? I LOVE OS!
ursulab2 Posted February 18, 2004 Author Posted February 18, 2004 Honestly, I have NO clue! I've installed so many mods it's hard to tell. Otherwise I would have just tried to narrow it down that way. :( Installed Modules: Paypal IPN, Site Map, Header Tags Controller, Advance Search, Login box, Purchase without Account, Support Ticket, OSC Affiliate, Testimonials, Guestbook , Printable Catalog, Shall I keep going? I LOVE OS!
Recommended Posts
Archived
This topic is now archived and is closed to further replies.