After some investigation, we noticed that the issue is with the length of the msg_id field in the mantis_plugin_EmailReporting_msgids_table table. The exact error we have seen is:
This was resolved after the length of the msg_id field was increased from 255 to a higher value in the database.
Code: Select all
Mailbox: email@example.com Message: Reporter: 1000 - firstname.lastname@example.org --> Issue ID: #99999 APPLICATION ERROR #401: Database query failed. Error received from database was #1406: Data too long for column 'msg_id' at row 1 for the query: INSERT INTO mantis_plugin_EmailReporting_msgids_table( issue_id, msg_id ) VALUES (?, ?). 2021-01-01 01:00 GMT MAIL_VERBOSE email_api.php:2377 email_shutdown_function() Shutdown function called for /var/www/support.sample.com/www/plugins/EmailReporting/scripts/bug_report_mail.php
The msg_id of the email in question was actually over 300 chars, it's something like:
According to https://stackoverflow.com/a/34811337, the msg ID of an email can be as long as 955 chars. Maybe this is something that can be fixed in the plugin?