Redmine › Extended Fields

# Logfile created on 2013-03-17 12:07:10 +0530 by logger.rb/31641

Connecting to database specified by database.yml

Starting Extended Fields plugin for Redmine

OpenIdAuthentication.store is nil. Using in-memory store.

Started GET "/journal/issues/1144" for 127.0.0.1 at 2013-03-17 12:07:13 +0530

Processing by IssuesController#show as HTML

  Parameters: {"id"=>"1144"}

  Setting Load (0.2ms)  SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'session_lifetime' LIMIT 1

  Setting Load (0.2ms)  SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'session_timeout' LIMIT 1

   (0.1ms)  SELECT MAX(`settings`.`updated_on`) AS max_id FROM `settings` 

  User Load (0.1ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `users`.`id` = 1 AND (users.status = 1) LIMIT 1

  Current user: admin (id=1)

  Issue Load (0.1ms)  SELECT `issues`.* FROM `issues` WHERE `issues`.`id` = 1144 LIMIT 1

  Project Load (0.2ms)  SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 12 LIMIT 1

  EnabledModule Load (0.1ms)  SELECT name FROM `enabled_modules` WHERE `enabled_modules`.`project_id` = 12

  Journal Load (0.2ms)  SELECT `journals`.* FROM `journals` WHERE `journals`.`journalized_id` = 1144 AND `journals`.`journalized_type` = 'Issue' ORDER BY journals.id ASC

  User Load (0.1ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `users`.`id` IN (1)

  JournalDetail Load (0.1ms)  SELECT `journal_details`.* FROM `journal_details` WHERE `journal_details`.`journal_id` IN (5284, 5285, 5286, 5287)

  UserPreference Load (0.1ms)  SELECT `user_preferences`.* FROM `user_preferences` WHERE `user_preferences`.`user_id` = 1 LIMIT 1

  SQL (0.1ms)  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

  IssueRelation Load (0.1ms)  SELECT `issue_relations`.* FROM `issue_relations` WHERE `issue_relations`.`issue_from_id` = 1144

  IssueRelation Load (0.1ms)  SELECT `issue_relations`.* FROM `issue_relations` WHERE `issue_relations`.`issue_to_id` = 1144

  IssueStatus Load (0.1ms)  SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` = 3 LIMIT 1

  Role Load (0.1ms)  SELECT `roles`.* FROM `roles` 

  Tracker Load (0.1ms)  SELECT `trackers`.* FROM `trackers` WHERE `trackers`.`id` = 1 LIMIT 1

  User Load (0.1ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `users`.`id` = 1 LIMIT 1

  WorkflowTransition Load (0.1ms)  SELECT `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))

  IssueStatus Load (0.3ms)  SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` IN (8, 2, 4, 3, 5, 6)

  TimeEntryActivity Load (0.1ms)  SELECT `enumerations`.* FROM `enumerations` WHERE `enumerations`.`type` IN ('TimeEntryActivity') AND `enumerations`.`is_default` = 1 ORDER BY enumerations.position ASC LIMIT 1

  CACHE (0.0ms)  SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 12 LIMIT 1

  IssueCustomField Load (0.2ms)  SELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`type` IN ('IssueCustomField') AND (is_for_all=1) ORDER BY position

  IssueCustomField Load (0.1ms)  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

  CACHE (0.0ms)  SELECT name FROM `enabled_modules` WHERE `enabled_modules`.`project_id` = 12

  Tracker Load (0.1ms)  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

  Setting Load (0.1ms)  SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'user_format' LIMIT 1

  IssueStatus Load (0.1ms)  SELECT `issue_statuses`.* FROM `issue_statuses` ORDER BY position

  IssuePriority Load (0.1ms)  SELECT `enumerations`.* FROM `enumerations` WHERE `enumerations`.`type` IN ('IssuePriority') ORDER BY enumerations.position ASC

  Principal Load (0.2ms)  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))

  Setting Load (0.2ms)  SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'issue_group_assignment' LIMIT 1

  Group Load (0.1ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` IN ('Group')

  Role Load (0.1ms)  SELECT `roles`.* FROM `roles` WHERE `roles`.`builtin` = 0 ORDER BY roles.position ASC

  IssueCategory Load (0.1ms)  SELECT `issue_categories`.* FROM `issue_categories` WHERE `issue_categories`.`project_id` = 12 ORDER BY issue_categories.name

  Project Load (0.2ms)  SELECT `projects`.* FROM `projects` WHERE `projects`.`parent_id` IS NULL AND (`projects`.`lft` <= 6 AND `projects`.`rgt` >= 7) ORDER BY `projects`.`lft` LIMIT 1

  SQL (0.2ms)  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'))))

  CustomField Load (0.2ms)  SELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`is_filter` = 1

   (0.2ms)  SELECT COUNT(*) FROM `projects` WHERE (`projects`.`lft` >= 6 AND `projects`.`rgt` <= 7) AND (`projects`.id != 12) AND (projects.status = 1)

  SQL (0.2ms)  SELECT 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

   (0.1ms)  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'

  Rendered issues/_action_menu.html.erb (12.8ms)

  IssuePriority Load (0.2ms)  SELECT `enumerations`.* FROM `enumerations` WHERE `enumerations`.`type` IN ('IssuePriority') AND `enumerations`.`id` = 4 ORDER BY enumerations.position ASC LIMIT 1

  CACHE (0.0ms)  SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` = 3 LIMIT 1

  Setting Load (0.1ms)  SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'issue_done_ratio' LIMIT 1

  Setting Load (0.1ms)  SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'gravatar_enabled' LIMIT 1

  Setting Load (0.2ms)  SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'time_format' LIMIT 1

  Setting Load (0.1ms)  SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'date_format' LIMIT 1

  Principal Load (0.2ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 1 LIMIT 1

  IssueCategory Load (0.1ms)  SELECT `issue_categories`.* FROM `issue_categories` WHERE `issue_categories`.`id` = 55 LIMIT 1

  Version Load (0.1ms)  SELECT `versions`.* FROM `versions` WHERE `versions`.`id` = 77 LIMIT 1

  CACHE (0.0ms)  SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 12 LIMIT 1

  CACHE (0.0ms)  SELECT name FROM `enabled_modules` WHERE `enabled_modules`.`project_id` = 12

   (0.2ms)  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)

  CACHE (0.0ms)  SELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`type` IN ('IssueCustomField') AND (is_for_all=1) ORDER BY position

  CACHE (0.0ms)  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

  IssueCustomField Load (0.2ms)  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` = 1

  SQL (0.2ms)  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

  Version Load (0.3ms)  SELECT `versions`.* FROM `versions` WHERE `versions`.`id` = 70 LIMIT 1

  Rendered plugins/extended_fields/app/views/custom_values/common/_link.html.erb (0.9ms)

  Rendered issues/show.html.erb within layouts/base (74.0ms)

Completed 500 Internal Server Error in 845ms

ActionView::Template::Error (undefined method `to_i' for ["6", "15"]:Array):

    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'

    65:   end

    66: end %>

    67: <%= render_custom_fields_rows(@issue) %>

    68: <%= call_hook(:view_issues_show_details_bottom, :issue => @issue) %>

    69: </table>

    70: 

  lib/redmine/custom_field_format.rb:56:in `block (2 levels) in <class:CustomFieldFormat>'

  lib/redmine/custom_field_format.rb:37:in `format'

  lib/redmine/custom_field_format.rb:110:in `format_value'

  app/helpers/issues_helper.rb:164:in `block in render_custom_fields_rows'

  app/helpers/issues_helper.rb:162:in `each'

  app/helpers/issues_helper.rb:162:in `render_custom_fields_rows'

  app/views/issues/show.html.erb:67:in `_app_views_issues_show_html_erb__423136792_78271030'

  app/controllers/issues_controller.rb:119:in `block (2 levels) in show'

  app/controllers/issues_controller.rb:116:in `show'