Troubles after upgrade

List overview All Threads
Download

newer

older

JFusion MediaWiki plug-in

Welcome to mediawiki-l (weekly...

Bovo

31 Oct 2008 31 Oct '08

1:35 a.m.

I upgrade wiki.irkutsk to 1.12 version but after this: I make updating process as in rules. I run the update.php maintenance script * MediaWiki version: 1.12.1 * PHP version: 5.2.6 (apache2handler) * MySQL version: 4.1.22-log * URL: http://wiki.irkutsk.ru 1. I miss all pages in Help (Справка - in russian) 2. Error on several pages: «Database::select». MySQL возвратил ошибку «1267: Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (koi8r_general_ci,COERCIBLE) for operation '=' (localhost)». 3. When I try to create a new page (create a link, turn it on and edit new page) - it is not recorded, and an error «Database::select». MySQL возвратил ошибку «1267: Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (koi8r_general_ci,COERCIBLE) for operation '=' (localhost)». What's wrong? Help!!!! -- best regards, Dmitry

Show replies by thread

Brion Vibber

31 Oct 31 Oct

6:28 p.m.

New subject: [Mediawiki-l] Troubles after upgrade

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Bovo wrote:

...

Sounds like your original installation was created on an old MediaWiki with the old default "charset-agnostic" mode ("backwards-compatible UTF-8" setting on the installer), with MySQL configured to have one server charset... then when you did the upgrade, it was configured to a different default server charset, and new tables/fields got created with the different charset and now it's terribly confused. The best solution, ultimately, is a fresh installation with the database configured for the binary schema -- this will be consistent and isn't dependent on the whims of the MySQL server's configuration. Unfortunately we don't have an automatic script right now to normalize your data. You can probably pull some sort of export/import to fix it, but the bad news is basically from using MySQL 4.1 and the crappy old defaults. - -- brion

...PGP SIGNATURE...

-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.8 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkkLQCsACgkQwRnhpk1wk472swCeLyPzPbTsfnWZ8BqJbQHX4VAj KzoAoJ5mKelqNJbXDEkrJG3m87qCXvh+ =e7Yv -----END PGP SIGNATURE-----

Frames Project

8 Dec 8 Dec

9 a.m.

New subject: [Mediawiki-l] Main Page missing in phpmyadmin database export

Hello I have no right to use mysql or mysqldump to dump my wiki database, I have to use phpmyadmin. I setup a local copy of my wiki to upgrade it locally and then move the updated copy on the provider's site. I dumped the database, using the export command of phpmyadmin. Everything seems ok except the "Main Page" is missing ! I tried three times the same operations : no "Main Page". Does somebody have an idea of what happened ? Thanks Francois Colonna

Platonides

6:38 p.m.

New subject: [Mediawiki-l] Main Page missing in phpmyadmin database export

Frames Project wrote:

...

How are you determining that there's no Main Page? Note that it is stored in the db as "Main_Page".

Frames Project

8:49 p.m.

New subject: [Mediawiki-l] Main Page missing in phpmyadmin database export

Le lundi 08 décembre 2008 à 18:38 +0100, Platonides a écrit :

...

Frames Project wrote:

How are you determining that there's no Main Page? Note that it is stored in the db as "Main_Page".

It is empty in the new wiki. The db of which was copied from the old one by phpmyadmin. Best, Francois Colonna

Platonides

9 Dec 9 Dec

12:06 a.m.

New subject: [Mediawiki-l] Main Page missing in phpmyadmin database export

Frames Project a écrit:

...

How are you determining that there's no Main Page? Note that it is stored in the db as "Main_Page".

It is empty in the new wiki. The db of which was copied from the old one by phpmyadmin. Best, Francois Colonna

What's the result of doing SELECT * FROM page WHERE page_title='Main_Page'; ?

Frames Project

10 Dec 10 Dec

1:10 p.m.

New subject: [Mediawiki-l] Main Page missing in phpmyadmin database export

Le mardi 09 décembre 2008 à 00:06 +0100, Platonides a écrit :

...

Frames Project a écrit:

How are you determining that there's no Main Page? Note that it is stored in the db as "Main_Page".

It is empty in the new wiki. The db of which was copied from the old one by phpmyadmin. Best, Francois Colonna

What's the result of doing SELECT * FROM page WHERE page_title='Main_Page'; ?

I run this command (Main_page is Acceuil in the french version) in the "new" wiki database : mysql> SELECT * FROM cla_page WHERE page_title='Acceuil'; Empty set (0.00 sec) It is there but empty. Even stranger I run the same command in phpmyadmin for the "old" wiki database, and I got : MySQL returned an empty result set (i.e. zero rows). (Query took 0.0036 sec) while the page Acceuil does exit ! Do you understand anything ? Thanks Francois Colonna

Jean-Marc van Leerdam

1:18 p.m.

New subject: [Mediawiki-l] Main Page missing in phpmyadmin database export

Hi Francois, 2008/12/10 Frames Project <frames(a)lct.jussieu.fr>

...

Le mardi 09 décembre 2008 à 00:06 +0100, Platonides a écrit :

Frames Project a écrit:

How are you determining that there's no Main Page? Note that it is stored in the db as "Main_Page".

It is empty in the new wiki. The db of which was copied from the old one by phpmyadmin. Best, Francois Colonna

What's the result of doing SELECT * FROM page WHERE page_title='Main_Page'; ?

Isn't it Accueil (like http://fr.wikipedia.org/wiki/Accueil)? -- Regards, Jean-Marc -- ___ @@ // \\ "De Chelonian Mobile" (_,\/ \_/ \ TortoiseSVN \ \_/_\_/> The coolest Interface to (Sub)Version Control /_/ \_\ http://tortoisesvn.net