We have upgraded to mysql 5, now we have an error on the index page.
We have lots of modifications in it, like featured sets, but really don't know how to fix this
1054 - Unknown column 'p.products_id' in 'on clause'
select p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_name, pd.products_description, pd.products_short, p.products_image, IF([url removed, login to view], s.specials_new_products_price, NULL) as specials_new_products_price, IF([url removed, login to view], s.specials_new_products_price, p.products_price) as final_price, m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.manufacturer_featured_until, mi.manufacturers_id, mi.languages_id, mi.manufacturers_url from products p, products_description pd, manufacturers m, manufacturers_info mi 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 = '4' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = mi.manufacturers_id and mi.languages_id = '4' and m.manufacturer_featured = '1' order by m.manufacturers_id DESC limit 2
This has to do with Mysql ,i already looked at oscommerce forums, but the given details to fix it, are too much for me.
Hello sir i have solved such an issue before to lot many clients.. i had even solved this for one in GAF too.. we can complete the work in 2 hrs.. Please check PMB for more details.. Regards Harishyam