381425 - if we want to reassign an issue to a person an error appears (Illegal mix of collations)

Status: RESOLVED DUPLICATE of bug 374951

(Bugzilla :: Bugzilla-General, defect)

Description

[Thomas Müller]

User-Agent:       Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)
Build Identifier: Mozilla 3.0

Software error:
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/bugzilla/process_bug.cgi line 1689



Reproducible: Always

Steps to Reproduce:
1. take an issue (in our case no special issue needed, error appears on every issue I want to reassign)
2. switch status to "reassign to ..."
3. click on commit
4. error message appears
Actual Results:  
- Issue did not change status one time, one time the status changed
- if the status is changed, the email was sent

Expected Results:  
- change the status without error
- if the change is not possible, to tell why (e.g. I did one step befor an other)

OS: SLES 10.x

Comment 1

[Max Kanat-Alexander]

Run checksetup.pl again and tell me if that fixes it.

Comment 2

[David Seymore]

(In reply to comment #1)
> Run checksetup.pl again and tell me if that fixes it.
> 

this fixed the issue for me. Thank you.