Mantis Bug Tracker - Forums

I have just tried upgrading Mantis from 1.0.2 to 1.1.6. I went through the "Mantis Administration" -> "Upgrade your installation" process, which reported that it had completed successfully. However, when I followed the link to log in to Mantis, I had the following error:

APPLICATION ERROR #401

Database query failed. Error received from database was #1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' for the query: SELECT id
FROM mantis_user_table
WHERE username='administrator'.

MySQL is version 4.1.7.

Is there something else I need to do before or after the upgrade to avoid this problem? Thanks in advance for any help.

I have the same problem.
Would be curious to know what you find out.

I am just installing 1.1.7 for the first time and ran into the same error. Here is how I fixed it:

I exported my entire mantis db (drop table and insert table commands), replaced 'latin1' with 'utf8', and then ran the exported sql statements. No more error msg.

this one seems to be a bug of Mantis. I am having the same trouble when I try Traditional Chinese input to a field.
searched the forum and found 5 posts with this same problem and only this one has an answer, but I don't want to mess up with my database (I am not a professional on database). anyone can help at all?