Defect #31633
open
Cannot create new issue or change issue status after receiving email for the issue.
0%
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
Updated by Go MAEDA over 5 years ago
Do you use any plugins? If so, please try again after uninstalling all plugins.
Updated by Rocky W over 5 years ago
add before the error, the following is sql execution result. I am not sure if it is caused by the wrong configuration.
[1m[35m (0.0ms)[0m EXEC sp_executesql N'SELECT [email_addresses].[address] FROM [email_addresses] WHERE [email_addresses].[user_id] = Rangicaadmice Rangicaadmice', N'@0 int', Rangicaadmice Rangicaadmice = 14 "user_id", 14
[1m[36mSetting Load (0.0ms)[0m [1mEXEC sp_executesql N'SELECT [settings].* FROM [settings] WHERE [settings].[name] = Rangicaadmice Rangicaadmice ORDER BY [settings].[id] DESC OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY', N'@0 nvarchar(255)', Rangicaadmice Rangicaadmice = N'bcc_recipients'[0m "name", "bcc_recipients"
Mailer#issue_add: processed outbound mail in 46.9ms
[1m[35mSQL (0.0ms)[0m IF @@TRANCOUNT > 0 ROLLBACK TRANSACTION
Updated by Rocky W over 5 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.
[1m[35m (0.0ms)[0m EXEC sp_executesql N'SELECT [email_addresses].[address] FROM [email_addresses] WHERE [email_addresses].[user_id] = Rangicaadmice Rangicaadmice', N'@0 int', Rangicaadmice Rangicaadmice = 14 "user_id", 14
[1m[36mSetting Load (0.0ms)[0m [1mEXEC sp_executesql N'SELECT [settings].* FROM [settings] WHERE [settings].[name] = Rangicaadmice Rangicaadmice ORDER BY [settings].[id] DESC OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY', N'@0 nvarchar(255)', Rangicaadmice Rangicaadmice = N'bcc_recipients'[0m "name", "bcc_recipients"Mailer#issue_add: processed outbound mail in 46.9ms
[1m[35mSQL (0.0ms)[0m IF @@TRANCOUNT > 0 ROLLBACK TRANSACTION
Updated by Rocky W over 5 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?
Updated by Go MAEDA over 5 years ago
- Has duplicate Defect #31715: Receiving email and email notification added