Hi
I had an annoying problem where my watch progress on some items was stuck and could not be changed
It was not because the item was still watched on another device, it failed because of data corruption in my sqldb
Today i took some time to fix it.
As i searched for the problem there were many answers but no solutions
So if you find yourselve stranded here, thats how i fixed it (bad luck if u dont use linux)
First check if you have the same problem
For that check your logs while changing the progress on an item
If your logs are smth like
Jul 30, 2025 14:25:37.317 [2774999920] ERROR - [Req#4b1fe] SQLITE3:(nil), 779, index corruption at line 94622 of [a29f994989]
Jul 30, 2025 14:25:37.317 [2774999920] ERROR - [Req#4b1fe] SQLITE3:(nil), 779, statement aborts at 52: [UPDATE metadata_item_settings SET view_offset=:U1,view_count=:U2,last_viewed_at=:U3,changed_at=:U4,updated_at=:U5 WHERE id=:C1] database disk image is malformed
Jul 30, 2025 14:25:37.317 [2774999920] ERROR - Got exception from request handler: std::except
Bingo! This is for you then
Stop your plex service
Make a backup of
Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db
No, dont skip, do it
Then make an sql dump of your db
sqlite3 com.plexapp.plugins.library.db “.dump” > plex_dump.sql
Then recreate a database from that dump
sqlite3 fixed.db < plex_dump.sql
Here you will see all the errors that appear
If you dont know what you do, ask chatgpt to help you fix them after you explained your problem, this may and probably will create a corrupt new database aka your stuff is gone
If it creates a db without any errors in the output you can copy it over your „com.plexapp.plugins.library.db“ for which you absolutely already have made an backup
Then start plexmediaserver and pray
Should now work again
