Re: [Mediawiki-l] Unknown column 'img_sha1' in 'field list'

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