Problems with DB encoding?

Chris Haus
  • Chris Haus

    Chris Haus - 2013-11-27


    I can't login into my pfAdmin anymore:

    Invalid query: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

    Please check the documentation and website for more information.

    How does your collation look like?
    Can I simply change it?


  • Chris Haus

    Chris Haus - 2013-12-08

    I found this one:
    but if I try to use the setup.php with the existing DB, I get the same error.
    Plus: I changed the vacation table which has been general and not swedish.
    But still .. same problem.

    I guess I'll try to re-setup pfa and import the data only.

  • Christian Boltz

    Christian Boltz - 2013-12-08

    Hmm, this should be fixed since a very long time.

    Which version of PostfixAdmin do you use?

    It might also be interesting to modify db_query() in so that it prints out the failed query in the error message. This might give a hint about the field causing the problem. (Please paste the "show create table" for the affected tables and the failing query.)


Log in to post a comment.