DBRepair development

[d2freak]

I can not do this right now Chuck. I apologize.

However you can see this post from @OttoKerner to see what I’m talking about (orphaned accounts being retained in the database after being removed from Plex)

How to remove orphaned user accounts?

There should be one table containing all the user names and their individual ID numbers. And there is another table containg all the playback history, containing both a time stamp, the user ID, and the media ID which has been played. You need to cross-reference one with the other, then remove all the lines with the user ID of users who no longer exist from the playback history. The whole will only require basic SQL knowledge. But still, you want to retain a backup of the primary database fil…

He knows how to do it. Perhaps you could collaborate about implementing a cleanup of this in your new program? Thanks for your work.

Edit: the option could say something like “prune orphaned users” and your program could cross check with Plex cloud which users are currently added, and prune the rest (orphaned). This should obviously not be included in the auto mode, but it should be safe in general.