Cannot convert data to std::tm after migration from macOS to Raspbian

Plex Media Server Desktops & Laptops
1

Server Version#: 1.14.1.5488
Player Version#: N/A

I’ve migrated my Plex server setup from a mac mini to a Raspberry, and after migration, one of my libraries displays the message “There was an unexpected error loading this library”. When I filter my movie library, titles display just fine, but when I clear the filter and select “All”, I get the error again.

I was able to track down the specific title that is causing the problem, and I can see in the log files the following error:

ERROR - Exception thrown during analysis: Cannot convert data to std::tm.

I stopped the Plex Server, and fired up the sqlite3 client and opened the com.plexapp.plugins.library.db database to find out what the problem is, but I am unable to identify the issue.

I read on the forum that sometimes the date formats are not correct, but in this case, all dates conform to the specified syntax (‘yyyy-mm-dd hh:mm:ss’), so I don’t know what to look for.

sqlite> select * from metadata_items where id=298;
                     id = 298
...
originally_available_at = 2005-10-14 00:00:00
           available_at = 
             expires_at = 
           refreshed_at = 2019-01-16 22:29:26
                   year = 2005
               added_at = 2009-10-10 16:16:49
             created_at = 2009-10-10 16:16:49
             updated_at = 2019-01-16 22:29:26
             deleted_at = 
...
             changed_at = 160497
   resources_changed_at = 160497

Please, can anyone help? I can provide the server logs or the database.

Thanks. Regards.

2

have you manually made any changes to the db outside of plex?

or imported from an itunes xml that didn’t come from itunes?

3

I didn’t manually alter the database. Just executed select queries to try to track down the issue.

The whole directory structured was copied ‘as is’ from the original system, as indicated on the following link:

The only change I made was copying values from the original com.plexapp.plexmediaserver.plist into the Preferences.xml, with the equivalent syntax.

4

if there is a specific title or file that you have tracked it down to, you should try moving it out if your library, then do clean bundles and empty trash, then see if you still have any errors.

If the errors are then cleared and everything works, then most like you have some kind of corrupted or otherwise incompatible file.

5

I tried that. Removed the file, re-analyzed the library, and it worked for a few minutes, and then again, same error “There was an unexpected error loading this library”.

I downloaded the logs again, and now I have hundreds of entries like this:

ERROR - Exception thrown during analysis: Cannot convert data to std::tm.

I don’t know if this is the reason, but now I can’t identify a particular item.

I think the database is not corrupted, but somehow Plex doesn’t like some information on it. The problem is I have no idea wha it is.

Any ideas? Anybody willing to take a look at my logs and/or database?

6

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