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

[jthomo]

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

[Guest]

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.