Problems with DB encoding?

Chris Haus
2013-11-27
2013-12-08
  • Chris Haus
    Chris Haus
    2013-11-27

    Hello,

    I can't login into my pfAdmin anymore:

    DEBUG INFORMATION:
    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?

    Thanks,
    Chris

     
  • Chris Haus
    Chris Haus
    2013-12-08

    I found this one:
    http://sourceforge.net/p/postfixadmin/bugs/79/
    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.

     
  • 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 functions.inc.php 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.)