SQL logic error or missing database no such index: IX_History_EpisodeId

Help & Support
1

Sonarr version (exact version): 2.0.0.5228
Mono version (if Sonarr is not running on Windows):
OS:
Debug logs: https://pastebin.com/gmk1aaUN
(Make sure debug logging is enabled in settings and post the full log to hastebin/pastebin/dropbox/google drive or something similar, do not post them directly here. Post in .txt not .doc, .rtf or some other formatted document)
Description of issue: Sonarr won’t start. Gives error SQL logic error or missing database
no such index: IX_History_EpisodeId

2

That index should exist from an early migration, though it missing wouldn’t break anything I’m a bit surprised it’s not there.

You could add it back with a sqlite editor: CREATE INDEX [IX_History_EpisodeId] ON [History] ([EpisodeId]); to satisfy the migration for now.

3

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.