https://bugzilla.wikimedia.org/show_bug.cgi?id=29102

Bruno <btech...@free.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |btech...@free.fr

--- Comment #25 from Bruno <btech...@free.fr> 2011-12-10 15:03:16 UTC ---
Hello,
I want to upgrade from MW 1.16.4 with MySql 5 database and I have same bug with
same message:
     Database returned error "1115: Unknown character set: 'mysql4'
(localhost)"

I'm not an expert with php and database but I have looked inside code and I
have found where the value 'mysql4' is determined in upgrade mode (I dont know
if it's same in installation mode, I have not tested)
This is in file: ...\mediawiki-1.18.0\includes\installer\MysqlInstaller.php at
line #160
    # Determine existing default character set
    if ( $conn->tableExists( "revision" ) ) {
        $revision = $conn->buildLike( $this->getVar( 'wgDBprefix' ) .
'revision' );
        $res = $conn->query( "SHOW TABLE STATUS $revision", __METHOD__ );
        $row = $conn->fetchObject( $res );
        if ( !$row ) {
            $this->parent->showMessage( 'config-show-table-status' );
            $existingSchema = false;
            $existingEngine = false;
        } else {
            if ( preg_match( '/^latin1/', $row->Collation ) ) {
                $existingSchema = 'mysql4';
            } elseif ( preg_match( '/^utf8/', $row->Collation ) ) {
                $existingSchema = 'utf8';
            } elseif ( preg_match( '/^binary/', $row->Collation ) ) {
                $existingSchema = 'binary';
            } else {
                $existingSchema = false;
                $this->parent->showMessage( 'config-unknown-collation' );
            }
            if ( isset( $row->Engine ) ) {
                $existingEngine = $row->Engine;
            } else {
                $existingEngine = $row->Type;
            }
        }
    } else {
        $existingSchema = false;
        $existingEngine = false;
    }

In my database I have different collation, som tables have utf8_general_ci, and
others latin1_swedish_ci
Is this normal or not ?

For the table 'revision' collation is 'latin1_swedish_ci' and it' why the
upgrade set the value to mysql4

What do you think about that, and have you an idea to correct

Thanks

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.

_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to