If you have not already, we suggest setting your Plex username to something else rather than email which is displayed on your posts in forum. You can change the username at https://app.plex.tv/desktop#!/account
Welcome to our forums! Please take a few moments to read through our Community Guidelines (also conveniently linked in the header at the top of each page). There, you'll find guidelines on conduct, tips on getting the help you may be searching for, and more!

There was an unexpected error loading this library

jonnystannardjonnystannard Posts: 2Members, Plex Pass Plex Pass

Hi

"There was an unexpected error loading this library
Please visit our forums if you continue to experience problems"

I get the above error when I try to access either movies or TV series. Music is fine. If I set the view to folder then its fine, but I don't want that as I will have to go into each of the various folders as I have got films and TV series spread across multiple drives. I have restarted my PC, the server software. It is the same on my android phone as well, although I can go to discover on there and it will bring up the various lists, recently watched etc... but it wont list the movies under the browse tab it says there is no items to display.

I am running server Version 1.12.3.4973, everything was fine just over a week ago.

Any assistance would be appreciated. I am sure it is something simple and I have to say this is the first error I have had that has got me stumped.

Let me know if there are any logs i need to post.

Regards
Johnathan

Answers

  • jonnystannardjonnystannard Posts: 2Members, Plex Pass Plex Pass

    I've just realised that if I change the filter from by Title to year or anything else then it loads the library fine. Annoying as I only want to see them by Title.

  • christophermnchristophermn Posts: 10Members, Plex Pass Plex Pass

    Same for me. I'm running 1.13.1.5063 on Windows 10. This affects all my 'movie' libraries, but not TV. I even created a new Movie library, added some media, and the same error appears when I list by Title. Changing to any other option (release, date added, etc.) all work fine.

    This problem is relatively new for me, but I can't say exactly when it started of what version started it (I track the Plex Pass betas automatically).

    This problem is NOT present in 1.13.1.5063 on MacOS.

  • christophermnchristophermn Posts: 10Members, Plex Pass Plex Pass

    I tracked this down to a sqlite error, "Error: no such collation sequence: naturalsort" and I fixed it a repair using the command-line sqlite client.

  • mshocklemshockle Posts: 11Members, Plex Pass Plex Pass

    Hello, can you elaborate on the method you used to repair this error? I tried rebuilding the db from a dump but the error showed up then. Do I need to manually change the collation for that index? I apologize but I'm not familiar with sqlite. Thanks.

  • grgzgrgz Posts: 13Members, Plex Pass Plex Pass

    I just had this problem with 1.13.1.5063 on MacOS. I seem to have fixed it by switching the sort order in each affected library to By Year, and then back again to By Title. No database fiddling necessary.

  • mshocklemshockle Posts: 11Members, Plex Pass Plex Pass
    edited May 18

    Hmm, for me it seems to occur infrequently (my server is pretty active). It seemed to start when I added my classical music library (about 800 artists across 50k files). Some have suggested keeping libraries like that (which don't change often) to separate plex servers with only manual updates, but this seems silly when I hear of people with 12k+ movies on 45TB NAS on a single server going by without issue (mine is 20TB so far but the classical is only 500gb).

    I will say though that I did what you suggested and those libraries suddenly started moving snappier, but I think there's a more permanent solution out there.

  • sol_slsol_sl Posts: 7Members, Plex Pass Plex Pass

    @christophermn said:
    I tracked this down to a sqlite error, "Error: no such collation sequence: naturalsort" and I fixed it a repair using the command-line sqlite client.

    @chrustalew@gmail.com , can you please tell us the steps/commands you used to repair the corruption? Seems like quite few people are having this isssue.

  • plexcahillplexcahill Posts: 13Members, Plex Pass Plex Pass

    I just tried to repair my database(on windows) and got the unknown collation error. My plex install goes back a long way.

    dump.sql contains:

    CREATE INDEX 'index_title_sort_naturalsort' ON 'metadata_items' ('title_sort' COLLATE naturalsort);

  • MacChadMacChad Posts: 1Members, Plex Pass Plex Pass

    same issue here - I tried the sorting change as described above to no avail...it just made everything disappear and I had to switch it over to the plex cloud server and then back to my local server for the libraries to appear again. and this still gives the same error:
    cmd: sqlite3 com.plexapp.plugins.library.db "PRAGMA integrity_check"
    Yields:
    Error: no such collation sequence: naturalsort

  • mshocklemshockle Posts: 11Members, Plex Pass Plex Pass
    edited May 22

    I wonder if this is the package improbability.net/#sqlitenatural. I've found this missing on several different sqlite installs (mac,windows,ubuntu) so I assume it's an optional package. Will perform some testing later today if possible.

    I'd also like to comment that I recreated my plex database (as I wanted to separate my music from tv/movie collections as the former doesn't require regular updates like tv/movie would) and the issue is (not surprisingly) found on the two fresh installs (mac,win).

Sign In or Register to comment.