After upgrading to Craft 3.2 I have problems saving entries with a date field.

[handplant]

Description

After saving a change in an entry with date field, the following message appears:

Internal Server Error
Server Error

The web logfile contains the following:
PDOException: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xF0\x9F\x98\x8E? ...' for column mysite.revisions.snapshot at row 1 in /vendor/yiisoft/yii2/db/Command.php:1290

Steps to reproduce

1. Edit an entry with date field
2. Change something and click "Update Entry"

Additional info

• Craft version: Craft Pro 3.2.0
• PHP version: 7.2.14
• Database driver & version: MySQL 5.5.5

[handplant]

Okay. I'm sorry. That was my problem. I have emotjis in the text which cause the error! :( Please close the issue!

[brandonkelly]

You had emojis in the date field? Or a different field type?

[handplant]

No, a Plain Text Field.

[brandonkelly]

Emojis should be getting converted to shortcodes in the backend. Do you remember which emoji character(s) were triggering this so we can look into it?

[brandonkelly]

I was able to reproduce this by temporarily disabling the emoji-shortcode conversion, and updated the UI to do a better job identifying the issue:

Hopefully that’ll save people some troubleshooting time in the future.

[narration-sd]

‘that, and convincing your phone you’re not talking about cake recipes 🍰’

[handplant]

I have the problem in several installations after updating to 3.2. In version 3.1.x I have no problems. What can I do? How can I activate emoji-shortcode?

[brandonkelly]

@handplant it just happens automatically. What exactly are you doing?

[handplant]

@brandonkelly Nothing special. Update to 3.2 without problem. After that I try to save this emoji 😃 in a plain text field. The draft is saved in the background without problems. After click "Update entry" the following error occurs: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xF0\x9F\x98\x80 \xF0...' for column mysite.revisions.snapshot.

[brandonkelly]

Doh, I guess I should have tested actually saving entries with emojis, rather than just ensuring draft saving was working :)

Just fixed this for the next release. To get the fix early, change your craftcms/cms requirement in composer.json to:

"require": {
  "craftcms/cms": "dev-develop#43d22b4403fb555e1d8db3efc4b9978071b1deb5 as 3.2.0",
  "...": "..."
}

Then run composer update.

[khalwat]

I'm experiencing this too: nystudio107/craft-seomatic#606 (comment)