library.db difference

[MagicPinball 3]

I am running Windows Emby version 4.2.1.  I have been taking manual backups as directed.  I recently had an issue with my dedicated HTPC and had to reset the PC.  I reinstalled Emby Server, copied files from backup, started Emby and identified my 3 libraries and let it scan them.  At this point all worked fined.  Verified my Movies and TV Shows are all in Emby.  All Movies and TV Shows showed unwatched.

 

I went to use SQLite DB Browser and open the old library.db file and attached the new library.db file.  Got the following error:

Result: table newlib.UserDatas has 12 columns but 14 values were supplied

At line 1:

replace into newlib.UserDatas select * from UserDatas

 

How can this be fixed?

[Luke 42086]

Hi, I suppose you could add the columns to the old database. That may work.

[MagicPinball 3]

No, the new library.db is missing 2 fields which are in the old library: key nvarchar, lastPlayedDate datetime

Why does my old 4.2.1 library.db contain two additional fields?

All I want to do is set the played flag for my played movies.

[Happy2Play 9785]

No, the new library.db is missing 2 fields which are in the old library: key nvarchar, lastPlayedDate datetime

Why does my old 4.2.1 library.db contain two additional fields?

All I want to do is set the played flag for my played movies.

I would assume you have a install that is older then 4.2 (ie upgraded install from previous versions).

 

Same discussions here with trying to do a manual migration without the plugin.  I would assume if the plug can do it that is can be done manually also.

 

https://emby.media/community/index.php?/topic/77238-unable-to-migrate-to-new-server/