Advanced Review - SQL Error

Hi,

I have purchased the Advanced review module - i have installed on my own cart and a fresh copy but i keep getting the same error :

Notice: Error: Unknown column 'r.vote_yes' in 'field list'
Error No: 1054
SELECT r.review_id, r.author, r.image AS review_image, r.vote_yes, r.vote_no, IFNULL((SELECT AVG(t.rating) as total FROM oc_pr_rating_review t WHERE t.review_id = r.review_id), r.rating) as rating, ROUND((r.vote_yes / (r.vote_no + r.vote_yes)) * 100) as vote, r.text, p.product_id, pd.name, p.price, p.image, r.date_added FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '43' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1' ORDER BY r.date_added DESC LIMIT 0,5 in /home/**/public_html/otest/system/database/mysql.php on line 50

This error appears on the Product review page and in the error logs,

This is the code from the readme which i added to the database

ALTER TABLE `oc_review` ADD `image` varchar(255) NOT NULL DEFAULT ''

Please advise? - seems like a database error

Chris

Is, but could have sprung (sproioioioing) from mistaken installer script. Version, theme?

I have tried on default theme new install of opencart the latest,

i have also tried on mine which is : v1.5.5.1 - custom theme and i get the same errors.

Install has been correct, installed vqmod / vqmod manager - added that line to database and installed files. Gave permissions.

thanks

With the same problem in both installations, and with both review_ and _review prominent in the error list, you should ask the author of your advanced review module.

I use opencart 1.5.5.1
when I edit product page error

"Warning: mysql_query(): Unable to save result set in /home/tabpcmar/domains/tabpcmarket.ir/public_html/system/database/mysql.php on line 22Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT DISTINCT *, (SELECT GROUP_CONCAT(cd1.name ORDER BY level SEPARATOR ' > ') FROM oc_category_path cp LEFT JOIN oc_category_description cd1 ON (cp.path_id = cd1.category_id AND cp.category_id != cp.path_id) WHERE cp.category_id = c.category_id AND cd1.language_id = '2' GROUP BY cp.category_id) AS path, (SELECT keyword FROM oc_url_alias WHERE query = 'category_id=63') AS keyword FROM oc_category c LEFT JOIN oc_category_description cd2 ON (c.category_id = cd2.category_id) WHERE c.category_id = '63' AND cd2.language_id = '2' in /home/tabpcmar/domains/tabpcmarket.ir/public_html/system/database/mysql.php on line 50 "
PLZ hepl me
thanks alot of

""Warning: mysql_query(): Unable to save result" . . . "Notice: Error: Subquery returns more than 1 row". Something is wrong with the syntax, it is being seen as a double-row rather than a single-row record. You are not editing that kind of thing, or at least your editing should not be causing double-rows where there should be one-line records. The author should be able to find the problem in his own work.