|
1
|
I, [2021-12-06T07:16:07.649641 #168] INFO -- : Starting issue_mail_with_attachments Redmine plugin
|
|
2
|
I, [2021-12-06T07:16:14.468232 #168] INFO -- : MailHandler: ignoring email with Auto-Submitted:auto-replied header
|
|
3
|
I, [2021-12-06T07:16:14.912726 #168] INFO -- : --- def issue_edit_with_attachments ------
|
|
4
|
D, [2021-12-06T07:16:14.914268 #168] DEBUG -- : [1m[36mSetting Load (0.4ms)[0m [1mSELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'protocol' ORDER BY `settings`.`id` DESC LIMIT 1[0m
|
|
5
|
D, [2021-12-06T07:16:14.915071 #168] DEBUG -- : [1m[35mSetting Load (0.3ms)[0m SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'host_name' ORDER BY `settings`.`id` DESC LIMIT 1
|
|
6
|
D, [2021-12-06T07:16:14.919159 #168] DEBUG -- : [1m[36mSetting Load (0.3ms)[0m [1mSELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'app_title' ORDER BY `settings`.`id` DESC LIMIT 1[0m
|
|
7
|
D, [2021-12-06T07:16:14.921347 #168] DEBUG -- : [1m[35m (0.4ms)[0m SELECT `email_addresses`.`address` FROM `email_addresses` WHERE `email_addresses`.`user_id` IN (1, 5, 6) AND (is_default = 1 OR notify = 1)
|
|
8
|
D, [2021-12-06T07:16:14.928059 #168] DEBUG -- : [1m[36mUserPreference Load (0.4ms)[0m [1mSELECT `user_preferences`.* FROM `user_preferences` WHERE `user_preferences`.`user_id` = 6 LIMIT 1[0m
|
|
9
|
D, [2021-12-06T07:16:14.934820 #168] DEBUG -- : [1m[35m (0.4ms)[0m SELECT `email_addresses`.`address` FROM `email_addresses` WHERE `email_addresses`.`user_id` = 6
|
|
10
|
D, [2021-12-06T07:16:14.936016 #168] DEBUG -- : [1m[36mSetting Load (0.4ms)[0m [1mSELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'bcc_recipients' ORDER BY `settings`.`id` DESC LIMIT 1[0m
|
|
11
|
D, [2021-12-06T07:16:14.989676 #168] DEBUG -- : [1m[35mSetting Load (0.6ms)[0m SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'user_format' ORDER BY `settings`.`id` DESC LIMIT 1
|
|
12
|
D, [2021-12-06T07:16:14.995441 #168] DEBUG -- : [1m[36mIssueStatus Load (0.5ms)[0m [1mSELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` = 1 LIMIT 1[0m
|
|
13
|
D, [2021-12-06T07:16:14.999303 #168] DEBUG -- : [1m[35mIssuePriority Load (0.4ms)[0m SELECT `enumerations`.* FROM `enumerations` WHERE `enumerations`.`type` IN ('IssuePriority') AND `enumerations`.`id` = 2 ORDER BY `enumerations`.`position` ASC LIMIT 1
|
|
14
|
D, [2021-12-06T07:16:15.013542 #168] DEBUG -- : [1m[36mIssueCategory Load (0.3ms)[0m [1mSELECT `issue_categories`.* FROM `issue_categories` WHERE `issue_categories`.`id` = 1 LIMIT 1[0m
|
|
15
|
D, [2021-12-06T07:16:15.028725 #168] DEBUG -- : [1m[35mAttachment Exists (0.4ms)[0m SELECT 1 AS one FROM `attachments` WHERE `attachments`.`container_id` = 7 AND `attachments`.`container_type` = 'Issue' LIMIT 1
|
|
16
|
D, [2021-12-06T07:16:15.029602 #168] DEBUG -- : [1m[36mAttachment Load (0.4ms)[0m [1mSELECT `attachments`.* FROM `attachments` WHERE `attachments`.`container_id` = 7 AND `attachments`.`container_type` = 'Issue' ORDER BY attachments.created_on ASC, attachments.id ASC[0m
|
|
17
|
I, [2021-12-06T07:16:15.039157 #168] INFO -- : Rendered mailer/_issue.text.erb (45.5ms)
|
|
18
|
I, [2021-12-06T07:16:15.039226 #168] INFO -- : Rendered mailer/issue_edit.text.erb within layouts/mailer (88.3ms)
|
|
19
|
D, [2021-12-06T07:16:15.040623 #168] DEBUG -- : [1m[35mSetting Load (0.5ms)[0m SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'emails_header' ORDER BY `settings`.`id` DESC LIMIT 1
|
|
20
|
D, [2021-12-06T07:16:15.041663 #168] DEBUG -- : [1m[36mSetting Load (0.4ms)[0m [1mSELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'emails_footer' ORDER BY `settings`.`id` DESC LIMIT 1[0m
|
|
21
|
D, [2021-12-06T07:16:15.042451 #168] DEBUG -- : [1m[35mSetting Load (0.3ms)[0m SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'plain_text_mail' ORDER BY `settings`.`id` DESC LIMIT 1
|
|
22
|
D, [2021-12-06T07:16:15.045163 #168] DEBUG -- : [1m[36mSetting Load (0.4ms)[0m [1mSELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'text_formatting' ORDER BY `settings`.`id` DESC LIMIT 1[0m
|
|
23
|
D, [2021-12-06T07:16:15.045992 #168] DEBUG -- : [1m[35mSetting Load (0.3ms)[0m SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'cache_formatted_text' ORDER BY `settings`.`id` DESC LIMIT 1
|
|
24
|
D, [2021-12-06T07:16:15.049960 #168] DEBUG -- : [1m[36mRole Load (0.3ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`builtin` = 1 ORDER BY `roles`.`id` ASC LIMIT 1[0m
|
|
25
|
D, [2021-12-06T07:16:15.051132 #168] DEBUG -- : [1m[35mGroupNonMember Load (0.4ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`type` IN ('GroupNonMember') ORDER BY id LIMIT 1
|
|
26
|
D, [2021-12-06T07:16:15.071795 #168] DEBUG -- : [1m[36m (0.4ms)[0m [1mSELECT `users`.`id` FROM `users` WHERE `users`.`type` IN ('GroupNonMember')[0m
|
|
27
|
D, [2021-12-06T07:16:15.073344 #168] DEBUG -- : [1m[35m (0.5ms)[0m SELECT `members`.`user_id`, role_id, `members`.`project_id` FROM `members` INNER JOIN `projects` ON `projects`.`id` = `members`.`project_id` INNER JOIN `member_roles` ON `member_roles`.`member_id` = `members`.`id` WHERE (projects.status <> 9) AND (members.user_id = 6 OR (projects.is_public = 1 AND members.user_id = 3))
|
|
28
|
D, [2021-12-06T07:16:15.074046 #168] DEBUG -- : [1m[36mRole Load (0.3ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`id` IN (3, 4)[0m
|
|
29
|
D, [2021-12-06T07:16:15.076019 #168] DEBUG -- : [1m[35mGroup Load (0.4ms)[0m SELECT `users`.* FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 6
|
|
30
|
D, [2021-12-06T07:16:15.077855 #168] DEBUG -- : [1m[36mIssue Load (0.5ms)[0m [1mSELECT `issues`.* FROM `issues` INNER JOIN `projects` ON `projects`.`id` = `issues`.`project_id` WHERE (((projects.status <> 9 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking')) AND (((projects.is_public = 1 AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (6,3))) AND ((issues.is_private = 0 OR issues.author_id = 6 OR issues.assigned_to_id IN (6)))) OR (projects.id IN (1) AND (1=1)) OR (projects.id IN (2) AND ((issues.author_id = 6 OR issues.assigned_to_id IN (6))))))) AND `issues`.`id` = 7 LIMIT 1[0m
|
|
31
|
D, [2021-12-06T07:16:15.079560 #168] DEBUG -- : [1m[35mIssuePriority Load (0.3ms)[0m SELECT `enumerations`.* FROM `enumerations` WHERE `enumerations`.`type` IN ('IssuePriority') AND `enumerations`.`id` = 2 ORDER BY `enumerations`.`position` ASC LIMIT 1
|
|
32
|
D, [2021-12-06T07:16:15.080379 #168] DEBUG -- : [1m[36mIssueStatus Load (0.3ms)[0m [1mSELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` = 1 LIMIT 1[0m
|
|
33
|
D, [2021-12-06T07:16:15.081261 #168] DEBUG -- : [1m[35mTracker Load (0.3ms)[0m SELECT `trackers`.* FROM `trackers` WHERE `trackers`.`id` = 1 LIMIT 1
|
|
34
|
D, [2021-12-06T07:16:15.082243 #168] DEBUG -- : [1m[36mGroupNonMember Load (0.3ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`type` IN ('GroupNonMember') ORDER BY id LIMIT 1[0m
|
|
35
|
D, [2021-12-06T07:16:15.083506 #168] DEBUG -- : [1m[35mIssue Load (0.5ms)[0m SELECT `issues`.* FROM `issues` INNER JOIN `projects` ON `projects`.`id` = `issues`.`project_id` WHERE (((projects.status <> 9 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking')) AND (((projects.is_public = 1 AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (6,3))) AND ((issues.is_private = 0 OR issues.author_id = 6 OR issues.assigned_to_id IN (6)))) OR (projects.id IN (1) AND (1=1)) OR (projects.id IN (2) AND ((issues.author_id = 6 OR issues.assigned_to_id IN (6))))))) AND `issues`.`id` = 7 LIMIT 1
|
|
36
|
D, [2021-12-06T07:16:15.084989 #168] DEBUG -- : [1m[36mIssuePriority Load (0.3ms)[0m [1mSELECT `enumerations`.* FROM `enumerations` WHERE `enumerations`.`type` IN ('IssuePriority') AND `enumerations`.`id` = 2 ORDER BY `enumerations`.`position` ASC LIMIT 1[0m
|
|
37
|
D, [2021-12-06T07:16:15.085689 #168] DEBUG -- : [1m[35mIssueStatus Load (0.3ms)[0m SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` = 1 LIMIT 1
|
|
38
|
D, [2021-12-06T07:16:15.086535 #168] DEBUG -- : [1m[36mTracker Load (0.3ms)[0m [1mSELECT `trackers`.* FROM `trackers` WHERE `trackers`.`id` = 1 LIMIT 1[0m
|
|
39
|
I, [2021-12-06T07:16:15.089583 #168] INFO -- : Rendered mailer/_issue.html.erb (2.1ms)
|
|
40
|
I, [2021-12-06T07:16:15.089643 #168] INFO -- : Rendered mailer/issue_edit.html.erb within layouts/mailer (46.0ms)
|
|
41
|
D, [2021-12-06T07:16:15.092789 #168] DEBUG -- : [1m[35mSetting Load (0.4ms)[0m SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'plugin_issue_mail_with_attachments' ORDER BY `settings`.`id` DESC LIMIT 1
|
|
42
|
D, [2021-12-06T07:16:15.094095 #168] DEBUG -- : [1m[36mEnabledModule Load (0.3ms)[0m [1mSELECT `enabled_modules`.* FROM `enabled_modules` WHERE `enabled_modules`.`project_id` = 1[0m
|
|
43
|
D, [2021-12-06T07:16:15.096303 #168] DEBUG -- : **** with_att:true, att_enabled: true, attach_all: true, mod_enabled: false, prj_ctl_enabled: false, cf_name_for_issue: , enabled_for_issue:
|
|
44
|
D, [2021-12-06T07:16:15.097626 #168] DEBUG -- : [1m[35m (0.4ms)[0m SELECT `email_addresses`.`address` FROM `email_addresses` WHERE `email_addresses`.`user_id` IN (1, 5, 6) AND (is_default = 1 OR notify = 1)
|
|
45
|
D, [2021-12-06T07:16:15.098310 #168] DEBUG -- : [1m[36m (0.3ms)[0m [1mSELECT `email_addresses`.`address` FROM `email_addresses` WHERE `email_addresses`.`user_id` = 6[0m
|
|
46
|
I, [2021-12-06T07:16:15.100274 #168] INFO -- : Rendered mailer/_issue.text.erb (0.9ms)
|
|
47
|
I, [2021-12-06T07:16:15.100342 #168] INFO -- : Rendered mailer/issue_edit.text.erb within layouts/mailer (1.2ms)
|
|
48
|
D, [2021-12-06T07:16:15.102893 #168] DEBUG -- : [1m[35mGroupNonMember Load (0.4ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`type` IN ('GroupNonMember') ORDER BY id LIMIT 1
|
|
49
|
D, [2021-12-06T07:16:15.104302 #168] DEBUG -- : [1m[36mIssue Load (0.6ms)[0m [1mSELECT `issues`.* FROM `issues` INNER JOIN `projects` ON `projects`.`id` = `issues`.`project_id` WHERE (((projects.status <> 9 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking')) AND (((projects.is_public = 1 AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (6,3))) AND ((issues.is_private = 0 OR issues.author_id = 6 OR issues.assigned_to_id IN (6)))) OR (projects.id IN (1) AND (1=1)) OR (projects.id IN (2) AND ((issues.author_id = 6 OR issues.assigned_to_id IN (6))))))) AND `issues`.`id` = 7 LIMIT 1[0m
|
|
50
|
D, [2021-12-06T07:16:15.105996 #168] DEBUG -- : [1m[35mIssuePriority Load (0.3ms)[0m SELECT `enumerations`.* FROM `enumerations` WHERE `enumerations`.`type` IN ('IssuePriority') AND `enumerations`.`id` = 2 ORDER BY `enumerations`.`position` ASC LIMIT 1
|
|
51
|
D, [2021-12-06T07:16:15.106784 #168] DEBUG -- : [1m[36mIssueStatus Load (0.3ms)[0m [1mSELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` = 1 LIMIT 1[0m
|
|
52
|
D, [2021-12-06T07:16:15.107570 #168] DEBUG -- : [1m[35mTracker Load (0.3ms)[0m SELECT `trackers`.* FROM `trackers` WHERE `trackers`.`id` = 1 LIMIT 1
|
|
53
|
D, [2021-12-06T07:16:15.108540 #168] DEBUG -- : [1m[36mGroupNonMember Load (0.3ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`type` IN ('GroupNonMember') ORDER BY id LIMIT 1[0m
|
|
54
|
D, [2021-12-06T07:16:15.109900 #168] DEBUG -- : [1m[35mIssue Load (0.6ms)[0m SELECT `issues`.* FROM `issues` INNER JOIN `projects` ON `projects`.`id` = `issues`.`project_id` WHERE (((projects.status <> 9 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking')) AND (((projects.is_public = 1 AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (6,3))) AND ((issues.is_private = 0 OR issues.author_id = 6 OR issues.assigned_to_id IN (6)))) OR (projects.id IN (1) AND (1=1)) OR (projects.id IN (2) AND ((issues.author_id = 6 OR issues.assigned_to_id IN (6))))))) AND `issues`.`id` = 7 LIMIT 1
|
|
55
|
D, [2021-12-06T07:16:15.111514 #168] DEBUG -- : [1m[36mIssuePriority Load (0.3ms)[0m [1mSELECT `enumerations`.* FROM `enumerations` WHERE `enumerations`.`type` IN ('IssuePriority') AND `enumerations`.`id` = 2 ORDER BY `enumerations`.`position` ASC LIMIT 1[0m
|
|
56
|
D, [2021-12-06T07:16:15.112263 #168] DEBUG -- : [1m[35mIssueStatus Load (0.3ms)[0m SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` = 1 LIMIT 1
|
|
57
|
D, [2021-12-06T07:16:15.113045 #168] DEBUG -- : [1m[36mTracker Load (0.3ms)[0m [1mSELECT `trackers`.* FROM `trackers` WHERE `trackers`.`id` = 1 LIMIT 1[0m
|
|
58
|
I, [2021-12-06T07:16:15.114908 #168] INFO -- : Rendered mailer/_issue.html.erb (1.4ms)
|
|
59
|
I, [2021-12-06T07:16:15.114959 #168] INFO -- : Rendered mailer/issue_edit.html.erb within layouts/mailer (14.3ms)
|
|
60
|
I, [2021-12-06T07:16:21.691027 #168] INFO -- : MailHandler: issue #7 updated by test test
|