MacrossWorld Posted June 24, 2021 Share 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`) Link to comment Share on other sites More sharing options...
Stuart Silvester Posted June 24, 2021 Share 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. Link to comment Share on other sites More sharing options...
MacrossWorld Posted June 24, 2021 Author Share 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? Link to comment Share on other sites More sharing options...
Stuart Silvester Posted June 24, 2021 Share 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 🙂 Link to comment Share on other sites More sharing options...
MacrossWorld Posted June 24, 2021 Author Share 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 Link to comment Share on other sites More sharing options...
Recommended Posts