VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: siongraham on June 14, 2013, 14:16:58 PM

Title: Problem editing reviews
Post by: siongraham on June 14, 2013, 14:16:58 PM
Hi,

Joomla Version: 2.5.9
VirtueMart Version: 2.0.20b
MySQL Version: 5.1.69-0ubuntu0.10.04.1-log

When editing a review in the Virtuemart backend, if you click save the review is updated, but the following error is displayed:

vmError: VirtueMartModelRatings::Error store rating TableRatings: :store failed
Duplicate entry '97-1' for key 'i_virtuemart_product_id' SQL=UPDATE `ap8q7_virtuemart_ratings` SET `virtuemart_product_id`='97',`rates`='5',`ratingcount`='1',`rating`='5',`published`='1',`created_on`='2013-06-13 15:45:22',`created_by`='51',`modified_on`='2013-06-14 12:14:51',`modified_by`='42' WHERE `virtuemart_rating_id`='1'

I've googled this and nobody else seems to have the problem... does anybody have any ideas?

I've attached a screenshot.

Thank you!

[attachment cleanup by admin]