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 NOT processed and left on the server