Problem editing reviews

[siongraham]

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]