1
|
# Logfile created on 2013-03-17 12:07:10 +0530 by logger.rb/31641
|
2
|
Connecting to database specified by database.yml
|
3
|
Starting Extended Fields plugin for Redmine
|
4
|
OpenIdAuthentication.store is nil. Using in-memory store.
|
5
|
Started GET "/journal/issues/1144" for 127.0.0.1 at 2013-03-17 12:07:13 +0530
|
6
|
Processing by IssuesController#show as HTML
|
7
|
Parameters: {"id"=>"1144"}
|
8
|
[1m[36mSetting Load (0.2ms)[0m [1mSELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'session_lifetime' LIMIT 1[0m
|
9
|
[1m[35mSetting Load (0.2ms)[0m SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'session_timeout' LIMIT 1
|
10
|
[1m[36m (0.1ms)[0m [1mSELECT MAX(`settings`.`updated_on`) AS max_id FROM `settings` [0m
|
11
|
[1m[35mUser Load (0.1ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `users`.`id` = 1 AND (users.status = 1) LIMIT 1
|
12
|
Current user: admin (id=1)
|
13
|
[1m[36mIssue Load (0.1ms)[0m [1mSELECT `issues`.* FROM `issues` WHERE `issues`.`id` = 1144 LIMIT 1[0m
|
14
|
[1m[35mProject Load (0.2ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 12 LIMIT 1
|
15
|
[1m[36mEnabledModule Load (0.1ms)[0m [1mSELECT name FROM `enabled_modules` WHERE `enabled_modules`.`project_id` = 12[0m
|
16
|
[1m[35mJournal Load (0.2ms)[0m SELECT `journals`.* FROM `journals` WHERE `journals`.`journalized_id` = 1144 AND `journals`.`journalized_type` = 'Issue' ORDER BY journals.id ASC
|
17
|
[1m[36mUser Load (0.1ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `users`.`id` IN (1)[0m
|
18
|
[1m[35mJournalDetail Load (0.1ms)[0m SELECT `journal_details`.* FROM `journal_details` WHERE `journal_details`.`journal_id` IN (5284, 5285, 5286, 5287)
|
19
|
[1m[36mUserPreference Load (0.1ms)[0m [1mSELECT `user_preferences`.* FROM `user_preferences` WHERE `user_preferences`.`user_id` = 1 LIMIT 1[0m
|
20
|
[1m[35mSQL (0.1ms)[0m SELECT `changesets`.`id` AS t0_r0, `changesets`.`repository_id` AS t0_r1, `changesets`.`revision` AS t0_r2, `changesets`.`committer` AS t0_r3, `changesets`.`committed_on` AS t0_r4, `changesets`.`comments` AS t0_r5, `changesets`.`commit_date` AS t0_r6, `changesets`.`scmid` AS t0_r7, `changesets`.`user_id` AS t0_r8, `repositories`.`id` AS t1_r0, `repositories`.`project_id` AS t1_r1, `repositories`.`url` AS t1_r2, `repositories`.`login` AS t1_r3, `repositories`.`password` AS t1_r4, `repositories`.`root_url` AS t1_r5, `repositories`.`type` AS t1_r6, `repositories`.`path_encoding` AS t1_r7, `repositories`.`log_encoding` AS t1_r8, `repositories`.`extra_info` AS t1_r9, `repositories`.`identifier` AS t1_r10, `repositories`.`is_default` AS t1_r11, `projects`.`id` AS t2_r0, `projects`.`name` AS t2_r1, `projects`.`description` AS t2_r2, `projects`.`homepage` AS t2_r3, `projects`.`is_public` AS t2_r4, `projects`.`parent_id` AS t2_r5, `projects`.`created_on` AS t2_r6, `projects`.`updated_on` AS t2_r7, `projects`.`identifier` AS t2_r8, `projects`.`status` AS t2_r9, `projects`.`lft` AS t2_r10, `projects`.`rgt` AS t2_r11, `projects`.`default_assignee_id` AS t2_r12, `projects`.`default_version_id` AS t2_r13 FROM `changesets` LEFT OUTER JOIN `repositories` ON `repositories`.`id` = `changesets`.`repository_id` LEFT OUTER JOIN `projects` ON `projects`.`id` = `repositories`.`project_id` INNER JOIN `changesets_issues` ON `changesets`.`id` = `changesets_issues`.`changeset_id` WHERE `changesets_issues`.`issue_id` = 1144 AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='repository')) ORDER BY changesets.committed_on ASC, changesets.id ASC
|
21
|
[1m[36mIssueRelation Load (0.1ms)[0m [1mSELECT `issue_relations`.* FROM `issue_relations` WHERE `issue_relations`.`issue_from_id` = 1144[0m
|
22
|
[1m[35mIssueRelation Load (0.1ms)[0m SELECT `issue_relations`.* FROM `issue_relations` WHERE `issue_relations`.`issue_to_id` = 1144
|
23
|
[1m[36mIssueStatus Load (0.1ms)[0m [1mSELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` = 3 LIMIT 1[0m
|
24
|
[1m[35mRole Load (0.1ms)[0m SELECT `roles`.* FROM `roles`
|
25
|
[1m[36mTracker Load (0.1ms)[0m [1mSELECT `trackers`.* FROM `trackers` WHERE `trackers`.`id` = 1 LIMIT 1[0m
|
26
|
[1m[35mUser Load (0.1ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `users`.`id` = 1 LIMIT 1
|
27
|
[1m[36mWorkflowTransition Load (0.1ms)[0m [1mSELECT `workflows`.* FROM `workflows` WHERE `workflows`.`type` IN ('WorkflowTransition') AND `workflows`.`old_status_id` = 3 AND (role_id IN (1,2,3,4,5,8) AND tracker_id = 1 AND ((author = 0 AND assignee = 0) OR author = 1 OR assignee = 1))[0m
|
28
|
[1m[35mIssueStatus Load (0.3ms)[0m SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` IN (8, 2, 4, 3, 5, 6)
|
29
|
[1m[36mTimeEntryActivity Load (0.1ms)[0m [1mSELECT `enumerations`.* FROM `enumerations` WHERE `enumerations`.`type` IN ('TimeEntryActivity') AND `enumerations`.`is_default` = 1 ORDER BY enumerations.position ASC LIMIT 1[0m
|
30
|
[1m[35mCACHE (0.0ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 12 LIMIT 1
|
31
|
[1m[36mIssueCustomField Load (0.2ms)[0m [1mSELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`type` IN ('IssueCustomField') AND (is_for_all=1) ORDER BY position[0m
|
32
|
[1m[35mIssueCustomField Load (0.1ms)[0m SELECT `custom_fields`.* FROM `custom_fields` INNER JOIN `custom_fields_projects` ON `custom_fields`.`id` = `custom_fields_projects`.`custom_field_id` WHERE `custom_fields`.`type` IN ('IssueCustomField') AND `custom_fields_projects`.`project_id` = 12 ORDER BY custom_fields.position
|
33
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT name FROM `enabled_modules` WHERE `enabled_modules`.`project_id` = 12[0m
|
34
|
[1m[35mTracker Load (0.1ms)[0m SELECT DISTINCT trackers.* FROM `trackers` INNER JOIN `projects_trackers` ON `projects_trackers`.`tracker_id` = `trackers`.`id` INNER JOIN `projects` ON `projects`.`id` = `projects_trackers`.`project_id` WHERE (projects.lft >= 6 AND projects.rgt <= 7 AND projects.status <> 9) ORDER BY trackers.position
|
35
|
[1m[36mSetting Load (0.1ms)[0m [1mSELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'user_format' LIMIT 1[0m
|
36
|
[1m[35mIssueStatus Load (0.1ms)[0m SELECT `issue_statuses`.* FROM `issue_statuses` ORDER BY position
|
37
|
[1m[36mIssuePriority Load (0.1ms)[0m [1mSELECT `enumerations`.* FROM `enumerations` WHERE `enumerations`.`type` IN ('IssuePriority') ORDER BY enumerations.position ASC[0m
|
38
|
[1m[35mPrincipal Load (0.2ms)[0m SELECT `users`.* FROM `users` INNER JOIN `members` ON `users`.`id` = `members`.`user_id` WHERE `members`.`project_id` = 12 AND (users.type='Group' OR (users.type='User' AND users.status=1))
|
39
|
[1m[36mSetting Load (0.2ms)[0m [1mSELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'issue_group_assignment' LIMIT 1[0m
|
40
|
[1m[35mGroup Load (0.1ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`type` IN ('Group')
|
41
|
[1m[36mRole Load (0.1ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`builtin` = 0 ORDER BY roles.position ASC[0m
|
42
|
[1m[35mIssueCategory Load (0.1ms)[0m SELECT `issue_categories`.* FROM `issue_categories` WHERE `issue_categories`.`project_id` = 12 ORDER BY issue_categories.name
|
43
|
[1m[36mProject Load (0.2ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`parent_id` IS NULL AND (`projects`.`lft` <= 6 AND `projects`.`rgt` >= 7) ORDER BY `projects`.`lft` LIMIT 1[0m
|
44
|
[1m[35mSQL (0.2ms)[0m SELECT `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`.`default_assignee_id` AS t1_r12, `projects`.`default_version_id` AS t1_r13 FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.`id` = `versions`.`project_id` WHERE (projects.id = 12 OR (projects.status <> 9 AND ( versions.sharing = 'system' OR (projects.lft >= 3 AND projects.rgt <= 16 AND versions.sharing = 'tree') OR (projects.lft < 6 AND projects.rgt > 7 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 6 AND projects.rgt < 7 AND versions.sharing = 'hierarchy'))))
|
45
|
[1m[36mCustomField Load (0.2ms)[0m [1mSELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`is_filter` = 1[0m
|
46
|
[1m[35m (0.2ms)[0m SELECT COUNT(*) FROM `projects` WHERE (`projects`.`lft` >= 6 AND `projects`.`rgt` <= 7) AND (`projects`.id != 12) AND (projects.status = 1)
|
47
|
[1m[36mSQL (0.2ms)[0m [1mSELECT issues.id FROM `issues` LEFT OUTER JOIN `projects` ON `projects`.`id` = `issues`.`project_id` LEFT OUTER JOIN `issue_statuses` ON `issue_statuses`.`id` = `issues`.`status_id` LEFT OUTER JOIN `users` ON `users`.`id` = `issues`.`assigned_to_id` LEFT OUTER JOIN `trackers` ON `trackers`.`id` = `issues`.`tracker_id` LEFT OUTER JOIN `enumerations` ON `enumerations`.`id` = `issues`.`priority_id` AND `enumerations`.`type` IN ('IssuePriority') LEFT OUTER JOIN `issue_categories` ON `issue_categories`.`id` = `issues`.`category_id` LEFT OUTER JOIN `versions` ON `versions`.`id` = `issues`.`fixed_version_id` WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND ((issues.status_id IN (SELECT id FROM issue_statuses WHERE is_closed=0)) AND projects.id = 12) ORDER BY issues.id DESC LIMIT 501[0m
|
48
|
[1m[35m (0.1ms)[0m SELECT `users`.id FROM `users` INNER JOIN `watchers` ON `users`.`id` = `watchers`.`user_id` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `watchers`.`watchable_id` = 1144 AND `watchers`.`watchable_type` = 'Issue'
|
49
|
Rendered issues/_action_menu.html.erb (12.8ms)
|
50
|
[1m[36mIssuePriority Load (0.2ms)[0m [1mSELECT `enumerations`.* FROM `enumerations` WHERE `enumerations`.`type` IN ('IssuePriority') AND `enumerations`.`id` = 4 ORDER BY enumerations.position ASC LIMIT 1[0m
|
51
|
[1m[35mCACHE (0.0ms)[0m SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` = 3 LIMIT 1
|
52
|
[1m[36mSetting Load (0.1ms)[0m [1mSELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'issue_done_ratio' LIMIT 1[0m
|
53
|
[1m[35mSetting Load (0.1ms)[0m SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'gravatar_enabled' LIMIT 1
|
54
|
[1m[36mSetting Load (0.2ms)[0m [1mSELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'time_format' LIMIT 1[0m
|
55
|
[1m[35mSetting Load (0.1ms)[0m SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'date_format' LIMIT 1
|
56
|
[1m[36mPrincipal Load (0.2ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 1 LIMIT 1[0m
|
57
|
[1m[35mIssueCategory Load (0.1ms)[0m SELECT `issue_categories`.* FROM `issue_categories` WHERE `issue_categories`.`id` = 55 LIMIT 1
|
58
|
[1m[36mVersion Load (0.1ms)[0m [1mSELECT `versions`.* FROM `versions` WHERE `versions`.`id` = 77 LIMIT 1[0m
|
59
|
[1m[35mCACHE (0.0ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 12 LIMIT 1
|
60
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT name FROM `enabled_modules` WHERE `enabled_modules`.`project_id` = 12[0m
|
61
|
[1m[35m (0.2ms)[0m SELECT SUM(time_entries.hours) AS sum_id FROM `issues` LEFT JOIN time_entries ON time_entries.issue_id = issues.id WHERE `issues`.`root_id` = 1144 AND (`issues`.`lft` >= 9 AND `issues`.`rgt` <= 10)
|
62
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`type` IN ('IssueCustomField') AND (is_for_all=1) ORDER BY position[0m
|
63
|
[1m[35mCACHE (0.0ms)[0m SELECT `custom_fields`.* FROM `custom_fields` INNER JOIN `custom_fields_projects` ON `custom_fields`.`id` = `custom_fields_projects`.`custom_field_id` WHERE `custom_fields`.`type` IN ('IssueCustomField') AND `custom_fields_projects`.`project_id` = 12 ORDER BY custom_fields.position
|
64
|
[1m[36mIssueCustomField Load (0.2ms)[0m [1mSELECT `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` = 1[0m
|
65
|
[1m[35mSQL (0.2ms)[0m SELECT `custom_values`.`id` AS t0_r0, `custom_values`.`customized_type` AS t0_r1, `custom_values`.`customized_id` AS t0_r2, `custom_values`.`custom_field_id` AS t0_r3, `custom_values`.`value` AS t0_r4, `custom_fields`.`id` AS t1_r0, `custom_fields`.`type` AS t1_r1, `custom_fields`.`name` AS t1_r2, `custom_fields`.`field_format` AS t1_r3, `custom_fields`.`possible_values` AS t1_r4, `custom_fields`.`regexp` AS t1_r5, `custom_fields`.`min_length` AS t1_r6, `custom_fields`.`max_length` AS t1_r7, `custom_fields`.`is_required` AS t1_r8, `custom_fields`.`is_for_all` AS t1_r9, `custom_fields`.`is_filter` AS t1_r10, `custom_fields`.`position` AS t1_r11, `custom_fields`.`searchable` AS t1_r12, `custom_fields`.`default_value` AS t1_r13, `custom_fields`.`editable` AS t1_r14, `custom_fields`.`visible` AS t1_r15, `custom_fields`.`multiple` AS t1_r16, `custom_fields`.`textilizable` AS t1_r17, `custom_fields`.`is_for_new` AS t1_r18, `custom_fields`.`hint` AS t1_r19 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.`id` = `custom_values`.`custom_field_id` WHERE `custom_values`.`customized_id` = 1144 AND `custom_values`.`customized_type` = 'Issue' ORDER BY custom_fields.position
|
66
|
[1m[36mVersion Load (0.3ms)[0m [1mSELECT `versions`.* FROM `versions` WHERE `versions`.`id` = 70 LIMIT 1[0m
|
67
|
Rendered plugins/extended_fields/app/views/custom_values/common/_link.html.erb (0.9ms)
|
68
|
Rendered issues/show.html.erb within layouts/base (74.0ms)
|
69
|
Completed 500 Internal Server Error in 845ms
|
70
|
|
71
|
ActionView::Template::Error (undefined method `to_i' for ["6", "15"]:Array):
|
72
|
64: rows.right l(:label_spent_time), (@issue.total_spent_hours > 0 ? (link_to l_hours(@issue.total_spent_hours), {:controller => 'timelog', :action => 'index', :project_id => @project, :issue_id => @issue}) : "-"), :class => 'spent-time'
|
73
|
65: end
|
74
|
66: end %>
|
75
|
67: <%= render_custom_fields_rows(@issue) %>
|
76
|
68: <%= call_hook(:view_issues_show_details_bottom, :issue => @issue) %>
|
77
|
69: </table>
|
78
|
70:
|
79
|
lib/redmine/custom_field_format.rb:56:in `block (2 levels) in <class:CustomFieldFormat>'
|
80
|
lib/redmine/custom_field_format.rb:37:in `format'
|
81
|
lib/redmine/custom_field_format.rb:110:in `format_value'
|
82
|
app/helpers/issues_helper.rb:164:in `block in render_custom_fields_rows'
|
83
|
app/helpers/issues_helper.rb:162:in `each'
|
84
|
app/helpers/issues_helper.rb:162:in `render_custom_fields_rows'
|
85
|
app/views/issues/show.html.erb:67:in `_app_views_issues_show_html_erb__423136792_78271030'
|
86
|
app/controllers/issues_controller.rb:119:in `block (2 levels) in show'
|
87
|
app/controllers/issues_controller.rb:116:in `show'
|
88
|
|
89
|
|