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?
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.
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.)
Log in to post a comment.