Data too long for column 'receiver_mail'

[imminger]

Problem:

An error occurs, when the mail to receiver is sent to many recipients: Data too long for column 'receiver_mail'

The FlexForm field settings.flexform.receiver.email allows more than 255 characters:

powermail/Configuration/FlexForms/FlexformPi1.xml

Lines 128 to 132 in c690974

	<config>
	<type>text</type>
	<cols>32</cols>
	<rows>2</rows>
	</config>

However, the database field tx_powermail_domain_model_mail.receiver_mail is limited to 255 characters:

powermail/ext_tables.sql

Line 161 in c690974

receiver_mail varchar(255) DEFAULT '' NOT NULL,

This leads to an error when a mail is sent to a large number of recipients and the total character count in the receiver email field exceeds 255 characters:
Data too long for column 'receiver_mail'

Reproduction scenario:

Send mail to receiver to many receivers (so string is longer than 255 characters). E.g.:

alexander.schmidt@example.org, christopher.johnson@example.org, maximilian.hoffmann@example.org, benjamin.mueller@example.org, johannes.kraemer@example.org, michael.bauer@example.org, sebastian.fischer@example.org, dominik.schneider@example.org, fabian.wagner@example.org, lukas.meier@example.org
(addresses are fictional)

Proposed solution:

• Add a character limit to the FlexForm field settings.flexform.receiver.email to prevent user misconfiguration.
• Alternatively: Extend the database field length (receiver_mail in tx_powermail_domain_model_mail) to support longer strings.

However, note that issue #424 warns against using too many recipients via this field. Therefore, introducing a limit on settings.flexform.receiver.email is likely the best approach.

Affected version:

powermail 12.5.1