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

[Firefly7071]

Thanks for any advice. :)

 

Two weeks ago my web hosting company upgraded their platform, so my oscommerce is having issues now.

 

I am trying to fix an online store, but on some of the products, I get the following error:

 

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 = '1' and p2c.categories_id = '32'

 

What do I need to change, and in what files? There are so many. Thanks everyone!! :)

[Firefly7071]

I think I found the fix on this thread. thanks!! :)

 

http://www.oscommerce.com/forums/index.php?sho...+unknown+column

[♥geoffreywalton]

Might be a good idea to apply all the patches

 

http://www.oscommerce.com/ext/update-20060817.txt