375257 - bug reassign fails with "Illegal mix of collations" after upgrading to 3rc1

Status: RESOLVED DUPLICATE of bug 374951

(Bugzilla :: Creating/Changing Bugs, defect)

Description

[jstaerk]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.3) Gecko/20070309 Firefox/2.0.0.3
Build Identifier: 

I have upgraded from 2.20 to 3.0rc1 with default upgrade proposal and left utf8 switched on (proposal of the upgrade). 



Reproducible: Always

Steps to Reproduce:
1.install bugzilla 2.20
2.insert some users and some bugs
3.upgrade to 3rc with default settings
4.choose any bug and try to reassign to sb else 
Actual Results:  
error message 
DBD::mysql::db do failed: Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation 'case' at /srv/www/htdocs/usegroup/bugzilla/process_bug.cgi line 1678


Expected Results:  
confirmation message that the bug has been reassigned

contrib/recode.pl --guess --charset=cp1252
does not help

switching unicode off works around the bug.

Comment 1

[Frédéric Buclin]

There seems to be many reports about this conversion to UTF8 when upgrading. We should make sure there is nothing wrong before releasing 3.0 final.

Comment 2

[jstaerk]

i volunteer to test if you have sth, to be honest, I did not even reproduce myself. if you like i can get myself a vmware snapshot with 2.22 and try to upgrade to 3rc1 (or is there a nightly version i'd better use?) and try to upgrade and reassign some bugs.

Comment 3

[Max Kanat-Alexander]

I'm guessing that at some point you did a mysqldump on the database without preserving the database charset?

Comment 4

[jstaerk]

you're right max, sorry.