Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

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


Tr1d3nt

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'

 

[TEP STOP]

 

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'

 

And

 

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!

 

Thanks,

Andy

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...