Mix of collations utf8_unicode_ci
Oops!
Something went wrong and we couldn’t process your request.
Please go back to the previous page and try again.
If the problem persists, please contact us.
Back to Homepage
For additional assistance, please reference the WHMCS TroubleShooting Guide »
PDOException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_unicode_ci,COERCIBLE) for operation ‘like’ in /home/xxx/public_html/whmcs/vendor/illuminate/database/Connection.php:331
Stack trace:
#0 /home/xxx/public_html/whmcs/vendor/illuminate/database/Connection.php(331): PDO->prepare(‘select * from `…’)
#1 /home/xxx/public_html/whmcs/vendor/illuminate/database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}(‘select * from `…’, Array)
Today encountered this error after upgrading MySQL and WHMCS as well. As this is the error related to collations, you will get suggestions to update tables and all ! Developer’s job !
However, a simple temporary fix to this is update your configuration file by commenting $mysql_charset = ‘utf8’; line.
You are done !
Tag: Database
Do you allow MySQL Triggers on Shared Hosting Account
We are runnig MySQL 5.0.x on our shared and reseller hosting servers. In order to use TRIGGERS with MySQL 5.0.x, you must have the SUPER privileges. For security reasons, we do not grant this to regular users.
We do plan to eventually upgrade to MySQL 5.1 and it will be a simple matter of enabling the TRIGGER privilege per-user. As if now, for security reasons, we will not be enabling any sort of workarounds to enable TRIGGER privileges. TRIGGER will not be available on shared reseller servers until MySQL 5.1 is installed.
We will suggest you to have a look at our economy VPS packages, where you will be able to escalate the privilages with the latest version of mysql installed.