Complete reviews system

[Guest]

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.

[Guest]

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