i’m watching that my plex are not syncing the item watched for example if a let a series episode in episode 5 when i come back to contionue watching i it show me that im in episode 4 and its wrong, so i enter to the plex database folder and i found duplicated item like this
com.plexapp.plugins.library.blobs.db-2022-12-06
com.plexapp.plugins.library.blobs.db-2022-12-09
com.plexapp.plugins.library.blobs.db-2022-12-12
com.plexapp.plugins.library.blobs.db-2022-12-15
and those too
com.plexapp.plugins.library.db-2022-12-06
com.plexapp.plugins.library.db-2022-12-09
com.plexapp.plugins.library.db-2022-12-12
com.plexapp.plugins.library.db-2022-12-15
Those are backups of the database created by the scheduled tasks run during server maintenance.
When tinkering with the database, ignore the versions with a date in their file name.
Also make sure to stop the server before messing with the database!
Tip!: If you stop watching an item part way through, the “in progress” information is not synced. Only if or when you complete the title (so it is “watched”) will the state get synced up. That’s intentional to ensure the source can’t be inferred to be a personal server.