Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

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


jthomo

Recommended Posts

Hi,

I have recently set up my store and set up one catagory with one products and i get this error when i click on my catagory:

 

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

 

[TEP STOP]

 

I have tried the code replace in index.php and advance search_result.php. but no luck.

 

I have Oscommerce 2.2-MS2 and MySQL 5.0.51a-community.

 

Please can someone help me as if i don't get this sorted i will have to use another script.

 

Thanks a lot in advance,

Jamie

Link to comment
Share on other sites

Are you sure you replaced all of the code correctly?

The left join specials s on p.products_id = s.products is wrong. That should be right after the left join manufacturers part.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...