get error admin/systemcleanup.php

[lims]

i get error access admin/systemcleanup.php with old database

PDOException: SQLSTATE[HY000]: General error: 1271 Illegal mix of collations for operation 'UNION' in /vendor/illuminate/database/Connection.php:333
Stack trace:
#0 /vendor/illuminate/database/Connection.php(333): PDO->prepare('(select `attach...')

when try fresh install with new database its work

can someone help fixed ?

[WHMCS John]

Hi @lims,

This suggests there are tables in your MySQL database with different collations. The full stack trace should contain more information.

Hazarding a guess I'd say tblticketmaillog, tbltickets and tblticketreplies.

This guide addresses the problem with some examples: https://help.whmcs.com/m/85428/l/797626-troubleshooting-a-blank-admin-dashboard-after-update

 

[lims]

5 hours ago, WHMCS John said:

Hi @lims,

This suggests there are tables in your MySQL database with different collations. The full stack trace should contain more information.

Hazarding a guess I'd say tblticketmaillog, tbltickets and tblticketreplies.

This guide addresses the problem with some examples: https://help.whmcs.com/m/85428/l/797626-troubleshooting-a-blank-admin-dashboard-after-update

 

thank you john, my issues was fixed with this solution

all tables now set to utf8_unicode_ci;

ALTER TABLE tblorders CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

 

[WHMCS ChrisD]

Glad to hear its sorted @lims