XF 2.2 1273 - Unknown collation: 'utf8mb4_0900_ai_ci


Active member
Having some issues changing hosts. Files seem to have moved over properly but when restoring the DB I get the following;

CREATE TABLE `xf_tag_result_cache` (  `result_cache_id` int unsigned NOT NULL AUTO_INCREMENT,  `tag_id` int unsigned NOT NULL,  `user_id` int unsigned NOT NULL,  `cache_date` int unsigned NOT NULL,  `expiry_date` int unsigned NOT NULL,  `results` mediumblob NOT NULL,  PRIMARY KEY (`result_cache_id`),  UNIQUE KEY `tag_id_user_id` (`tag_id`,`user_id`),  KEY `expiration_date` (`expiry_date`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

I have searched and found the following topic here....

Maybe I don't fully understand what I need to do or maybe I am missing something but what exactly should I do? Where should I looks for further information? I have checked the error logs but for some reason not seeing anything there. It is clear it is the hosting change. I am just hoping I can correct it and would appreciate anything anyone can provide. Worst case I can pull essential information from the original site but that would be a very slow process.