Help migrating "date added" from 1.23 on ubuntu to 1.29 on truenas

Ok, the long and short of it is I have an existing plexserver v1.23 on an old ubuntu system. I just build a new rack truenas box and isntalled plexserver 1.29.

The question is, can I import the database from 1.23 to 1.29 even tho it appears the format of stored dates has changed in newer version?

The issue is, I sort by “date last added”, and I am migrating all of the files from multiple smaller storage devices to a large truenas pool, the newest version of plex is now sorting everything by the new date added.

I was able to rip tables for “viewed” and “unviewed” data and got that working correctly, but I’d like the original date added to be pulled into the new server. What I noticed in viewing the databases is that the newest version is using Unix time for date/time fields as opposed to the old database using standard date/time formats.

Can I simply move all of the files, then copy the database files from the old server to the new even tho the version disparity is pretty large?

Thanks in advance!

Great question about date formats.
Looks like you’re doing good things so far.
Reminds me of PlexDBRepair in some ways.

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