Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

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


Recommended Posts

Please can someone help me. I have a an old Oscommerce installation and the host has upgraded the mysql and it now no longer works. I have followed the suggestions on the forum to fix it but have not done so successfully.

The error I get is as follows whenever I try to look at any product.

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


select pd.products_name, p.products_model, p.products_image, p.products_id, p.manufacturers_id, p.products_price, p.products_weight, p.products_price1,p.products_price2,p.products_price3,p.products_price4, p.products_price1_qty,p.products_price2_qty,p.products_price3_qty,p.products_pri

ce4_qty, p.products_qty_blocks, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price 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 = '165' and pd.products_id = '165' and pd.language_id = '1'


the site has had a few contributions added and I would hate to have to upgrade to a later version and loose the contributions and also somehow have to reimport the database.


It is at www.coffeebuzz.co.uk


Link to comment
Share on other sites


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

  • Create New...