Error 1064 on MySQL in catalog

[Guest]

Hi there,

 

I got this error in the products page, when i try to enter the details section. The error appeared from nowhere, from one day to another without me entering to change something in the site. Please help me .. i don't understand mysql and people who i've talked about said they don't know anything about it. Please help!

 

The error is:

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 'p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id =' at line 1

 

select count(p.products_id) as total 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.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 = '132'

 

and it's located here: http://www.buyiq.com/index.php?cPath=128_132

 

 

Thank you!

[♥geoffreywalton]

Has you server just been upgraded to use mysql5?

 

If so the patches required can be found below in the link to the solution to loads of problems below.