Collation Error after Upgrade #690
Description
After i install the new Version 3.3.12 and made a SQL Upgrade from 1844 over 1845 to 1846 i got an mix of collations SQL error.
Maybe the same error in #688 but i got only in the virtual List.
I got this errors in the logs:
[Mon Dec 5 18:32:29 2022] 172.172.172.172:54568 Accepted
[Mon Dec 5 18:32:29 2022] Invalid query: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' caused by SELECT `mailbox`.* , `alias`.goto , `mailbox`.password_expiry as password_expiration , `vacation`.active AS v_active , `quota2`.bytes as current
FROM `mailbox`
LEFT JOIN `alias` ON `mailbox`.username=`alias`.address LEFT JOIN `vacation` ON `mailbox`.username=`vacation`.email LEFT JOIN `quota2` ON `mailbox`.username=`quota2`.username
WHERE `mailbox`.domain= :domain
ORDER BY `mailbox`.username
LIMIT 10 OFFSET 0
[Mon Dec 5 18:32:29 2022] PHP Fatal error: Uncaught Exception: DEBUG INFORMATION: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='<br/> Check your error_log for the failed query in /postfixadmin/functions.inc.php:1872
Stack trace:
#0 /postfixadmin/functions.inc.php(1811): db_query()
#1 /postfixadmin/public/list-virtual.php(236): db_query_all()
#2 {main}
thrown in /postfixadmin/functions.inc.php on line 1872
[Mon Dec 5 18:32:29 2022] 172.172.172.172:54568 [500]: GET /list-virtual.php - Uncaught Exception: DEBUG INFORMATION: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='<br/> Check your error_log for the failed query in /postfixadmin/functions.inc.php:1872
Stack trace:
#0 /postfixadmin/functions.inc.php(1811): db_query()
#1 /postfixadmin/public/list-virtual.php(236): db_query_all()
#2 {main}
thrown in /postfixadmin/functions.inc.php on line 1872
[Mon Dec 5 18:32:29 2022] 172.172.172.172:54568 Closing