Will I need to completely re-install?

[Guest]

I have suddenly a major problem developed with my installation of oscommerce.

I have had our shop up and running perfectly for a year at http://www.amandasicingonthecake.com/

Suddenly after adding new stock when a user displays the main categories we get this error message:

 

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

 

[TEP STOP]

 

I have replaced all the main files from backup to no avail. The database looks OK but there is obviously a major error somewhere. New products works fine!

 

I am at a loss as to how this can have happened. Can anybody give me some advice as to how to proceed. Will I need a complete re-installation or can I save the situation?

[Hotclutch]

I have suddenly a major problem developed with my installation of oscommerce.

I have had our shop up and running perfectly for a year at http://www.amandasicingonthecake.com/

Suddenly after adding new stock when a user displays the main categories we get this error message:

 

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

 

[TEP STOP]

 

I have replaced all the main files from backup to no avail. The database looks OK but there is obviously a major error somewhere. New products works fine!

 

I am at a loss as to how this can have happened. Can anybody give me some advice as to how to proceed. Will I need a complete re-installation or can I save the situation?

 

Put this into Google, then you will get an idea of what needs to done:

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

[Guest]

Put this into Google, then you will get an idea of what needs to done:

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

[Guest]

Thanks I found what I needed and the problem is now solved.