I’m trying to view TV shows by episode in order to find dupes but I keep getting this error. Looking at the logs doesn’t reveal anything particularly telling:
Feb 23, 2020 12:11:24.963 [0x700006e3c000] ERROR - Unknown metadata type: folder
Feb 23, 2020 12:11:25.020 [0x700006e3c000] ERROR - Soci Exception handled: Cannot convert data to std::tm.
These occur when I choose TV shows by episode. The page has a retry button but it just loads the TV show names rather than the episodes. All other views appear to be working.
I have optimized the database, updated metadata and even rebuilt the database with no change to this. Does anyone have any other ideas?
For completeness, I checked on the iPad version and it gives a slightly different error on the client side, “the active filter has no matches”. On the server it gives only the “Soci Exception”.
So after fighting this for several hours, I finally got to the bottom of this. The database that powers PMS is SQLite. For some reason it allows values in datetime columns that are not a valid date time or NULL. This is how you fix this issue.
1.) Stop Plex Media Server
2.) Download SQLite Browser @ https://sqlitebrowser.org/
3.) Open up your Plex DB on my linux machine it is under: Library/Application Support/Plex Media Server/Plug-in Support/Databases
4.) Export out all the tables as CSV to a folder
5.) Open up your favorite text editor and search for << , look for <<NULLSTR in datetime fields
6.) Note the table(s) and the IDS where that occurs
7.) Go back to SQLlite and open up a sql prompt
8.) for each instance of the NULLSTR delete it by doing
delete from where id = OF NULLSTR
I just tried that and I found no nulls. I noticed that there aren’t any datetime columns though, the “last_accessed_time_t” is a BIGINT and while it does allow nulls, querying both tables that have this column for null returns zero rows.
