Mautic Community Forums

Can not send email to segments with Mautic 2.1.1

Dear Mautic Community,



After upgrading from 2.0 to 2.0.1 I received some slight visual errors with Mautic. Campaign triggered emails were sending perfectly fine along with emails to segments.



The only visual issue I experienced was the sending progress bar would not update by batch size like it would before. Instead of updating every 100, or however many emails I set the batch send value to, it would stay at 0 until all sending was complete and then the progress bar would go to 100%.



For example it would stay at 0% indicating 0 out of 1000 emails were sent until all 1000 emails were sent, then the progress bar would update to 100% indicating all 1000 emails were sent.



This wasn’t too big of an issue as I could open the emails list in a new tab and I could occasionally refresh the emails list to see the segments sending true progress.



After updating to 2.1.1 the progress bar just hangs at 0% like before when sending emails to segments, except now no emails are sent.



I’ve left this segment email sending page open for hours and it never sends a single email.

When checking the error log there isn’t any helpful messages in the log.



The only error message I see is:



[2016-09-15 04:48:56] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionDriverException: “An exception occurred while executing ‘INSERT INTO email_stats (email_address, date_sent, is_read, is_failed, viewed_in_browser, date_read, tracking_hash, retry_count, source, source_id, tokens, open_count, last_opened, open_details, email_id, lead_id, list_id, ip_id, copy_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [“CUSTOMEREMAILHERE@yahoo.com”, “2016-09-15 04:48:01”, 0, 0, 0, null, “57da27ffd95ff”, 0, “email”, 18, “a:9:{s:18:”{unsubscribe_text}”;s:118:“Unsubscribe to no longer receive emails from us.”;s:17:"{unsubscribe_url}";s:55:“https://rstkd.com/email/email/unsubscribe/57da27ffd95ff";s:14:"{webview_text}";s:109:"Having trouble reading this email? Click here.”;s:13:"{webview_url}";s:48:“https://rstkd.com/email/email/view/57da27ffd95ff";s:11:"{signature}";s:26:"Best regards, Connor James”;s:9:"{subject}";s:59:“ud83dudea7 Get your favorite items NOW and then pay LATER! u26a0ufe0f”;s:37:"{trackable=948ccfe49918b0e6e110d951d}";s:263:“https://rstkd.com/email/r/948ccfe49918b0e6e110d951d?ct=YTo1OntzOjY6InNvdXJjZSI7YToyOntpOjA7czo1OiJlbWFpbCI7aToxO2k6MTg7fXM6NToiZW1haWwiO2k6MTg7czo0OiJzdGF0IjtzOjEzOiI1N2RhMjdmZmQ5NWZmIjtzOjQ6ImxlYWQiO3M6MjoiODAiO3M6NzoiY2hhbm5lbCI7YToxOntzOjU6ImVtYWlsIjtpOjE4O319";s:37:"{trackable=e964ab5940f2400d9f1338dd4}";s:263:“https://rstkd.com/email/r/e964ab5940f2400d9f1338dd4?ct=YTo1OntzOjY6InNvdXJjZSI7YToyOntpOjA7czo1OiJlbWFpbCI7aToxO2k6MTg7fXM6NToiZW1haWwiO2k6MTg7czo0OiJzdGF0IjtzOjEzOiI1N2RhMjdmZmQ5NWZmIjtzOjQ6ImxlYWQiO3M6MjoiODAiO3M6NzoiY2hhbm5lbCI7YToxOntzOjU6ImVtYWlsIjtpOjE4O319”;s:16:"{tracking_pixel}";s:47:“https://rstkd.com/email/email/57da27ffd95ff.gif”;}", null, null, “a:0:{}”, 18, “80”, 6, null, “1c8a26b9b460e35066bcad40e7615f11”]: SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘xF0x9Fx9AxA7 G…’ for column ‘tokens’ at row 1” at /home2/rstkd/public_html/email/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 {“exception”:"[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘INSERT INTO email_stats (email_address, date_sent, is_read, is_failed, viewed_in_browser, date_read, tracking_hash, retry_count, source, source_id, tokens, open_count, last_opened, open_details, email_id, lead_id, list_id, ip_id, copy_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [“CUSTOMEREMAILHERE@yahoo.com”, “2016-09-15 04:48:01”, 0, 0, 0, null, “57da27ffd95ff”, 0, “email”, 18, “a:9:{s:18:”{unsubscribe_text}";s:118:“Unsubscribe</a> to no longer receive emails from us.”;s:17:"{unsubscribe_url}";s:55:“https://rstkd.com/email/email/unsubscribe/57da27ffd95ff";s:14:"{webview_text}";s:109:"Having trouble reading this email? Click here.</a>”;s:13:"{webview_url}";s:48:“https://rstkd.com/email/email/view/57da27ffd95ff";s:11:"{signature}";s:26:"Best regards, Connor James”;s:9:"{subject}";s:59:"\ud83d\udea7 Get your favorite items NOW and then pay LATER! \u26a0\ufe0f";s:37:"{trackable=948ccfe49918b0e6e110d951d}";s:263:“https://rstkd.com/email/r/948ccfe49918b0e6e110d951d?ct=YTo1OntzOjY6InNvdXJjZSI7YToyOntpOjA7czo1OiJlbWFpbCI7aToxO2k6MTg7fXM6NToiZW1haWwiO2k6MTg7czo0OiJzdGF0IjtzOjEzOiI1N2RhMjdmZmQ5NWZmIjtzOjQ6ImxlYWQiO3M6MjoiODAiO3M6NzoiY2hhbm5lbCI7YToxOntzOjU6ImVtYWlsIjtpOjE4O319";s:37:"{trackable=e964ab5940f2400d9f1338dd4}";s:263:“https://rstkd.com/email/r/e964ab5940f2400d9f1338dd4?ct=YTo1OntzOjY6InNvdXJjZSI7YToyOntpOjA7czo1OiJlbWFpbCI7aToxO2k6MTg7fXM6NToiZW1haWwiO2k6MTg7czo0OiJzdGF0IjtzOjEzOiI1N2RhMjdmZmQ5NWZmIjtzOjQ6ImxlYWQiO3M6MjoiODAiO3M6NzoiY2hhbm5lbCI7YToxOntzOjU6ImVtYWlsIjtpOjE4O319”;s:16:"{tracking_pixel}";s:47:“https://rstkd.com/email/email/57da27ffd95ff.gif”;}", null, null, “a:0:{}”, 18, “80”, 6, null, “1c8a26b9b460e35066bcad40e7615f11”]:nnSQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\xF0\x9F\x9A\xA7 G…’ for column ‘tokens’ at row 1 at /home2/rstkd/public_html/email/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\DBAL\Driver\PDOException(code: HY000): SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\xF0\x9F\x9A\xA7 G…’ for column ‘tokens’ at row 1 at /home2/rstkd/public_html/email/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\xF0\x9F\x9A\xA7 G…’ for column ‘tokens’ at row 1 at /home2/rstkd/public_html/email/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)”} []



My installation of mautic is still sending emails in campaigns perfectly fine, and it also sends the email I am trying to send to my segment perfectly fine to myself when I send a test email using the send test feature.



Note: the email in the error log has been modified from my real customers email to 'CUSTOMEREMAILHERE@yahoo.com" to preserve their privacy.



Is anyone else having this same issue? I saw a few posts about people having this same issue on 2.0 but the posts just end with saying this error will be fixed in new versions.



Hope to hear back soon.



Best regards,

Connor

Dear Mautic Community,

After upgrading from 2.0 to 2.0.1 I received some slight visual errors with Mautic. Campaign triggered emails were sending perfectly fine along with emails to segments.

The only visual issue I experienced was the sending progress bar would not update by batch size like it would before. Instead of updating every 100, or however many emails I set the batch send value to, it would stay at 0 until all sending was complete and then the progress bar would go to 100%.

For example it would stay at 0% indicating 0 out of 1000 emails were sent until all 1000 emails were sent, then the progress bar would update to 100% indicating all 1000 emails were sent.

This wasn’t too big of an issue as I could open the emails list in a new tab and I could occasionally refresh the emails list to see the segments sending true progress.

After updating to 2.1.1 the progress bar just hangs at 0% like before when sending emails to segments, except now no emails are sent.

I’ve left this segment email sending page open for hours and it never sends a single email.
When checking the error log there isn’t any helpful messages in the log.

The only error message I see is:

[2016-09-15 04:48:56] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionDriverException: “An exception occurred while executing ‘INSERT INTO email_stats (email_address, date_sent, is_read, is_failed, viewed_in_browser, date_read, tracking_hash, retry_count, source, source_id, tokens, open_count, last_opened, open_details, email_id, lead_id, list_id, ip_id, copy_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [“CUSTOMEREMAILHERE@yahoo.com”, “2016-09-15 04:48:01”, 0, 0, 0, null, “57da27ffd95ff”, 0, “email”, 18, “a:9:{s:18:”{unsubscribe_text}”;s:118:“Unsubscribe to no longer receive emails from us.”;s:17:"{unsubscribe_url}";s:55:“https://rstkd.com/email/email/unsubscribe/57da27ffd95ff";s:14:"{webview_text}";s:109:"Having trouble reading this email? Click here.”;s:13:"{webview_url}";s:48:“https://rstkd.com/email/email/view/57da27ffd95ff";s:11:"{signature}";s:26:"Best regards, Connor James”;s:9:"{subject}";s:59:“ud83dudea7 Get your favorite items NOW and then pay LATER! u26a0ufe0f”;s:37:"{trackable=948ccfe49918b0e6e110d951d}";s:263:“https://rstkd.com/email/r/948ccfe49918b0e6e110d951d?ct=YTo1OntzOjY6InNvdXJjZSI7YToyOntpOjA7czo1OiJlbWFpbCI7aToxO2k6MTg7fXM6NToiZW1haWwiO2k6MTg7czo0OiJzdGF0IjtzOjEzOiI1N2RhMjdmZmQ5NWZmIjtzOjQ6ImxlYWQiO3M6MjoiODAiO3M6NzoiY2hhbm5lbCI7YToxOntzOjU6ImVtYWlsIjtpOjE4O319";s:37:"{trackable=e964ab5940f2400d9f1338dd4}";s:263:“https://rstkd.com/email/r/e964ab5940f2400d9f1338dd4?ct=YTo1OntzOjY6InNvdXJjZSI7YToyOntpOjA7czo1OiJlbWFpbCI7aToxO2k6MTg7fXM6NToiZW1haWwiO2k6MTg7czo0OiJzdGF0IjtzOjEzOiI1N2RhMjdmZmQ5NWZmIjtzOjQ6ImxlYWQiO3M6MjoiODAiO3M6NzoiY2hhbm5lbCI7YToxOntzOjU6ImVtYWlsIjtpOjE4O319”;s:16:"{tracking_pixel}";s:47:“https://rstkd.com/email/email/57da27ffd95ff.gif”;}", null, null, “a:0:{}”, 18, “80”, 6, null, “1c8a26b9b460e35066bcad40e7615f11”]: SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘xF0x9Fx9AxA7 G…’ for column ‘tokens’ at row 1” at /home2/rstkd/public_html/email/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 {“exception”:"[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘INSERT INTO email_stats (email_address, date_sent, is_read, is_failed, viewed_in_browser, date_read, tracking_hash, retry_count, source, source_id, tokens, open_count, last_opened, open_details, email_id, lead_id, list_id, ip_id, copy_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [“CUSTOMEREMAILHERE@yahoo.com”, “2016-09-15 04:48:01”, 0, 0, 0, null, “57da27ffd95ff”, 0, “email”, 18, “a:9:{s:18:”{unsubscribe_text}";s:118:“Unsubscribe</a> to no longer receive emails from us.”;s:17:"{unsubscribe_url}";s:55:“https://rstkd.com/email/email/unsubscribe/57da27ffd95ff";s:14:"{webview_text}";s:109:"Having trouble reading this email? Click here.</a>”;s:13:"{webview_url}";s:48:“https://rstkd.com/email/email/view/57da27ffd95ff";s:11:"{signature}";s:26:"Best regards, Connor James”;s:9:"{subject}";s:59:"\ud83d\udea7 Get your favorite items NOW and then pay LATER! \u26a0\ufe0f";s:37:"{trackable=948ccfe49918b0e6e110d951d}";s:263:“https://rstkd.com/email/r/948ccfe49918b0e6e110d951d?ct=YTo1OntzOjY6InNvdXJjZSI7YToyOntpOjA7czo1OiJlbWFpbCI7aToxO2k6MTg7fXM6NToiZW1haWwiO2k6MTg7czo0OiJzdGF0IjtzOjEzOiI1N2RhMjdmZmQ5NWZmIjtzOjQ6ImxlYWQiO3M6MjoiODAiO3M6NzoiY2hhbm5lbCI7YToxOntzOjU6ImVtYWlsIjtpOjE4O319";s:37:"{trackable=e964ab5940f2400d9f1338dd4}";s:263:“https://rstkd.com/email/r/e964ab5940f2400d9f1338dd4?ct=YTo1OntzOjY6InNvdXJjZSI7YToyOntpOjA7czo1OiJlbWFpbCI7aToxO2k6MTg7fXM6NToiZW1haWwiO2k6MTg7czo0OiJzdGF0IjtzOjEzOiI1N2RhMjdmZmQ5NWZmIjtzOjQ6ImxlYWQiO3M6MjoiODAiO3M6NzoiY2hhbm5lbCI7YToxOntzOjU6ImVtYWlsIjtpOjE4O319”;s:16:"{tracking_pixel}";s:47:“https://rstkd.com/email/email/57da27ffd95ff.gif”;}", null, null, “a:0:{}”, 18, “80”, 6, null, “1c8a26b9b460e35066bcad40e7615f11”]:nnSQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\xF0\x9F\x9A\xA7 G…’ for column ‘tokens’ at row 1 at /home2/rstkd/public_html/email/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\DBAL\Driver\PDOException(code: HY000): SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\xF0\x9F\x9A\xA7 G…’ for column ‘tokens’ at row 1 at /home2/rstkd/public_html/email/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\xF0\x9F\x9A\xA7 G…’ for column ‘tokens’ at row 1 at /home2/rstkd/public_html/email/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)”} []

My installation of mautic is still sending emails in campaigns perfectly fine, and it also sends the email I am trying to send to my segment perfectly fine to myself when I send a test email using the send test feature.

Note: the email in the error log has been modified from my real customers email to 'CUSTOMEREMAILHERE@yahoo.com" to preserve their privacy.

Is anyone else having this same issue? I saw a few posts about people having this same issue on 2.0 but the posts just end with saying this error will be fixed in new versions.

Hope to hear back soon.

Best regards,
Connor

Also as a side note my server time, timezone in the mautic configuration, and my Mauitc account timezone are all set to the same timezone: Chicago.

When I view a contacts history all times listed here are in Central Standard Time, which is correct as this is the timezone for Chicago, but when I view the all contacts page the times given in this list are all incorrect.

It seems the contacts list page with all contacts is using UTC or a different timezone then the individual contact page when inspecting one contacts history.

Does anyone know could this be causing my segments to not send properly?
Has anyone else experienced this?

Does anyone know of a potential fix?

Hope to hear back soon.

Best regards,
Connor

I have a problem but because campaigns are not activated.
you did to that Actien and send messages?

connorj10

I’m having the same issue with UTC vs Chicago time.
My emails are not sending either and I have configured all the cron jobs.
Also I would just push the email, but can’t figure out how.

Paris

@connorj10 @Paris check this
https://www.mautic.org/community/index.php/5501-wrong-timestamps-contact-history-vs-last-active/p1#p15588

@ninjoan thank you so much! this resolved my incorrect timezone time stamps on the contact page.

Your the best!