Blog Documentation Book a Demo
Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

illegal mix of collations when signing in after a nasty hack

klipklip New
edited December 2007 in Vanilla 1.0 Help
hm, not sure if this is gonna be interesting for anybody. I just did some nasty thing for one forum: replaced English and None language definitions by Czech language definitions, so there won't be possible to fallback to any other language than Czech. After that I couldn't login:
Error Message An error occurred while attempting to validate your credentials Affected Elements Authenticator.Authenticate(); The error occurred on or near: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
Not sure if it was caused by that defs replacment but I fixed that by running sql command 'SET CHARACTER SET utf8' right after 'SET NAMES utf8' in Framework.Class.MySQL.php

Comments

  • klipklip New
    Ah, I've just found out there is latin1 CHARACTER SET for database and its tables, so this might be the cause #1.

    Shouldn't installer set "CHARACTER SET utf8 COLLATE utf8_bin" when creating databases?
This discussion has been closed.