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

[Platonides]

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