I’ve been testing Plex in the last few days, partially playing stuff and now I want to start using it “for real” and reset all the stats gathered during the tests - is this possible?
Note - I’m mainly talking about the view statistics in the Dashboard, I know that I can mark any movie I started as “unwatched” to reset its progress, but I can’t find any “delete user stats” option.
BTW, I wouldn’t want to delete the user and create a new one because… the user is me, I’m the admin and don’t want to wait a month before I can recreate the account (which I also paid for, though that’s not the main issue as I’m planning to cancel the subscription anyway and get the lifetime pass ).
There is no need to cancel the subscription or erase the account if you want to go from monthly to lifetime. https://plex.tv/subscription
The only way to erase the statistics is to edit the database directly (i.e. from outside of the Plex user interface). I am waiting for detailed info in that.
I paid via PayPal so I was referring to just canceling the monthly payment authorization there and of course I do NOT want to delete the account - that’s the whole point. I know I could probably wipe the stats by deleting the account which I don’t wanna do.
Anyway, let me know once you have the details, I’m guessing it’ll be somewhere in C:\Users\username\AppData\Local\Somethingsomething…?
You will be needing either the SQLite tools (command line)
or you use any other GUI SQLite editor. I use sqlitebrowser.org
You must stop Plex server from running before doing any manipulations on the database.
(on Windows, ‘Exit’ Plex server using the tray bar icon. Closing the web browser window is not enough!)
Make a backup copy of the DB file before you do anything.
Statistics are in 4 tables inside the main database file
The statistics_* tables - are used for all the graphs
The metadata_item_views - used for all the ‘top’ playbacks etc.
Don’t erase the tables. Only empty them out.
SQL command is DELETE FROM table_name
General advise is to not nuke things from the metadata_item_views tables (given it is the server playback history) but it should be ok to do so.
But don’t make a habit of it.
I want to add that deleting the user account or cancelling the monthly Plex Pass payment will not erase the playback history from your server’s database.
).