# Database malformed error **URL:** \ **Category:** Installation Issues\ **Created:** [September 8, 2022, 12:17pm UTC](https://kanboard.discourse.group/t/database-malformed-error/2362 "2022-09-08T12:17:44Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![emzeweb](https://yyz2.discourse-cdn.com/free1/user_avatar/kanboard.discourse.group/emzeweb/32/1037_2.png) [@emzeweb](https://kanboard.discourse.group/u/emzeweb)\ **Post date:** [September 8, 2022, 12:17pm UTC](https://kanboard.discourse.group/t/database-malformed-error/2362/1 "2022-09-08T12:17:44Z")
Hi all, I encountered lately the same error as [somebody else reported a few years ago here](https://kanboard.discourse.group/t/probleme-de-connexion-tous-les-utilisateurs/842) : 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 !! ---
**Author:** ![alfredb](https://yyz2.discourse-cdn.com/free1/user_avatar/kanboard.discourse.group/alfredb/32/1051_2.png) [@alfredb](https://kanboard.discourse.group/u/alfredb)\ **Post date:** [September 8, 2022, 1:05pm UTC](https://kanboard.discourse.group/t/database-malformed-error/2362/2 "2022-09-08T13:05:25Z")
> [@emzeweb](#): > > first i was suddenly unable to login (whatever registered user/password I was using), running kanboard 1.2.22 on OVH shared hosting. Why didn’t you try to solve this first? What exactly was the issue? ---
**Author:** ![emzeweb](https://yyz2.discourse-cdn.com/free1/user_avatar/kanboard.discourse.group/emzeweb/32/1037_2.png) [@emzeweb](https://kanboard.discourse.group/u/emzeweb)\ **Post date:** [September 8, 2022, 1:12pm UTC](https://kanboard.discourse.group/t/database-malformed-error/2362/3 "2022-09-08T13:12:05Z")
well, i just couldn’t login anymore (before that, i noticed sometimes a strange behaviour on comments not being recorded : when clicking on ‘submit’ button, both fields would empty and a red alert indicating “title field must be filled in” or something of the kind). same kind of behaviour on the login page : both fields returned blank and red alert saying fields must be filled in… I did a bit of research on the forum, but didn’t find any solution, so I thought it’d work better on the new release. (and I’m not sure how your comment is helping here…?) ---
**Author:** ![emzeweb](https://yyz2.discourse-cdn.com/free1/user_avatar/kanboard.discourse.group/emzeweb/32/1037_2.png) [@emzeweb](https://kanboard.discourse.group/u/emzeweb)\ **Post date:** [September 8, 2022, 1:15pm UTC](https://kanboard.discourse.group/t/database-malformed-error/2362/4 "2022-09-08T13:15:25Z")
and from what i read in the thread I linked to in my original post, I believe it’s the same bug (that was listed on 2019 - release 1.2.12) “The problem occurred after validating a dialogue box. (…) Some user have interrupted a saving command. It is an important bug in my opinion !” ---
**Author:** ![alfredb](https://yyz2.discourse-cdn.com/free1/user_avatar/kanboard.discourse.group/alfredb/32/1051_2.png) [@alfredb](https://kanboard.discourse.group/u/alfredb)\ **Post date:** [September 8, 2022, 1:37pm UTC](https://kanboard.discourse.group/t/database-malformed-error/2362/5 "2022-09-08T13:37:33Z")
> [@emzeweb](#): > > (and I’m not sure how your comment is helping here…?) Sorry, for disturbing you, I was just trying to get more details about your issue. Good luck! ---
**Author:** ![emzeweb](https://yyz2.discourse-cdn.com/free1/user_avatar/kanboard.discourse.group/emzeweb/32/1037_2.png) [@emzeweb](https://kanboard.discourse.group/u/emzeweb)\ **Post date:** [September 9, 2022, 11:49am UTC](https://kanboard.discourse.group/t/database-malformed-error/2362/6 "2022-09-09T11:49:35Z")
hey sorry alfredb, I see your point, and I’m sorry that I overreacted a little on the first part of your comment (“Why didn’t you try to solve this first?”) Anyway, I’m still trying to recover / repair my latest database, based on other sqlite3 user experiences I found on github, stackoverflow, etc. but since it’s not possible for me to run command line utilities on the hosting server, nothing succesful until now… I’ll let you know if I manage to solve my issue. Otherwise, I’ll just roll back to my old working db backup, and spend quite a few hours/days updating it manually… 😉 ---
**Author:** ![emzeweb](https://yyz2.discourse-cdn.com/free1/user_avatar/kanboard.discourse.group/emzeweb/32/1037_2.png) [@emzeweb](https://kanboard.discourse.group/u/emzeweb)\ **Post date:** [September 9, 2022, 1:48pm UTC](https://kanboard.discourse.group/t/database-malformed-error/2362/7 "2022-09-09T13:48:31Z")
Still trying to figure it out, but this time by digging into the server logs at the time the login failures happened two days ago… > [@alfredb](#): > > What exactly was the issue? seems to me that the last entries before the login issue started read as follows : ```auto [07/Sep/2022:15:07:22 +0200] "POST /?controller=TaskCreationController&action=save&project_id=4 HTTP/1.1" 200 4404 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:104.0) Gecko/20100101 Firefox/104.0" [07/Sep/2022:15:07:25 +0200] "GET /?controller=BoardAjaxController&action=check&project_id=4×tamp=1662556023&csrf_token=5ecead798785507a74e9a64a304e55fc34d602e1a9a8924a85c157bfac57&_=1662556023142 HTTP/1.1" 304 - "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:104.0) Gecko/20100101 Firefox/104.0" [07/Sep/2022:15:07:35 +0200] "GET /?controller=BoardAjaxController&action=check&project_id=4×tamp=1662556023&csrf_token=5ecead798785507a74e9a64a304e55fc34d602e1a9a8924a85c157bfac57&_=1662556023143 HTTP/1.1" 304 - "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:104.0) Gecko/20100101 Firefox/104.0" [07/Sep/2022:15:07:45 +0200] "GET /?controller=BoardAjaxController&action=check&project_id=4×tamp=1662556023&csrf_token=5ecead798785507a74e9a64a304e55fc34d602e1a9a8924a85c157bfac57&_=1662556023144 HTTP/1.1" 500 94 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:104.0) Gecko/20100101 Firefox/104.0" [07/Sep/2022:15:07:46 +0200] "POST /?controller=TaskCreationController&action=save&project_id=4 HTTP/1.1" 500 94 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:104.0) Gecko/20100101 Firefox/104.0" ``` and I see that the day before, I got a hell of a lot of : ```auto [06/Sep/2022:15:14:29 +0200] "GET /?controller=ChatController&action=ping&plugin=Chat&lastMessageId=1 HTTP/1.1" 304 - "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:104.0) Gecko/20100101 Firefox/104.0" ``` I don’t know if these can help somebody point me in the right direction ? one last thing, if I remember correctly, shortly before that, I had uninstalled the [Search plugin](https://github.com/ipunkt/KanboardSearch) since I encountered trouble finding some tasks since it was installed… ---
**Author:** ![alfredb](https://yyz2.discourse-cdn.com/free1/user_avatar/kanboard.discourse.group/alfredb/32/1051_2.png) [@alfredb](https://kanboard.discourse.group/u/alfredb)\ **Post date:** [September 9, 2022, 8:40pm UTC](https://kanboard.discourse.group/t/database-malformed-error/2362/8 "2022-09-09T20:40:49Z")
I recommend enabling the debug log, if not yet done. This might give some hints. ---
**Author:** ![alfredb](https://yyz2.discourse-cdn.com/free1/user_avatar/kanboard.discourse.group/alfredb/32/1051_2.png) [@alfredb](https://kanboard.discourse.group/u/alfredb)\ **Post date:** [September 10, 2022, 6:57am UTC](https://kanboard.discourse.group/t/database-malformed-error/2362/9 "2022-09-10T06:57:12Z")
Some idea: > [@emzeweb](#): > > I saved manually the data/db.sqlite file through ftp > [@emzeweb](#): > > SQLSTATE[HY000]: General error: 11 database disk image is malformed I hope, you used the binary mode within ftp. ---
**Author:** ![emzeweb](https://yyz2.discourse-cdn.com/free1/user_avatar/kanboard.discourse.group/emzeweb/32/1037_2.png) [@emzeweb](https://kanboard.discourse.group/u/emzeweb)\ **Post date:** [September 12, 2022, 10:24am UTC](https://kanboard.discourse.group/t/database-malformed-error/2362/10 "2022-09-12T10:24:20Z")
Hello @alfredb, thanks for the follow up on this topic. When you say > I hope, you used the binary mode within ftp. I’m not sure where to find this info : I use Filezilla FTP client, and the only specifics I see are - Passive transfer mode, and - automatic detection of the character set. (UTF-8 as default if it’s used on the server, otherwise the local character set…) ---
**Author:** ![alfredb](https://yyz2.discourse-cdn.com/free1/user_avatar/kanboard.discourse.group/alfredb/32/1051_2.png) [@alfredb](https://kanboard.discourse.group/u/alfredb)\ **Post date:** [September 12, 2022, 10:27am UTC](https://kanboard.discourse.group/t/database-malformed-error/2362/11 "2022-09-12T10:27:17Z")
> [@emzeweb](#): > > automatic detection I assume that’s OK. I just wasn’t sure. ---
**Author:** ![emzeweb](https://yyz2.discourse-cdn.com/free1/user_avatar/kanboard.discourse.group/emzeweb/32/1037_2.png) [@emzeweb](https://kanboard.discourse.group/u/emzeweb)\ **Post date:** [September 12, 2022, 11:10am UTC](https://kanboard.discourse.group/t/database-malformed-error/2362/12 "2022-09-12T11:10:47Z")
Now, since the database malformed error occured after upgrading to kanboard 1.2.23, when it ran the version\_126 schema, I re-installed version 1.2.22, enabled debug log, and re-uploaded the gzipped database. > [2022-09-12 13:01:52] [debug] Kanboard\Core\Controller\Runner::executeMiddleware > [2022-09-12 13:01:52] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute > [2022-09-12 13:01:52] [debug] Kanboard\Core\Controller\BaseMiddleware::next =\> Kanboard\Middleware\AuthenticationMiddleware > [2022-09-12 13:01:52] [debug] Kanboard\Core\Controller\Runner::executeMiddleware > [2022-09-12 13:01:52] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute > [2022-09-12 13:01:52] [debug] Kanboard\Core\Controller\BaseMiddleware::next =\> Kanboard\Middleware\AuthenticationMiddleware > [2022-09-12 13:01:52] [debug] Kanboard\Core\Controller\Runner::executeController =\> \Kanboard\Controller\AuthController::login > [2022-09-12 13:01:54] [debug] Kanboard\Core\Controller\Runner::executeMiddleware > [2022-09-12 13:01:54] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute > [2022-09-12 13:01:54] [debug] Kanboard\Core\Controller\BaseMiddleware::next =\> Kanboard\Middleware\AuthenticationMiddleware > [2022-09-12 13:01:54] [debug] Kanboard\Core\Controller\Runner::executeController =\> \Kanboard\Controller\AuthController::check > [2022-09-12 13:02:20] [debug] Kanboard\Core\Controller\Runner::executeMiddleware > [2022-09-12 13:02:20] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute > [2022-09-12 11:02:20] [debug] Kanboard\Core\Controller\BaseMiddleware::next =\> Kanboard\Middleware\AuthenticationMiddleware > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_1 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_2 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_3 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_4 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_5 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_6 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_7 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_8 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_9 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_10 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_11 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_12 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_13 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_14 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_15 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_16 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_17 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_18 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_19 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_20 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_21 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_22 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_23 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_24 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_25 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_26 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_27 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_28 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_29 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_30 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_31 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_32 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_33 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_34 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_35 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_36 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_37 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_38 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_39 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_40 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_41 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_42 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_43 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_44 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_45 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_46 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_47 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_48 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_52 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_53 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_54 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_55 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_56 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_57 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_58 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_59 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_60 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_61 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_62 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_63 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_64 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_65 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_66 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_67 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_68 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_69 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_70 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_71 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_72 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_73 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_74 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_75 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_76 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_77 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_78 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_79 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_80 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_81 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_82 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_83 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_84 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_85 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_86 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_87 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_88 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_89 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_90 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_91 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_92 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_93 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_94 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_95 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_96 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_97 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_98 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_99 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_100 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_101 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_102 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_103 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_104 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_105 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_106 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_107 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_108 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_109 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_110 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_111 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_112 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_113 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_114 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_115 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_116 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_117 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_118 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_119 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_120 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_121 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_122 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_123 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_124 > [2022-09-12 11:02:20] [debug] SQL: Running migration \Schema\version\_125 > [2022-09-12 11:02:20] [debug] SQL: SELECT “data” FROM “sessions” WHERE “id” = ? LIMIT 1 > [2022-09-12 11:02:20] [debug] SQL: query\_duration=0.00098299980163574 > [2022-09-12 11:02:20] [debug] SQL: total\_execution\_time=0.00098299980163574 > [2022-09-12 11:02:20] [debug] SQL: SELECT “option”, “value” FROM “settings” > [2022-09-12 11:02:20] [debug] SQL: query\_duration=0.00056695938110352 > [2022-09-12 11:02:20] [debug] SQL: total\_execution\_time=0.0015499591827393 > [2022-09-12 11:02:20] [debug] SQL: SELECT \* FROM “actions” > [2022-09-12 11:02:20] [debug] SQL: query\_duration=0.00056910514831543 > [2022-09-12 11:02:20] [debug] SQL: total\_execution\_time=0.0021190643310547 > [2022-09-12 11:02:20] [debug] SQL: SELECT \* FROM “action\_has\_params” > [2022-09-12 11:02:20] [debug] SQL: query\_duration=0.00056314468383789 > [2022-09-12 11:02:20] [debug] SQL: total\_execution\_time=0.0026822090148926 > [2022-09-12 11:02:20] [debug] SQL: SELECT \* FROM “remember\_me” WHERE “token” = ? AND “sequence” = ? AND “expiration” \> ? LIMIT 1 > [2022-09-12 11:02:20] [debug] SQL: query\_duration=0.00076103210449219 > [2022-09-12 11:02:20] [debug] SQL: total\_execution\_time=0.0034432411193848 > [2022-09-12 11:02:20] [debug] SQL: SELECT 1 FROM “sessions” WHERE “id” = ? > [2022-09-12 11:02:20] [debug] SQL: query\_duration=0.00055909156799316 > [2022-09-12 11:02:20] [debug] SQL: total\_execution\_time=0.0040023326873779 > [2022-09-12 11:02:20] [debug] SQL: INSERT INTO “sessions” (“id”, “expire\_at”, “data”) VALUES (:id, :expire\_at, :data) > [2022-09-12 11:02:20] [debug] SQL: query\_duration=0.00042295455932617 > [2022-09-12 11:02:20] [debug] SQL: total\_execution\_time=0.0044252872467041 > [2022-09-12 11:02:20] [debug] APP: nb\_queries=7 > [2022-09-12 11:02:20] [debug] APP: rendering\_time=0.57262802124023 > [2022-09-12 11:02:20] [debug] APP: memory\_usage=5.22M > [2022-09-12 11:02:20] [debug] APP: uri=/ > [2022-09-12 11:02:20] [debug] ############################################### (to be continued in next post, since it’s too long to fit in this one) ---
**Author:** ![emzeweb](https://yyz2.discourse-cdn.com/free1/user_avatar/kanboard.discourse.group/emzeweb/32/1037_2.png) [@emzeweb](https://kanboard.discourse.group/u/emzeweb)\ **Post date:** [September 12, 2022, 11:10am UTC](https://kanboard.discourse.group/t/database-malformed-error/2362/13 "2022-09-12T11:10:59Z")
> [2022-09-12 13:02:20] [debug] Kanboard\Core\Controller\Runner::executeMiddleware > [2022-09-12 13:02:20] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute > [2022-09-12 11:02:20] [debug] Kanboard\Core\Controller\BaseMiddleware::next =\> Kanboard\Middleware\AuthenticationMiddleware > [2022-09-12 11:02:20] [debug] Kanboard\Core\Controller\Runner::executeController =\> \Kanboard\Controller\AuthController::login > [2022-09-12 11:02:20] [debug] SQL: SELECT “data” FROM “sessions” WHERE “id” = ? LIMIT 1 > [2022-09-12 11:02:20] [debug] SQL: query\_duration=0.0046508312225342 > [2022-09-12 11:02:20] [debug] SQL: total\_execution\_time=0.0046508312225342 > [2022-09-12 11:02:20] [debug] SQL: SELECT “option”, “value” FROM “settings” > [2022-09-12 11:02:20] [debug] SQL: query\_duration=0.0011250972747803 > [2022-09-12 11:02:20] [debug] SQL: total\_execution\_time=0.0057759284973145 > [2022-09-12 11:02:20] [debug] SQL: SELECT \* FROM “actions” > [2022-09-12 11:02:20] [debug] SQL: query\_duration=0.00083708763122559 > [2022-09-12 11:02:20] [debug] SQL: total\_execution\_time=0.00661301612854 > [2022-09-12 11:02:20] [debug] SQL: SELECT \* FROM “action\_has\_params” > [2022-09-12 11:02:20] [debug] SQL: query\_duration=0.00094103813171387 > [2022-09-12 11:02:20] [debug] SQL: total\_execution\_time=0.0075540542602539 > [2022-09-12 11:02:20] [debug] SQL: SELECT 1 FROM “sessions” WHERE “id” = ? > [2022-09-12 11:02:20] [debug] SQL: query\_duration=0.00075006484985352 > [2022-09-12 11:02:20] [debug] SQL: total\_execution\_time=0.0083041191101074 > [2022-09-12 11:02:20] [debug] SQL: UPDATE “sessions” SET “expire\_at”=?, “data”=? WHERE “id” = ? > [2022-09-12 11:02:20] [debug] SQL: query\_duration=0.00044012069702148 > [2022-09-12 11:02:20] [debug] SQL: total\_execution\_time=0.0087442398071289 > [2022-09-12 11:02:20] [debug] APP: nb\_queries=6 > [2022-09-12 11:02:20] [debug] APP: rendering\_time=0.061378002166748 > [2022-09-12 11:02:20] [debug] APP: memory\_usage=5.48M > [2022-09-12 11:02:20] [debug] APP: uri=/?controller=AuthController&action=login > [2022-09-12 11:02:20] [debug] ############################################### > [2022-09-12 13:02:22] [debug] Kanboard\Core\Controller\Runner::executeMiddleware > [2022-09-12 13:02:22] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute > [2022-09-12 11:02:22] [debug] Kanboard\Core\Controller\BaseMiddleware::next =\> Kanboard\Middleware\AuthenticationMiddleware > [2022-09-12 11:02:22] [debug] Kanboard\Core\Controller\Runner::executeController =\> \Kanboard\Controller\AuthController::check > [2022-09-12 11:02:22] [debug] Subscriber executed: Kanboard\Subscriber\AuthSubscriber::afterLogin > [2022-09-12 11:02:22] [debug] SQL: SELECT “data” FROM “sessions” WHERE “id” = ? LIMIT 1 > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.004633903503418 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.004633903503418 > [2022-09-12 11:02:22] [debug] SQL: SELECT “option”, “value” FROM “settings” > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.0011270046234131 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.0057609081268311 > [2022-09-12 11:02:22] [debug] SQL: SELECT \* FROM “actions” > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.00081801414489746 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.0065789222717285 > [2022-09-12 11:02:22] [debug] SQL: SELECT \* FROM “action\_has\_params” > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.00084710121154785 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.0074260234832764 > [2022-09-12 11:02:22] [debug] SQL: SELECT 1 FROM “users” WHERE “username” = ? AND “lock\_expiration\_date” != ? AND “lock\_expiration\_date” \>= ? > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.0011758804321289 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.0086019039154053 > [2022-09-12 11:02:22] [debug] SQL: SELECT “nb\_failed\_login” FROM “users” WHERE “username” = ? LIMIT 1 > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.00060892105102539 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.0092108249664307 > [2022-09-12 11:02:22] [debug] SQL: SELECT “id”, “password” FROM “users” WHERE “username” = ? AND “disable\_login\_form” = ? AND “is\_ldap\_user” = ? AND “is\_active” = ? LIMIT 1 > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.00059795379638672 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.0098087787628174 > [2022-09-12 11:02:22] [debug] SQL: SELECT \* FROM “users” WHERE “id” = ? LIMIT 1 > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.00064682960510254 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.01045560836792 > [2022-09-12 11:02:22] [debug] SQL: UPDATE “users” SET “nb\_failed\_login”=?, “lock\_expiration\_date”=? WHERE “username” = ? > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.0024800300598145 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.012935638427734 > [2022-09-12 11:02:22] [debug] SQL: SELECT “id” FROM “last\_logins” WHERE “user\_id” = ? ORDER BY “id” DESC > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.0011579990386963 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.014093637466431 > [2022-09-12 11:02:22] [debug] SQL: INSERT INTO “last\_logins” (“auth\_type”, “user\_id”, “ip”, “user\_agent”, “date\_creation”) VALUES (:auth\_type, :user\_id, :ip, :user\_agent, :date\_creation) > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.0026159286499023 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.016709566116333 > [2022-09-12 11:02:22] [debug] SQL: DELETE FROM “remember\_me” WHERE “user\_id” = ? AND “expiration” \< ? > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.0013701915740967 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.01807975769043 > [2022-09-12 11:02:22] [debug] SQL: INSERT INTO “remember\_me” (“user\_id”, “ip”, “user\_agent”, “token”, “sequence”, “expiration”, “date\_creation”) VALUES (:user\_id, :ip, :user\_agent, :token, :sequence, :expiration, :date\_creation) > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.0022501945495605 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.02032995223999 > [2022-09-12 11:02:22] [debug] SQL: SELECT 1 FROM “sessions” WHERE “id” = ? > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.00094199180603027 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.021271944046021 > [2022-09-12 11:02:22] [debug] SQL: UPDATE “sessions” SET “expire\_at”=?, “data”=? WHERE “id” = ? > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.00045108795166016 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.021723031997681 > [2022-09-12 11:02:22] [debug] APP: nb\_queries=15 > [2022-09-12 11:02:22] [debug] APP: rendering\_time=0.15726089477539 > [2022-09-12 11:02:22] [debug] APP: memory\_usage=5.46M > [2022-09-12 11:02:22] [debug] APP: uri=/?controller=AuthController&action=check > [2022-09-12 11:02:22] [debug] ############################################### > [2022-09-12 13:02:22] [debug] Kanboard\Core\Controller\Runner::executeMiddleware > [2022-09-12 13:02:22] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute > [2022-09-12 11:02:22] [debug] Kanboard\Core\Controller\BaseMiddleware::next =\> Kanboard\Middleware\AuthenticationMiddleware > [2022-09-12 11:02:22] [debug] Kanboard\Core\Controller\BaseMiddleware::next =\> Kanboard\Middleware\PostAuthenticationMiddleware > [2022-09-12 11:02:22] [debug] Kanboard\Core\Controller\BaseMiddleware::next =\> Kanboard\Middleware\ApplicationAuthorizationMiddleware > [2022-09-12 11:02:22] [debug] Kanboard\Core\Controller\BaseMiddleware::next =\> Kanboard\Middleware\ProjectAuthorizationMiddleware > [2022-09-12 11:02:22] [debug] Kanboard\Core\Controller\Runner::executeController =\> \Kanboard\Controller\DashboardController::show > [2022-09-12 11:02:22] [debug] SQL: SELECT “data” FROM “sessions” WHERE “id” = ? LIMIT 1 > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.0051639080047607 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.0051639080047607 > [2022-09-12 11:02:22] [debug] SQL: SELECT “option”, “value” FROM “settings” > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.0009300708770752 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.0060939788818359 > [2022-09-12 11:02:22] [debug] SQL: SELECT projects.id, projects.name FROM “projects” LEFT JOIN “project\_has\_users” ON “project\_has\_users”.“project\_id”=“projects”.“id” WHERE project\_has\_users.user\_id = ? AND projects.is\_active IN (?) > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.00098204612731934 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.0070760250091553 > [2022-09-12 11:02:22] [debug] SQL: SELECT projects.id, projects.name FROM “projects” LEFT JOIN “project\_has\_groups” ON “project\_has\_groups”.“project\_id”=“projects”.“id” LEFT JOIN “group\_has\_users” ON “group\_has\_users”.“group\_id”=“project\_has\_groups”.“group\_id” WHERE group\_has\_users.user\_id = ? AND projects.is\_active IN (?) > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.00058293342590332 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.0076589584350586 > [2022-09-12 11:02:22] [debug] SQL: SELECT 1 FROM “users” WHERE “id” = ? AND “is\_active” = ? AND “role” = ? > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.00056004524230957 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.0082190036773682 > [2022-09-12 11:02:22] [debug] SQL: SELECT \* FROM “users” WHERE “id” = ? LIMIT 1 > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.00075793266296387 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.008976936340332 > [2022-09-12 11:02:22] [debug] SQL: SELECT projects.id, projects.name FROM “projects” LEFT JOIN “project\_has\_users” ON “project\_has\_users”.“project\_id”=“projects”.“id” WHERE project\_has\_users.user\_id = ? AND projects.is\_active IN (?) > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.00076103210449219 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.0097379684448242 > [2022-09-12 11:02:22] [debug] SQL: SELECT projects.id, projects.name FROM “projects” LEFT JOIN “project\_has\_groups” ON “project\_has\_groups”.“project\_id”=“projects”.“id” LEFT JOIN “group\_has\_users” ON “group\_has\_users”.“group\_id”=“project\_has\_groups”.“group\_id” WHERE group\_has\_users.user\_id = ? AND projects.is\_active IN (?) > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.00098299980163574 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.01072096824646 > [2022-09-12 11:02:22] [debug] SQL: SELECT projects.id, projects.name FROM “projects” LEFT JOIN “project\_has\_users” ON “project\_has\_users”.“project\_id”=“projects”.“id” WHERE project\_has\_users.user\_id = ? AND projects.is\_active IN (?) > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.00060892105102539 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.011329889297485 > [2022-09-12 11:02:22] [debug] SQL: SELECT projects.id, projects.name FROM “projects” LEFT JOIN “project\_has\_groups” ON “project\_has\_groups”.“project\_id”=“projects”.“id” LEFT JOIN “group\_has\_users” ON “group\_has\_users”.“group\_id”=“project\_has\_groups”.“group\_id” WHERE group\_has\_users.user\_id = ? AND projects.is\_active IN (?) > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.00071287155151367 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.012042760848999 > [2022-09-12 11:02:22] [debug] SQL: SELECT COUNT(\*) FROM “projects” WHERE projects.id = ? > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.00072598457336426 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.012768745422363 > [2022-09-12 11:02:22] [debug] SQL: SELECT projects.id, projects.name FROM “projects” LEFT JOIN “project\_has\_users” ON “project\_has\_users”.“project\_id”=“projects”.“id” WHERE project\_has\_users.user\_id = ? AND projects.is\_active IN (?) > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.00058603286743164 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.013354778289795 > [2022-09-12 11:02:22] [debug] SQL: SELECT projects.id, projects.name FROM “projects” LEFT JOIN “project\_has\_groups” ON “project\_has\_groups”.“project\_id”=“projects”.“id” LEFT JOIN “group\_has\_users” ON “group\_has\_users”.“group\_id”=“project\_has\_groups”.“group\_id” WHERE group\_has\_users.user\_id = ? AND projects.is\_active IN (?) > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.00072407722473145 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.014078855514526 > [2022-09-12 11:02:22] [debug] SQL: SELECT 1 FROM “user\_has\_unread\_notifications” WHERE “user\_id” = ? > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.0011279582977295 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.015206813812256 > [2022-09-12 11:02:22] [debug] SQL: SELECT 1 FROM “sessions” WHERE “id” = ? > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.00057578086853027 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.015782594680786 > [2022-09-12 11:02:22] [debug] SQL: UPDATE “sessions” SET “expire\_at”=?, “data”=? WHERE “id” = ? > [2022-09-12 11:02:22] [debug] SQL: query\_duration=0.00050902366638184 > [2022-09-12 11:02:22] [debug] SQL: total\_execution\_time=0.016291618347168 > [2022-09-12 11:02:22] [debug] APP: nb\_queries=16 > [2022-09-12 11:02:22] [debug] APP: rendering\_time=0.097965955734253 > [2022-09-12 11:02:22] [debug] APP: memory\_usage=5.86M > [2022-09-12 11:02:22] [debug] APP: uri=/ > [2022-09-12 11:02:22] [debug] ############################################### > [2022-09-12 13:02:25] [debug] Kanboard\Core\Controller\Runner::executeMiddleware > [2022-09-12 13:02:25] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute > [2022-09-12 11:02:25] [debug] Kanboard\Core\Controller\BaseMiddleware::next =\> Kanboard\Middleware\AuthenticationMiddleware > [2022-09-12 11:02:25] [debug] Kanboard\Core\Controller\BaseMiddleware::next =\> Kanboard\Middleware\PostAuthenticationMiddleware > [2022-09-12 11:02:25] [debug] Kanboard\Core\Controller\BaseMiddleware::next =\> Kanboard\Middleware\ApplicationAuthorizationMiddleware > [2022-09-12 11:02:25] [debug] Kanboard\Core\Controller\BaseMiddleware::next =\> Kanboard\Middleware\ProjectAuthorizationMiddleware > [2022-09-12 11:02:25] [debug] Kanboard\Core\Controller\Runner::executeController =\> \Kanboard\Controller\ConfigController::index > [2022-09-12 11:02:25] [debug] SQL: SELECT “data” FROM “sessions” WHERE “id” = ? LIMIT 1 > [2022-09-12 11:02:25] [debug] SQL: query\_duration=0.0045349597930908 > [2022-09-12 11:02:25] [debug] SQL: total\_execution\_time=0.0045349597930908 > [2022-09-12 11:02:25] [debug] SQL: SELECT “option”, “value” FROM “settings” > [2022-09-12 11:02:25] [debug] SQL: query\_duration=0.0010359287261963 > [2022-09-12 11:02:25] [debug] SQL: total\_execution\_time=0.0055708885192871 > [2022-09-12 11:02:25] [debug] SQL: SELECT projects.id, projects.name FROM “projects” LEFT JOIN “project\_has\_users” ON “project\_has\_users”.“project\_id”=“projects”.“id” WHERE project\_has\_users.user\_id = ? AND projects.is\_active IN (?) > [2022-09-12 11:02:25] [debug] SQL: query\_duration=0.0010461807250977 > [2022-09-12 11:02:25] [debug] SQL: total\_execution\_time=0.0066170692443848 > [2022-09-12 11:02:25] [debug] SQL: SELECT projects.id, projects.name FROM “projects” LEFT JOIN “project\_has\_groups” ON “project\_has\_groups”.“project\_id”=“projects”.“id” LEFT JOIN “group\_has\_users” ON “group\_has\_users”.“group\_id”=“project\_has\_groups”.“group\_id” WHERE group\_has\_users.user\_id = ? AND projects.is\_active IN (?) > [2022-09-12 11:02:25] [debug] SQL: query\_duration=0.00061321258544922 > [2022-09-12 11:02:25] [debug] SQL: total\_execution\_time=0.007230281829834 > [2022-09-12 11:02:25] [debug] SQL: SELECT 1 FROM “users” WHERE “id” = ? AND “is\_active” = ? AND “role” = ? > [2022-09-12 11:02:25] [debug] SQL: query\_duration=0.00077104568481445 > [2022-09-12 11:02:25] [debug] SQL: total\_execution\_time=0.0080013275146484 > [2022-09-12 11:02:25] [debug] SQL: SELECT “option”, “value” FROM “settings” > [2022-09-12 11:02:25] [debug] SQL: query\_duration=0.00060009956359863 > [2022-09-12 11:02:25] [debug] SQL: total\_execution\_time=0.0086014270782471 > [2022-09-12 11:02:25] [debug] SQL: SELECT projects.id, projects.name FROM “projects” LEFT JOIN “project\_has\_users” ON “project\_has\_users”.“project\_id”=“projects”.“id” WHERE project\_has\_users.user\_id = ? AND projects.is\_active IN (?) > [2022-09-12 11:02:25] [debug] SQL: query\_duration=0.00067901611328125 > [2022-09-12 11:02:25] [debug] SQL: total\_execution\_time=0.0092804431915283 > [2022-09-12 11:02:25] [debug] SQL: SELECT projects.id, projects.name FROM “projects” LEFT JOIN “project\_has\_groups” ON “project\_has\_groups”.“project\_id”=“projects”.“id” LEFT JOIN “group\_has\_users” ON “group\_has\_users”.“group\_id”=“project\_has\_groups”.“group\_id” WHERE group\_has\_users.user\_id = ? AND projects.is\_active IN (?) > [2022-09-12 11:02:25] [debug] SQL: query\_duration=0.0006110668182373 > [2022-09-12 11:02:25] [debug] SQL: total\_execution\_time=0.0098915100097656 > [2022-09-12 11:02:25] [debug] SQL: SELECT 1 FROM “user\_has\_unread\_notifications” WHERE “user\_id” = ? > [2022-09-12 11:02:25] [debug] SQL: query\_duration=0.0011811256408691 > [2022-09-12 11:02:25] [debug] SQL: total\_execution\_time=0.011072635650635 > [2022-09-12 11:02:25] [debug] SQL: SELECT 1 FROM “sessions” WHERE “id” = ? > [2022-09-12 11:02:25] [debug] SQL: query\_duration=0.00056695938110352 > [2022-09-12 11:02:25] [debug] SQL: total\_execution\_time=0.011639595031738 > [2022-09-12 11:02:25] [debug] SQL: UPDATE “sessions” SET “expire\_at”=?, “data”=? WHERE “id” = ? > [2022-09-12 11:02:25] [debug] SQL: query\_duration=0.0004580020904541 > [2022-09-12 11:02:25] [debug] SQL: total\_execution\_time=0.012097597122192 > [2022-09-12 11:02:25] [debug] APP: nb\_queries=11 > [2022-09-12 11:02:25] [debug] APP: rendering\_time=0.17080688476562 > [2022-09-12 11:02:25] [debug] APP: memory\_usage=5.8M > [2022-09-12 11:02:25] [debug] APP: uri=/?controller=ConfigController&action=index > [2022-09-12 11:02:25] [debug] ############################################### > [2022-09-12 13:02:27] [debug] Kanboard\Core\Controller\Runner::executeMiddleware > [2022-09-12 13:02:27] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute > [2022-09-12 11:02:27] [debug] Kanboard\Core\Controller\BaseMiddleware::next =\> Kanboard\Middleware\AuthenticationMiddleware > [2022-09-12 11:02:27] [debug] Kanboard\Core\Controller\BaseMiddleware::next =\> Kanboard\Middleware\PostAuthenticationMiddleware > [2022-09-12 11:02:27] [debug] Kanboard\Core\Controller\BaseMiddleware::next =\> Kanboard\Middleware\ApplicationAuthorizationMiddleware > [2022-09-12 11:02:27] [debug] Kanboard\Core\Controller\BaseMiddleware::next =\> Kanboard\Middleware\ProjectAuthorizationMiddleware > [2022-09-12 11:02:27] [debug] Kanboard\Core\Controller\Runner::executeController =\> \Kanboard\Controller\ConfigController::uploadDb > [2022-09-12 11:02:27] [debug] SQL: SELECT “data” FROM “sessions” WHERE “id” = ? LIMIT 1 > [2022-09-12 11:02:27] [debug] SQL: query\_duration=0.0049889087677002 > [2022-09-12 11:02:27] [debug] SQL: total\_execution\_time=0.0049889087677002 > [2022-09-12 11:02:27] [debug] SQL: SELECT “option”, “value” FROM “settings” > [2022-09-12 11:02:27] [debug] SQL: query\_duration=0.0010139942169189 > [2022-09-12 11:02:27] [debug] SQL: total\_execution\_time=0.0060029029846191 > [2022-09-12 11:02:27] [debug] SQL: SELECT projects.id, projects.name FROM “projects” LEFT JOIN “project\_has\_users” ON “project\_has\_users”.“project\_id”=“projects”.“id” WHERE project\_has\_users.user\_id = ? AND projects.is\_active IN (?) > [2022-09-12 11:02:27] [debug] SQL: query\_duration=0.0010838508605957 > [2022-09-12 11:02:27] [debug] SQL: total\_execution\_time=0.0070867538452148 > [2022-09-12 11:02:27] [debug] SQL: SELECT projects.id, projects.name FROM “projects” LEFT JOIN “project\_has\_groups” ON “project\_has\_groups”.“project\_id”=“projects”.“id” LEFT JOIN “group\_has\_users” ON “group\_has\_users”.“group\_id”=“project\_has\_groups”.“group\_id” WHERE group\_has\_users.user\_id = ? AND projects.is\_active IN (?) > [2022-09-12 11:02:27] [debug] SQL: query\_duration=0.00065398216247559 > [2022-09-12 11:02:27] [debug] SQL: total\_execution\_time=0.0077407360076904 > [2022-09-12 11:02:27] [debug] SQL: SELECT 1 FROM “users” WHERE “id” = ? AND “is\_active” = ? AND “role” = ? > [2022-09-12 11:02:27] [debug] SQL: query\_duration=0.0005791187286377 > [2022-09-12 11:02:27] [debug] SQL: total\_execution\_time=0.0083198547363281 > [2022-09-12 11:02:27] [debug] SQL: SELECT 1 FROM “sessions” WHERE “id” = ? > [2022-09-12 11:02:27] [debug] SQL: query\_duration=0.00075602531433105 > [2022-09-12 11:02:27] [debug] SQL: total\_execution\_time=0.0090758800506592 > [2022-09-12 11:02:27] [debug] SQL: UPDATE “sessions” SET “expire\_at”=?, “data”=? WHERE “id” = ? > [2022-09-12 11:02:27] [debug] SQL: query\_duration=0.00047993659973145 > [2022-09-12 11:02:27] [debug] SQL: total\_execution\_time=0.0095558166503906 > [2022-09-12 11:02:27] [debug] APP: nb\_queries=7 > [2022-09-12 11:02:27] [debug] APP: rendering\_time=0.068113088607788 > [2022-09-12 11:02:27] [debug] APP: memory\_usage=5.65M > [2022-09-12 11:02:27] [debug] APP: uri=/?controller=ConfigController&action=uploadDb > [2022-09-12 11:02:27] [debug] ############################################### > [2022-09-12 13:02:38] [debug] Kanboard\Core\Controller\Runner::executeMiddleware > [2022-09-12 13:02:38] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute > [2022-09-12 11:02:38] [debug] Kanboard\Core\Controller\BaseMiddleware::next =\> Kanboard\Middleware\AuthenticationMiddleware > [2022-09-12 11:02:38] [debug] Kanboard\Core\Controller\BaseMiddleware::next =\> Kanboard\Middleware\PostAuthenticationMiddleware > [2022-09-12 11:02:38] [debug] Kanboard\Core\Controller\BaseMiddleware::next =\> Kanboard\Middleware\ApplicationAuthorizationMiddleware > [2022-09-12 11:02:38] [debug] Kanboard\Core\Controller\BaseMiddleware::next =\> Kanboard\Middleware\ProjectAuthorizationMiddleware > [2022-09-12 11:02:38] [debug] Kanboard\Core\Controller\Runner::executeController =\> \Kanboard\Controller\ConfigController::saveUploadedDb > [2022-09-12 13:02:39] [debug] Kanboard\Core\Controller\Runner::executeMiddleware > [2022-09-12 13:02:39] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute > [2022-09-12 13:02:39] [debug] Kanboard\Core\Controller\BaseMiddleware::next =\> Kanboard\Middleware\AuthenticationMiddleware > [2022-09-12 13:02:39] [debug] Kanboard\Core\Controller\Runner::executeMiddleware > [2022-09-12 13:02:39] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute > [2022-09-12 13:02:39] [debug] Kanboard\Core\Controller\BaseMiddleware::next =\> Kanboard\Middleware\AuthenticationMiddleware > [2022-09-12 13:02:39] [debug] Kanboard\Core\Controller\Runner::executeController =\> \Kanboard\Controller\AuthController::login > [2022-09-12 13:02:43] [debug] Kanboard\Core\Controller\Runner::executeMiddleware > [2022-09-12 13:02:43] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute > [2022-09-12 13:02:43] [debug] Kanboard\Core\Controller\BaseMiddleware::next =\> Kanboard\Middleware\AuthenticationMiddleware > [2022-09-12 13:02:43] [debug] Kanboard\Core\Controller\Runner::executeMiddleware > [2022-09-12 13:02:43] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute > [2022-09-12 13:02:43] [debug] Kanboard\Core\Controller\BaseMiddleware::next =\> Kanboard\Middleware\AuthenticationMiddleware > [2022-09-12 13:02:43] [debug] Kanboard\Core\Controller\Runner::executeController =\> \Kanboard\Controller\AuthController::login > [2022-09-12 13:02:45] [debug] Kanboard\Core\Controller\Runner::executeMiddleware > [2022-09-12 13:02:45] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute > [2022-09-12 13:02:45] [debug] Kanboard\Core\Controller\BaseMiddleware::next =\> Kanboard\Middleware\AuthenticationMiddleware > [2022-09-12 13:02:45] [debug] Kanboard\Core\Controller\Runner::executeController =\> \Kanboard\Controller\AuthController::check ---
**Author:** ![alfredb](https://yyz2.discourse-cdn.com/free1/user_avatar/kanboard.discourse.group/alfredb/32/1051_2.png) [@alfredb](https://kanboard.discourse.group/u/alfredb)\ **Post date:** [September 12, 2022, 12:09pm UTC](https://kanboard.discourse.group/t/database-malformed-error/2362/14 "2022-09-12T12:09:16Z")
Thanks for the log. > [@emzeweb](#): > > (to be continued in next post, since it’s too long to fit in this one) You can, better should use a service like [pastebin.com](http://pastebin.com) or similar for such bulky data. As I cannot see any error in the log, is everything working now? ---
**Author:** ![emzeweb](https://yyz2.discourse-cdn.com/free1/user_avatar/kanboard.discourse.group/emzeweb/32/1037_2.png) [@emzeweb](https://kanboard.discourse.group/u/emzeweb)\ **Post date:** [September 12, 2022, 12:33pm UTC](https://kanboard.discourse.group/t/database-malformed-error/2362/15 "2022-09-12T12:33:44Z")
> [@alfredb](#): > > As I cannot see any error in the log, is everything working now? Nope. Still can’t login (with correct user credentials), page refreshes to : ![Screenshot 2022-09-12 at 14-32-09 Connexion](https://global.discourse-cdn.com/free1/uploads/kanboard1/original/2X/9/9345b48e5928697c24cf506710d438b79dcdcd7d.png) ---
**Author:** ![alfredb](https://yyz2.discourse-cdn.com/free1/user_avatar/kanboard.discourse.group/alfredb/32/1051_2.png) [@alfredb](https://kanboard.discourse.group/u/alfredb)\ **Post date:** [September 12, 2022, 12:35pm UTC](https://kanboard.discourse.group/t/database-malformed-error/2362/16 "2022-09-12T12:35:34Z")
Uhhh. Could it be that you have lost your users-table? ---
**Author:** ![emzeweb](https://yyz2.discourse-cdn.com/free1/user_avatar/kanboard.discourse.group/emzeweb/32/1037_2.png) [@emzeweb](https://kanboard.discourse.group/u/emzeweb)\ **Post date:** [September 12, 2022, 12:41pm UTC](https://kanboard.discourse.group/t/database-malformed-error/2362/17 "2022-09-12T12:41:41Z")
I don’t think so, it looks ok in the db when I look it up in SQLite Expert Pro… ![users_db](https://global.discourse-cdn.com/free1/uploads/kanboard1/original/2X/e/eb250ef43fcfe385456322564cdd6aeff31e4e53.jpeg) ---
**Author:** ![alfredb](https://yyz2.discourse-cdn.com/free1/user_avatar/kanboard.discourse.group/alfredb/32/1051_2.png) [@alfredb](https://kanboard.discourse.group/u/alfredb)\ **Post date:** [September 12, 2022, 1:40pm UTC](https://kanboard.discourse.group/t/database-malformed-error/2362/18 "2022-09-12T13:40:40Z")
Did you ever clear your browser cache? As a next step, I’d uninstall all plugins, to be certain none of them disturbs. ---
**Author:** ![emzeweb](https://yyz2.discourse-cdn.com/free1/user_avatar/kanboard.discourse.group/emzeweb/32/1037_2.png) [@emzeweb](https://kanboard.discourse.group/u/emzeweb)\ **Post date:** [September 12, 2022, 2:07pm UTC](https://kanboard.discourse.group/t/database-malformed-error/2362/19 "2022-09-12T14:07:07Z")
Yes, of course, I started by clearing the browser cache. I’ve also uninstalled all plugins. But with no luck either. Also, I tried to use the “password forgotten” link, but it returns a similar symptom as the login form : when validating the form, I get the same page again, with empty fields, and error messages telling me the username is compulsory, and the captcha too, as if the fields where not filled in when the form is submitted… ![Screenshot 2022-09-12 at 16-02-53 Kanboard](https://global.discourse-cdn.com/free1/uploads/kanboard1/original/2X/d/d73bcab87ca33f68354f7fe48d37ef9c62d01f06.png) ---
**Author:** ![alfredb](https://yyz2.discourse-cdn.com/free1/user_avatar/kanboard.discourse.group/alfredb/32/1051_2.png) [@alfredb](https://kanboard.discourse.group/u/alfredb)\ **Post date:** [September 12, 2022, 2:21pm UTC](https://kanboard.discourse.group/t/database-malformed-error/2362/20 "2022-09-12T14:21:03Z")
> [@emzeweb](#): > > as if the fields where not filled in when the form is submitted… Check the browser console, whether the input is submitted. ![](https://global.discourse-cdn.com/free1/uploads/kanboard1/original/2X/d/d326569ba07580e639ffbae288bb0ebb03c3ab9a.png) [Next page](https://kanboard.discourse.group/t/database-malformed-error/2362.md?page=2)