Create a batch file (A text file with the extension of .bat)
Add the below script
After you save the script, just double click on the .bat file.
@echo off
set PlexDatabase=%UserProfile%\AppData\Local\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db
set DeleteRottenReviews=delete FROM taggings WHERE extra_data LIKE ‘%%rotten%%’;
“C:\Apps\Plex Media Server\Plex Media Server.exe” -sqlite “%PlexDatabase%” “%DeleteRottenReviews%”
See the new agent configuration settings here:
This is about reviews, not about ratings.
Would these reviews just return upon a metadata refresh of a movie?
Most certainly yes.
Yes, they will return, but you can setup a windows scheduler to execute the script every day.
Mine is set to run at 3am each day.
Cool, will test this out myself via a cron job. If it goes well I’ll add it to my weekly maintenance of bloat I nuke on my plex server.
I’d also HIGHLY recommend no one runs that delete statement while the server is running. Recipe for disaster 
Why? There is nothing in it which could collide with other server activities. Except maybe a metadata update.
Right, let’s say someone was doing a refresh of a large library and not thinking (or understanding) then went and deleted this content. God knows what type of locks / errors / corruption… might happen.
I’d personally never adjust anything in the plex db while it’s live and online. Best to work offline IMO. Better safe than sorry.
Can’t argue with that.
What other routines do you run?
Curious what other jobs are needed.
I basically do this weekly via a cronjob (ensuring plex is stopped beforehand) …
sudo rm -rf /var/lib/plexmediaserver/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Caches/*
sudo rm -rf /var/lib/plexmediaserver/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Data/*
sudo rm -rf /var/lib/plexmediaserver/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Metadata\ Combination/*
sudo rm -rf /var/lib/plexmediaserver/Library/Application\ Support/Plex\ Media\ Server/Cache/PhotoTranscoder/*
The PhotoTranscoder is especially important to me as it grows unbounded and has massive amounts of duplicate files as proved in this thread Cache/PhotoTranscoder Folder Size Sanity Check
Just found a setting that will prevent them from coming back.
[\Settings\Schedule Tasks\Refresh library metadata periodically]
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
