Defect #31633

Cannot create new issue or change issue status after receiving email for the issue.

Added by Rocky W about 2 years ago. Updated about 2 years ago.

Status:NewStart date:
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Email receiving
Target version:-
Resolution: Affected version:3.4.11

Description

I have setup the receiving email and Redmine did receive email to process it. But Redmine cannot create the issue for the new or change issue status. the error message is following:

@MailHandler: an unexpected error occurred when receiving email: Missing template mailer/issue_add with {:locale=>[:en], :formats=>[:text], :variants=>[], :handlers=>[:erb, :builder, :raw, :ruby, :rsb]}. Searched in: * "C:/Webserver/redmine-3.4.11/app/views"

MailHandler: an unexpected error occurred when receiving email: Missing template mailer/issue_edit with {:locale=>[:en], :formats=>[:text], :variants=>[], :handlers=>[:erb, :builder, :raw, :ruby, :rsb]}. Searched in: * "C:/Webserver/redmine-3.4.11/app/views"@

I checked the folder C:/Webserver/redmine-3.4.11/app/views/mailer, there are issue_add.html.erb, issue_add.text.erb, issue_edit.html.erb, issue_edit.text.erb.

Environment:
Windows 2012,
MS SQL Server 2016
Ruby 2.3 x64
Redmine 3.4.11

Any idea how to fix it?
Thanks.


Related issues

Duplicated by Redmine - Defect #31715: Receiving email and email notification Closed

History

#1 Updated by Go MAEDA about 2 years ago

Do you use any plugins? If so, please try again after uninstalling all plugins.

#2 Updated by Rocky W about 2 years ago

I did not use any plugin.

#3 Updated by Rocky W about 2 years ago

add before the error, the following is sql execution result. I am not sure if it is caused by the wrong configuration.
 (0.0ms) EXEC sp_executesql N'SELECT [email_addresses].[address] FROM [email_addresses] WHERE [email_addresses].[user_id] = @0', N'@0 int', @0 = 14 "user_id", 14
Setting Load (0.0ms) EXEC sp_executesql N'SELECT [settings].* FROM [settings] WHERE [settings].[name] = @0 ORDER BY [settings].[id] DESC OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY', N'@0 nvarchar(255)', @0 = N'bcc_recipients' "name", "bcc_recipients"

Mailer#issue_add: processed outbound mail in 46.9ms
SQL (0.0ms) IF @@TRANCOUNT > 0 ROLLBACK TRANSACTION

#4 Updated by Rocky W about 2 years ago

Rocky W wrote:
the error is happening when executing issue.save! in mail_handling

add before the error, the following is sql execution result. I am not sure if it is caused by the wrong configuration.
 (0.0ms) EXEC sp_executesql N'SELECT [email_addresses].[address] FROM [email_addresses] WHERE [email_addresses].[user_id] = @0', N'@0 int', @0 = 14 "user_id", 14
Setting Load (0.0ms) EXEC sp_executesql N'SELECT [settings].* FROM [settings] WHERE [settings].[name] = @0 ORDER BY [settings].[id] DESC OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY', N'@0 nvarchar(255)', @0 = N'bcc_recipients' "name", "bcc_recipients"

Mailer#issue_add: processed outbound mail in 46.9ms
SQL (0.0ms) IF @@TRANCOUNT > 0 ROLLBACK TRANSACTION

#5 Updated by Rocky W about 2 years ago

I did some test again. If I disable the "Email Notification"-> "Issue Added" , "Issue Updated" in the setting, the incoming email will create the issue or update the issue. If I enable "Issue Added", or "Issue Updated", the incoming email will cause the error. Looks like the issue caused by the notification cannot be generated.

But when I enable "Issue Added", or "Issue Updated", I can create the issue from web page and get the notification.

Do you have the same issue on that? Any idea on that?

#6 Updated by Go MAEDA about 2 years ago

  • Duplicated by Defect #31715: Receiving email and email notification added

Also available in: Atom PDF