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
klip
New
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:
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
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
0
This discussion has been closed.
Comments
Shouldn't installer set "CHARACTER SET utf8 COLLATE utf8_bin" when creating databases?