hyungjay Posted March 1, 2018 Share Posted March 1, 2018 Hi, I am new in here and trying to find out why the Seach shows up error, I am getting "1054 - Unknown column 'p.products_id' in 'on clause' select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id), products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%bb026%' or p.products_model like '%bb026%' or m.manufacturers_name like '%bb026%') )" Could you please any one help out why it shows that error when try to search? http://www.fashionpointinc.com/advanced_search_result.php?keywords=bb026&x=3&y=12 Please advise, Link to comment Share on other sites More sharing options...
MrPhil Posted March 1, 2018 Share Posted March 1, 2018 Exactly what version of osCommerce? Older versions broke when an incompatible change was made to how the MySQL database implemented operation precedence, but this was fixed long ago, unless you're using an ancient (2.2) version. You might want to search this forum for the 1054 error and see what kind of code changes were made to fix it. Even better, if you are running something old (anything not 2.3.4.1 or even better, 2.3.4BS Edge), it's time to upgrade to something current. It's also possible, if this is add-on code, that for some reason products_id was not added to the products table, or was somehow removed. Has anyone been working in the code or database lately? Was an add-on just installed? Link to comment Share on other sites More sharing options...
hyungjay Posted March 1, 2018 Author Share Posted March 1, 2018 I have "osCommerce 2.2-MS2" could you please send me how to upgrade the osCommerce and what version should I go? Also how can I back up the site before upgrade? Please advise Link to comment Share on other sites More sharing options...
Dan Cole Posted March 1, 2018 Share Posted March 1, 2018 17 minutes ago, hyungjay said: could you please send me how to upgrade the osCommerce and what version should I go? See this thread for information on upgrading and have a look at MrPhi's signature file, or mine for that matter, on where to download the latest version. Dan Need help? See this thread and provide the information requested. Is your version of osC up to date? You'll find the latest osC community version (CE Phoenix) here. Link to comment Share on other sites More sharing options...
hyungjay Posted March 1, 2018 Author Share Posted March 1, 2018 Thank you very much! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.