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!!!!
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Bovo wrote:
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
I miss all pages in Help (Справка - in russian)
Error on several pages:
«Database::select». MySQL возвратил ошибку «1267: Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (koi8r_general_ci,COERCIBLE) for operation '=' (localhost)».
- 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!!!!
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
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
Frames Project wrote:
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
How are you determining that there's no Main Page? Note that it is stored in the db as "Main_Page".
Le lundi 08 décembre 2008 à 18:38 +0100, Platonides a écrit :
Frames Project wrote:
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
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
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'; ?
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
Hi Francois,
2008/12/10 Frames Project frames@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'; ?
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 !
Isn't it Accueil (like http://fr.wikipedia.org/wiki/Accueil)?
Le mercredi 10 décembre 2008 à 13:18 +0100, Jean-Marc van Leerdam a écrit :
Hi Francois,
2008/12/10 Frames Project frames@lct.jussieu.fr
Isn't it Accueil (like http://fr.wikipedia.org/wiki/Accueil)?
Yes it is. F.
mediawiki-l@lists.wikimedia.org