I'm so glad I found this thread!
These Incorrect string value: '\x... errors have been driving me crazy for some time.
Basically it boil down to customer-input of emojis that will either:
- crash at checkout (email can't be recorded in the archives, order is create but is empty)
- crash at Paypal payment (payment arrives, order is not created)
Each time an emoji was either added in an order comment or in the Paypal payment comments, crashing the whole thing on a database error.
Found this thread + the ut8mb4 script but of course I was on 1.5.5f + ZC dates back to 1.3.8 in 2009!
Double fail: pre-v1.5.6 + old v1.3.8 database structure
Code:
v1.5.5e [2017-03-19 17:11:48] (Version Update 1.5.4->1.5.5e)
v1.5.4 [2017-03-19 17:11:44] (Version Update 1.5.3->1.5.4)
v1.5.3 [2017-03-19 17:11:40] (Version Update 1.5.2->1.5.3)
v1.5.2 [2017-03-19 17:11:34] (Version Update 1.5.1->1.5.2)
v1.5.1 [2017-03-19 17:11:28] (Version Update 1.5.0->1.5.1)
v1.5.0 [2017-03-19 17:11:20] (Version Update 1.3.9->1.5.0)
v1.3.9h [2010-11-04 22:35:18] (Version Update 1.3.9g->1.3.9h)
v1.3.9g [2010-10-01 12:17:54] (Version Update 1.3.9f->1.3.9g)
v1.3.9f [2010-09-10 23:38:40] (Version Update 1.3.8->1.3.9f)
v1.3.8 [2009-07-04 20:22:05] (Fresh Installation)
I brought my ZC up to speed:
Code:
v1.5.6c [2021-01-07 15:05:13] (Version Update 1.5.5->1.5.6c)
And now all I need to do is get these emojis to work without damaging the accents in the existing fields.
My ZC is in FRENCH, tons of accents lying around.
I tried a dry-run of the utf8mb4 script and it completed successfully but after that most of the Admin accentuated contents located in the DB (menus, controls, product names, categories) would show up weird even after updating the CHARSET.
Everything in UTF-8 */includes/languages/french* shows correctly.
Did anyone experience such issues when upgrading to utf8/utf8mb4?
Julien
Bookmarks