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

[guguedada]

I THERE! I have paid to a guy to put my store with oscommerce, but he have disapear, so i don´t know what to do.... my problem have start yesterday, i have a store of informatic products and now is giving me this:

 

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

 

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.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 = '4' and p2c.categories_id = '195'

 

 

 

 

My store is www.prinfor.com.pt, and when i go to the sub-categories it appears that, so please really, eally anyone help me please, i don´t understand very much in another posts what to do... so can anyone make the explanation with calm for me to understand?

 

Thanks a lot, Paulo from Portugal

[♥geoffreywalton]

This is a typical error that occurs when a site developed using earlier versions of mysql are transferred onto servers running later versions (v5).

 

Follow the link in my signature block "Solutions to loads of common problems." and apply the patches for "MySQL 5.0 Compatibility"