IMpure Posted April 28, 2008 Posted April 28, 2008 I had a server shift. Transfer done by hosting guy but after the transfer, I start encountering this 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 = '7' I have made these attempts:- 1.) Restored a previous backup 2.) myself created 'products_id' field in all product relevant tables where it seems missing but nothing seems to work. Any suggestion? To be or not to be, that is the question!
IMpure Posted April 28, 2008 Author Posted April 28, 2008 If someone could even explain me the error, I would be grateful To be or not to be, that is the question!
♥Vger Posted April 28, 2008 Posted April 28, 2008 p2c left join I'm guessing your new server uses MySQL 5 and your osCommerce install is not MySQL 5 compliant. MySQL 5 handles 'joins' in a different way to MySQL 4. Either downgrade to MySQL 4+ or else you'll have to update your shop to be MySQL 5 compliant. Vger
IMpure Posted April 28, 2008 Author Posted April 28, 2008 p2c left join I'm guessing your new server uses MySQL 5 and your osCommerce install is not MySQL 5 compliant. MySQL 5 handles 'joins' in a different way to MySQL 4. Either downgrade to MySQL 4+ or else you'll have to update your shop to be MySQL 5 compliant. Vger updating my shop to MYSQL5 would cause configuration loss? or it is just like installing a patch and everything would start to work normally as it was previously doing. Any link containing info to update shop to MYSQL5? Is there any software which automatically converts MYSQL4 dbase to MYSQL5? To be or not to be, that is the question!
IMpure Posted April 28, 2008 Author Posted April 28, 2008 I have fixed it using this contribution:- http://addons.oscommerce.com/info/3727 I'm just posting it so other could get help from it. Thanks a lot To be or not to be, that is the question!
♥geoffreywalton Posted April 28, 2008 Posted April 28, 2008 There are other places where your shop will have to be patched to work with mysql5. The patch link below is a good place to start. Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.