Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

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


Recommended Posts

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



Evertime I click on a product, some of them come up and some of them dont? On the products that come up everything works fine...

I have never had this problem. can you help?

Here is the full 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 = '488'




I can't seem to fix it? is it with my database? if it is then how come some of my products come up

and other dont?

Link to comment
Share on other sites


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

  • Create New...