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

[lucakuehne]

I changed the column 'lower' to utf8mb4_unicode_ci, but in the 'email_address' table and not in the 'email' table.
And that did the trick. The emails are now getting sent. :-)

EDIT: Sorry for the missleady typo! The emails ARE getting sent

[yuri]

Try to convert column 'lower' in 'email' table to utf8mb4_unicode_ci. Make a backup of the table just in case. This may take a while if you have a big table.

[lucakuehne]

I'm running a MariaDB 10.3.16

[yuri]

What mysql version do you have?

[lucakuehne]

I did change those things.
And I got the bad email address. The only thing which might cause an exception is a "é" in the email address... It is is a valid character, but it might cause some problems...

[yuri]

Hi Luca,

Please replace the file again: https://raw.githubusercontent.com/es.../MassEmail.php. I made a few changes to it.

Then.

Add to this line: https://github.com/espocrm/espocrm/blob/hotfix/5.8.5/application/Espo/Modules/Crm/Services/MassEmail.php#L179

the following code:

$GLOBALS['log']->error('Item count: '. count($itemList)); 

Wrap this line https://github.com/espocrm/espocrm/b...Email.php#L185 with try catch

try {
     $emailAddressRecord = $this->getEntityManager()->getRepository('EmailAddress')->getByAddress($emailAddress);
} catch (\Exception $e) {
   $GLOBALS['log']->error('Bad email address: ' . $emailAddress);
   throw new \Exception($e->getMessage());
} 

[lucakuehne]

Hi Yuri

Yes it does indeed stop ervery time after it has processed 621 contacts.
But how can I determine at which contact the proccess fails? I don't really see the logic on how the mass email processes the target items...

[yuri]

Does it process the same number of targets every time? Maybe the error occurs at a specific record?

[lucakuehne]

I replaced the file and restarted the apache, but the error still occurs.

[yuri]

Try to replace application/Espo/Modules/Crm/Services/MassEmail.php file with this one: https://raw.githubusercontent.com/es.../MassEmail.php'

It's from the next version, maybe it will help.

[lucakuehne]

Do you have the latest version of EspoCRM?

Yes, version 5.8.4

Please check the collations of the following columns in database:
table: contact
column: id

table: contact_target_list
column: contact_id

I checked them and they are they same:
contact.id => utf8_unicode_ci
contact_target_list.contact_id => utf8_unicode_ci

[yuri]

Please check the collations of the following columns in database:

table: contact
column: id

table: contact_target_list
column: contact_id

[yuri]

Do you have the latest version of EspoCRM?

[yuri]

It's an ID of MassEmail record

[lucakuehne]

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

So let's find out together :-) I'll help you as much as I can.

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

Just contacts and some leads.
I just removed the leads from the target list. The scheduled job for the processing of the mass emails did just run, but nothing different. I also recreated a new mass mail record. Just to be sure to have a clean record to start with. But saddly still the same error in the logs...

Also another question: What is the UID in the log entry? Is this the ID of the scheduled job or, the running job instance? Or the mass email or the contact?
EDIT: I just figured out the UID is the ID of the mass email