I’ve copied the PlexDBRepair-0.6.5.tar.gz file to the downloads folder.
Executed the following:
To launch from the command line on MacOS (on the administrator account)
osascript -e 'quit app "Plex Media Server"'
cd ~/Downloads
tar xvf PlexDBRepai PlexDBRepair-0.6.1.tar.gz
cd PlexDBRepai PlexDBRepair-0.6.1
chmod +x DBRepair.sh
./DBRepair.sh
Get to the 3rd line of instructions and get this in terminal:
Last login: Tue Feb 14 13:57:09 on ttys000
lucashboyle@Lucass-iMac ~ % osascript -e 'quit app "Plex Media Server"'
lucashboyle@Lucass-iMac ~ % cd ~/Downloads
lucashboyle@Lucass-iMac Downloads % tar xvf PlexDBRepai PlexDBRepair-0.6.1.tar.gz
tar: Error opening archive: Failed to open 'PlexDBRepai'
lucashboyle@Lucass-iMac Downloads %
Attempted option 4. I guess it’s looking like i need to start again. Also what is the most common causes for the library to get “damaged”.
Enter choice: 4
Exporting current databases using timestamp: 2023-02-14_15.36.28
Export: (main)…(blobs)…done.
Successfully exported the main and blobs databases. Proceeding to import into new databases.
Import: (main)…Error: near line 863864: UNIQUE constraint failed: fts4_metadata_titles_icu_segdir.level, fts4_metadata_titles_icu_segdir.idx
Error: near line 863865: UNIQUE constraint failed: fts4_metadata_titles_icu_segdir.level, fts4_metadata_titles_icu_segdir.idx
Error: near line 863866: UNIQUE constraint failed: fts4_metadata_titles_icu_segdir.level, fts4_metadata_titles_icu_segdir.idx
Error: near line 863867: UNIQUE constraint failed: fts4_metadata_titles_icu_segdir.level, fts4_metadata_titles_icu_segdir.idx
Error: near line 863868: UNIQUE constraint failed: fts4_metadata_titles_icu_segdir.level, fts4_metadata_titles_icu_segdir.idx
Error: near line 863869: UNIQUE constraint failed: fts4_metadata_titles_icu_segdir.level, fts4_metadata_titles_icu_segdir.idx
Error: near line 863870: UNIQUE constraint failed: fts4_metadata_titles_icu_segdir.level, fts4_metadata_titles_icu_segdir.idx
Error: near line 863871: UNIQUE constraint failed: fts4_metadata_titles_icu_segdir.level, fts4_metadata_titles_icu_segdir.idx
Error: near line 863872: UNIQUE constraint failed: fts4_metadata_titles_icu_segdir.level, fts4_metadata_titles_icu_segdir.idx
Error 1 from Plex SQLite while importing from ‘./dbtmp/library.plexapp.sql-2023-02-14_15.36.28’
Cannot continue.
You can try restoring from an available database backup (configured in Settings → Scheduled Tasks → Backup database every three days).
If successful, you will not have to re-create your libraries, reshare with friends, etc. You will need to re-scan your libraries to pick up any changes since the backup occurred.
Checking the PMS databases
Check complete. PMS main database is damaged.
Check complete. PMS blobs database is OK.
Database is damaged and no backups avaiable.
Only available option is Repair.
Enter choice: 4
Exporting current databases using timestamp: 2023-02-14_16.11.32
Export: (main)…(blobs)…done.
Successfully exported the main and blobs databases. Proceeding to import into new databases.
Import: (main)…Error: near line 863864: UNIQUE constraint failed: fts4_metadata_titles_icu_segdir.level, fts4_metadata_titles_icu_segdir.idx
Error: near line 863865: UNIQUE constraint failed: fts4_metadata_titles_icu_segdir.level, fts4_metadata_titles_icu_segdir.idx
Error: near line 863866: UNIQUE constraint failed: fts4_metadata_titles_icu_segdir.level, fts4_metadata_titles_icu_segdir.idx
Error: near line 863867: UNIQUE constraint failed: fts4_metadata_titles_icu_segdir.level, fts4_metadata_titles_icu_segdir.idx
Error: near line 863868: UNIQUE constraint failed: fts4_metadata_titles_icu_segdir.level, fts4_metadata_titles_icu_segdir.idx
Error: near line 863869: UNIQUE constraint failed: fts4_metadata_titles_icu_segdir.level, fts4_metadata_titles_icu_segdir.idx
Error: near line 863870: UNIQUE constraint failed: fts4_metadata_titles_icu_segdir.level, fts4_metadata_titles_icu_segdir.idx
Error: near line 863871: UNIQUE constraint failed: fts4_metadata_titles_icu_segdir.level, fts4_metadata_titles_icu_segdir.idx
Error: near line 863872: UNIQUE constraint failed: fts4_metadata_titles_icu_segdir.level, fts4_metadata_titles_icu_segdir.idx
Error 1 from Plex SQLite while importing from ‘./dbtmp/library.plexapp.sql-2023-02-14_16.11.32’
Cannot continue.