1054 - Unknown column 'p.products_id' in 'on clause'

[Kimosen]

My host just upgraded to MySQL 5, from what I can gather.

 

I've tried editing all the files I'm supposed to, and running all the queries.

 

I've managed to get the search and catagory display functions running smoothly, but I still come up with this error every time I try to view a product or add it to the cart:

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select pd.products_name, p.products_model, p.products_image, p.products_id, p.manufacturers_id, p.products_price, p.products_weight, p.products_price1,p.products_price2,p.products_price3,p.products_price4, p.products_price5,p.products_price6,p.products_price7,p.products_price8, p.products_price1_qty,p.products_price2_qty,p.products_price3_qty,p.products_pri

ce4_qty, p.products_price5_qty,p.products_price6_qty,p.products_price7_qty,p.products_pri

ce8_qty, p.products_qty_blocks, 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 = '83' and pd.products_id = '83' and pd.language_id = '1'

 

I'm not sure what I need to change or where to get this to go away. I've got the "Quantity price breaks" mod installed, if you're wondering about the extra code in there.

 

Any help would be greatly appreciated.