Database malformed error

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

Why didn’t you try to solve this first? What exactly was the issue?

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…?)

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

Sorry, for disturbing you, I was just trying to get more details about your issue. Good luck!

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… :wink:

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…

seems to me that the last entries before the login issue started read as follows :

[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&timestamp=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&timestamp=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&timestamp=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 :

[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 since I encountered trouble finding some tasks since it was installed…

I recommend enabling the debug log, if not yet done. This might give some hints.

Some idea:

I hope, you used the binary mode within ftp.

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…)

I assume that’s OK. I just wasn’t sure.

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)

[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

Thanks for the log.

You can, better should use a service like pastebin.com or similar for such bulky data.

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

Uhhh. Could it be that you have lost your users-table?

I don’t think so, it looks ok in the db when I look it up in SQLite Expert Pro…

Did you ever clear your browser cache?
As a next step, I’d uninstall all plugins, to be certain none of them disturbs.

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

Check the browser console, whether the input is submitted.