Tcet Posted March 24, 2006 Posted March 24, 2006 Hi I Really need help ASAP ..HELP!!!! I've had a oscommerce site for a long time now ..everything was fine until the server that the runs on .. got upgraded with mysql 5 ... used to be 4 i guess... The site works just fine..only when products need to be listed (after selecting a category in the menu.. I get a Mysql error... the grammar is no longer working in mysql 5.0. 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 = '5' and p2c.categories_id = '35' SO HOW do i change the grammar to work ...where do i change it ..??? I cant find this section anywhere...on the index page that generates it......? www.maha-nail.nl/catalog and click link in left menu...for category ... Super thanx! Alx HELP???...anyone... I just really need it wrking and have no idea about mysql grammar..
satish Posted March 24, 2006 Posted March 24, 2006 Hi I Really need help ASAP ..HELP!!!! I've had a oscommerce site for a long time now ..everything was fine until the server that the runs on .. got upgraded with mysql 5 ... used to be 4 i guess... The site works just fine..only when products need to be listed (after selecting a category in the menu.. I get a Mysql error... the grammar is no longer working in mysql 5.0. 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 = '5' and p2c.categories_id = '35' SO HOW do i change the grammar to work ...where do i change it ..??? I cant find this section anywhere...on the index page that generates it......? www.maha-nail.nl/catalog and click link in left menu...for category ... EMail: [email protected] Super thanx! Alx HELP???...anyone... I'll pay 20 Bucks! I just really need it wrking and have no idea about mysql grammar.. Apply the updates that come up with the updated release of Oscommerce osCommerce 2.2 Milestone 2 051112 Update Released from the following URL you can get the fixes article to read. http://www.oscommerce.com/about/news,121 Satish Mantri Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site. Check My About US For who am I and what My company does.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.