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 !!
