sqlite3 .db "DROP index 'index_title_sort_naturalsort'".Even if the results come back “OK”, it’s still possible for there to be issues with a database, though. You can run commands to check how corrupt the database might be. If you haven’t added the SQLite executable to your path environment, then it’s easiest to simply copy the sqlite3.exe executable file into the above directory so that it’s easy to run. cd "%LOCALAPPDATA%\Plex Media Server\Plug-in Support\Databases" First, simply switch over to the directory containing the database. When running the commands, be sure to enclose paths in quotes to handle spaces in paths. The following commands are run in the Command Prompt application. Make sure you quit/exit your Plex Media Server so that it is not running.
However, you can download and install them yourself from the SQLite website. Windows installs don’t come with SQLite3 tools installed by default. Related Page: For Plex Media Server 1.23.2 and newer Repair a Corrupted Database Windows Related Page: Restore a Database Backed Up via 'Scheduled Tasks' Related Page: Where is the Plex Media Server data directory located? That is expected and the errors won’t affect anything. Warning: With the instructions below, if you run all of the “Check for Corruption” instructions aprior to running the “Run a Repair” instructions, you will receive errors related to steps 2 & 3 of the latter. You will lose your existing libraries and need to recreate them, but you won’t be affecting your content itself.) Restarting the server will then restore your server to a nearly-fresh install state. Note: You can also simply delete the .db database file while the Plex Media Server is not running. The commands listed below will assume the default server data directory locations. The data directory location can vary by operating system and device. The database file will be located at /Plug-in Support/Databases/.db inside the main Plex Media Server data directory. In many cases, you may also be able to restore a database copy that was backed up via the Scheduled Tasks feature. Tip!: It’s always a good idea make a backup copy of the database file before doing any work on it. If using version 1.23.2 and newer see Repair a Corrupted Database This article is for Plex Media Server version 1.22.0 and earlier. In such a situation, you can attempt to repair the database.
For instance, it might happen if the computer is turned off without first quitting Plex Media Server. Though rare, it is possible for your main Plex Media Server database to become corrupted.
0 kommentar(er)
