acozad12 1 Posted May 1, 2022 Share Posted May 1, 2022 Hi Emby Community, First time posting. Hope I am doing this right. Hoping someone can point me in the right direction on how to fix this error that I am currently having. I have listed below the current error that I am receiving. I have attached my log to this message if anyone would like to take a look. I am currently running Emby 4.7.0.36 in an Unraid Docker. Please let me know if you need any further information. Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown. at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc) at SQLitePCL.pretty.StatementImpl.MoveNext() at Emby.Sqlite.SqliteExtensions.ExecuteQuery(IStatement This)+MoveNext() at Emby.Server.Implementations.Data.SqliteItemRepository.QueryItemsInTransaction[T](InternalItemsQuery query, IDatabaseConnection db, String[] columnsToSelect, Func`5 rowReaderFn, Boolean singleResult, String methodName) at Emby.Server.Implementations.Data.SqliteItemRepository.GetInternalItemIdsListInTransaction(InternalItemsQuery query, IDatabaseConnection connection) at Emby.Server.Implementations.Data.SqliteItemRepository.CleanPrograms() at Emby.LiveTV.LiveTvManager.RefreshChannels(IProgress`1 progress, CancellationToken cancellationToken) at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker.ExecuteInternal(TaskOptions options) embyserver.txt Link to comment Share on other sites More sharing options...
Solution Happy2Play 8252 Posted May 1, 2022 Solution Share Posted May 1, 2022 Unfortunately, you have a corrupt database. SQLiteException: Corrupt: database disk image is malformed You will need to reset your database but can try to recover it. Corrupt Database : Emby Link to comment Share on other sites More sharing options...
acozad12 1 Posted May 1, 2022 Author Share Posted May 1, 2022 (edited) Thank you for your reply. I followed the corrupt database link and ran SQ Lite and it was clean with no errors. Should I just delete the data base and have Emby rebuild it? Any other suggestions would be great on how to fix or rebuild this data base. The strange part is that its just the TV guide. Thank you for your time. Edited May 1, 2022 by acozad12 Link to comment Share on other sites More sharing options...
Luke 37026 Posted May 1, 2022 Share Posted May 1, 2022 Hi, what exactly did you run? Link to comment Share on other sites More sharing options...
acozad12 1 Posted May 1, 2022 Author Share Posted May 1, 2022 (edited) Good Afternoon, Thank you for reaching out. I ran and followed the corrupt database link that Happy2play provided me. I ran my library.db through SQ Lite and it finished with no errors. I am thinking of doing the reset option at the bottom of the list, Changing the library.db to corrupt and doing a re-scan. Edited May 1, 2022 by acozad12 Link to comment Share on other sites More sharing options...
Luke 37026 Posted May 1, 2022 Share Posted May 1, 2022 OK, yes that's likely what you need to do. Let us know how you get on. Thanks. Link to comment Share on other sites More sharing options...
acozad12 1 Posted May 2, 2022 Author Share Posted May 2, 2022 Ok, I will go ahead and proceed with making those changes and getting back to you when everything is completed. Thank you again for taking a look at my post. You guys are amazing. 1 Link to comment Share on other sites More sharing options...
acozad12 1 Posted May 2, 2022 Author Share Posted May 2, 2022 Good Morning, I went head and renamed the old library to corrupted and re-scanned my library and it is back to normal. That did take awhile to rebuild but all good again. One last question. Can I delete the old corrupted library? Don't see why I would keep it since it is bad. Thank you again for your assistance on this. Life saver. Link to comment Share on other sites More sharing options...
Luke 37026 Posted May 2, 2022 Share Posted May 2, 2022 Hi, these you can delete it. Thanks for the feedback. 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