Collections issues after 'mostly' successful migration to new hardware

[eblue 1]

I recently rebuilt my server that hosts Emby from scratch. I thought that I had followed the instructions for migrating properly. Just about everything seems to work as expected, except for a couple of issues with my Collections.

 

• I can no longer create new collections but I can modify existing collections.
• The Collections section in the Metadata manager does not work at all.
• If I try to add a new collection, a new, non-functional 'Collections' item is created in the Library manager
• The logs seem to indicate that something is still looking for my old Media Browser-based install location eg.: 'C:\Users\Administrator\AppData\Roaming\MediaBrowser-Server\data\collections'. My current install path is actually: C:\Users\eBlue\AppData\Roaming\Emby-Server\programdata\data\collections
• I suspect that the variable %AppDataPath% might somehow still be pointing to the old install location at least as it relates to Collections
• I'm not certain if this caused the issue, but I did restore a backup from my old server after doing a manual migration of my data.

 

I'm comfortable with tweaking files or I could even modify the db using DB Browser. I just need some help in figuring out what needs to be changed.

 

-e.B

[Luke 42083]

Hi there, did you check out our  help article on migrating collections?

https://support.emby.media/support/solutions/articles/44001173192-collections-manual-migration

[eblue 1]

Hi there, did you check out our  help article on migrating collections?

https://support.emby.media/support/solutions/articles/44001173192-collections-manual-migration

 

Hi Luke. Yes, I have referred to that article. I have confirmed that all of the collections.xml files are correct and point to the correct locations. All of my existing Collections are available in Emby and work as expected and can even be modified. In fact, I can even manually create a new Collection in the collections folder and it will show up in Emby. I guess the primary issue is that I can no longer create new Collections from the Emby browser interface. Whenever I attempt to create a new collection, the GUI just displays the spinning busy doo-dad and never completes.

 

Thanks,

-e.B

[Happy2Play 9783]

Hi Luke. Yes, I have referred to that article. I have confirmed that all of the collections.xml files are correct and point to the correct locations. All of my existing Collections are available in Emby and work as expected and can even be modified. In fact, I can even manually create a new Collection in the collections folder and it will show up in Emby. I guess the primary issue is that I can no longer create new Collections from the Emby browser interface. Whenever I attempt to create a new collection, the GUI just displays the spinning busy doo-dad and never completes.

 

Thanks,

-e.B

 

You would need to post a server log and tell us the time this happened.

Edited February 12, 2020 by Happy2Play

[Luke 42083]

HI there, yes a server log would be the best way to find out what happened. Thanks.

[eblue 1]

Here is a log which was taken shortly after I attempted to create a 'Rugrats Collection". You can see that the error generated is referencing the old install folder C:\Users\Administrator\AppData\Roaming\MediaBrowser-Server\data\collections

 

Thanks,

e.B

 

embyserver.txt

[Happy2Play 9783]

You migrated databases from one installation to another, correct?  Looking at that naming scheme "\MediaBrowser-Server\" that would appear to before portable tokens were added to the database.

 

If this is correct your only option would be editing the database, but I honestly could not tell you everything you would need to change.

 

But this specifically would be MediaItems table, sort Type column with 3, and Path column with Collections and Path would be "%AppDataPath%\collections"

[Luke 42083]

OK yes i wouldn't suggest migrating a db file from a very old installation. While you can do that with a newer installation, the older versions were saving database entries with full paths, and now that those paths are no longer available, there will be problems. You might be able to fix up your db manually as happy2play is suggesting.

[eblue 1]

I was able to edit the database using DB Browser and have replaced the old value with '%AppDataPath%\collections' and voila my Collections are now working again!

 

Thanks for all of the help!

 

-e.B

[Happy2Play 9783]

You will/might have issues with the Images column with images pointing to the wrong path also.  I know there is a old topic somewhere on this but they probably point to "C:\Users\Administrator\AppData\Roaming\MediaBrowser-Server\metadata\library\...." instead of "%MetadataPath%\library\...".

[eblue 1]

So I did a bit more searching and found this column. Has about 70000 records that need to be modified. Fixing something like this is wayyyyy beyond by SQL-fu skill set. 

 

 

Any suggestions?

 

-e.B

 

[Luke 42083]

The TypedBaseitems table in the latest version is not used anymore.

[Happy2Play 9783]

So I did a bit more searching and found this column. Has about 70000 records that need to be modified. Fixing something like this is wayyyyy beyond by SQL-fu skill set. 

 

 

Any suggestions?

 

-e.B

Something like this.

https://emby.media/community/index.php?/topic/63573-36051-metadata-people-empty/?p=631143