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.