RM 2.2 BUG ? Old review reappears after deleting the resource

[Old Nick]

Hello,

I had created some time ago a resource and a review for testing.
They stayed on the forum a few weeks then when I put my site into production I deleted them permanently.
I've since created new resources, no problem.
However, today I am creating a resource again and the old review of the deleted resource has reappeared attached to the newly created resource. I try to delete it but the system refuses with a weird error message.

Oops, something is wrong
please enter a number of at least 0
please enter a number of at least 0

What's going on here?
Thanks !

 

[Old Nick]

Maybe it's a bug, i can't delete the review.
The release date of the resource is yesterday and the review is dated from October 23

Désactiver un lien avec CSS | Cocori Web | La communauté

 

[Old Nick]

Is someone get an idea to delete the review ? Database ?

 

[beerForo]

Per chance did you use the change date add-on to make the date of the recourse newer than the review?

 

[Old Nick]

I'm sorry i don't understand what you mean.
This review was deleted with the original resource several weeks ago, i don't know why it reappears like a ghost with this new resource.

And why it is not possible to delete it with this weird alert message.

 

[beerForo]

Did you alter your database especially the autoincrement of the table?

 

[Old Nick]

I've never been to my database since installing the site. I remember this review it corresponded to a tutorial related to Windows, nothing to do with the current tutorial

 

[Paul B]

It looks like you have some corruption/inconsistency in the database.

Check the xf_rm_resource_rating table for an entry which corresponds with the review text.

 

[Old Nick]

Ok, i deleted the entry in the table. It works now. Thanks @beerForo & @Brogan

 

[Paul B]

Err, it would have been better to post the row data first so I could confirm if it was an orphaned review or not.

 

[Old Nick]

Oops... The review was attached to the resource id9 in the table. The current resource has the id9 too.

 

[Paul B]

It's likely okay but it may have been useful to see the data to try and determine how the database got into that state.

If there was a resource with an ID of 9 which was permanently deleted then there shouldn't be another resource created with the same ID as the table should auto increment.

 

[Old Nick]

I suppose there is no trash in DB ?
Sorry for that, it may have been useful to know how this happends, yes.

I don't remember if i created this resource about windows when the site was in localhost or with the previous domain name. I think it was on localhost. I had exported the DB (localhost) and then had imported it on the new (live site), maybe something happends here ?
But the resource wasn't deleted on localhost but in livesite.

 

[Paul B]

I think it was on localhost. I had exported the DB (localhost) and then had imported it on the new (live site), maybe something happends here ?

I was going to ask whether you originally started on localhost so that is the most likely explanation - an incomplete/corrupt backup or restore.

 

[Old Nick]

Is a review is DB deleted when his resource is hard-deleted with moderator tools ?

I was going to ask whether you originally started on localhost so that is the most likely explanation - an incomplete/corrupt backup or restore.

I found the original resource in my localhost XF installation, but the resource get the id8 and at this time there was no review so I had to write it later when the site was live... weird.

 

[Old Nick]

an incomplete/corrupt backup or restore.

the DB was very light, less than 30Mo, there was 2 members, 3 threads, 3 resources. I've done the export with Heidi SQL.