Getting error when I go to catagories or products from catalog side

[Redeye_Joe]

--------------------------------------------------------------------------------

All of a sudden I am getting this error when I try to go to any of my pages in my catalog;
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_retail_prices 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 = '25'

[TEP STOP]

It is happening on multiple sites, so I think it may have to do with my server but I can figure out why, any help would greatly be appreciated.
D

[met00]

if it's on existing stores you have a problem. p.products_id is the auto increment key used to access the products in the product table (and the join key used on products to manufacturers table and products description table). Use a tool to look at the mysql database and see that they field exists in the table, then look to see if the table is corrupted in some way and try to repair it if the key filed exists or the tool shows the table is corrupted.

[michael_s]

Ask your host if they just upgraded mysql. Common issue with mysql 5, as it changes the correct syntax for queries.