Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

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


trubuy

Recommended Posts

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

 

Help-

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'

 

[TEP STOP]

 

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

Archived

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

×
×
  • Create New...