XF 2.2 Resolved

[JackieChun]

I am running the script to enable emoji support in the database per XenForo instructions but getting the following error.

The forum originally ran XenForo 1.5 and later upgraded to 2.2.

Any ideas?

The following tables failed to convert:
* xf_search_index: xf_search_index: MySQL query error [1366]: Incorrect string value: '\xB8\xCB\x00\x00'...' for column forum_xf.xf_search_index.message at row 57443
You should contact the table creator for guidance. Failure to correct this may lead to unexpected behavior.

 

[Jeremy P]

Presumably re-running the converter results in the same error?

You might try checking the existing table collation:

SHOW TABLE STATUS LIKE 'xf_search_index'

And the column collation, particularly of the message column:

SHOW FULL COLUMNS FROM `xf_search_index`

They should be utf8_general_ci prior to conversion or utf8mb4_general_ci after conversion.

You can try truncating the table, re-running the converter, and rebuilding the search index:

TRUNCATE TABLE `xf_search_index`

And if all else fails, you can drop and recreate the table with the correct collation, and then rebuild the search index:

DROP TABLE `xf_search_index`;

CREATE TABLE `xf_search_index` (
  `content_type` varchar(25) NOT NULL,
  `content_id` int(10) unsigned NOT NULL,
  `title` varchar(250) NOT NULL DEFAULT '',
  `message` mediumtext NOT NULL,
  `metadata` mediumtext NOT NULL,
  `user_id` int(10) unsigned NOT NULL DEFAULT 0,
  `item_date` int(10) unsigned NOT NULL,
  `discussion_id` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`content_type`,`content_id`),
  KEY `user_id_item_date` (`user_id`,`item_date`),
  FULLTEXT KEY `title_message_metadata` (`title`,`message`,`metadata`),
  FULLTEXT KEY `title_metadata` (`title`,`metadata`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;