MacrossWorld Posted June 24, 2021 Posted June 24, 2021 Getting this error when updating the latest security patch, can't continue. Any ideas? Incorrect string value: '\xF0\x9F\x8E\x89 Y...' for column 'word_default' at row 5 ..../system/Application/Application.php::2140 INSERT INTO `ibf_core_sys_lang_words` ( `word_app`, `word_key`, `lang_id`, `word_default`, `word_default_version`, `word_js`, `word_export` ) VALUES ( ?, ?, ?, ?, ?, ?, ? ), ( ?, ?, ?, ?, ?, ?, ? ), ( ?, ?, ?, ?, ?, ?, ? ), ( ?, ?, ?, ?, ?, ?, ? ), ( ?, ?, ?, ?, ?, ?, ? ), ( ?, ?, ?, ?, ?, ?, ? ), ( ?, ?, ?, ?, ?, ?, ? ), ( ?, ?, ?, ?, ?, ?, ? ), ( ?, ?, ?, ?, ?, ?, ? ), ( ?, ?, ?, ?, ?, ?, ? ), ( ?, ?, ?, ?, ?, ?, ? ), ( ?, ?, ?, ?, ?, ?, ? ), ( ?, ?, ?, ?, ?, ?, ? ), ( ?, ?, ?, ?, ?, ?, ? ) ON DUPLICATE KEY UPDATE `word_app`=VALUES(`word_app`), `word_key`=VALUES(`word_key`), `lang_id`=VALUES(`lang_id`), `word_default`=VALUES(`word_default`), `word_default_version`=VALUES(`word_default_version`), `word_js`=VALUES(`word_js`), `word_export`=VALUES(`word_export`)
Stuart Silvester Posted June 24, 2021 Posted June 24, 2021 2 minutes ago, MacrossWorld said: Getting this error when updating the latest security patch, can't continue. Any ideas? Incorrect string value: '\xF0\x9F\x8E\x89 Y...' for column 'word_default' at row 5 ..../system/Application/Application.php::2140 INSERT INTO `ibf_core_sys_lang_words` ( `word_app`, `word_key`, `lang_id`, `word_default`, `word_default_version`, `word_js`, `word_export` ) VALUES ( ?, ?, ?, ?, ?, ?, ? ), ( ?, ?, ?, ?, ?, ?, ? ), ( ?, ?, ?, ?, ?, ?, ? ), ( ?, ?, ?, ?, ?, ?, ? ), ( ?, ?, ?, ?, ?, ?, ? ), ( ?, ?, ?, ?, ?, ?, ? ), ( ?, ?, ?, ?, ?, ?, ? ), ( ?, ?, ?, ?, ?, ?, ? ), ( ?, ?, ?, ?, ?, ?, ? ), ( ?, ?, ?, ?, ?, ?, ? ), ( ?, ?, ?, ?, ?, ?, ? ), ( ?, ?, ?, ?, ?, ?, ? ), ( ?, ?, ?, ?, ?, ?, ? ), ( ?, ?, ?, ?, ?, ?, ? ) ON DUPLICATE KEY UPDATE `word_app`=VALUES(`word_app`), `word_key`=VALUES(`word_key`), `lang_id`=VALUES(`lang_id`), `word_default`=VALUES(`word_default`), `word_default_version`=VALUES(`word_default_version`), `word_js`=VALUES(`word_js`), `word_export`=VALUES(`word_export`) If you can submit a ticket via the client area, we'll look into this for you.
MacrossWorld Posted June 24, 2021 Author Posted June 24, 2021 I don't see any ticket area, just a support request option, which opens a chat window...is this the ticket area now?
Stuart Silvester Posted June 24, 2021 Posted June 24, 2021 20 minutes ago, MacrossWorld said: I don't see any ticket area, just a support request option, which opens a chat window...is this the ticket area now? Yes, that's right 🙂
MacrossWorld Posted June 24, 2021 Author Posted June 24, 2021 (edited) Support teasm was able to get into my instance and fix so I could complete the update. I also needed to enable UTF8MB4 and convert my db. Thank you for the quick responses! Edited June 24, 2021 by MacrossWorld Ryan Ashbrook 1
Recommended Posts