Im in the same boat as you, im giving up on trying to fix it. now im trying to just migrate my watched history to a clean install… but plex’s guide is not accurate. so im stuck again, lovely.
but for you (i see youre on linux), their guide should work. have you considered a clean install? force plex to relearn all metadata.