Good day everyone, hoping someone can help me. My collections stopped working after updating to the two latest beta versions in the subject. Prior versions it would show the Collection, and then the titles within the collections. After updating to the two latest, it shows different errors depending on the device/browser being used. This wasn’t an issue on the Betas until the most recent two updates.
When updating to 1.20.3.3421, when using Plex Web, it shows the collections, but when opening a collection, it gives a “Something went wrong, an unexpected error occurred.” message. In the Plex Media Player, the same experience, except it shows an “Unable to load items” error.
I had to downgrade to 1.20.2.3402 from both to view my collections and the movies within them as well as play them. Is this a known bug either in the betas or in the NAS versions?
Just tried 1.20.3.3437 and the same issue; when using Plex Web, it shows the collections, but when opening a collection, it gives a “Something went wrong, an unexpected error occurred.” message. In the Plex Media Player, the same experience, except it shows an “Unable to load items” error. Hvae to downgrade back to 1.20.2.3402 to have them show.
Feels like I might be the only one seeing this issue since I don’t see other reports of it, but not sure why. Not sure if the logs helped at all.
Just tried again with the latest update 1.20.3.3483 and still the same issue, had to revert back to 1.20.2.3402 for collections to be seen, is no one else seeing this behavior?
Some part of your database is corrupt. It could be that the new version of PMS is needing to access something the previous version did not.
Oct 13, 2020 18:47:28.614 [0x7fafc3a23700] ERROR - SQLITE3:(nil), 11, database corruption at line 79051 of [bf8c1b2b7a]
Oct 13, 2020 18:47:28.614 [0x7fafc3a23700] ERROR - SQLITE3:(nil), 11, statement aborts at 11: [select distinct metadata_items.id from metadata_items left join taggings on taggings.metadata_item_id=metadata_items.id left join tags on taggings.tag_id=tags.id left join media_ite
Oct 13, 2020 18:47:28.615 [0x7fafc3a23700] ERROR - Soci Exception handled: sqlite3_statement_backend::loadRS: database disk image is malformed
Thank you for the advice. It worked. I pulled a copy over to my windows machine, ran the repair, copied that back to the NAS, and then upgraded to 3483 and all is good again. That also fixed the issue I was having with downloading backups of the database using the Troubleshooting tab. Rock on.
Filed for future reference, and will scan for any DB corruption prior to posting next time. Thanks again!
I’m having the same issue with the collections, So your saying to fix it you pull a copy of the database from the NAS to your windows machine then run the command script and repair the database file?
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…
You have to copy the sqlite3 into the same directory as the db file you copied over to your PC. Then you have to CD to that directory in the command prompt (run as administrator). Then you run the commands as listed in the previous link for Windows.
