Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

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


Recommended Posts

I was got this error for a few days ago:


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




The error was occored whne i click on the category menu on index page.


And i was read the resoleve of this error on this very useful forum. But i don't do following their idea.

I just install the oscommerce store in differrent folder (on my server). For example, the existing of my store is www.a.com/shop1 , and the new store folder is www.a.com/shop2 . Then i was copy an index.php and stylesheet.css from shop2, then put them into the shop1 catalog.

After i put them, my store (www.a.com/shop1) was work properly.

Link to comment
Share on other sites


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

  • Create New...