Email campagin won't send (or queue all emails)

[yuri]

What entity types the faulty campaign has in the target list. Only contacts or mix of different entity types?

[yuri]

Seems the mysql error is a culprit. Must be different collations are used for some columns in database. I don't know where yet.

[lucakuehne]

Hi Yuri

The status of the mass-email record ist "Pending".

I was able to find some entries regarding mass emails in the logs:

[2020-03-31 04:30:08] Espo.ERROR: Job ProcessMassEmail#createQueue 5e81e21f01c05fa4c: [HY000] SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=' [] []
[2020-03-31 04:35:07] Espo.ERROR: Job ProcessMassEmail#createQueue 5e81e21f01c05fa4c: [HY000] SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=' [] []
[2020-03-31 04:40:16] Espo.ERROR: Job ProcessMassEmail#createQueue 5e81e21f01c05fa4c: [HY000] SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=' [] []

That's a bit strange for me, as in the jobs in the administration all mass email jobs have been marked as "Success"

[yuri]

Hi Luca,

What status of Mass Email record? In Process, Complete or something else?

Anything in data/logs?

[lucakuehne]

Hi

Yesterday I created an email-campagin. Then I created a mass-email planned for todays morning. I also sent a test-email for this mass-email and everything looked fine.
Today I checked the campaign and saw that the massemail hasn't been sent. And only around 620 of the ~10'000 contacts in the targetlist have been queued for sending.

For testing purposed I created another campaign with just a smaller targetlist and the all emails did get cued and sent as well.

I guess this is a bug based on the size of the targetlist... Could anybody confirm that they have successfully sent an email-campaign with a targetlist bigger than 10'000 items?

Best regards
Luca