XF 2.1 Emoji SSH conversion - One table fault?

[DaveL]

Carried out the emoji conversion and only got one error:

The following tables failed to convert:
        * xf_search_index: xf_search_index: MySQL query error [1366]: Incorrect string value: '\  x88\xF\x00\x00B...' for column `db_xenforo`.`xf_search_index`.`message` at row 83859

Is this something I need to worry about or can I leave it as is?

 

[DaveL]

Looks like it is an issue as just tested with an emoji and got this:

    XF\Db\Exception: MySQL query error [1366]: Incorrect string value: '\xF0\x9F\xA4\xA3' for column `airportc_xenforo`.`xf_search_index`.`message` at row 1 src/XF/Db/AbstractStatement.php:217

    Generated by: Dave 19 June 2019 at 10:42

Stack trace

INSERT  INTO `xf_search_index` (`content_type`, `content_id`, `title`, `message`, `metadata`, `item_date`, `user_id`, `discussion_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?) ON DUPLICATE KEY UPDATE title = VALUES(title), message = VALUES(message), metadata = VALUES(metadata), item_date = VALUES(item_date), user_id = VALUES(user_id), discussion_id = VALUES(discussion_id)
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1366, '22007')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1366, '22007')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(218): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#4 src/XF/Search/Source/MySqlFt.php(96): XF\Db\AbstractAdapter->insert('xf_search_index', Array, false, 'title = VALUES(...')
#5 src/XF/Search/Search.php(40): XF\Search\Source\MySqlFt->index(Object(XF\Search\IndexRecord))
#6 src/XF/Behavior/Indexable.php(46): XF\Search\Search->index('post', Object(XF\Entity\Post), false)
#7 src/XF.php(290): XF\Behavior\Indexable->XF\Behavior\{closure}()
#8 src/XF/Mvc/Dispatcher.php(143): XF::triggerRunOnce(true)
#9 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#10 src/XF/App.php(2177): XF\Mvc\Dispatcher->run()
#11 src/XF.php(390): XF\App->run()
#12 index.php(20): XF::runApp('XF\\Pub\\App')
#13 {main}

Request state

array(4) {
  ["url"] => string(37) "/threads/private-test.15163/add-reply"
  ["referrer"] => string(59) "https://www.airportcitygame.com/threads/private-test.15163/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(9) {
    ["message_html"] => string(11) "<p>🤣</p>"
    ["attachment_hash"] => string(32) "5d7983def6f2a601f385ddf52236c32e"
    ["attachment_hash_combined"] => string(87) "{"type":"post","context":{"thread_id":15163},"hash":"5d7983def6f2a601f385ddf52236c32e"}"
    ["last_date"] => string(10) "1511448037"
    ["last_known_date"] => string(10) "1511448037"
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(28) "/threads/private-test.15163/"
    ["_xfWithData"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}