Collections Error after updating WD PR4100 to Versions 1.20.3.3401 and later

Yes, that’s it in a nutshell. Here’s what I did for reference. I was on 3402 when running the fix, but you should be able to run it on the latest version, so YMMV…

  • Enabled SSH to NAS (PR4100)
  • Shut down the Plex server
  • Pulled a copy of the db over to my Windows machine
    • com.plexapp.plugins.library.db from /mnt/HD/HD_a2/Nas_Prog/plex_conf/Plex Media Server/Plug-in Support/Databases
    • made a copy of that to ensure I had a good backup in case something went awry…
  • Ran all of the commands and items listed in https://support.plex.tv/articles/201100678-repair-a-corrupt-database/
    • This included deleting com.plexapp.plugins.library.db-shm and com.plexapp.plugins.library.db-wal
  • Copied the repaired db back over to /mnt/HD/HD_a2/Nas_Prog/plex_conf/Plex Media Server/Plug-in Support/Databases and overwrote the file
  • Restarted Plex and updated to the latest version and validated fixed
  • Disabled SSH

It was easy to do, just ensure the SQLlite tools are in the same folder of your copy of the DB is for Windows to run the commands in the above URL.