Thanks Chuck. Didn’t notice that the post had been edited. Sorry for not looking for that before asking the question 
.
-Shark2k
Because I don’t want to make mistakes, could you help me anderstand each step?
I downloaded your script and paste it to C:
Now:
- I turn off PMS
- Then run the script
3. How do I repair the DB?
4. How do I REINDEX? - I’ll restart PMS
This is not for Windows. It is only for Linux-based hosts.
The script will present those options clearly.
Edit: wasn’t paying attention to OS.
To all who might find this useful (or are curious) 
It will detect the OS and configure itself to the Plex standard for that OS.
On Redhat & Debian Linux systems, it will attempt to follow Override.conf (if simple)
Supported platforms are:
- Mainstream Linux platforms (RPM & DEB)
- QNAP (QTS/QuTS 5+), Synology (DSM 6 & 7), ASUSTOR, Netgear
- Docker (s6-exec)
- Full LXC which presents as a standard RPM/DEB host
Why not just build this functionality into the binary and make it a butler task so it works across all OS and even the non-power users will benefit? This should probably be part of the existing “optimize” functionality.
Because you can’t operate on the DB while PMS has the DB open.
ALSO
I’m doing this to support those cases where the DB is corrupted and PMS won’t start.
1 Like
Sure, but it can occur on start up or shutdown ie upgrades. That is exactly what I have scripted is to run after every upgrade but before restarting Plex. The binary executable can operate with the sqlite connection closed, hence the ability to make calls to Plex SQLite.
Arf 
That would be great if it was possible to run it in other OS like … windows 
I hear what you’re saying but this is not the venue for that discussion.
Please consider what I’ve done as PoC and the First-Aid Kit.
It addresses the problem in 99.9% of the cases.
(No need for a vaccine to be developed for a paper cut – analogy)
Please remember I’m support and independent of what Product & Engineering might decide.
1 Like
So without using your tool, I could still go through this:
https://support.plex.tv/articles/repair-a-corrupted-database/
and it may help?
Is there an conspicuous link to get a copy of this script?
It’s in this thread… You only needed to scroll back.
It worked on Gentoo 
Without using my tool, you perform all the steps by hand.
I give you more ways to repair the DB than the support article with simple menu choices.
Thank you
As a windows user that seems to be my only solution, or do you plan to make it for this OS too ?
Thanks for the location of the link to the file.
However, unless I am mistaken, the tool is not compatible with the linuxserver.io docker image as there is no file named plex_service.sh included in that image, and perhaps other needed files too.
I don’t keep track of all the docker images as there are too many
If you’re going to use Docker, it is suggested you know how to control it.
cd /var/run/s6/services
s6-svc -d plex
-or-
s6-svc -d /var/run/service/plex
Everything else needed is there. I already worked with a user who uses Linuxserver.io.
When I get a chance, I’ll see if i can add “Linuxserver.io” as a host type.
I currently have the official Plex docker image .
you all know I’m not fond of docker due to all the variations. This is a prime example
EDIT: No changes to existing scripting is required to support Linuxserver.io Docker image. Default location for PMS is unchanged.
This script is a personal project of mine. It’s not the slightest bit official.
I don’t have any windows computers in my house.
That as basis, I have no idea how PMS runs on Windows platforms.
Does my script even run on Windows?
From what I remember , BAT files at just that – batty as heck.
and Cygwin stuff isn’t compatible because of all the variations.
If that’s changed, maybe it can be developed but working that out and making it happen are a separate discussion.
