Page 1 of 1

Error updating realname in Mantis

PostPosted: Friday, 31st December 2010, 11:29
by dpc
  Code:
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='Dawid Ciężarkiewicz'.


This error happened after I've tried to update my surname.

Re: Mantis username update error.

PostPosted: Friday, 31st December 2010, 12:02
by jpeg
Added to the bug tracker.

Re: Error updating realname in Mantis

PostPosted: Saturday, 1st January 2011, 22:46
by Napkin
I enabled utf8_general_ci as valid charset for username & realname.

I set your real name for testing purposes, Dawid - you may want to change that back.

Cheers!

Re: Error updating realname in Mantis

PostPosted: Saturday, 1st January 2011, 23:07
by Napkin
For the record:

This "Real Name" is used nowhere throughout the system (mantis/dokuwiki/phpbb3). It's an completely optional & cosmetic setting, which can only be seen by the administrators.

Same goes for the email addresses given.

Administrators are: evktalo, jpeg, dpeg & me.