Change DB TO column to something bigger

Hello there,

Would you please share some more details so that we can investigate further? For instance, some screenshots about how you set up the email notification so that we can recreate the issue on our end.

Let me know the update.

Thank you

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.

Hello there,

I have set an email notification from Fluent Forms, set the to address to 8 emails and it worked fine, kindly check the screenshot. All the emails arrived to my inbox, kindly check the screenshot. Would you please let us know which email-sending service you are using so that we can investigate further?

Thank you

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.

Hello there,

Thanks for the information, in my cases, the To column wasn’t empty, kindly check the screenshot. Also, thanks for the suggestion regarding string length. I have forwarded this to our developers and hopefully, they will take a further look on this.

Thank you

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