Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

SQL Errors: 1054 - Unknown column 'p.products_id' in 'on clause'


Recommended Posts

Hello all,


First of all - appologies if this is the incorrect forum.


I've been working on this problem for the majority of today and had 3 SQL developers take a look at it quickly and no-one can figure out why this is happening and a solution to the problem, The 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 = '32'




I've ran a couple of queries on the database and they keep returning:


MySQL said: Documentation

#1054 - Unknown column 'products.products_id' in 'on clause'




MySQL said: Documentation

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



Does anyone have any clue or a fix or that can throw together a piece of script that i can enter into the Database or whether it's a fix on the PHP side, i'm just becoming really very tired now and if i can't solve this... Then maybe more will be on the line than just a website :'(


Website: http://www.firsttradelimited.com/future


The error occurs when you click any of the categories, Click: http://firsttradelimited.com/future/specials.php or use the search engine so it would be, as a guess, a problem at the base somewhere!


Sorry for the wall of text!

Hope someone out there can help me!




Link to comment
Share on other sites


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

  • Create New...