When submitting emoji it crashes

  • Resolved Jaro

    (@pixtweaks)


    1 year ago

    Hi,
    I’ve noticed in PHP error log that we had a fatal error on form submission. After inspection, the only suspicious thing is that the emoji has been used like “??”, when tested it throws the error. After changing the character set to utf8mb4 no error running the query. Please fix!

    Thank you!

    Error thrown at:
    /wp-content/plugins/fluentform/vendor/wpfluent/framework/src/WPFluent/Database/Query/WPDBConnection.php:224

    SQL to change charset:
    ALTER?TABLE?wp_fluentform_submissions?CONVERT?TO?CHARACTER?SET?utf8mb4?COLLATE?utf8mb4_general_ci;

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Tahmid ul Karim

    (@tahmidulkarim)

    Hi There,

    Can you please share a bit more details regarding the issue? If you can share a few screenshots of your form or a video if possible then that would be helpful for us to better understand the issue that you are facing.

    Thank you!

    Thread Starter Jaro

    (@pixtweaks)

    Hello Tahmid,
    I can’t replicate this issue. I’ve used the original SQL query and now it works. I tried to rollback to older version of the plugin but it still it was working fine. Maybe it’s related to given version of MariaDB. What I would suggest is to review if used COLLATE is good one for all modern emojis and used characters. As well avoid PHP fatal error on that part of the code if DB return an error.

    Thank you very much for looking into it.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘When submitting emoji it crashes’ is closed to new replies.