Help with errors when show a products

[Guest]

Hello forum.

I need please some help with some errors when Im add products on categories, I upload a picture with specification then go and make a click on Mens clothes and the picture with specifications doesn't show up, something show on page like:

 

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

 

Please let me know what I have to do to fix the problem.

 

Thank you so much

[sLaV-]

If you get this message it is probably due to your server upgrading to php5 or MySQL5. You get the message when you try a search on your site. The new OSC from around Sept-Oct 2006 or so, doesn't have this problem.

 

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

[Guest]

Hello forum.

I need please some help with some errors when Im add products on categories, I upload a picture with specification then go and make a click on Mens clothes and the picture with specifications doesn't show up, something show on page like:

 

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

 

Please let me know what I have to do to fix the problem.

 

Thank you so much

Look here

[Guest]

Woww, Thank you so much you are so nice and fast too,

and thanks to all forum too.