jbmtk Posted June 5, 2007 Share Posted June 5, 2007 AFter installing the latest build, I still get this error: 1054 - Unknown column 'p.newsdesk_id' in 'on clause' when clicking on a article under "news catagoires" and not "news articles" I was told this maybe due to Mysql 5.xx not handling the request well. If so, how do I downgrade mysql through xampp? thanks Quote Link to comment Share on other sites More sharing options...
satish Posted June 5, 2007 Share Posted June 5, 2007 Well no need to downgrade from php 5. Just YOu need to modify the sql query. You can paste here and will help out. Satish Quote 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. Link to comment Share on other sites More sharing options...
jbmtk Posted June 5, 2007 Author Share Posted June 5, 2007 I meant sql5, but here is the error message, I'm not sure how to fix this. 1054 - Unknown column 'p.newsdesk_id' in 'on clause' select count(p.newsdesk_id) as total from newsdesk_description pd, newsdesk p left join manufacturers m on p.newsdesk_id = m.manufacturers_id, newsdesk_to_categories p2c left join specials s on p.newsdesk_id = s.products_id where p.newsdesk_status = '1' and p.newsdesk_id = p2c.newsdesk_id and pd.newsdesk_id = p2c.newsdesk_id and pd.language_id = '1' and p2c.categories_id = '11' [TEP STOP] Quote Link to comment Share on other sites More sharing options...
jbmtk Posted June 7, 2007 Author Share Posted June 7, 2007 I searched all over and i guess some other users here have the same problem...is there a solution? Quote Link to comment Share on other sites More sharing options...
Guest Posted June 8, 2007 Share Posted June 8, 2007 I searched all over and i guess some other users here have the same problem...is there a solution? yes, you need to change the sql queries to conform to mysql 5.x Quote Link to comment Share on other sites More sharing options...
jbmtk Posted June 11, 2007 Author Share Posted June 11, 2007 yes, you need to change the sql queries to conform to mysql 5.x I recall seeing a link to that, does anyone have that link of how to change the sql queries? thanks Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.