Re: [Codestriker-user] mysql error when upgrading 1.9.1 to 1.9.2
Brought to you by:
sits
|
From: David S. <si...@us...> - 2007-01-21 23:14:46
|
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 |