The error log file of my Kanboard has been flooded with these messages but I don’t know what’s gone wrong. I deleted a 2-GB log file, and after about 10 minutes it’s now 5MB. Could someone please tell me what the problem is and how to fix it? Thank you very much.
Mao
[15-Apr-2022 01:57:14 UTC] [debug] Kanboard\Core\Controller\Runner::executeMiddleware
[15-Apr-2022 01:57:14 UTC] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\AuthenticationMiddleware
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\PostAuthenticationMiddleware
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\ApplicationAuthorizationMiddleware
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] Kanboard\Core\Controller\BaseMiddleware::next => Kanboard\Middleware\ProjectAuthorizationMiddleware
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] Kanboard\Core\Controller\Runner::executeController => \Kanboard\Controller\DashboardController::show
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT version FROM plugin_schema_versions WHERE plugin = ? LIMIT 1
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=0.00069189071655273
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.00069189071655273
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT * FROM customizer_files WHERE custom_id = ? LIMIT 1
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=0.0010521411895752
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.0017440319061279
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT option, value FROM settings
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=0.0018420219421387
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.0035860538482666
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT version FROM plugin_schema_versions WHERE plugin = ? LIMIT 1
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=0.00010204315185547
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.0036880970001221
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT version FROM plugin_schema_versions WHERE plugin = ? LIMIT 1
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=0.00012707710266113
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.0038151741027832
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT version FROM plugin_schema_versions WHERE plugin = ? LIMIT 1
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=0.00011205673217773
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.0039272308349609
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT data FROM sessions WHERE id = ? LIMIT 1
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=0.0012378692626953
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.0051651000976562
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [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 (?)
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=0.0020229816436768
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.007188081741333
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [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 (?)
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=0.0017600059509277
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.0089480876922607
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT * FROM actions WHERE project_id IN (?)
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=0.0013711452484131
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.010319232940674
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT * FROM action_has_params WHERE action_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=0.0011019706726074
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.011421203613281
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT value FROM user_has_metadata WHERE user_id = ? AND name = ? LIMIT 1
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=0.0019209384918213
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.013342142105103
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT 1 FROM users WHERE id = ? AND is_active = ? AND role = ?
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=0.001600980758667
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.01494312286377
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT * FROM users WHERE id = ? LIMIT 1
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=0.00018215179443359
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.015125274658203
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [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 (?)
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=0.0001978874206543
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.015323162078857
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [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 (?)
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=0.00014400482177734
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.015467166900635
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT COUNT() FROM tasks LEFT JOIN users ON users.id=tasks.owner_id LEFT JOIN users AS uc ON uc.id=tasks.creator_id LEFT JOIN project_has_categories ON project_has_categories.id=tasks.category_id LEFT JOIN columns ON columns.id=tasks.column_id LEFT JOIN swimlanes ON swimlanes.id=tasks.swimlane_id LEFT JOIN groups ON groups.id=tasks.owner_gp LEFT JOIN multiselect ON multiselect.id=tasks.owner_ms LEFT JOIN projects ON projects.id=tasks.project_id WHERE (tasks.owner_id = ? OR tasks.id IN (SELECT task_id FROM subtasks WHERE subtasks.user_id=‘1’) OR tasks.owner_gp IN (SELECT group_id FROM group_has_users WHERE group_has_users.user_id=‘1’) OR tasks.owner_ms IN (SELECT group_id FROM multiselect_has_users WHERE multiselect_has_users.user_id=‘1’)) AND tasks.is_active = ? AND projects.is_active = ? AND columns.hide_in_dashboard = ? AND projects.id = ?
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=0.036042213439941
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.051509380340576
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [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 (?)
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=0.00027012825012207
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.051779508590698
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [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 (?)
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=0.00014710426330566
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.051926612854004
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT COUNT() FROM projects LEFT JOIN users ON users.id=projects.owner_id WHERE projects.id IN (?)
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=0.00010895729064941
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.052035570144653
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT projects., users.username AS owner_username, users.name AS owner_name FROM projects LEFT JOIN users ON users.id=projects.owner_id WHERE projects.id IN (?) ORDER BY projects.name ASC LIMIT 10 OFFSET 0
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=0.0002138614654541
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.052249431610107
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT id, title, position, task_limit, description, hide_in_dashboard, project_id, (SELECT COUNT() FROM tasks WHERE column_id=columns.id AND is_active=‘1’) AS nb_open_tasks, (SELECT COUNT() FROM tasks WHERE column_id=columns.id AND is_active=‘0’) AS nb_closed_tasks FROM columns WHERE project_id = ? ORDER BY position ASC
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=0.00276780128479
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.055017232894897
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT 1 FROM project_has_metadata WHERE project_id = ? AND name = ?
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=0.001133918762207
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.056151151657104
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT value FROM project_has_metadata WHERE project_id = ? AND name = ? LIMIT 1
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=0.00011992454528809
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.056271076202393
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT (SELECT COUNT() FROM comments WHERE task_id=tasks.id) AS nb_comments, (SELECT COUNT() FROM task_has_files WHERE task_id=tasks.id) AS nb_files, (SELECT COUNT() FROM subtasks WHERE subtasks.task_id=tasks.id) AS nb_subtasks, (SELECT COUNT() FROM subtasks WHERE subtasks.task_id=tasks.id AND status=2) AS nb_completed_subtasks, (SELECT COUNT() FROM task_has_links WHERE task_has_links.task_id = tasks.id) AS nb_links, (SELECT COUNT() FROM task_has_external_links WHERE task_has_external_links.task_id = tasks.id) AS nb_external_links, (SELECT DISTINCT 1 FROM task_has_links WHERE task_has_links.task_id = tasks.id AND task_has_links.link_id = 9) AS is_milestone, tasks.id, tasks.reference, tasks.title, tasks.description, tasks.date_creation, tasks.date_modification, tasks.date_completed, tasks.date_started, tasks.date_due, tasks.color_id, tasks.project_id, tasks.column_id, tasks.swimlane_id, tasks.owner_id, tasks.creator_id, tasks.position, tasks.is_active, tasks.score, tasks.category_id, tasks.priority, tasks.date_moved, tasks.recurrence_status, tasks.recurrence_trigger, tasks.recurrence_factor, tasks.recurrence_timeframe, tasks.recurrence_basedate, tasks.recurrence_parent, tasks.recurrence_child, tasks.time_estimated, tasks.time_spent, users.username AS assignee_username, users.name AS assignee_name, users.email AS assignee_email, users.avatar_path AS assignee_avatar_path, project_has_categories.name AS category_name, project_has_categories.description AS category_description, project_has_categories.color_id AS category_color_id, columns.title AS column_name, columns.position AS column_position, swimlanes.name AS swimlane_name, projects.name AS project_name, tasks.owner_ms, groups.name AS assigned_groupname FROM tasks LEFT JOIN users ON users.id=tasks.owner_id LEFT JOIN users AS uc ON uc.id=tasks.creator_id LEFT JOIN project_has_categories ON project_has_categories.id=tasks.category_id LEFT JOIN columns ON columns.id=tasks.column_id LEFT JOIN swimlanes ON swimlanes.id=tasks.swimlane_id LEFT JOIN groups ON groups.id=tasks.owner_gp LEFT JOIN multiselect ON multiselect.id=tasks.owner_ms LEFT JOIN projects ON projects.id=tasks.project_id WHERE (tasks.owner_id = ? OR tasks.id IN (SELECT task_id FROM subtasks WHERE subtasks.user_id=‘1’) OR tasks.owner_gp IN (SELECT group_id FROM group_has_users WHERE group_has_users.user_id=‘1’) OR tasks.owner_ms IN (SELECT group_id FROM multiselect_has_users WHERE multiselect_has_users.user_id=‘1’)) AND tasks.is_active = ? AND projects.is_active = ? AND columns.hide_in_dashboard = ? AND projects.id = ? ORDER BY tasks.priority DESC LIMIT 15 OFFSET 0
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=0.02752685546875
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.083797931671143
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT tags.id, tags.name, tags.color_id, task_has_tags.task_id FROM tags LEFT JOIN task_has_tags ON task_has_tags.tag_id=tags.id WHERE task_has_tags.task_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY tags.name ASC
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=0.0084829330444336
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.092280864715576
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT subtasks., users.username, users.name, (SELECT start FROM subtask_time_tracking WHERE user_id=‘1’ AND end=‘0’ AND subtask_id=subtasks.id LIMIT 1) AS timer_start_date FROM subtasks LEFT JOIN users ON users.id=subtasks.user_id WHERE task_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND subtasks.user_id = ? ORDER BY subtasks.position ASC
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=0.0066349506378174
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.098915815353394
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT role FROM project_has_users WHERE user_id = ? AND project_id = ? LIMIT 1
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=0.00017094612121582
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.099086761474609
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT project_role_has_restrictions.restriction_id, project_role_has_restrictions.project_id, project_role_has_restrictions.role_id, project_role_has_restrictions.rule, pr.role FROM project_role_has_restrictions LEFT JOIN project_has_roles AS pr ON pr.role_id=project_role_has_restrictions.role_id WHERE project_role_has_restrictions.project_id = ? AND role = ?
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=0.0024571418762207
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.10154390335083
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT value FROM project_has_metadata WHERE project_id = ? AND name = ? LIMIT 1
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=0.00016093254089355
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.10170483589172
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT value FROM project_has_metadata WHERE project_id = ? AND name = ? LIMIT 1
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=8.5115432739258E-5
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.10178995132446
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT value FROM project_has_metadata WHERE project_id = ? AND name = ? LIMIT 1
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=6.8902969360352E-5
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.10185885429382
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT value FROM project_has_metadata WHERE project_id = ? AND name = ? LIMIT 1
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=6.3180923461914E-5
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.10192203521729
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT value FROM project_has_metadata WHERE project_id = ? AND name = ? LIMIT 1
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=6.0081481933594E-5
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.10198211669922
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT value FROM project_has_metadata WHERE project_id = ? AND name = ? LIMIT 1
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=8.2015991210938E-5
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.10206413269043
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT value FROM project_has_metadata WHERE project_id = ? AND name = ? LIMIT 1
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: query_duration=6.3896179199219E-5
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: total_execution_time=0.10212802886963
[15-Apr-2022 08:57:14 Asia/Ho_Chi_Minh] [debug] SQL: SELECT value FROM project_has_metadata WHERE project_id = ? AND name = ? LIMIT 1