Mail archive not displaying special characters
Issue that can happen after version 8.6.0
In the mail archive or the view it online link we display the mail that was sent with all the dynamic content frozen when the email is sent.
To do it we have created a new table acym_mail_archive in which we save the content of the email.
On some servers, the default collation and charset of the table might be wrong even if we add it in the table creation.
The charset (character set) should be utf8 and the collation should be utf8_general_ci
With MySQL Workbench
Connect to your PhpMyAdmin and search the table
Then go to the Operation tab on the top and select
utf8_general_ciand don't forget to check the option Change all column collations to apply the modification to all columns of the table.
Connect to your server with MySQL Workbench and search for the table
Once you've found it click on the spanner icon to configure the table.
On the configuration page, you have to click on the double arrow icon in the top right corner to display the collation option. Once you've displayed it you can change the Collation to
utf8in the first select and then
utf8_general_ciin the second select.
You can now click on the apply button on the bottom right corner.
Once this is done you have to verify every column (body, subject, settings, stylesheet, attachments) to the right collation if the new default one is not set.
To do it, on the same configuration page, click on every column mentioned below and change its collation settings to default.
Once it's done you can click on the apply button
Once the collation is fixed on your table, you can run the following SQL query to clear the existing archive and force AcyMailing to re-generate it:
// Replace the "xxxx_" by the real table prefix or your database
DELETE FROM XXXX_acym_mail_archive WHERE 1 = 1