Guide searches return zero results

[KLeeStark]

All guide searches return zero results regardless of search string. Same result with Windows client and via browser.

NPVR.log shows:

2021-04-10 16:31:47.033 [ERROR][1] Unexpected error in FirstLetterSearch(): Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 11: 'database disk image is malformed'.
  at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
  at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
  at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
  at Microsoft.Data.Sqlite.SqliteCommand.ExecuteDbDataReader(CommandBehavior behavior)
  at System.Data.Common.DbCommand.ExecuteReader()
  at NextPVR.TV.SearchGuide.FreeTextSearch(String freeText)

Guide is otherwise browsable; guide updates and recordings are occurring as scheduled.

Is this recoverable, or do I need to start over clean?

[sub]

Yeah, it does sound like your npvr.db3 database file is damaged. A quick google indicates a few suggestions:

https://stackoverflow.com/questions/1825...e/18260642

[KLeeStark]

Thanks so much for the link.
Appears to be working normally after doing the following:
[note to others: this is an overview, not a complete list of steps!]

Code:

net stop "NextPVR Service"
sqlite3 npvr.db3 .recover | sqlite3 npvr-NEW.db3
ren npvr.db3 npvr-BAD.db3
ren npvr-NEW.db3 npvr.db3
net start "NextPVR Service"

[then "Update EPG" from Settings dialog on server:8866]