Redmine

Connecting to database specified by database.yml

Creating scope :system. Overwriting existing method Enumeration.system.

Creating scope :sorted. Overwriting existing method User.sorted.

Creating scope :sorted. Overwriting existing method Group.sorted.

XLS export controller: rubyzip gem not available

Connecting to 10.1.1.1...

1 email(s) to process...

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

  User Load (0.5ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND (LOWER(mail) = 'user@hinet.net') LIMIT 1

  AnonymousUser Load (0.5ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` IN ('AnonymousUser') LIMIT 1

  Project Load (0.4ms)  SELECT `projects`.* FROM `projects` WHERE `projects`.`identifier` = 'technical-support' LIMIT 1

  IssueStatus Load (0.3ms)  SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`is_default` = 1 LIMIT 1

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

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

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

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

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

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

  Tracker Load (0.5ms)  SELECT `trackers`.* FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.`id` = `projects_trackers`.`tracker_id` WHERE `projects_trackers`.`project_id` = 190 AND (LOWER(trackers.name) = LOWER('Support')) ORDER BY trackers.position LIMIT 1

  IssueStatus Load (0.4ms)  SELECT `issue_statuses`.* FROM `issue_statuses` WHERE (LOWER(issue_statuses.name) = LOWER('new')) LIMIT 1

  IssuePriority Load (0.5ms)  SELECT `enumerations`.* FROM `enumerations` WHERE `enumerations`.`type` IN ('IssuePriority') AND (LOWER(enumerations.name) = LOWER('normal')) ORDER BY enumerations.position ASC LIMIT 1

  IssueStatus Load (0.5ms)  SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`is_default` = 1 LIMIT 1

  Role Load (0.3ms)  SELECT `roles`.* FROM `roles` WHERE `roles`.`builtin` = 2 LIMIT 1

  GroupAnonymous Load (0.4ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` IN ('GroupAnonymous') ORDER BY id LIMIT 1

  GroupNonMember Load (0.5ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` IN ('GroupNonMember') ORDER BY id LIMIT 1

  Member Load (0.4ms)  SELECT `members`.* FROM `members` WHERE `members`.`project_id` = 190 AND `members`.`user_id` IN (107, 108)

  SQL (0.5ms)  SELECT `enabled_modules`.`name` FROM `enabled_modules` WHERE `enabled_modules`.`project_id` = 190

   (0.3ms)  SELECT COUNT(*) FROM `workflows` WHERE `workflows`.`type` IN ('WorkflowPermission') AND `workflows`.`tracker_id` IS NULL AND `workflows`.`old_status_id` = 1 AND `workflows`.`role_id` IN (2)

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

   (0.5ms)  SELECT COUNT(*) FROM `workflows` WHERE `workflows`.`type` IN ('WorkflowPermission') AND `workflows`.`tracker_id` = 3 AND `workflows`.`old_status_id` = 1 AND `workflows`.`role_id` IN (2)

  IssueStatus Load (0.4ms)  SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`is_default` = 1 LIMIT 1

  WorkflowTransition Load (0.5ms)  SELECT `workflows`.* FROM `workflows` WHERE `workflows`.`type` IN ('WorkflowTransition') AND `workflows`.`old_status_id` = 1 AND (role_id IN (2) AND tracker_id = 3 AND ((author = 0 AND assignee = 0) OR author = 1))

  IssueStatus Load (0.6ms)  SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`is_default` = 1 LIMIT 1

  WorkflowTransition Load (0.5ms)  SELECT `workflows`.* FROM `workflows` WHERE `workflows`.`type` IN ('WorkflowTransition') AND `workflows`.`old_status_id` = 1 AND (role_id IN (2) AND tracker_id = 3 AND ((author = 0 AND assignee = 0) OR author = 1))

   (0.4ms)  SELECT COUNT(*) FROM `workflows` WHERE `workflows`.`type` IN ('WorkflowPermission') AND `workflows`.`tracker_id` = 3 AND `workflows`.`old_status_id` = 1 AND `workflows`.`role_id` IN (2)

  IssueCustomField Load (0.8ms)  SELECT `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 = 190)) ORDER BY custom_fields.position ASC

  IssueCustomField Load (0.6ms)  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` = 3

  IssueStatus Load (0.4ms)  SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`is_default` = 1 LIMIT 1

  WorkflowTransition Load (0.5ms)  SELECT `workflows`.* FROM `workflows` WHERE `workflows`.`type` IN ('WorkflowTransition') AND `workflows`.`old_status_id` = 1 AND (role_id IN (2) AND tracker_id = 3 AND ((author = 0 AND assignee = 0) OR author = 1))

   (0.4ms)  SELECT COUNT(*) FROM `workflows` WHERE `workflows`.`type` IN ('WorkflowPermission') AND `workflows`.`tracker_id` = 3 AND `workflows`.`old_status_id` = 1 AND `workflows`.`role_id` IN (2)

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

   (0.2ms)  BEGIN

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

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

  Tracker Exists (0.4ms)  SELECT 1 AS one FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.`id` = `projects_trackers`.`tracker_id` WHERE `projects_trackers`.`project_id` = 190 AND `trackers`.`id` = 3 LIMIT 1

   (0.4ms)  SELECT COUNT(*) FROM `workflows` WHERE `workflows`.`type` IN ('WorkflowPermission') AND `workflows`.`tracker_id` = 3 AND `workflows`.`old_status_id` = 1 AND `workflows`.`role_id` IN (2)

  Issue Load (0.5ms)  SELECT `issues`.* FROM `issues` ORDER BY `issues`.`rgt` desc LIMIT 1 FOR UPDATE

  Issue Load (0.4ms)  SELECT `issues`.* FROM `issues` ORDER BY `issues`.`rgt` desc LIMIT 1 FOR UPDATE

  SQL (0.4ms)  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`, `reminder_notification`, `rgt`, `root_id`, `start_date`, `status_id`, `subject`, `tracker_id`, `updated_on`) VALUES (NULL, 2, NULL, NULL, '2018-10-03 12:59:54', 'iPhone', 0, NULL, NULL, NULL, 0, 33, 0, NULL, 4, 190, NULL, 34, NULL, '2018-10-03', 1, 'Test', 3, '2018-10-03 12:59:54')

  SQL (0.4ms)  INSERT INTO `custom_values` (`custom_field_id`, `customized_id`, `customized_type`, `value`) VALUES (43, 195, 'Issue', '')

  SQL (0.4ms)  INSERT INTO `custom_values` (`custom_field_id`, `customized_id`, `customized_type`, `value`) VALUES (92, 195, 'Issue', NULL)

  SQL (0.3ms)  INSERT INTO `custom_values` (`custom_field_id`, `customized_id`, `customized_type`, `value`) VALUES (97, 195, 'Issue', NULL)

  SQL (0.2ms)  INSERT INTO `custom_values` (`custom_field_id`, `customized_id`, `customized_type`, `value`) VALUES (80, 195, 'Issue', '')

  SQL (0.3ms)  INSERT INTO `custom_values` (`custom_field_id`, `customized_id`, `customized_type`, `value`) VALUES (82, 195, 'Issue', '')

  SQL (0.2ms)  INSERT INTO `custom_values` (`custom_field_id`, `customized_id`, `customized_type`, `value`) VALUES (83, 195, 'Issue', '')

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

  SQL (0.7ms)  SELECT `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, `users`.`reminder_notification` AS t1_r19, `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` = 190 AND (users.type='User' AND users.status=1)

  User Load (0.4ms)  SELECT `users`.* FROM `users` INNER JOIN `watchers` ON `users`.`id` = `watchers`.`user_id` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `watchers`.`watchable_id` = 195 AND `watchers`.`watchable_type` = 'Issue' AND `users`.`status` = 1

  IssueRelation Load (0.4ms)  SELECT `issue_relations`.* FROM `issue_relations` WHERE `issue_relations`.`issue_from_id` = 195

  SQL (0.3ms)  UPDATE `issues` SET root_id = 195 WHERE (id = 195)

   (8.1ms)  COMMIT

--> Message <F651716E-37E4-4AF6-BBF7-B7DA70226643@hinet.net> NOT processed and left on the server