Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1054 - Unknown column 'r.products_id' in 'on clause'


oreind

Recommended Posts

Posted

Got this error:

"1054 - Unknown column 'r.products_id' in 'on clause'" when clicking reviews.

 

Do you know what is wrong?

 

Can it be that i am using now MySQL client version: 5.0.15 but earlier v.4?

 

What do I need to change?

 

Baldur

Posted

you will fid it is because of the mysql update, something to do with the way the joins are done on the sql querys, have a search of the forum as many people have had this issue

Or download the latest version of the cart and run through the updates one at a time by hand, takes time but works wonders

Posted

You will find there is a contribution that covers the required updates.

 

http://addons.oscommerce.com/

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...