Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Complete reviews system


Guest

Recommended Posts

Hi, I've just tried the complete reveiws system but can't get it to work. In the default reviews box on the main page I'm getting a load of text beginning with '1054 - Unknown column 'r.approved' in 'where clause'' and then

 

'select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' and r.approved = '1' order by r.reviews_id desc limit 10

 

[TEP STOP]'

 

 

Does anyone know what this means or how to fix it? I'd love to use this add-on.Seems more secure than the default reveiw system.

Link to comment
Share on other sites

I found the answer on another forum - the sql file enclosed in the pack has to be uploaded to, or the script pasted to, your sql database. All fixed now :D

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...