Unknown column 'p.products_id' in 'on clause

[Guest]

I get the following error on the page when I click on a link for say Catagories, or one of the other links...how do I fix this and what may have caused it?

 

Thanks

Susan

 

Here is 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 = '28'

[TEP STOP]

[Jack_mcs]

See this thread.

 

Jack

[Guest]

Thank you Jack...I followed the information from franck and pasted his suggestion in and now it works beautifully. Thank you so much for the pointer! :thumbsup:

 

See this thread.

 

Jack

[pistonie]

Thank you Jack...I followed the information from franck and pasted his suggestion in and now it works beautifully. Thank you so much for the pointer! :thumbsup:

 

i cant seem to get into the page. i signed up to the site, but it wont take me to anything relating to this problem. please help!

[Guest]

i cant seem to get into the page. i signed up to the site, but it wont take me to anything relating to this problem. please help!

 

 

me too I sign on but cannot get to anything relating to this problem

[Jack_mcs]

Hmm, that must be new. It didn't use to require a login. Try looking at this page (the mysql 5 compatibility section).

 

Jack