Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

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


Recommended Posts



I have just installed a fresh version of oscommerce on a new path.


So now i have a version which runs on www.mydomain.com/catalog and one that runs on www.mydomain.com/shop


The install has gone through fine and i have set up a new database for this.


I have also done a back up of my existing data from my 1st shop and imported it via phpmyadmin into my new shop.


The problem that i am having with this is that when i click on a category i receive 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 = '174'



Can anyone suggest what may be the issue here?


Many Thanks


Link to comment
Share on other sites


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

  • Create New...