yoni Posted May 29, 2007 Share Posted May 29, 2007 Hello i have updated my server to php5 and mysql5. After correcting the usual bug i found myself stuck with Wolfen Feature set. Does someone has done the proper correction to make it work with Mysql5 ? Thanks Yoni Quote Link to comment Share on other sites More sharing options...
kflack Posted December 13, 2007 Share Posted December 13, 2007 Hello i have updated my server to php5 and mysql5. After correcting the usual bug i found myself stuck with Wolfen Feature set. Does someone has done the proper correction to make it work with Mysql5 ? Thanks Yoni Hi Yoni Did you ever find a solution ? My provider just upgraded their site to MySQL 5 and PHP 5... I now have this error on my home page..... Being a non programmer I am looking for step by step instructions to correct this problem.... 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(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, 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 = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = mi.manufacturers_id and mi.languages_id = '1' and m.manufacturer_featured = '1' order by rand() DESC limit 3 [TEP STOP] Ken Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.