MediaWiki Bugzilla Report for April 05, 2010 - April 12, 2010
Status changes this week
Bugs NEW : 89 Bugs ASSIGNED : 9 Bugs REOPENED : 11 Bugs RESOLVED : 99
Total bugs still open: 4336
Resolutions for the week:
Bugs marked FIXED : 62 Bugs marked REMIND : 0 Bugs marked INVALID : 14 Bugs marked DUPLICATE : 14 Bugs marked WONTFIX : 3 Bugs marked WORKSFORME : 5 Bugs marked LATER : 1 Bugs marked MOVED : 0
Specific Product/Component Resolutions & User Metrics
New Bugs Per Component
UsabilityInitiative 15 General/Unknown 5 Images and files 4 General/Unknown 3 Site requests 3
New Bugs Per Product
MediaWiki 22 Wikimedia 11 MediaWiki extensions 29
Top 5 Bug Resolvers
alex.emsenhuber [AT] bluewin.ch 18 jeluf [AT] gmx.de 15 roan.kattouw [AT] gmail.com 12 Bryan.TongMinh [AT] Gmail.com 7 conrad.irwin [AT] gmail.com 5
Hi I'm wondering if anyone can help with this multibyte character corruption: http://aqes.organicdesign.tv/Categor%C3%ADa:Arquitecto
The site was moved from a shared host to a dedicated server, but now it's not rendering the multibyte characters properly in the titles, but seems ok in the content. The mediawiki version went from 1.15.1 to 1.15.3 and the MySQL version 5.1.30 to 5.1.45 and all the configuration seems identical on the new server.
I've tried all the tips about --default-character-set to latin1 or utf8 etc mentioned in the MW manual page but nothing seems to change it no matter what I use for export or import.
A solution would be greatly appreciated as their site has been down for almost a week now while trying to solve this.
Thanks, Aran
Aran Dunkley escribió:
Hi I'm wondering if anyone can help with this multibyte character corruption: http://aqes.organicdesign.tv/Categor%C3%ADa:Arquitecto
The site was moved from a shared host to a dedicated server, but now it's not rendering the multibyte characters properly in the titles, but seems ok in the content. The mediawiki version went from 1.15.1 to 1.15.3 and the MySQL version 5.1.30 to 5.1.45 and all the configuration seems identical on the new server.
I've tried all the tips about --default-character-set to latin1 or utf8 etc mentioned in the MW manual page but nothing seems to change it no matter what I use for export or import.
A solution would be greatly appreciated as their site has been down for almost a week now while trying to solve this.
Thanks, Aran
What do you have $wgDBmysql5 set to? What's the output of doing SHOW CREATE TABLE page; ?
$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
Platonides wrote:
Aran Dunkley escribió:
Hi I'm wondering if anyone can help with this multibyte character corruption: http://aqes.organicdesign.tv/Categor%C3%ADa:Arquitecto
The site was moved from a shared host to a dedicated server, but now it's not rendering the multibyte characters properly in the titles, but seems ok in the content. The mediawiki version went from 1.15.1 to 1.15.3 and the MySQL version 5.1.30 to 5.1.45 and all the configuration seems identical on the new server.
I've tried all the tips about --default-character-set to latin1 or utf8 etc mentioned in the MW manual page but nothing seems to change it no matter what I use for export or import.
A solution would be greatly appreciated as their site has been down for almost a week now while trying to solve this.
Thanks, Aran
What do you have $wgDBmysql5 set to? What's the output of doing SHOW CREATE TABLE page; ?
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
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 :/
wikitech-l@lists.wikimedia.org