Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

News Desk


jbmtk

Recommended Posts

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

Link to comment
Share on other sites

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

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

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]

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...