Plex does not display movies sorted by all

Server Version#:1.16.5.1488
Player Version#:

I’m having a weird issue where Plex will not display all my movies. It displays reccomended, collections & playlists but does not display the full library. I can sort by unplayed, year, decade, genre and the like but not all. I’ve tested this on multiple clients, including Android & the windows web client. There are no errors that I am seeing other than a “Held Transaction for too long” warning.

I’ll post my logs if needed.

Any help would be appreciated.

Can you also provide a screenshot to illustrate the issue?

Plex Media Server Logs_2019-08-21_14-46-06.zip (2.8 MB)

Aug 21, 2019 14:42:59.041 [0x14fb4f3f9700] ERROR - Soci Exception handled: Cannot convert data to std::tm.

I’ve seen this error before. You basically have a media item with a corrupted date. It appears to be within the first 50 files you have. I can’t narrow it down any further.

First thing you can try is to clear out your agent cache, https://support.plex.tv/articles/202967376-clearing-plugin-channel-agent-http-caches/, then refresh your entire library.

If that doesn’t work, you can repair your database, https://support.plex.tv/articles/201100678-repair-a-corrupt-database/. That should remove the bad entry from the database. The movie will get added back on the next file scan and hopefully without the bad data.

If that doesn’t work, you’ll need to manually edit the database to remove the bad entry. This can be complicated, so if you don’t feel comfortable dealing with a database, PM me the file and I can take a look.

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.