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 ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Codestriker-user mailing list Codestriker-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/codestriker-user
