DSM 6.x to DSM 7.1.1-42962 Update 6 upgrade -- Emby fails startup

[jasondeb17 2]

After copying my data, setting permissions and attempting to start the log has this error:

 

2024-11-12 11:54:17.758 Error Main: Error in appHost.Init
    *** Error Report ***
    Version: 4.7.14.0
    Command line: /volume1/@appstore/EmbyServer/system/EmbyServer.dll -programdata /var/packages/EmbyServer/var -ffdetect /var/packages/EmbyServer/target/bin/ffdetect -ffmpeg /var/packages/EmbyServer/target/bin/ffmpeg -ffprobe /var/packages/EmbyServer/target/bin/ffprobe -nolocalportconfig -ignore_vaapi_enabled_flag -pidfile /var/packages/EmbyServer/var/EmbyServer.pid -defaultdirectory /volume1/Public -updatepackage emby-server-synology7_{version}_x86_64.spk
    Operating system: Linux version 4.4.180+ (root@build3) (gcc version 8.5.0 (GCC) ) #42962 SMP Mon May 29 14:38:23 CST 2023
    Framework: .NET 6.0.20
    OS/Process: x64/x64
    Runtime: volume1/@appstore/EmbyServer/system/System.Private.CoreLib.dll
    Processor count: 2
    Data path: /var/packages/EmbyServer/var
    Application path: /volume1/@appstore/EmbyServer/system
    SQLitePCL.pretty.SQLiteException: Error: no such column: IsFolder - create index if not exists idx_MediaItems36 on MediaItems(SeriesPresentationUniqueKey,Type,IsFolder,IsVirtualItem) where SeriesPresentationUniqueKey not null;create index if not exists idx_MediaItems10 on MediaItems(Type,TopParentId,Id);create index if not exists idx_MediaItems11 on MediaItems(Type,TopParentId,PresentationUniqueKey);create index if not exists idx_MediaItems46 on MediaItems(TopParentId,IsVirtualItem) where TopParentId not null;create index if not exists idx_MediaItems47 on MediaItems(TopParentId,Type,IsVirtualItem,PresentationUniqueKey,DateCreated) where TopParentId not null;create index if not exists idx_MediaItems48 on MediaItems(TopParentId,IsFolder,IsVirtualItem,PresentationUniqueKey,DateCreated) where TopParentId not null;create index if not exists idx_MediaItems49 on MediaItems(TopParentId,MediaType,IsVirtualItem,PresentationUniqueKey) where TopParentId not null;create index if not exists idx_MediaItems50 on MediaItems(Type, TopParentId, AlbumId) where TopParentId not null;create index if not exists idx_MediaItems51 on MediaItems(Type,IsSeries) where Type=27;create index if not exists idxItemLinks_1 on ItemLinks(LinkedId, Type, ItemId)^M
    SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
       at SQLitePCL.pretty.SQLiteDatabaseConnection.PrepareStatement(String sql, String& tail)
       at SQLitePCL.pretty.DatabaseConnection.PrepareAllEnumerator(IDatabaseConnection This, String sql)+MoveNext()
       at SQLitePCL.pretty.DatabaseConnection.ExecuteAll(IDatabaseConnection This, String sql)
       at Emby.Server.Implementations.Data.SqliteItemRepository.Initialize(SqliteUserDataRepository userDataRepo, IUserManager userManager)
       at Emby.Server.Implementations.ApplicationHost.InitDatabases()
       at Emby.Server.Implementations.ApplicationHost.Init()
       at EmbyServer.HostedService.StartAsync(CancellationToken cancellationToken)
    Source: SQLitePCL.pretty
    TargetSite: SQLitePCL.pretty.IStatement PrepareStatement(System.String, System.String ByRef)

Server doesn't start.

[Carlo 4560]

DSM 7 was a breaking change for many 3rd party Synology apps.  DSM 7 did a revamp of the way application run moving forward.

The major issue for your Emby installation is that programs are no longer allowed to run in the previous location.

Follow the instructions in the first post, but keep in mind that was written for version 7.0 but you're on 7.1
The guide will refer the "latest" version at the time of writing.  Just download the latest version from our website download section and you'll be fine.
In case you're not aware DSM 7.2 is another breaking change. It requires a new version Emby to be installed but that's it.

On our website in the download section, you'll see 3 separate choices of DSM to download for.
You'll be using the DSM 7 version which is for both 7.0 and 7.1. Once you update to DSM 7.2 you again switch and use the 7.2 downloads.

Carlo

[Luke 42077]

@jasondeb17please let us know if this helps. Thanks !

[jasondeb17 2]

I had installed via the Synology package manager --  that is version that failed for me.

Downloading the package directly from your side and re-installing the package manually solved the problem.  

Thanks guys.

[Carlo 4560]

Great to hear!