Guest Posted October 3, 2008 Posted October 3, 2008 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- Posted October 3, 2008 Posted October 3, 2008 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 Posted October 3, 2008 Posted October 3, 2008 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 Posted October 3, 2008 Posted October 3, 2008 Woww, Thank you so much you are so nice and fast too, and thanks to all forum too.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.