Hi all,
I encountered lately the same error as somebody else reported a few years ago here : first i was suddenly unable to login (whatever registered user/password I was using), running kanboard 1.2.22 on OVH shared hosting.
So I saved manually the data/db.sqlite file through ftp, and did a fresh install of the latest kanboard release (1.2.23). When uploading the db.sqlite that i gzipped in the meantime, and got the following error :
Internal Error: Unable to run SQL migrations: Running migration \Schema\version_126, SQLSTATE[HY000]: General error: 11 database disk image is malformed (You may have to fix it manually)
I opened the original db.sqlite file in SQLite Expert Professional 5.4, and ran the SQLite3_analyser tool.
It reported the following :
ERROR: database disk image is malformed
database disk image is malformed
while executing
“db eval {CREATE TEMP TABLE dbstat AS SELECT * FROM temp.stat
ORDER BY name, path}”
So I ran the repair tool in SQLite Expert Professional 5.4, gzipped the repaired file, deleted the corrupted data/db.sqlite file from the server throught ftp, and uploaded the gzipped repaired file via admin settings page, and got another error :
Internal Error: Unable to run SQL migrations: Running migration \Schema\version_1, SQLSTATE[HY000]: General error: 1 table users already exists (You may have to fix it manually)
Any idea on how to correctly fix my corrupted database file please ? (I do have an older db backup file, downloaded a month ago from the admin settings page, which uploads fine, but we have worked quite a bit with kanboard since then, and it would be really nice not to do all this work again…)
Thanks in advance for your help, and thanks already for reading me !!
