1
|
Parameters: {"no_permission_check"=>"1", "unknown_user"=>"create", "allow_override"=>"project,tracker,category,priority,status,assigned_to", "issue"=>{"project"=>"Support", "tracker"=>"Support"}, "key"=>"xxxxxxxxxxxxxxxxx", "email"=>"From user@xxxxxx.com Tue Oct 18 11:24:41 2011\nReturn-Path: <user@xxxxxx.com>\nX-Original-To: support@redmine.xxxxxx.com\nDelivered-To: support@redmine.xxxxxx.com\nReceived: from ex2.intranet.xxxxxx.com (ex2.intranet.xxxxxx.com [192.168.200.1xx])\n\tby redmine.intranet.xxxxxx.com (Postfix) with ESMTPS id 10A216219C1\n\tfor <support@redmine.xxxxxx.com>; Tue, 18 Oct 2011 11:24:41 +0100 (BST)\nReceived: from EX2.intranet.xxxxxx.com ([fe80::1b8:fa33:66f9:434e]) by\n ex2.intranet.xxxxxx.com ([fe80::1b8:fa33:66f9:434e%10]) with mapi id\n 14.01.0339.001; Tue, 18 Oct 2011 11:24:41 +0100\nFrom: <user@xxxxxx.com>\nTo: <support@redmine.xxxxxx.com>\nSubject: test\nThread-Topic: test\nThread-Index: AcyNgCUT6GvJJswwTG+/5NO01RTkJA==\nContent-Class:\nDate: Tue, 18 Oct 2011 10:24:40 +0000\nMessage-ID: <25DF3A1A5BDE294FA79FD33928C96E30072161E4@ex2.intranet.xxxxxx.com>\nAccept-Language: en-GB, en-US\nContent-Language: en-GB\nX-MS-Has-Attach:\nX-MS-TNEF-Correlator:\nContent-Type: multipart/alternative;\n\tboundary=\"_000_25DF3A1A5BDE294FA79FD33928C96E30072161E4ex2intranetxxxc_\"\nMIME-Version: 1.0\n\n--_000_25DF3A1A5BDE294FA79FD33928C96E30072161E4ex2intranetxxxc_\nContent-Type: text/plain; charset=\"gb2312\"\nContent-Transfer-Encoding: base64\n\nZGFuaWVsDQoNClNlbnQgZnJvbSBteSBIVEMNCl9fX19fX19fX19fX19fX19fX19fX19fX19fX19f\nX19fDQoNCioqKioqIEUtbWFpbCBjb25maWRlbnRpYWxpdHkgbm90aWNlICoqKioqDQoNClRoaXMg\nbWVzc2FnZSBpcyBpbnRlbmRlZCBmb3IgdGhlIGFkZHJlc3NlZSBvbmx5LiBJdCBpcyBwcml2YXRl\nIGFuZCBjb25maWRlbnRpYWwuIElmIHlvdSBoYXZlIHJlY2VpdmVkIHRoaXMgbWVzc2FnZSBpbiBl\ncnJvciwgcGxlYXNlIG5vdGlmeSBwb3N0bWFzdGVyQGdicC5jby51ayBhbmQgcmVtb3ZlIGl0IGZy\nb20geW91ciBzeXN0ZW0uDQoNCkdsb2JlIEJ1c2luZXNzIFB1Ymxpc2hpbmcgTHRkLiBSZWdpc3Rl\ncmVkIE9mZmljZTogMTAgU2FsaXNidXJ5IFNxdWFyZSwgTG9uZG9uIEVDNFkgOEVILiBSZWdpc3Rl\ncmVkIGluIEVuZ2xhbmQgYW5kIFdhbGVzLCBOby4gMzIwNTE1OQ0K\n\n--_000_25DF3A1A5BDE294FA79FD33928C96E30072161E4ex2intranetxxxc_\nContent-Type: text/html; charset=\"gb2312\"\nContent-ID: <502DAEDB009906429FA8753424877FAA@xxxxxx.com>\nContent-Transfer-Encoding: quoted-printable\n\n<html>\n<head>\n<meta http-equiv=3D\"Content-Type\" content=3D\"text/html; charset=3Dgb2312\">\n</head>\n<body>\n<span style=3D\"font-size:10pt; font-family:Arial; font-weight:Normal\">danie=\nl<br>\n<br>\nSent from my HTC</span> <br>\n<hr>\n<font face=3D\"Arial\" color=3D\"Gray\" size=3D\"1\"><br>\n***** E-mail confidentiality notice *****<br>\n<br>\nThis message is intended for the addressee only. It is private and confiden=\ntial. If you have received this message in error, please notify postmaster@=\nxxxxxx.com and remove it from your system.<br>\n<br>\nCompany Name Ltd. Registered Office: <br>\n</font>\n</body>\n</html>\n\n--_000_25DF3A1A5BDE294FA79FD33928C96E30072161E4ex2intranetxxxc_--\n"}
|
2
|
^[[4;36;1mSetting Load (0.3ms)^[[0m ^[[0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'mail_handler_api_enabled') LIMIT 1^[[0m
|
3
|
^[[4;35;1mSetting Load (0.2ms)^[[0m ^[[0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'mail_handler_api_key') LIMIT 1^[[0m
|
4
|
^[[4;36;1mSetting Load (0.3ms)^[[0m ^[[0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'mail_from') LIMIT 1^[[0m
|
5
|
^[[4;35;1mUser Load (0.7ms)^[[0m ^[[0mSELECT * FROM `users` WHERE (LOWER(mail) = 'user@xxxxx.com') AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) LIMIT 1^[[0m
|
6
|
^[[4;36;1mSetting Load (0.1ms)^[[0m ^[[0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'default_language') LIMIT 1^[[0m
|
7
|
^[[4;35;1mProject Load (0.1ms)^[[0m ^[[0mSELECT * FROM `projects` WHERE (`projects`.`identifier` = 'Support') LIMIT 1^[[0m
|
8
|
^[[4;36;1mIssueStatus Load (0.1ms)^[[0m ^[[0;1mSELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` = 0) ^[[0m
|
9
|
^[[4;35;1mIssueStatus Load (0.2ms)^[[0m ^[[0mSELECT * FROM `issue_statuses` WHERE (is_default=1) LIMIT 1^[[0m
|
10
|
^[[4;36;1mIssuePriority Load (0.1ms)^[[0m ^[[0;1mSELECT * FROM `enumerations` WHERE (`enumerations`.`id` = 0) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC^[[0m
|
11
|
^[[4;35;1mIssuePriority Load (0.1ms)^[[0m ^[[0mSELECT * FROM `enumerations` WHERE (`enumerations`.`is_default` = 1) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC LIMIT 1^[[0m
|
12
|
^[[4;36;1mTracker Load (0.2ms)^[[0m ^[[0;1mSELECT `trackers`.* FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.id = `projects_trackers`.tracker_id WHERE (`trackers`.`name` = 'Support') AND (`projects_trackers`.project_id = 18 ) ORDER BY trackers.position LIMIT 1^[[0m
|
13
|
^[[4;35;1mMember Load Including Associations (0.2ms)^[[0m ^[[0mSELECT `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, `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, `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 `projects` ON `projects`.id = `members`.project_id LEFT OUTER JOIN `member_roles` ON (`members`.`id` = `member_roles`.`member_id`) LEFT OUTER JOIN `roles` ON (`roles`.`id` = `member_roles`.`role_id`) WHERE (`members`.user_id = 83 AND (projects.status=1)) ORDER BY projects.name^[[0m
|
14
|
^[[4;36;1mTracker Load (0.2ms)^[[0m ^[[0;1mSELECT * FROM `trackers` WHERE (`trackers`.`id` = 0) ^[[0m
|
15
|
^[[4;35;1mEnabledModule Load (0.1ms)^[[0m ^[[0mSELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 18) ^[[0m
|
16
|
^[[4;36;1mTracker Load (0.1ms)^[[0m ^[[0;1mSELECT * FROM `trackers` WHERE (`trackers`.`id` = 3) ^[[0m
|
17
|
^[[4;35;1mIssueCustomField Load (0.1ms)^[[0m ^[[0mSELECT * FROM `custom_fields` WHERE (is_for_all=1) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY position^[[0m
|
18
|
^[[4;36;1mcustom_fields_projects Columns (0.7ms)^[[0m ^[[0;1mSHOW FIELDS FROM `custom_fields_projects`^[[0m
|
19
|
^[[4;35;1mIssueCustomField Load (0.1ms)^[[0m ^[[0mSELECT * FROM `custom_fields` INNER JOIN `custom_fields_projects` ON `custom_fields`.id = `custom_fields_projects`.custom_field_id WHERE (`custom_fields_projects`.project_id = 18 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY custom_fields.position^[[0m
|
20
|
^[[4;36;1mIssueCustomField Load (0.1ms)^[[0m ^[[0;1mSELECT `custom_fields`.* FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields_trackers`.tracker_id = 3 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ^[[0m
|
21
|
^[[4;35;1mCustomValue Columns (0.4ms)^[[0m ^[[0mSHOW FIELDS FROM `custom_values`^[[0m
|
22
|
^[[4;36;1mWorkflow Load (0.2ms)^[[0m ^[[0;1mSELECT * FROM `workflows` WHERE (`workflows`.old_status_id = 1 AND (`workflows`.`assignee` = 0 AND `workflows`.`role_id` IN (4,5) AND `workflows`.`tracker_id` = 3)) ^[[0m
|
23
|
^[[4;35;1mWorkflow Columns (0.5ms)^[[0m ^[[0mSHOW FIELDS FROM `workflows`^[[0m
|
24
|
^[[4;36;1mIssueStatus Load (0.1ms)^[[0m ^[[0;1mSELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` IN (11,2,3,4,5)) ^[[0m
|
25
|
^[[4;35;1mSQL (0.1ms)^[[0m ^[[0mBEGIN^[[0m
|
26
|
^[[4;36;1mSQL (0.1ms)^[[0m ^[[0;1mCOMMIT^[[0m
|
27
|
^[[4;35;1mSetting Load (0.1ms)^[[0m ^[[0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'mail_handler_body_delimiters') LIMIT 1^[[0m
|
28
|
^[[4;36;1mUser Load (0.5ms)^[[0m ^[[0;1mSELECT * FROM `users` WHERE (LOWER(mail) IN ('support@redmine.xxxxx.com')) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) ^[[0m
|
29
|
^[[4;35;1mSQL (0.1ms)^[[0m ^[[0mBEGIN^[[0m
|
30
|
^[[4;36;1mSetting Load (0.1ms)^[[0m ^[[0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'issue_done_ratio') LIMIT 1^[[0m
|
31
|
^[[4;35;1mTracker Load (0.1ms)^[[0m ^[[0mSELECT `trackers`.id FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.id = `projects_trackers`.tracker_id WHERE (`trackers`.`id` = 3) AND (`projects_trackers`.project_id = 18 ) ORDER BY trackers.position LIMIT 1^[[0m
|
32
|
^[[4;36;1mSQL (0.1ms)^[[0m ^[[0;1mROLLBACK^[[0m
|
33
|
Completed in 56ms (View: 0, DB: 6) | 422 Unprocessable Entity [http://redmine/mail_handler]
|