Cannot Set Variable Value

Console log as below:

2022-11-28 13:59:46 FMDB Error: Unknown error calling sqlite3_step
2022-11-28 13:59:46 FMDB Error: executeUpdate sqlite3_step returned  (11: database disk image is malformed)
2022-11-28 13:59:46 FMDB Query: DELETE FROM variables WHERE name = ?
2022-11-28 13:59:46 FMDB Path: /Users/Fengchao/Library/Application Support/Keyboard Maestro/Keyboard Maestro Variables.sqlite
2022-11-28 13:59:46 FMDB Error: Unknown error finalizing or resetting statement calling sqlite3_finalize
2022-11-28 13:59:46 FMDB Error: executeUpdate sqlite3_finalize returned  (11: database disk image is malformed)
2022-11-28 13:59:46 FMDB Query: DELETE FROM variables WHERE name = ?
2022-11-28 13:59:46 FMDB Path: /Users/Fengchao/Library/Application Support/Keyboard Maestro/Keyboard Maestro Variables.sqlite
2022-11-28 13:59:46 Assertion Failed: ([gDatabase executeUpdate:@"DELETE FROM variables WHERE name = ?" , variable]),  file: …/Source/Defines/KMVariables.mm:640, value: 0
2022-11-28 13:59:46 FMMDB error 11: database disk image is malformed

@peternlewis, one for you, methinks.

Looks like your Keyboard Maestro Variables database is corrupted.

  • In the editor, choose Help ➤ Open Preferences Folder
  • In the editor, choose File ➤ Quit Engine
  • Quit the editor.

In the Finder, in the Keyboard Maestro preferences folder that has been opened, delete the files that start with “Keyboard Maestro Variables” - usually there is only one, “Keyboard Maestro Variables.sqlite”, but there can be a plist one as well if you have owned Keyboard Maestro a long time. Delete both of them.

Launch Keyboard Maestro (it will re-launch the Engine).

Check that the issue is resolved.

2 Likes

Solved by deleting the variable sqlite file.

Thanks!

1 Like