4.2: Can't send email, error 500, foreign key constraint fails

the table column on mauticemail_stats is
copy_id varchar(32) DEFAULT NULL,

and on mauticemail_copies it’s defined as
id varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,

so you need to make sure both tables are encoded with the same collation.

You need to convert all the tables into the same (preferability utf8mb4_unicode_ci) on all tables, there’s some other posts on this forum and github related to this issue. One issue you may face after trying to convert the columns to utf8mb4_unicode_ci, is that the index is bigger than what’s supported on mysql/mariadb, so you need to reduce the column from 255 to 191 chars