Error Main: Error in appHost.Init

[say170 1]

Hi Devs,

I'm unable to connect to emby on my QNAP.  I've checked the logs and found the following. 

2023-11-12 18:40:38.694 Error Main: Error in appHost.Init
    *** Error Report ***
    Version: 4.7.14.0
    Command line: /share/CACHEDEV1_DATA/.qpkg/EmbyServer/system/EmbyServer.dll -programdata /share/CACHEDEV1_DATA/.qpkg/EmbyServer/programdata -ffdetect /share/CACHEDEV1_DATA/.qpkg/EmbyServer/bin/ffdetect -ffmpeg /share/CACHEDEV1_DATA/.qpkg/EmbyServer/bin/ffmpeg -ffprobe /share/CACHEDEV1_DATA/.qpkg/EmbyServer/bin/ffprobe -defaultdirectory /share/CACHEDEV1_DATA/Public -updatepackage emby-server-qnap_{version}_x86_64.qpkg
    Operating system: Linux version 5.10.60-qnap (root@U16BuildServer172) (x86_64-QNAP-linux-gnu-gcc (toolchain config: [gcc-4.9.2 binutils-2.25 glibc-2.21]) 4.9.2, GNU ld
    Framework: .NET 6.0.20
    OS/Process: x64/x64
    Runtime: share/CACHEDEV1_DATA/.qpkg/EmbyServer/system/System.Private.CoreLib.dll
    Processor count: 2
    Data path: /share/CACHEDEV1_DATA/.qpkg/EmbyServer/programdata
    Application path: /share/CACHEDEV1_DATA/.qpkg/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)
    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)

Any thoughts?

[Luke 42077]

HI, looks like you installed the 4.8 beta channel and then tried to roll back to 4.7. Why did you do that?

[say170 1]

I wasn't aware I did.  Will upgrade and try again

[say170 1]

That fixed it.  Thanks for your help