Hello,
I am trying to update my mediawiki 1.10.2 in 1.15.3.
I just try to put my Database in the newinstallation but i have this error :
« LocalFile::loadFromDB ». MySQL a renvoyé l’erreur « 1054 : Unknown column 'img_sha1' in 'field list' (localhost) ».
Can you help me to upgrade please ?
Thanks you.
http://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script Sorry >_<
— Kalan
I know that but i have probleme with eaccelerator if i use this method :
PHP Fatal error: Call to a member function matchStartToEnd() on a non-object in /var/www/html/ddco/includes/parser/Parser.php on line 2741
It works if i disable eaccelerator but :s
2009/8/5 Kalan kalan.001@gmail.com
http://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script Sorry >_<
— Kalan
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
On Wed, Aug 5, 2009 at 13:58, nicolas gogueygoguey.nicolas@gmail.com wrote:
It works if i disable eaccelerator but :s
You only need to run updater only once after upgrading files, so it shouldn’t be a problem.
— Kalan
Ok thanks
I have a new problème. my conversion of charactere is really bad for example :
é for é
can you help me for this ? thank you very much
2009/8/5 Kalan kalan.001@gmail.com
On Wed, Aug 5, 2009 at 13:58, nicolas gogueygoguey.nicolas@gmail.com wrote:
It works if i disable eaccelerator but :s
You only need to run updater only once after upgrading files, so it shouldn’t be a problem.
— Kalan
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
On Wed, Aug 5, 2009 at 19:01, nicolas gogueygoguey.nicolas@gmail.com wrote:
I have a new problème. my conversion of charactere is really bad for example é for é
MediaWiki works with bytes, not characters. It doesn’t care about the encoding your SQL server stores bytes in, so should you.
— Kalan
Sorry but i don't understand.
I explain :
I want update my wikipedia to : 1.10.2 to 1.15.2.
I begin to export my database (i try with mysqldump and with phpmyadmin). I use php update.php and i import my database but all accent stocked in my database are like this : è ---> è é ---> é À ---> À .....
And all my page are broken :(.
I try to use
UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'è','è'); UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'é','é'); UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'À','À'); UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'î','î'); UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'â','â'); UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'à _','à_'); UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'É','É'); UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'û','û'); UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'ê','ê'); UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'Ã','Ï'); UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'ç','ç'); UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'ö','ö'); UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'ï','ï'); UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'’','’');
for all my tables but i don't know all the change :s and i have lot of page !
Please help me.
Thank you.
2009/8/5 Kalan kalan.001@gmail.com
On Wed, Aug 5, 2009 at 19:01, nicolas gogueygoguey.nicolas@gmail.com wrote:
I have a new problème. my conversion of charactere is really bad for
example
é for é
MediaWiki works with bytes, not characters. It doesn’t care about the encoding your SQL server stores bytes in, so should you.
— Kalan
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
nicolas goguey wrote:
Sorry but i don't understand.
I explain :
I want update my wikipedia to : 1.10.2 to 1.15.2.
I begin to export my database (i try with mysqldump and with phpmyadmin). I use php update.php and i import my database but all accent stocked in my database are like this : è ---> è é ---> é À ---> À .....
And all my page are broken :(.
I try to use
UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'è','è'); UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'é','é'); UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'À','À'); UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'î','î'); UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'â','â'); UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'à _','à_'); UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'É','É'); UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'û','û'); UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'ê','ê'); UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'Ã','Ï'); UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'ç','ç'); UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'ö','ö'); UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'ï','ï'); UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'’','’');
for all my tables but i don't know all the change :s and i have lot of page !
No, no, no. That's wrong! MediaWiki will be storing è as è but that's just because mysql thinks it's in latin1 (whereas it's in fact utf-8).
MediaWiki should be showing it right. Do you have $wgDBmysql5 set to false?
Also, you could have had problems due to http://www.mediawiki.org/wiki/Manual:Backing_up_a_wiki#Character_set
nicolas goguey wrote:
I try to use
UPDATE recentchanges SET `rc_comment` = REPLACE(rc_comment,'è','è');
Don't do that!
From my experience, this happens due to broken MySQL export, specially
the one in phpMyAdmin. Check your export and import procedures. Use mysqldump to export.
mediawiki-l@lists.wikimedia.org