Guest Posted March 22, 2006 Posted March 22, 2006 Help please - my shop is broken and I can't work out why! The error I am getting is this: 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 = '34' To the best of my knowledge, I haven't changed anything except the text on the index page. I have restored the old index page (yes, I did do a backup!) and it is still broken. Can anyone help please? Thanks Tim
Guest Posted March 22, 2006 Posted March 22, 2006 Help please - my shop is broken and I can't work out why! The error I am getting is this: To the best of my knowledge, I haven't changed anything except the text on the index page. I have restored the old index page (yes, I did do a backup!) and it is still broken. Can anyone help please? Thanks Tim OK - don't bother with for the moment, I am fairly certain that the problem is caused by my hosting company changing the MySQL to version 5. Tim
Guest Posted March 30, 2006 Posted March 30, 2006 OK - don't bother with for the moment, I am fairly certain that the problem is caused by my hosting company changing the MySQL to version 5. Tim Tim did fix your problem? what did you have to do as im having the same problem with one of my stores at the moment!
Guest Posted March 30, 2006 Posted March 30, 2006 Just download the latest osc version it includes these mods for mysql5.x
dynamoeffects Posted March 30, 2006 Posted March 30, 2006 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 = '34' The bolded portion is not correct. Please use the forums for support! I am happy to help you here, but I am unable to offer free technical support over instant messenger or e-mail.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.