nightknight 5 Posted February 28 Share Posted February 28 emby had a restart after an update and not it wont run, this is the error in my log. my library is massive and prefer not to start over after years. how can i fix this 2024-02-27 23:34:57.095 Error Main: Error in appHost.Init *** Error Report *** Version: 4.8.1.0 Command line: C:\Users\User\AppData\Roaming\Emby-Server\system\EmbyServer.dll Operating system: Microsoft Windows 10.0.26058 Framework: .NET 6.0.26 OS/Process: x64/x64 Runtime: C:/Users/User/AppData/Roaming/Emby-Server/system/System.Private.CoreLib.dll Processor count: 16 Data path: C:\Users\User\AppData\Roaming\Emby-Server\programdata Application path: C:\Users\User\AppData\Roaming\Emby-Server\system SQLitePCL.pretty.SQLiteException: Error: no such column: Album - insert into fts_search8(RowId, Name, OriginalTitle, SeriesName, Album) select id, replace(replace(Name,'''',''),'.',''), replace(replace(OriginalTitle,'''',''),'.',''), replace(replace(SeriesName,'''',''),'.',''), replace(replace(Album,'''',''),'.','') from MediaItems SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown. at SQLitePCL.pretty.SQLiteDatabaseConnection.PrepareStatement(String sql, ReadOnlySpan`1& 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, SyncRepository syncRepo) 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.ReadOnlySpan`1[System.Byte] ByRef) Link to comment Share on other sites More sharing options...
Gilgamesh_48 944 Posted February 28 Share Posted February 28 (edited) 12 minutes ago, nightknight said: emby had a restart after an update and not it wont run, this is the error in my log. my library is massive and prefer not to start over after years. how can i fix this 2024-02-27 23:34:57.095 Error Main: Error in appHost.Init *** Error Report *** Version: 4.8.1.0 Command line: C:\Users\User\AppData\Roaming\Emby-Server\system\EmbyServer.dll Operating system: Microsoft Windows 10.0.26058 Framework: .NET 6.0.26 OS/Process: x64/x64 Runtime: C:/Users/User/AppData/Roaming/Emby-Server/system/System.Private.CoreLib.dll Processor count: 16 Data path: C:\Users\User\AppData\Roaming\Emby-Server\programdata Application path: C:\Users\User\AppData\Roaming\Emby-Server\system SQLitePCL.pretty.SQLiteException: Error: no such column: Album - insert into fts_search8(RowId, Name, OriginalTitle, SeriesName, Album) select id, replace(replace(Name,'''',''),'.',''), replace(replace(OriginalTitle,'''',''),'.',''), replace(replace(SeriesName,'''',''),'.',''), replace(replace(Album,'''',''),'.','') from MediaItems SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown. at SQLitePCL.pretty.SQLiteDatabaseConnection.PrepareStatement(String sql, ReadOnlySpan`1& 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, SyncRepository syncRepo) 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.ReadOnlySpan`1[System.Byte] ByRef) There is an discussion of this in the beta forums. The bottom line is that the new beta update was screwed up big time. Emby, I believe, did not take enough care to make sure the beta they released failed to run after installing in any way. Many of the folks there have reported they were able to roll back to the previous ver without too much problem. I was not so lucky and something really messed up most everything and I am having to do a "Remove Emby Server and all traces" followed by a new install of the release ver. The libraries and everything will be rebuilding for the next couple of days. I hope you are able to get your instillation working again. Basically Emby pulled the new beta after all this happened. Edited February 28 by Gilgamesh_48 Link to comment Share on other sites More sharing options...
nightknight 5 Posted February 28 Author Share Posted February 28 wow this is unfortunate my system.old dont work either. this is not good Link to comment Share on other sites More sharing options...
Solution darkassassin07 429 Posted February 28 Solution Share Posted February 28 Installing the previous beta directly over the broken one should sort you back out: https://github.com/MediaBrowser/Emby.Releases/releases/tag/4.9.0.5 The broken version has been pulled from release. Link to comment Share on other sites More sharing options...
nightknight 5 Posted February 28 Author Share Posted February 28 23 minutes ago, darkassassin07 said: Installing the previous beta directly over the broken one should sort you back out: https://github.com/MediaBrowser/Emby.Releases/releases/tag/4.9.0.5 The broken version has been pulled from release. you mean just overwrite the system folder with the prev versions? Link to comment Share on other sites More sharing options...
darkassassin07 429 Posted February 28 Share Posted February 28 Yes. Keeping your programdata folder, but replacing the system folder. (making a backup copy first is never a bad idea) Link to comment Share on other sites More sharing options...
nightknight 5 Posted February 28 Author Share Posted February 28 (edited) 1 minute ago, darkassassin07 said: Yes. Keeping your programdata folder, but replacing the system folder. (making a backup copy first is never a bad idea) indeed it did, thanks !!!!!!! my 400gb programdata folder with countless days of manually renaming and locking metadata Edited February 28 by nightknight 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