Fabio Nunes

The column is not empty, but it also doesn’t display the list of emails as it should ??

It should only show the list of emails and, in your screenshot, it shows an invalid serialized string because the string has been cut off from character 255 on the database table – which is exactly the error I’m reporting.

Thank you for forwarding this to the developers

Hello.

I wasn’t reporting that the emails weren’t sent, in fact, I said when they were. What I’m reporting is that after sending, the string where they store the TO’s email list is serialized and exceeds the 255 character limit.

Look at your printscreen, the string is cut off halfway through. And if you go to the plugin’s Email Logs page, you’ll see that the TO column is blank because, since the string (from the printscreen) has been cut off, it’s no longer a valid serialized string.

Again, my proposed solution: As I said previously, VARCHAR is still enough, but maybe change length to something higher? Maybe 1024? For reference, 623 was the total size of my serialized string with the 9 emails.

Sure, here is the serialized string that was saved in the database. I have redacted it for privacy purposes, but I have maintained the same string size as the original.

Doing a quick test, it appears that, in my case, if email is sent with 5 or more email addresses (~30 chars each) in the TO field, it will cause the serialized string to exceed 255 characters, which will exceed the TO column size VARCHAR(255) in the _fsmpt_email_logs table.

As I said previously, VARCHAR is still enough, but maybe change length to something higher? Maybe 1024? For reference, 623 was the total size of my serialized string with the 9 emails.

If you need to reproduce this, try to send an email to 7 different email accounts and then check the logs. The TO column in wp-admin will be blank and the TO column in the DB will have an invalid serialized string.

• This reply was modified 1 year, 6 months ago by Fabio Nunes.