Your software
My Mautic version is: PHP 7.1.33-21
My PHP version is: PHP 7.1.33-21
My Database type and version is: 2.15.3
Your problem
I’ve duplicate a Marketing email in Mautic as a segment email. Updated the Internal name. This works ok for a test send but has incomplete Plain text. If I auto generate plain text and save I get an Error 500 in the browser. Mautic’s log seems to point to an incorrect date format. But I’m unsure how to solve this as it seems like a coding error.
I do have access to ssh and the database.
Would manually changing the date time field resolve this?
I’ve replaced some of the values like usernames and email addresses in the log below
These errors are showing in the log :
[2020-10-30 10:20:41] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing ‘INSERT INTO mtc_emails (is_published, date_added, created_by, created_by_user, date_modified, modified_by, modified_by_user, checked_out, checked_out_by, checked_out_by_user, name, description, subject, from_address, from_name, reply_to_address, bcc_address, template, content, utm_tags, plain_text, custom_html, email_type, publish_up, publish_down, read_count, sent_count, variant_sent_count, variant_read_count, revision, lang, variant_settings, variant_start_date, dynamic_content, headers, public_preview, category_id, translation_parent_id, variant_parent_id, unsubscribeform_id, preference_center_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [0, “2020-10-30 08:20:41”, 1, “User Name Replaced Here”, null, null, null, null, null, null, “Internal Mail name replaced here”, null, “Subject line replaced here”, “sender@example.com”, “sender@example.com”, “sender@example.com”, null, “blank”, “a:0:{}”, “a:4:{s:9:“utmSource”;N;s:9:“utmMedium”;N;s:11:“utmCampaign”;N;s:10:“utmContent”;N;}”, “HALLO {CONTACTFIELD=FIRSTNAME}’ for column mauticdb.mtc_emails.plain_text at row 1 at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\DBAL\Driver\PDOException(code: 22007): SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8E\x81\x0A\x0A…’ for column mauticdb.mtc_emails.plain_text at row 1 at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 22007): SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8E\x81\x0A\x0A…’ for column mauticdb.mtc_emails.plain_text at row 1 at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)”}
Steps I have tried to fix the problem:
- I retried.
- Checked that I filled out all the fields.
- Busy looking into correcting the date format by hand in Mysql.
