Too long message ids lead to crash

[tograss]

Having a mail with a message_id > 255 leads to a crash of the plugin and hence stops mail import in glpi all together.
Reason is the restriction to 255 chars in the table glpi_plugin_mailanalyzer_message_id.

The responsible lines are

                  $DB->insert(
                     'glpi_plugin_mailanalyzer_message_id',
                     [
                        'message_id'        => $messageId,
                        'tickets_id'        => $input['items_id'],
                        'mailcollectors_id' => $mailgateId
                     ]
                  );

in hook.php. The case that this insert fails should be handled gracefully.

[tomolimo]

Hello @tograss
Thank you for the issue report.
As a workaround, you may increase the size of the field to 512 (for example), with following SQL DDL script to be executed in any MySQL (or MariaDB) client:

ALTER TABLE `glpi_plugin_mailanalyzer_message_id`
	CHANGE COLUMN `message_id` `message_id` VARCHAR(512) NOT NULL DEFAULT '0'  AFTER `id`;

Thank you,
Regards,
Tomolimo

[Aleko-SaR]

The same problem on GLPI 10.0.4 and 10.0.5

[tomolimo]

Hello @Aleko-SaR
Did you try the workaround?
Thank you,
Regards,
Tomolimo