Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Error when trying to browse categories.


Recommended Posts



On the template I have uploaded to http://www.sub-zeroclothing.co.uk/shop


When clicking on the products such as Camcorders it comes up with 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 = '95'




I have only uploaded the template and not touched anything as yet. Does anyone have any idea what could be causing this and how to fix it please?


Thanks in advance for your help! :)


Link to comment
Share on other sites

Hi Baz


Have you tried looking at this thread


If you still have problems post back including PHP version and OScommerce release that you are using.




My advice is personal and not from my company. Use it at your own risk!



1. Backup before making any changes.

2. Try one thing at a time.

3. Write down all steps you take.

4. Make any changes on a development server/domain before on a live site.


Link to comment
Share on other sites


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

  • Create New...