XenForo 1273 - Unknown collation: 'utf8mb4_0900_ai_ci

[Straydog]

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

SQL:

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...

Read more

Continue reading...