Re: [Codestriker-user] mysql error when upgrading 1.9.1 to 1.9.2

[David S. <si...@us...>]

Hi David,

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
> /var/www/codestriker/codestriker-1.9.2/bin/../lib/Codestriker/Model/Topic.pm
> 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 
collation operation.

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 
more details.

You might also need to do something like:

ALTER TABLE topic CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

Cheers,
David