The standard search function (using the search box in the main GUI) no longer produces any results, even for simple search terms like "file" or "the". The basic search function (prefixing the search term with a forward slash) works well. I saw this thread that suggests the issue may be database corruption: Search function not working anymore?
I've updated my installation of Joplin to v3.0.15, and the problem still occurs.
Below are 2 screenshots showing the results for searches with and without the forward-slash prefix.
I also don't understand why I haven't had any response to my calls for support - please respond! If there's something inappropriate about my request, please tell me. Thank you.
Thanks for your replies @laurent
As I said in an earlier post, I have updated to Joplin V3.0.15 and the problem still occurs.
I followed your suggestions. Before enabling debugging, I checked the Developer Tools Console after trying a search and saw this error, which seems to diagnose database corruption - is that right?
/tmp/.mount_Joplin9xV2o5/resources/app.asar/node_modules/@joplin/utils/dist/Logger.js:270 15:29:33: Cannot execute MATCH query: phone: Error: SQLITE_CORRUPT: database disk image is malformed:
SELECT
notes_fts.id,
notes_fts.title,
offsets(notes_fts) AS offsets, matchinfo(notes_fts, 'pcnalx') AS matchinfo,
notes_fts.user_created_time,
notes_fts.user_updated_time,
notes_fts.is_todo,
notes_fts.todo_completed,
notes_fts.parent_id
FROM notes_fts
WHERE 1 AND notes_fts MATCH ?: "phone*"
After enabling debugging and restarting Joplin, I tried another search and this text appeared in the console:
node:internal/process/task_queues:95 15:37:49: Cannot execute MATCH query: the: Error: SQLITE_CORRUPT: database disk image is malformed:
SELECT
notes_fts.id,
notes_fts.title,
offsets(notes_fts) AS offsets, matchinfo(notes_fts, 'pcnalx') AS matchinfo,
notes_fts.user_created_time,
notes_fts.user_updated_time,
notes_fts.is_todo,
notes_fts.todo_completed,
notes_fts.parent_id
FROM notes_fts
WHERE 1 AND notes_fts MATCH ?: "the*"
node:internal/timers:573 15:37:53: SearchEngine: Updating FTS table...
node:internal/process/task_queues:95 15:37:53: SearchEngine: Error while processing changes: Error: Error: SQLITE_CORRUPT: database disk image is malformed: DELETE FROM notes_normalized WHERE id = ?: b759919ca5ab4e7fa5aaa223809baf9f
at DatabaseDriverNode.sqliteErrorToJsError (/tmp/.mount_JoplinKV…river-node.js:23:18)
at JoplinDatabase.sqliteErrorToJsError (/tmp/.mount_JoplinKV…b/database.js:36:30)
at JoplinDatabase.<anonymous> (/tmp/.mount_JoplinKV…/database.js:141:36)
at Generator.throw (<anonymous>)
at rejected (/tmp/.mount_JoplinKV…ib/database.js:6:65)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
Yes looks like the database is corrupted so there's not much to do unfortunately. Best would be to restore from a backup if you have one, or export all your notes, delete the profile and import them back.
