[Mediawiki-l] [SPAM?]: error after importing database with phpmyadmin

[Vasiliadis, Thomas]

Tschecht Michał 

Could it be, that your mysql server at home and your online server have different codepages? (latin1_bin vs. latin2_general_ci).
Your online and offline Databases have to have the same type of codepages or sth like this can happen.
Take care that both are of the same type and try again,

TV


 


-----Ursprüngliche Nachricht-----
Von: mediawiki-l-bounces at Wikimedia.org [mailto:mediawiki-l-bounces at Wikimedia.org] Im Auftrag von Michal Gawronski
Gesendet: Montag, 5. Juni 2006 21:15
An: mediawiki-l at Wikimedia.org
Betreff: [SPAM?]: [Mediawiki-l] error after importing database with phpmyadmin

Hello.
Ive prepared my wikipedia on localmachine - running Windows XP and EasyPHP, when ive copied all files to server, exported database from EasyPHP with phpmyadmin and imported it to server using phpmyadmin too.
But now i get this error message when i try to open wiki on server:
Error in fetchObject(): Illegal mix of collations (latin1_bin,IMPLICIT) and (latin2_general_ci,COERCIBLE) for operation ' IN '

Backtrace:
GlobalFunctions.php line 602 calls wfbacktrace() Database.php line 596 calls wfdebugdiebacktrace() Database.php line 1787 calls databasemysql::fetchobject() LinkBatch.php line 76 calls resultwrapper::fetchobject() LinkBatch.php line 55 calls linkbatch::executeinto() Skin.php line 192 calls linkbatch::execute() Skin.php line 171 calls skinmonobook::preloadexistence() SkinTemplate.php line 108 calls skin::initpage() MonoBook.php line 28 calls skintemplate::initpage() SkinTemplate.php line 151 calls skinmonobook::initpage() OutputPage.php line 577 calls skinmonobook::outputpage() OutputPage.php line 794 calls outputpage::output() Database.php line 476 calls outputpage::databaseerror() Database.php line 419 calls databasemysql::reportqueryerror() Database.php line 806 calls databasemysql::query() Database.php line 825 calls databasemysql::select() Article.php line 391 calls databasemysql::selectrow() Article.php line 403 calls article::pagedata() Wiki.php line 209 calls article::pagedatafromtitle() Wiki.php line 48 calls mediawiki::initializearticle() index.php line 123 calls mediawiki::initialize()

Whats going on? Wiki is in poland language.



--
Pozdrowienia,
 Michał Gawroński

_______________________________________________
MediaWiki-l mailing list
MediaWiki-l at Wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l