Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

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


Firefly7071

Recommended Posts

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!! :)

Link to comment
Share on other sites

Might be a good idea to apply all the patches

 

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

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...