Hi there... I have a wiki running like a charm for two years. Last month I
was trying to migrate to a brand new server, so I did the following:
1. Install mediawiki 1.26.0 on the new server
2. Upgrade from mediawiki 1.25.3 to 1.26.0 on the old server
3. Dump the old database on a .sql file
4. Load the database on the new server
5. Copy the files from the old to the new server
Everything works fine EXCEPT those pages with an apostrophe on the page
title, which send an
ERR_TOO_MANY_REDIRECTS
error.
I have compared both the database character set and the storage engine and
their are the same... Could you help me guess what could be the problem.
The wiki is in French, so there are lots of pages with an apostrophe on
their name....
Cheers
PS: Both records are identical in both databases
SELECT default_character_set_name FROM information_schema.SCHEMATA
-> WHERE schema_name = "wikircln";
+----------------------------+
| default_character_set_name |
+----------------------------+
| latin1 |
+----------------------------+
page | CREATE TABLE `page` (
`page_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`page_namespace` int(11) NOT NULL,
`page_title` varbinary(255) NOT NULL,
`page_restrictions` tinyblob NOT NULL,
`page_is_redirect` tinyint(3) unsigned NOT NULL DEFAULT '0',
`page_is_new` tinyint(3) unsigned NOT NULL DEFAULT '0',
`page_random` double unsigned NOT NULL,
`page_touched` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`page_latest` int(10) unsigned NOT NULL,
`page_len` int(10) unsigned NOT NULL,
`page_content_model` varbinary(32) DEFAULT NULL,
`page_links_updated` varbinary(14) DEFAULT NULL,
`page_lang` varbinary(35) DEFAULT NULL,
PRIMARY KEY (`page_id`),
UNIQUE KEY `name_title` (`page_namespace`,`page_title`),
KEY `page_random` (`page_random`),
KEY `page_len` (`page_len`),
KEY `page_redirect_namespace_len`
(`page_is_redirect`,`page_namespace`,`page_len`)
) ENGINE=InnoDB AUTO_INCREMENT=155 DEFAULT CHARSET=binary |