David Carson wrote:
> I'm trying to upgrade from 1.9.1 to 1.9.2. I exploded the tarball.
> Then I modified the .conf file to incorporate the changes I had put in
> 1.9.1, including pointing to the correct db name. I get the following
> error when I try to run codestriker.pl:
> DBD::mysql::db selectrow_array failed: Illegal mix of collations
> (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for
> operation '=' at
> line 386.
Strange - what version of mysql are you using?
You probably have done this already, but before doing anything - backup
your codestriker database.
The default character set which codestriker uses now is utf8. It seems
that your current database is set to use latin1_swedish_ci as its
Perhaps you need to get a mysql shell, and alter the table's collation.
ALTER TABLE topic DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci"
Check out http://dev.mysql.com/doc/refman/4.1/en/charset-table.html for
You might also need to do something like:
ALTER TABLE topic CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;