Not signed in (Sign In)

Categories

Vanilla 1.1.5 is a product of Lussumo. More Information: Documentation, Community Support.

Help keep Vanilla free:
Welcome Guest!
Want to take part in these discussions? If you have an account, sign in now.
If you don't have an account, apply for one now.

General Support & Troubleshooting: illegal mix of collations when signing in after a nasty hack

Bottom of Page

1 to 2 of 2

  1.  
    •  
      CommentAuthorklip
    • CommentTimeDec 3rd 2007 edited
     # 1
    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
    •  
      CommentAuthorklip
    • CommentTimeDec 3rd 2007
     # 2
    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?

1 to 2 of 2

  1.  
Add your comments
    Username Password
  • Format comments as
 
Back to Discussions Top of Page