Clear watched episodes for a specific user

General Discussions
1

Hi,

How would I go about clearing the watched status of an entire user. At some point I had an issue where watched status was synced to all users which was incorrect so now want to reset this for a specific user.

I’ve tried to remove the user completely and re-add them but the problem persists.

Thanks.

2

There isn’t a way in Plex to remove the watched status, except to have that user mark each library as unplayed.

If you are adventurous, you could manually do it by manipulating the Plex database.

3

I am a software developer by trade so if you can point me in the right direction I’m sure I’ll be able to sort it out but if it can be updated on a library level it might not be the end of the world. Just scared that content no longer available in the libraries might still stay as watch in the database.

4

Yes, that will happen. Plex is like an elephant and never forgets. It’s intentional so if you remove a movie, then add it back later, the status will still be there. You’ll have to edit the database to totally remove that info.

Here is a support article on repairing the Plex database. You don’t need to do that, but it has info on how to find and access the database. https://support.plex.tv/articles/201100678-repair-a-corrupt-database/

You basically want to run an SQL statement to remove all the entries from 1 specific table for that user. You should first shut down PMS, then you’ll need to identify the user id.

SELECT id, name FROM accounts;

This will give a list of your users and their ID. Then the removal.

DELETE FROM metadata_item_settings WHERE account_id = 999;

Change the 999 to match the user you are interested in.

5

Thanks for the response, it seems that the metadata table provided does not exist but found that it was just called item instead of items.

I have removed the details from said user and the on deck information is no longer showing.

Thanks for the help.

6

Oops, yeah typo. Edited my post above.

7

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.