Aran Dunkley escribió:
$wgDBmysql5 is set to false, the show create table for page gives this on both the original and the new server:
mwiki_page | CREATE TABLE `mwiki_page` ( `page_id` int(8) unsigned NOT NULL AUTO_INCREMENT, `page_namespace` int(11) NOT NULL DEFAULT '0', `page_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `page_restrictions` tinyblob NOT NULL, `page_counter` bigint(20) unsigned NOT NULL DEFAULT '0', `page_is_redirect` tinyint(1) unsigned NOT NULL DEFAULT '0', `page_is_new` tinyint(1) unsigned NOT NULL DEFAULT '0', `page_random` double unsigned NOT NULL DEFAULT '0', `page_touched` varchar(14) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '', `page_latest` int(8) unsigned NOT NULL DEFAULT '0', `page_len` int(8) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`page_id`), UNIQUE KEY `name_title` (`page_namespace`,`page_title`), KEY `page_random` (`page_random`), KEY `page_len` (`page_len`) ) ENGINE=MyISAM AUTO_INCREMENT=19105 DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci
Your table has latin1 charset, but page_title has it as utf-8. Since page_touched will contain the same in latin1 as utf-8, you could fix this changing $wgDBmysql5 to true, but given this inconsistence, that might break displaying of content from other tables :/