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

[vegasvillan]

Hello please help....I get these 2 error messages

 

This one with my category/products

 

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

 

and this with my manufactures

 

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

 

select count(p.products_id) as total from products p, products_description pd, manufacturers m left join specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '19'

 

 

please help

[roya.k]

More details about this bug:

http://bugs.mysql.com/bug.php?id=13551

 

I think that you need to contact your hosting compay.

[lindsayanng]

there is an ENTIRE CONTRIBUTION dedicated to this error

 

CLICK HERE

 

I am very surprised how few people know about the knowledge base.. reading through that would be more instant gratification than asking here and waiting for someone to answer a question that you can answer yourself.

 

For future reference, if you go to google and type it

site:www.oscommerce.com/forums 1054 - Unknown column 'p.products_id' in 'on clause'

 

you w ill get ALL threads relating to that error.. You can do this with ALL errors or issues, just never put in your companies direct file paths, or you will turn up with no results.