Redmine

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

I did not use any plugin.

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

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

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?