Fossil Forum
Post: Quick integrity check failing in repositories with FTS4 search index
I recently updated my backup script to perform an integrity check (with fossil test-integrity --quick) on the repository backups I made, which failed for several of them with this message:
SQLITE_ERROR(1): no such function: title in "SELECT rowid, x.'title', x.'body' FROM 'repository'.'ftscontent' AS x"
SQL: PRAGMA repository.quick_check
quick_check failed!
A quick check (of the manual kind) showed that the affected repositories all had search indexing enabled, apparently back when that was done with FTS4. So I rebuilt the search index, which switched the search engine over to FTS5, and no problems have occurred since then.
It was easy to fix, but I thought I’d let people know just in case someone else runs into it. Z
but I thought I’d let people know just in case someone else runs into it.
Thanks for sharing. I recognized it as a problem with FTS (given the ftscontent in the output) but wasn't certain what to do about it since I don't use FTS (at least not yet). Z