Page MenuHomePhabricator

Impossible to undelete one page
Closed, InvalidPublic

Description

For restauring a deleted page, I see the following message :

depuis la fonction « LinkCache::addLinkObj ». MySQL a renvoyé l’erreur « 1267 : Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' (localhost) ».

I've imported histories from french wikipedia with Special:Import.

After I saw that it was impossible to watch history, I deleted it and I can't restore it. See this message on the head of this message


Version: 1.12.x
Severity: enhancement
URL: http://fr.vikidia.org/index.php/Special:Restaurer/Aung_San_Suu_Kyi

Details

Reference
bz12883

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 10:04 PM
bzimport set Reference to bz12883.
bzimport added a subscriber: Unknown Object (MLST).

It's now impossible to import a page with this name from french wikipédia to http://fr.vikidia.org/index.php/Aung_San_Suu_Kyi

Warning: preg_replace_callback() [function.preg-replace-callback]: Unable to call custom replacement function in /var/www/vhosts/vikidia.org/subdomains/fr/httpdocs/includes/Linker.php on line 1031
Erreur de la base de données
Erreur de syntaxe dans la base de données. Cette erreur est peut-être due à une requête de recherche incorrecte (voir $5) ou une erreur dans le logiciel. La dernière requête traitée par la base de données était :

(Requête SQL cachée)

depuis la fonction « LinkCache::addLinkObj ». MySQL a renvoyé l’erreur « 1267 : Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' (localhost) ».

Bref, quel est le con qui a bidouillé Special:Import ?

Just for clarity, "undelete" is the English term for this action. "Restaure" is Frenglish.

Sounds like you've got a corrupt database, probably from selecting a non-default DB layout at install under an older MediaWiki version and then upgrading it.

You'll need to manually sort out the collations or dump everything and build a fresh DB.