martinstan Posted August 21, 2006 Share Posted August 21, 2006 Hi My first day using oscommerce and looks great, however I receive the following error when add a new category and the click on it to view it. I've search the forum but the particular link I have found that addresses my problem seems to be dead. Anyone help? Thanks in advance. Martin 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 = '21' Link to comment Share on other sites More sharing options...
martinstan Posted August 21, 2006 Author Share Posted August 21, 2006 Hi I found this somewhere. Does this ring true with anyone. Thanks If you are Running osCommerce on MySQL 5.0.12 (static gcc compiled version) on SuSe Linux 9.1, any query with LEFT/INNER JOIN would result in error message "1054 - Unknown column 'p.products_id' in 'on clause'". Find out which mySQL version you are using. If you are using MySQL 5.0.12 then you will ned to ask your hosting company to downgrade that software to MySQL 4.1 standard Link to comment Share on other sites More sharing options...
Guest Posted August 22, 2006 Share Posted August 22, 2006 HiI found this somewhere. Does this ring true with anyone. Thanks If you are Running osCommerce on MySQL 5.0.12 (static gcc compiled version) on SuSe Linux 9.1, any query with LEFT/INNER JOIN would result in error message "1054 - Unknown column 'p.products_id' in 'on clause'". Find out which mySQL version you are using. If you are using MySQL 5.0.12 then you will ned to ask your hosting company to downgrade that software to MySQL 4.1 standard No you don't need to downgrade, you just need to change some lines of code to make the queries mysql 5+ compatible. These can be found here: http://www.oscommerce.com/solutions/downloads. The upgrades also contain some changes for safety. Good luck. Link to comment Share on other sites More sharing options...
martinstan Posted September 1, 2006 Author Share Posted September 1, 2006 No you don't need to downgrade, you just need to change some lines of code to make the queries mysql 5+ compatible. These can be found here: http://www.oscommerce.com/solutions/downloads. The upgrades also contain some changes for safety. Good luck. Thanks. Got it sorted Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.