Refresh Guide Failed

[acozad12 1]

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

[Happy2Play 9780]

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

[acozad12 1]

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

[Luke 42077]

Hi, what exactly did you run?

[acozad12 1]

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

[Luke 42077]

OK, yes that's likely what you need to do. Let us know how you get on. Thanks.

[acozad12 1]

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.

[acozad12 1]

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.

[Luke 42077]

Hi, these you can delete it. Thanks for the feedback.