Running 1.11.0.4666 on Windows 10
I currently have 3329 movies in my library.
If I view the library “By Title”, I get the error “There was an unexpected error loading this library”. If I view by most other fields (such as “By Release Date”) it views fine.
If I go back to viewing “By Title”, and filter “By Year”, some years will load fine, while other years will show the “There was an unexpected error loading this library”.
I made a copy of the database and inspected the metadata_items table, but could not find anything odd about the records for the years where the library will not load By Title. (There are a number of years where this is happening - not just one).
I suspect that the number of movies isn’t the issue since I’m sure that people are running plex with orders of magnitude more files. I really don’t want to build the library/DB again from scratch, since there are a number of manual matches that were required for a lot of the films.
Any ideas on what to look at next to try to fix this? Is there anything in the logs that would give a clue?
Thanks!!!
I tried both checking for corruption (none) and running the repair, but it didn’t help 
How much RAM is in the machine and where is the Plex data folder stored?
With that big a server, you might want to consider a dedicated SSD for it.
16GB RAM with an i7-6700 @ 3.4Ghz processor.
Data folder is on a HDD (but transcode folder is on an SSD).
May I see a full set of log files please?
(first, enable debug logging, then restart Plex server, then wait 2 minutes, then fetch log files)
https://support.plex.tv/articles/200250417-plex-media-server-log-files/
Thanks in advance for your help!!!
Alright, some progress.
There appear to be some invalid data in your database. Particularly it appears that some date strings of a few of your movies are invalid. Which would then make a database query error out like you have experienced.
If you agree to send me your main database file, I can relay it to our expert.
Please zip it beforehand and send me the download link per PM.
PM sent. Curious - where in the logs can you see that invalid dates were found in the DB?
Our expert found it. There must be somewhere a 500 error, which was caused by some invalid data during the database query.
@BradInToronto said:
PM sent. Curious - where in the logs can you see that invalid dates were found in the DB?
Sorry, I have received no personal message on this forum. How did you send it?
Sorry, I have received no personal message on this forum. How did you send it?
PM resent. Not sure what I did wrong yesterday! Thanks again!
The amazing Plex team found the corrupted files in my DB and even sent me back a cleaned up file! Bravo Plex support!!!
