Error: deleted credits are still showing in author DB

Sally Green https://bookbrainz.org/author/ab2d4e53-807d-4c23-8a52-d17fa1168b55 has two Edition Groups credited in her DB, which were deleted in 2015: https://bookbrainz.org/edition-group/704eb5af-3b56-43b2-b84d-70a1491a17c0 and https://bookbrainz.org/edition-group/50c185bc-2e2b-4fed-8d1b-c03c7d093406

For some reason they haven’t disappeared, is there any way of removing them?

This one as well:
J. K. Rowling: https://bookbrainz.org/author/e5c4e68b-bfce-4c77-9ca2-0f0a2d4d09f0 with https://bookbrainz.org/work/97395842-1bd8-49d0-92a6-469c26160f57 (deleted 2019)

Having read the information, maybe they just remain in the database.

Deleted entities do remain in the database in some form; as you see, visiting the page shows the deleted edition and its revision history (which will allow us to un-delete it once that feature is implemented).

However, that they are still showing in the author’s relationships is not normal.
There was a bug that has been corrected, but I yet have to fix the orphaned relationships in the database.
I tread lightly when it comes to executing a script that will modify hundreds of entries in the database…

Thanks for reporting these examples though, it’ll be useful for the process!

Here’s the ticket where we’re tracking this: BB-459

2 Likes

You might like this one as well: https://bookbrainz.org/work/00d88436-c728-434f-9d8c-d53b9e70a7f8 and https://bookbrainz.org/edition/8b250c7e-9e5a-48ab-814e-3db8adb87512