Skip to content

Instantly share code, notes, and snippets.

@CoMPaTech
Created March 16, 2016 09:22
Show Gist options
  • Save CoMPaTech/33d50323b4347e82b9f7 to your computer and use it in GitHub Desktop.
Save CoMPaTech/33d50323b4347e82b9f7 to your computer and use it in GitHub Desktop.
Kanboard duplicate with all boxes checked
[2016-03-16 10:19:58] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute
[2016-03-16 10:19:58] [error] ActionParameter::duplicateParameters => unable to resolve category_id=
[2016-03-16 10:19:58] [error] Action::duplicate => skip action \Kanboard\Action\TaskAssignColorCategory 8
[2016-03-16 10:19:58] [debug] 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 = ? OR projects.is_everybody_allowed = ?) AND projects.is_active IN (?)
[2016-03-16 10:19:58] [debug] QUERY_DURATION=0.00024509429931641 ALL_QUERIES_DURATION=0.00024509429931641
[2016-03-16 10:19:58] [debug] 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 (?)
[2016-03-16 10:19:58] [debug] QUERY_DURATION=0.00019598007202148 ALL_QUERIES_DURATION=0.00044107437133789
[2016-03-16 10:19:58] [debug] SELECT * FROM `actions` WHERE `project_id` IN (?, ?)
[2016-03-16 10:19:58] [debug] QUERY_DURATION=0.00017309188842773 ALL_QUERIES_DURATION=0.00061416625976562
[2016-03-16 10:19:58] [debug] SELECT * FROM `action_has_params` WHERE `action_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[2016-03-16 10:19:58] [debug] QUERY_DURATION=0.00016403198242188 ALL_QUERIES_DURATION=0.0007781982421875
[2016-03-16 10:19:58] [debug] SELECT `option`, `value` FROM `settings`
[2016-03-16 10:19:58] [debug] QUERY_DURATION=0.00010585784912109 ALL_QUERIES_DURATION=0.00088405609130859
[2016-03-16 10:19:58] [debug] SELECT 1 FROM `users` WHERE `id` = ? AND `is_active` = ?
[2016-03-16 10:19:58] [debug] QUERY_DURATION=9.2983245849609E-5 ALL_QUERIES_DURATION=0.0009770393371582
[2016-03-16 10:19:58] [debug] 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 = ? LIMIT 1
[2016-03-16 10:19:58] [debug] QUERY_DURATION=0.00016212463378906 ALL_QUERIES_DURATION=0.0011391639709473
[2016-03-16 10:19:58] [debug] SELECT * FROM `projects` WHERE `id` = ? LIMIT 1
[2016-03-16 10:19:58] [debug] QUERY_DURATION=0.00011610984802246 ALL_QUERIES_DURATION=0.0012552738189697
[2016-03-16 10:19:58] [debug] INSERT INTO `projects` (`name`, `is_active`, `last_modified`, `token`, `is_public`, `is_private`, `owner_id`) VALUES (?, ?, ?, ?, ?, ?, ?)
[2016-03-16 10:19:58] [debug] QUERY_DURATION=7.4148178100586E-5 ALL_QUERIES_DURATION=0.0013294219970703
[2016-03-16 10:19:58] [debug] SELECT `title`, `task_limit`, `description` FROM `columns` WHERE `project_id` = ? ORDER BY `position` ASC
[2016-03-16 10:19:58] [debug] QUERY_DURATION=0.00012302398681641 ALL_QUERIES_DURATION=0.0014524459838867
[2016-03-16 10:19:58] [debug] INSERT INTO `columns` (`title`, `position`, `project_id`, `task_limit`, `description`) VALUES (?, ?, ?, ?, ?)
[2016-03-16 10:19:58] [debug] QUERY_DURATION=9.2029571533203E-5 ALL_QUERIES_DURATION=0.0015444755554199
[2016-03-16 10:19:58] [debug] INSERT INTO `columns` (`title`, `position`, `project_id`, `task_limit`, `description`) VALUES (?, ?, ?, ?, ?)
[2016-03-16 10:19:58] [debug] QUERY_DURATION=5.2928924560547E-5 ALL_QUERIES_DURATION=0.0015974044799805
[2016-03-16 10:19:58] [debug] INSERT INTO `columns` (`title`, `position`, `project_id`, `task_limit`, `description`) VALUES (?, ?, ?, ?, ?)
[2016-03-16 10:19:58] [debug] QUERY_DURATION=4.887580871582E-5 ALL_QUERIES_DURATION=0.0016462802886963
[2016-03-16 10:19:58] [debug] INSERT INTO `columns` (`title`, `position`, `project_id`, `task_limit`, `description`) VALUES (?, ?, ?, ?, ?)
[2016-03-16 10:19:58] [debug] QUERY_DURATION=4.5061111450195E-5 ALL_QUERIES_DURATION=0.0016913414001465
[2016-03-16 10:19:58] [debug] INSERT INTO `columns` (`title`, `position`, `project_id`, `task_limit`, `description`) VALUES (?, ?, ?, ?, ?)
[2016-03-16 10:19:58] [debug] QUERY_DURATION=4.5061111450195E-5 ALL_QUERIES_DURATION=0.0017364025115967
[2016-03-16 10:19:58] [debug] INSERT INTO `columns` (`title`, `position`, `project_id`, `task_limit`, `description`) VALUES (?, ?, ?, ?, ?)
[2016-03-16 10:19:58] [debug] QUERY_DURATION=5.3167343139648E-5 ALL_QUERIES_DURATION=0.0017895698547363
[2016-03-16 10:19:58] [debug] SELECT `name` FROM `project_has_categories` WHERE `project_id` = ? ORDER BY `name` ASC
[2016-03-16 10:19:58] [debug] QUERY_DURATION=8.5830688476562E-5 ALL_QUERIES_DURATION=0.0018754005432129
[2016-03-16 10:19:58] [debug] INSERT INTO `project_has_categories` (`name`, `project_id`) VALUES (?, ?)
[2016-03-16 10:19:58] [debug] QUERY_DURATION=5.2928924560547E-5 ALL_QUERIES_DURATION=0.0019283294677734
[2016-03-16 10:19:58] [debug] INSERT INTO `project_has_categories` (`name`, `project_id`) VALUES (?, ?)
[2016-03-16 10:19:58] [debug] QUERY_DURATION=6.5088272094727E-5 ALL_QUERIES_DURATION=0.0019934177398682
[2016-03-16 10:19:58] [debug] INSERT INTO `project_has_categories` (`name`, `project_id`) VALUES (?, ?)
[2016-03-16 10:19:58] [debug] QUERY_DURATION=4.2915344238281E-5 ALL_QUERIES_DURATION=0.0020363330841064
[2016-03-16 10:19:58] [debug] INSERT INTO `project_has_categories` (`name`, `project_id`) VALUES (?, ?)
[2016-03-16 10:19:58] [debug] QUERY_DURATION=4.1961669921875E-5 ALL_QUERIES_DURATION=0.0020782947540283
[2016-03-16 10:19:58] [debug] INSERT INTO `project_has_categories` (`name`, `project_id`) VALUES (?, ?)
[2016-03-16 10:19:58] [debug] QUERY_DURATION=4.1007995605469E-5 ALL_QUERIES_DURATION=0.0021193027496338
[2016-03-16 10:19:58] [debug] INSERT INTO `project_has_categories` (`name`, `project_id`) VALUES (?, ?)
[2016-03-16 10:19:58] [debug] QUERY_DURATION=5.0067901611328E-5 ALL_QUERIES_DURATION=0.0021693706512451
[2016-03-16 10:19:58] [debug] SELECT * FROM `project_has_users` WHERE `project_id` = ?
[2016-03-16 10:19:58] [debug] QUERY_DURATION=6.6995620727539E-5 ALL_QUERIES_DURATION=0.0022363662719727
[2016-03-16 10:19:58] [debug] INSERT INTO `project_has_users` (`project_id`, `user_id`, `role`) VALUES (?, ?, ?)
[2016-03-16 10:19:58] [debug] QUERY_DURATION=4.8160552978516E-5 ALL_QUERIES_DURATION=0.0022845268249512
[2016-03-16 10:19:58] [debug] SELECT * FROM `project_has_groups` WHERE `project_id` = ?
[2016-03-16 10:19:58] [debug] QUERY_DURATION=7.7009201049805E-5 ALL_QUERIES_DURATION=0.002361536026001
[2016-03-16 10:19:58] [debug] SELECT * FROM `actions` WHERE `project_id` = ?
[2016-03-16 10:19:58] [debug] QUERY_DURATION=9.2029571533203E-5 ALL_QUERIES_DURATION=0.0024535655975342
[2016-03-16 10:19:58] [debug] SELECT * FROM `action_has_params` WHERE `action_id` IN (?, ?, ?, ?, ?, ?, ?, ?)
[2016-03-16 10:19:58] [debug] QUERY_DURATION=0.00011515617370605 ALL_QUERIES_DURATION=0.0025687217712402
[2016-03-16 10:19:58] [debug] INSERT INTO `actions` (`project_id`, `event_name`, `action_name`) VALUES (?, ?, ?)
[2016-03-16 10:19:58] [debug] QUERY_DURATION=6.1988830566406E-5 ALL_QUERIES_DURATION=0.0026307106018066
[2016-03-16 10:19:58] [debug] INSERT INTO `action_has_params` (`action_id`, `name`, `value`) VALUES (?, ?, ?)
[2016-03-16 10:19:58] [debug] QUERY_DURATION=5.4121017456055E-5 ALL_QUERIES_DURATION=0.0026848316192627
[2016-03-16 10:19:58] [debug] SELECT `name` FROM `project_has_categories` WHERE `id` = ? LIMIT 1
[2016-03-16 10:19:58] [debug] QUERY_DURATION=4.7922134399414E-5 ALL_QUERIES_DURATION=0.0027327537536621
[2016-03-16 10:19:58] [debug] SELECT `id` FROM `project_has_categories` WHERE `project_id` = ? AND `name` = ? LIMIT 1
[2016-03-16 10:19:58] [debug] QUERY_DURATION=6.1988830566406E-5 ALL_QUERIES_DURATION=0.0027947425842285
[2016-03-16 10:19:58] [debug] INSERT INTO `actions` (`project_id`, `event_name`, `action_name`) VALUES (?, ?, ?)
[2016-03-16 10:19:58] [debug] SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`kanboard`.`actions`, CONSTRAINT `actions_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE)
[2016-03-16 10:19:58] [debug] INSERT INTO `actions` (`project_id`, `event_name`, `action_name`) VALUES (?, ?, ?)
[2016-03-16 10:19:58] [debug] SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`kanboard`.`actions`, CONSTRAINT `actions_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE)
[2016-03-16 10:19:58] [debug] INSERT INTO `actions` (`project_id`, `event_name`, `action_name`) VALUES (?, ?, ?)
[2016-03-16 10:19:58] [debug] SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`kanboard`.`actions`, CONSTRAINT `actions_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE)
[2016-03-16 10:19:58] [debug] INSERT INTO `actions` (`project_id`, `event_name`, `action_name`) VALUES (?, ?, ?)
[2016-03-16 10:19:58] [debug] SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`kanboard`.`actions`, CONSTRAINT `actions_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE)
[2016-03-16 10:19:58] [debug] INSERT INTO `actions` (`project_id`, `event_name`, `action_name`) VALUES (?, ?, ?)
[2016-03-16 10:19:58] [debug] SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`kanboard`.`actions`, CONSTRAINT `actions_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE)
[2016-03-16 10:19:58] [debug] INSERT INTO `actions` (`project_id`, `event_name`, `action_name`) VALUES (?, ?, ?)
[2016-03-16 10:19:58] [debug] SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`kanboard`.`actions`, CONSTRAINT `actions_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE)
[2016-03-16 10:19:58] [debug] INSERT INTO `actions` (`project_id`, `event_name`, `action_name`) VALUES (?, ?, ?)
[2016-03-16 10:19:58] [debug] SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`kanboard`.`actions`, CONSTRAINT `actions_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE)
[2016-03-16 10:19:58] [debug] SELECT * FROM `swimlanes` WHERE `project_id` = ? ORDER BY `position` ASC
[2016-03-16 10:19:58] [debug] QUERY_DURATION=0.00014400482177734 ALL_QUERIES_DURATION=0.0029387474060059
[2016-03-16 10:19:58] [debug] INSERT INTO `swimlanes` (`name`, `position`, `is_active`, `project_id`, `description`) VALUES (?, ?, ?, ?, ?)
[2016-03-16 10:19:58] [debug] SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`kanboard`.`swimlanes`, CONSTRAINT `swimlanes_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE)
[2016-03-16 10:19:58] [debug] SQL_QUERIES=33
[2016-03-16 10:19:58] [debug] RENDERING=0.043154001235962
[2016-03-16 10:19:58] [debug] MEMORY=4.98M
[2016-03-16 10:19:58] [debug] URI=/kb/?controller=project&action=duplicate&project_id=2&duplicate=yes
[2016-03-16 10:19:58] [debug] ###############################################
[2016-03-16 10:19:58] [debug] Subscriber executed: Kanboard\Subscriber\BootstrapSubscriber::execute
[2016-03-16 10:19:58] [debug] Rendering app/notfound in 7.3909759521484E-5s, total=7.3909759521484E-5
[2016-03-16 10:19:58] [debug] Rendering header in 0.00072979927062988s, total=0.00080370903015137
[2016-03-16 10:19:58] [debug] Rendering layout in 0.00094199180603027s, total=0.0017457008361816
[2016-03-16 10:19:58] [debug] 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 = ? OR projects.is_everybody_allowed = ?) AND projects.is_active IN (?)
[2016-03-16 10:19:58] [debug] QUERY_DURATION=0.0001981258392334 ALL_QUERIES_DURATION=0.0001981258392334
[2016-03-16 10:19:58] [debug] 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 (?)
[2016-03-16 10:19:58] [debug] QUERY_DURATION=0.00015497207641602 ALL_QUERIES_DURATION=0.00035309791564941
[2016-03-16 10:19:58] [debug] SELECT * FROM `actions` WHERE `project_id` IN (?, ?)
[2016-03-16 10:19:58] [debug] QUERY_DURATION=0.00010800361633301 ALL_QUERIES_DURATION=0.00046110153198242
[2016-03-16 10:19:58] [debug] SELECT * FROM `action_has_params` WHERE `action_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[2016-03-16 10:19:58] [debug] QUERY_DURATION=0.00015592575073242 ALL_QUERIES_DURATION=0.00061702728271484
[2016-03-16 10:19:58] [debug] SELECT `option`, `value` FROM `settings`
[2016-03-16 10:19:58] [debug] QUERY_DURATION=9.7990036010742E-5 ALL_QUERIES_DURATION=0.00071501731872559
[2016-03-16 10:19:58] [debug] SELECT 1 FROM `users` WHERE `id` = ? AND `is_active` = ?
[2016-03-16 10:19:58] [debug] QUERY_DURATION=0.00010180473327637 ALL_QUERIES_DURATION=0.00081682205200195
[2016-03-16 10:19:58] [debug] 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 = ? LIMIT 1
[2016-03-16 10:19:58] [debug] QUERY_DURATION=0.00011110305786133 ALL_QUERIES_DURATION=0.00092792510986328
[2016-03-16 10:19:58] [debug] SELECT 1 FROM `user_has_unread_notifications` WHERE `user_id` = ?
[2016-03-16 10:19:58] [debug] QUERY_DURATION=9.7990036010742E-5 ALL_QUERIES_DURATION=0.001025915145874
[2016-03-16 10:19:58] [debug] SQL_QUERIES=8
[2016-03-16 10:19:58] [debug] RENDERING=0.027294158935547
[2016-03-16 10:19:58] [debug] MEMORY=4.83M
[2016-03-16 10:19:58] [debug] URI=/kb/project/
[2016-03-16 10:19:58] [debug] ###############################################
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment