patrickbailey1 Posted June 22, 2004 Posted June 22, 2004 1064 - You have an error in your SQL syntax near 'select p.products_image, m.manufacturers_name, pd.products_name, p.products_id,' at line 1 select count(select p.products_image, m.manufacturers_name, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.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\' and p2c.categories_id = \'38\' order by pd.products_name) as total [TEP STOP] Anyone know how to fix this? I searched but it seemed like everyone's was related to a contribution. I've just installed FreeCallForPrice, but the very basic version with just 4 files or so. I have no idea where to look so if you could just point me in the right direction that would be great...i'm assuming that i have some file screwed up. Thanks! Patrick Patrick Bailey www.DisplayHaven.com
patrickbailey1 Posted June 22, 2004 Author Posted June 22, 2004 Please...any help whatsoever!!!!????!?!?!?! Patrick Bailey www.DisplayHaven.com
patrickbailey1 Posted June 22, 2004 Author Posted June 22, 2004 p-p-p-p-p-lease! Patrick Bailey www.DisplayHaven.com
patrickbailey1 Posted June 22, 2004 Author Posted June 22, 2004 Thanks! I checked it out...but that guy is running a newer version of FreeCallForPrice than me...i dont have version 3.0 with patches 1 and 2 installed...just the basic version! Any other ideas? Patrick Bailey www.DisplayHaven.com
patrickbailey1 Posted June 22, 2004 Author Posted June 22, 2004 Nevermind...i just fixed it! Been struggling all night...when the guy said 'latest' he didn't mean earliest, he meant newest! I thought he meant that he used the newest and reverted back to the oldest, which is what i was already using. Thanks so much! Patrick Patrick Bailey www.DisplayHaven.com
Recommended Posts
Archived
This topic is now archived and is closed to further replies.