Migration of View History is failing due to mismatched table size

Plex Media Server NAS & Devices
1

Server Source Version#: QNAP TS-469 Pro firmware 4.3.4.1652 Build 20210413
Server Target Version#: TrueNAS-12.0-U5.1

Both are running Plex server Version 1.24.0.4930

I had two servers running completely separate instances of Plex server. I decided to migrate both of them into one single server to make it easier to manage. Moved all the files, then I created the libraries to account for the changes. Now I want to migrate the watch history from source server to target server.

I’m trying to run the instructions here:

I stopped both of the services, downloaded the com.plexapp.plugins.library.db from the Source server, then I uploaded it to the target server into the same folder where I cound the other com.plexapp.plugins.library.db file. Made a backup of the target file, then I ran the commands. The echo .dump command ran without error. But, when I try to do the second command, cat settings.sql, I get this error:

Error: near line 2012: table metadata_item_settings has 13 columns but 14 values were supplied

If I turn on the server as-is, the Watched history does not reflect what I had on the source server.

Any advice?

2

You cannot combine the “watched” status of two servers.
You can only import the watched status from an older server into a newly created server (which hasn’t recorded any “watched” events of its own, yet).

3

Damn. That’s lame. At least I know to not waste time with it anymore. Thank you for the quick response.

4

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