Moving libraries to a different disk

[jellyfin]

I found out more!

Code:

sqlite> SELECT Name,Path,HEX(guid) as guid,HEX(ParentId) as parentid,TopParentId,PresentationUniqueKey,UserDataKey FROM typedbaseitems WHERE hex(ParentId) = (SELECT hex(guid) FROM typedbaseitems WHERE type = 'MediaBrowser.Controller.Entities.AggregateFolder') ORDER BY Name ;

INTERNET|/Volumes/XTRMQ/MEDIA/INTERNET|F17B5FB1A7A65125BCFF69C95D57F289|37AA7CF214E52522CCEDED48F6553502|b15f7bf1a6a72551bcff69c95d57f289|b15f7bf1a6a72551bcff69c95d57f289|b15f7bf1-a6a7-2551-bcff-69c95d57f289
INTERNET|/Volumes/XTRMQ/MEDIA/INTERNET|E7624A7F08ADAD3B05693ACDAC81F61A|37AA7CF214E52522CCEDED48F6553502|7f4a62e7ad083bad05693acdac81f61a|7f4a62e7ad083bad05693acdac81f61a|7f4a62e7-ad08-3bad-0569-3acdac81f61a

MOVIES|/Volumes/XTRMQ/MEDIA/MOVIES|BDFFC07943EEECE12ABC61E3FADDF700|37AA7CF214E52522CCEDED48F6553502|79c0ffbdee43e1ec2abc61e3faddf700|79c0ffbdee43e1ec2abc61e3faddf700|79c0ffbd-ee43-e1ec-2abc-61e3faddf700
MOVIES|/Volumes/XTRMQ/MEDIA/MOVIES|E6026DCC3C642CEB1C17AB4A881FE7DA|37AA7CF214E52522CCEDED48F6553502|cc6d02e6643ceb2c1c17ab4a881fe7da|cc6d02e6643ceb2c1c17ab4a881fe7da|cc6d02e6-643c-eb2c-1c17-ab4a881fe7da

PRIVATE|/Volumes/XTRMQ/MEDIA/PRIVATE|A6EC99ABFD114741DCAB49F0D087A2C9|37AA7CF214E52522CCEDED48F6553502|ab99eca611fd4147dcab49f0d087a2c9|ab99eca611fd4147dcab49f0d087a2c9|ab99eca6-11fd-4147-dcab-49f0d087a2c9
PRIVATE|/Volumes/XTRMQ/MEDIA/PRIVATE|19EAA92527086AE320FE1AFC3EEFD57D|37AA7CF214E52522CCEDED48F6553502|25a9ea190827e36a20fe1afc3eefd57d|25a9ea190827e36a20fe1afc3eefd57d|25a9ea19-0827-e36a-20fe-1afc3eefd57d

SERIES|/Volumes/XTRMQ/MEDIA/SERIES|EAB3D01034C1B9E26F88B0336B3D681C|37AA7CF214E52522CCEDED48F6553502|10d0b3eac134e2b96f88b0336b3d681c|10d0b3eac134e2b96f88b0336b3d681c|10d0b3ea-c134-e2b9-6f88-b0336b3d681c
SERIES|/Volumes/XTRMQ/MEDIA/SERIES|CB97ECCF0EE8608C61CDAE4EEC30703F|37AA7CF214E52522CCEDED48F6553502|cfec97cbe80e8c6061cdae4eec30703f|cfec97cbe80e8c6061cdae4eec30703f|cfec97cb-e80e-8c60-61cd-ae4eec30703f

This is the root for the doubled entries!

In the link mentioned above, there is a second set of commands for such a migration and here, the problem is mentioned.

Sadly, the given syntax to remove the doubled entries does not work:

Code:

sqlite> UPDATE TypedBaseItems Set ParentId=x'destGUID', TopParentId=x'destTopParentID' WHERE ParentId = x'sourceGUID';
Parse error: unrecognized token: "x'destGUID'"
  UPDATE TypedBaseItems Set ParentId=x'destGUID', TopParentId=x'destTopParentID'
                      error here ---^