Ability to clear watch history of items no longer on server

Feature Suggestions
1

Please put an option to clear watch history for item that you no longer have access to/no longer on the server.

I have a library that is setup for temp videos (to be watched then deleted) and I don’t like that the watch history has entries for tons of items that are not on my plex server anymore and i cant even clear those entries (unless I make a file with the same name and mark it as unwatched then delete it).

2

To be clear, Plex does not remove any watched history, watched or not. Marking something as unwatched resets that flag but any previous history is still saved.

Is there any particular reason you don’t want the history saved? Other than hiding your viewing habits. Only your account would ever see this.

3

didnt know marking it as unwatched didnt remove it from play history…

reason:

  1. it takes up extra space (i know it isnt much but each one adds up)
  2. it harder to look through a play history (cant exclude a single library from play history), i know you can see view history of a whole library
4

1 - each entry is at most 100 bytes, so yes they add up, but very slowly.

2 - this is a better reason

This is a very unique request so not sure if something like this would ever get implemented. You can manually do it through SQL. These 2 commands will remove anything that doesn’t currently exist in any library.

“delete from metadata_item_views where guid not in (select guid from metadata_items);”

“delete from metadata_item_settings where guid not in (select guid from metadata_items);”

1 Like
5

thanks for the SQL command… I’ll try it out (I know to backup the DB before I do)

6

if i can jump in here…

i have a similar problem in my music library (see my post here: How can i purge missing items from my library? )

i think ‘big wheel’ has helped me fix the problem that caused me to get duplicate entries in the first place, but i still have numerous album thumbnails in my library which point to directories which no longer exist.

can you give me a command or a few that would get rid of any album thumbnails showing in my library which are pointing to non-existant folders?

…and not to be a complete idiot, but where do i get a command line to enter the SQL commands?