|
1
|
Started POST "/projects/xxxx-rplus/issues" for 31.18.159.163 at 2016-11-23 21:58:59 +0100
|
|
2
|
Processing by IssuesController#create as HTML
|
|
3
|
Parameters: {"utf8"=>"?", "authenticity_token"=>"5hf8+Nh813lQ9s6t4XWwXveXF8lBzEFiRYOLQHCvBP4=", "issue"=>{"is_private"=>"0", "tracker_id"=>"2", "subject"=>"LCmd GC Rolle V0 - Dialogüberschrift anpassen", "description"=>"<pre>\r\nPanel OPRPDIG\r\n\r\nJe nachdem welche Version einer Rolle mit dem LCmd GC aufgerufen wurde, sollte die Panel-Überschrift entsprechend sein\r\n\r\nRolle V = 0 - Panel-Überschrift - List role connected groups\r\nRolle V > 0 - Panel-Überschrift - List user connected groups\r\n</pre> ", "status_id"=>"1", "priority_id"=>"2", "assigned_to_id"=>"5", "fixed_version_id"=>"5", "parent_issue_id"=>"", "start_date"=>"2016-11-23", "due_date"=>"", "estimated_hours"=>"", "done_ratio"=>"0", "custom_field_values"=>{"2"=>[""], "3"=>""}}, "commit"=>"Anlegen", "project_id"=>"xxxx-rplus"}
|
|
4
|
[1m[35m (0.4ms)[0m SELECT MAX(`settings`.`updated_on`) AS max_id FROM `settings`
|
|
5
|
[1m[36mUser Load (0.5ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `users`.`status` = 1 AND `users`.`id` = 6 LIMIT 1[0m
|
|
6
|
Current user: jaro (id=6)
|
|
7
|
[1m[35mProject Load (0.4ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`identifier` = 'xxxx-rplus' LIMIT 1
|
|
8
|
[1m[36mSQL (0.5ms)[0m [1mSELECT `enabled_modules`.`name` FROM `enabled_modules` WHERE `enabled_modules`.`project_id` = 10[0m
|
|
9
|
[1m[35mIssueStatus Load (0.4ms)[0m SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`is_default` = 1 LIMIT 1
|
|
10
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`is_default` = 1 LIMIT 1[0m
|
|
11
|
[1m[35mIssuePriority Load (0.7ms)[0m SELECT `enumerations`.* FROM `enumerations` WHERE `enumerations`.`type` IN ('IssuePriority') AND `enumerations`.`is_default` = 1 ORDER BY enumerations.position ASC LIMIT 1
|
|
12
|
[1m[36mProject Load (0.4ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 10 LIMIT 1[0m
|
|
13
|
[1m[35mTracker Load (0.5ms)[0m SELECT `trackers`.* FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.`id` = `projects_trackers`.`tracker_id` WHERE `projects_trackers`.`project_id` = 10 AND `trackers`.`id` = 2 ORDER BY trackers.position LIMIT 1
|
|
14
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`is_default` = 1 LIMIT 1[0m
|
|
15
|
[1m[35mRole Load (0.4ms)[0m SELECT `roles`.* FROM `roles`
|
|
16
|
[1m[36mWorkflowTransition Load (1.1ms)[0m [1mSELECT `workflows`.* FROM `workflows` WHERE `workflows`.`type` IN ('WorkflowTransition') AND `workflows`.`old_status_id` = 1 AND (role_id IN (1,2,3,4,5,6) AND tracker_id = 2 AND ((author = 0 AND assignee = 0) OR author = 1))[0m
|
|
17
|
[1m[35mIssueStatus Load (0.5ms)[0m SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` IN (2, 3, 4, 5, 6, 1)
|
|
18
|
[1m[36mSQL (0.5ms)[0m [1mSELECT `enabled_modules`.`name` FROM `enabled_modules` WHERE `enabled_modules`.`project_id` = 10[0m
|
|
19
|
[1m[35mCACHE (0.0ms)[0m SELECT `roles`.* FROM `roles`
|
|
20
|
[1m[36m (0.8ms)[0m [1mSELECT COUNT(*) FROM `workflows` WHERE `workflows`.`type` IN ('WorkflowPermission') AND `workflows`.`tracker_id` = 2 AND `workflows`.`old_status_id` = 1 AND `workflows`.`role_id` IN (1, 2, 3, 4, 5, 6)[0m
|
|
21
|
[1m[35mTracker Load (0.4ms)[0m SELECT `trackers`.* FROM `trackers` WHERE `trackers`.`id` = 2 LIMIT 1
|
|
22
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `roles`.* FROM `roles` [0m
|
|
23
|
[1m[35mCACHE (0.0ms)[0m SELECT COUNT(*) FROM `workflows` WHERE `workflows`.`type` IN ('WorkflowPermission') AND `workflows`.`tracker_id` = 2 AND `workflows`.`old_status_id` = 1 AND `workflows`.`role_id` IN (1, 2, 3, 4, 5, 6)
|
|
24
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`is_default` = 1 LIMIT 1[0m
|
|
25
|
[1m[35mCACHE (0.0ms)[0m SELECT `roles`.* FROM `roles`
|
|
26
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `workflows`.* FROM `workflows` WHERE `workflows`.`type` IN ('WorkflowTransition') AND `workflows`.`old_status_id` = 1 AND (role_id IN (1,2,3,4,5,6) AND tracker_id = 2 AND ((author = 0 AND assignee = 0) OR author = 1))[0m
|
|
27
|
[1m[35mCACHE (0.0ms)[0m SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` IN (2, 3, 4, 5, 6, 1)
|
|
28
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`is_default` = 1 LIMIT 1[0m
|
|
29
|
[1m[35mCACHE (0.0ms)[0m SELECT `roles`.* FROM `roles`
|
|
30
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `workflows`.* FROM `workflows` WHERE `workflows`.`type` IN ('WorkflowTransition') AND `workflows`.`old_status_id` = 1 AND (role_id IN (1,2,3,4,5,6) AND tracker_id = 2 AND ((author = 0 AND assignee = 0) OR author = 1))[0m
|
|
31
|
[1m[35mCACHE (0.0ms)[0m SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` IN (2, 3, 4, 5, 6, 1)
|
|
32
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `roles`.* FROM `roles` [0m
|
|
33
|
[1m[35mCACHE (0.0ms)[0m SELECT COUNT(*) FROM `workflows` WHERE `workflows`.`type` IN ('WorkflowPermission') AND `workflows`.`tracker_id` = 2 AND `workflows`.`old_status_id` = 1 AND `workflows`.`role_id` IN (1, 2, 3, 4, 5, 6)
|
|
34
|
[1m[36mIssueCustomField Load (0.7ms)[0m [1mSELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`type` IN ('IssueCustomField') AND (is_for_all = 1 OR id IN (SELECT DISTINCT cfp.custom_field_id FROM custom_fields_projects cfp WHERE cfp.project_id = 10)) ORDER BY custom_fields.position ASC[0m
|
|
35
|
[1m[35mIssueCustomField Load (0.5ms)[0m SELECT `custom_fields`.* FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.`id` = `custom_fields_trackers`.`custom_field_id` WHERE `custom_fields`.`type` IN ('IssueCustomField') AND `custom_fields_trackers`.`tracker_id` = 2
|
|
36
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `roles`.* FROM `roles` [0m
|
|
37
|
[1m[35mCACHE (0.0ms)[0m SELECT COUNT(*) FROM `workflows` WHERE `workflows`.`type` IN ('WorkflowPermission') AND `workflows`.`tracker_id` = 2 AND `workflows`.`old_status_id` = 1 AND `workflows`.`role_id` IN (1, 2, 3, 4, 5, 6)
|
|
38
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `roles`.* FROM `roles` [0m
|
|
39
|
[1m[35mCACHE (0.0ms)[0m SELECT COUNT(*) FROM `workflows` WHERE `workflows`.`type` IN ('WorkflowPermission') AND `workflows`.`tracker_id` = 2 AND `workflows`.`old_status_id` = 1 AND `workflows`.`role_id` IN (1, 2, 3, 4, 5, 6)
|
|
40
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`is_default` = 1 LIMIT 1[0m
|
|
41
|
[1m[35mCACHE (0.0ms)[0m SELECT `roles`.* FROM `roles`
|
|
42
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `workflows`.* FROM `workflows` WHERE `workflows`.`type` IN ('WorkflowTransition') AND `workflows`.`old_status_id` = 1 AND (role_id IN (1,2,3,4,5,6) AND tracker_id = 2 AND ((author = 0 AND assignee = 0) OR author = 1))[0m
|
|
43
|
[1m[35mCACHE (0.0ms)[0m SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` IN (2, 3, 4, 5, 6, 1)
|
|
44
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`is_default` = 1 LIMIT 1[0m
|
|
45
|
[1m[35m (0.7ms)[0m SELECT DISTINCT COUNT(DISTINCT `users`.`id`) FROM `users` INNER JOIN `members` ON `members`.`user_id` = `users`.`id` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `users`.`status` = 1 AND (members.project_id = 10)
|
|
46
|
[1m[36mUser Load (0.8ms)[0m [1mSELECT DISTINCT `users`.* FROM `users` INNER JOIN `members` ON `members`.`user_id` = `users`.`id` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `users`.`status` = 1 AND (members.project_id = 10)[0m
|
|
47
|
[1m[35m (0.1ms)[0m BEGIN
|
|
48
|
[1m[36mIssuePriority Load (0.5ms)[0m [1mSELECT `enumerations`.* FROM `enumerations` WHERE `enumerations`.`type` IN ('IssuePriority') AND `enumerations`.`id` = 2 ORDER BY enumerations.position ASC LIMIT 1[0m
|
|
49
|
[1m[35mIssueStatus Load (0.4ms)[0m SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` = 1 LIMIT 1
|
|
50
|
[1m[36mVersion Load (0.5ms)[0m [1mSELECT `versions`.* FROM `versions` WHERE `versions`.`id` = 5 LIMIT 1[0m
|
|
51
|
[1m[35mProject Load (0.7ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`parent_id` IS NULL AND (`projects`.`lft` <= 30) AND (`projects`.`rgt` >= 31) ORDER BY `projects`.`lft` LIMIT 1
|
|
52
|
[1m[36mSQL (1.0ms)[0m [1mSELECT `versions`.`id` AS t0_r0, `versions`.`project_id` AS t0_r1, `versions`.`name` AS t0_r2, `versions`.`description` AS t0_r3, `versions`.`effective_date` AS t0_r4, `versions`.`created_on` AS t0_r5, `versions`.`updated_on` AS t0_r6, `versions`.`wiki_page_title` AS t0_r7, `versions`.`status` AS t0_r8, `versions`.`sharing` AS t0_r9, `projects`.`id` AS t1_r0, `projects`.`name` AS t1_r1, `projects`.`description` AS t1_r2, `projects`.`homepage` AS t1_r3, `projects`.`is_public` AS t1_r4, `projects`.`parent_id` AS t1_r5, `projects`.`created_on` AS t1_r6, `projects`.`updated_on` AS t1_r7, `projects`.`identifier` AS t1_r8, `projects`.`status` AS t1_r9, `projects`.`lft` AS t1_r10, `projects`.`rgt` AS t1_r11, `projects`.`inherit_members` AS t1_r12 FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.`id` = `versions`.`project_id` WHERE `versions`.`status` = 'open' AND (projects.id = 10 OR (projects.status <> 9 AND ( versions.sharing = 'system' OR (projects.lft >= 25 AND projects.rgt <= 32 AND versions.sharing = 'tree') OR (projects.lft < 30 AND projects.rgt > 31 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 30 AND projects.rgt < 31 AND versions.sharing = 'hierarchy'))))[0m
|
|
53
|
[1m[35mTracker Exists (0.5ms)[0m SELECT 1 AS one FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.`id` = `projects_trackers`.`tracker_id` WHERE `projects_trackers`.`project_id` = 10 AND `trackers`.`id` = 2 LIMIT 1
|
|
54
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `roles`.* FROM `roles` [0m
|
|
55
|
[1m[35mCACHE (0.0ms)[0m SELECT COUNT(*) FROM `workflows` WHERE `workflows`.`type` IN ('WorkflowPermission') AND `workflows`.`tracker_id` = 2 AND `workflows`.`old_status_id` = 1 AND `workflows`.`role_id` IN (1, 2, 3, 4, 5, 6)
|
|
56
|
[1m[36mIssue Load (1.4ms)[0m [1mSELECT `issues`.* FROM `issues` ORDER BY `issues`.`rgt` desc LIMIT 1 FOR UPDATE[0m
|
|
57
|
[1m[35mIssue Load (1.4ms)[0m SELECT `issues`.* FROM `issues` ORDER BY `issues`.`rgt` desc LIMIT 1 FOR UPDATE
|
|
58
|
[1m[36mPrincipal Load (0.5ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 5 LIMIT 1[0m
|
|
59
|
[1m[35mSQL (0.6ms)[0m INSERT INTO `issues` (`assigned_to_id`, `author_id`, `category_id`, `closed_on`, `created_on`, `description`, `done_ratio`, `due_date`, `estimated_hours`, `fixed_version_id`, `is_private`, `lft`, `lock_version`, `parent_id`, `priority_id`, `project_id`, `rgt`, `root_id`, `start_date`, `status_id`, `subject`, `tracker_id`, `updated_on`) VALUES (5, 6, NULL, NULL, '2016-11-23 21:58:59', '<pre>\r\nPanel OPRPDIG\r\n\r\nJe nachdem welche Version einer Rolle mit dem LCmd GC aufgerufen wurde, sollte die Panel-Überschrift entsprechend sein\r\n\r\nRolle V = 0 - Panel-Überschrift - List role connected groups\r\nRolle V > 0 - Panel-Überschrift - List user connected groups\r\n</pre> ', 0, NULL, NULL, 5, 0, 553, 0, NULL, 2, 10, 554, NULL, '2016-11-23', 1, 'LCmd GC Rolle V0 - Dialogüberschrift anpassen', 2, '2016-11-23 21:58:59')
|
|
60
|
[1m[36mSQL (0.3ms)[0m [1mINSERT INTO `custom_values` (`custom_field_id`, `customized_id`, `customized_type`, `value`) VALUES (2, 283, 'Issue', '')[0m
|
|
61
|
[1m[35mSQL (0.4ms)[0m INSERT INTO `custom_values` (`custom_field_id`, `customized_id`, `customized_type`, `value`) VALUES (3, 283, 'Issue', '')
|
|
62
|
[1m[36mSQL (1.0ms)[0m [1mSELECT `members`.`id` AS t0_r0, `members`.`user_id` AS t0_r1, `members`.`project_id` AS t0_r2, `members`.`created_on` AS t0_r3, `members`.`mail_notification` AS t0_r4, `users`.`id` AS t1_r0, `users`.`login` AS t1_r1, `users`.`hashed_password` AS t1_r2, `users`.`firstname` AS t1_r3, `users`.`lastname` AS t1_r4, `users`.`mail` AS t1_r5, `users`.`admin` AS t1_r6, `users`.`status` AS t1_r7, `users`.`last_login_on` AS t1_r8, `users`.`language` AS t1_r9, `users`.`auth_source_id` AS t1_r10, `users`.`created_on` AS t1_r11, `users`.`updated_on` AS t1_r12, `users`.`type` AS t1_r13, `users`.`identity_url` AS t1_r14, `users`.`mail_notification` AS t1_r15, `users`.`salt` AS t1_r16, `users`.`must_change_passwd` AS t1_r17, `users`.`passwd_changed_on` AS t1_r18, `roles`.`id` AS t2_r0, `roles`.`name` AS t2_r1, `roles`.`position` AS t2_r2, `roles`.`assignable` AS t2_r3, `roles`.`builtin` AS t2_r4, `roles`.`permissions` AS t2_r5, `roles`.`issues_visibility` AS t2_r6 FROM `members` LEFT OUTER JOIN `users` ON `users`.`id` = `members`.`user_id` LEFT OUTER JOIN `member_roles` ON `member_roles`.`member_id` = `members`.`id` LEFT OUTER JOIN `roles` ON `roles`.`id` = `member_roles`.`role_id` WHERE `members`.`project_id` = 10 AND (users.type='User' AND users.status=1)[0m
|
|
63
|
[1m[35mUser Load (0.7ms)[0m SELECT `users`.* FROM `users` INNER JOIN `watchers` ON `users`.`id` = `watchers`.`user_id` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `watchers`.`watchable_id` = 283 AND `watchers`.`watchable_type` = 'Issue' AND `users`.`status` = 1
|
|
64
|
[1m[36mUserPreference Load (0.5ms)[0m [1mSELECT `user_preferences`.* FROM `user_preferences` WHERE `user_preferences`.`user_id` = 6 LIMIT 1[0m
|
|
65
|
[1m[35m (0.5ms)[0m SELECT COUNT(*) FROM `attachments` WHERE `attachments`.`container_id` = 283 AND `attachments`.`container_type` = 'Issue'
|
|
66
|
Rendered mailer/_issue.text.erb (4.5ms)
|
|
67
|
Rendered mailer/issue_add.text.erb within layouts/mailer (5.8ms)
|
|
68
|
Rendered mailer/_issue.html.erb (2.4ms)
|
|
69
|
Rendered mailer/issue_add.html.erb within layouts/mailer (3.2ms)
|
|
70
|
[1m[36mIssueRelation Load (0.6ms)[0m [1mSELECT `issue_relations`.* FROM `issue_relations` WHERE `issue_relations`.`issue_from_id` = 283[0m
|
|
71
|
[1m[35mSQL (0.4ms)[0m UPDATE `issues` SET root_id = 283 WHERE (id = 283)
|
|
72
|
[1m[36m (5.3ms)[0m [1mCOMMIT[0m
|
|
73
|
Redirected to http://tickets.xxxx-it.at/issues/283
|
|
74
|
Completed 302 Found in 16632.0ms (ActiveRecord: 27.7ms)
|