Fatal Error SQLITE_CORRUPT on Mac OS

Support
1

Hello! thanks for the useful app I use it every day but recently a message shows up in my Macbook Air (Mojave 10.14.6) when I launch the app:

Fatal error:

Error: SQLITE_CORRUPT: database disk image is malformed: CREATE TABLE folders (id TEXT PRIMARY KEY, title TEXT NOT NULL DEFAULT “”, created_time INT NOT NULL, updated_time INT NOT NULL);

Error: Error: SQLITE_CORRUPT: database disk image is malformed: CREATE TABLE folders (id TEXT PRIMARY KEY, title TEXT NOT NULL DEFAULT “”, created_time INT NOT NULL, updated_time INT NOT NULL);
at DatabaseDriverNode.sqliteErrorToJsError (/Applications/Joplin.app/Contents/Resources/app/lib/database-driver-node.js:21:16)
at JoplinDatabase.sqliteErrorToJsError (/Applications/Joplin.app/Contents/Resources/app/lib/database.js:22:24)
at JoplinDatabase.tryCall (/Applications/Joplin.app/Contents/Resources/app/lib/database.js:85:17)
at process._tickCallback (internal/process/next_tick.js:68:7)

Using older or more updated versions of the Joplin app doesn’t solve it. Neither uninstalling and reinstalling it. Though it works perfectly in my Android and Windows devices. Could you help me deal with this one? thanks a lot

2

If the database is corrupted there’s nothing we can do, you can only restore from backup. Otherwise, delete your profile, and sync again to rebuild the database.

3

OK it works now. I cannot find any profile but I found an entry in Github on a similar problem (Starting terminal application gives this error. · Issue #77 · laurent22/joplin · GitHub), that recommends deleting the database file in ~/.config/joplin . Thanks a lot :kissing_heart: