7webcreator Posted October 7, 2017 Share Posted October 7, 2017 Hello, I have the problem with the Blend template too. The admin dashboard is totally blank after that I updated WHMCs to 7.3. Link to comment Share on other sites More sharing options...
7webcreator Posted October 7, 2017 Author Share Posted October 7, 2017 I got this error in the SQL log Smarty Error: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' (SQL: select count(`tblorders`.`id`) as aggregate from `tblorders` inner join `tblorderstatuses` on `tblorders`.`status` = `tblorderstatuses`.`title` where `tblorderstatuses`.`showpending` = 1) Link to comment Share on other sites More sharing options...
WHMCS Support Manager WHMCS John Posted October 8, 2017 WHMCS Support Manager Share Posted October 8, 2017 Hi @7webcreator, I've split your post into a new topic as you are reporting a different issue to the OP. To resolve this error, please perform this command on your WHMCS database using a tool such as phpmyadmin or directly on the MySQL command line: ALTER TABLE tblorders CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; More information: http://help.whmcs.com/m/72132/l/797626-troubleshooting-a-blank-admin-dashboard-after-update Link to comment Share on other sites More sharing options...
7webcreator Posted October 17, 2017 Author Share Posted October 17, 2017 Thank you very much, John. It is working again. Link to comment Share on other sites More sharing options...
Recommended Posts