say170 1 Posted November 12, 2023 Share Posted November 12, 2023 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? Link to comment Share on other sites More sharing options...
Solution Luke 37100 Posted November 12, 2023 Solution Share Posted November 12, 2023 HI, looks like you installed the 4.8 beta channel and then tried to roll back to 4.7. Why did you do that? Link to comment Share on other sites More sharing options...
say170 1 Posted November 12, 2023 Author Share Posted November 12, 2023 I wasn't aware I did. Will upgrade and try again Link to comment Share on other sites More sharing options...
say170 1 Posted November 12, 2023 Author Share Posted November 12, 2023 That fixed it. Thanks for your help 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now