error 1054

[stasmmr]

My server has just updated our database and all is a mess. I keep getting this error on my products pages. please help ready to delete all and start agaim!!!

 

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 = '26'

 

 

 

thanks

 

stasmmr

[nat8100]

Has your sever updated to SQL 5.0? If you download the latest version of osCommerce and look at the updates document I think it lists the changes to make for SQL 5.0 compatibility.

 

My server has just updated our database and all is a mess. I keep getting this error on my products pages. please help ready to delete all and start agaim!!!

 

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 = '26'

thanks

 

stasmmr

[stasmmr]

Thanks for that,

I have tried and when i upload pages i end up with a blank web site nothing there. Anymore suggestions anyone?

 

 

Thanks stasmmr

[spax]

Try this:

 

http://www.oscommerce.com/community/bugs,3171/status,open