battles Posted October 3, 2017 Share Posted October 3, 2017 I just upgraded to 7.3 and the admin area is now blank. Using template 6, in outside folder. Do I need to move something? 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Developer WHMCS Andrew Posted October 3, 2017 WHMCS Developer Share Posted October 3, 2017 Hey Battles, I would generally advise you open a ticket, especially in cases where you are having issues accessing your install. But, you can try the following to see if you can grab the error occurring: http://help.whmcs.com/m/64804/l/679701-how-to-resolve-an-http-500-error-after-update 0 Quote Link to comment Share on other sites More sharing options...
battles Posted October 3, 2017 Author Share Posted October 3, 2017 Thanks Andrew, I've opened a ticket. 0 Quote Link to comment Share on other sites More sharing options...
battles Posted October 3, 2017 Author Share Posted October 3, 2017 we've kept up with all upgrades and this is first blank dashboard issues we've encountered. 0 Quote Link to comment Share on other sites More sharing options...
WebsiteIntegrations Posted October 3, 2017 Share Posted October 3, 2017 Is the whole thing blank or does the dashboard just not show anything but the header/footer works? That is what is happening on one of mine. 0 Quote Link to comment Share on other sites More sharing options...
battles Posted October 3, 2017 Author Share Posted October 3, 2017 See attached: I just see "Dashboard" - all other content on my home page is gone (i see the sidebar) everything else seems to be working fine. I was wondering if it wasnt a permissions issue now that they've added the ability to hide widgets, but I dont see that being the case. I also dont see the new gear to show or hide widgets. 0 Quote Link to comment Share on other sites More sharing options...
WebsiteIntegrations Posted October 3, 2017 Share Posted October 3, 2017 Hi Yeah that is what i get too. Works on my dev site. Only difference is that dev site uses admin name for the folder and my main whmcs uses a custom admin name like you do. Do this, go to Utilities -> Logs -> Activity Logs are you getting an error like this Smarty Error: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_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) 0 Quote Link to comment Share on other sites More sharing options...
battles Posted October 3, 2017 Author Share Posted October 3, 2017 Yup that's exactly the error I am getting 0 Quote Link to comment Share on other sites More sharing options...
bear Posted October 3, 2017 Share Posted October 3, 2017 I'm able to access it and see everything in the dev install here. None of the "hidden" widgets stay hidden, but it all shows up. 0 Quote Link to comment Share on other sites More sharing options...
WebsiteIntegrations Posted October 3, 2017 Share Posted October 3, 2017 (edited) So I am looking at tblorders in the database. For the site that is having the issue the Collation shows as latin1_general_ci for the whmcs with no issue it is utf8_general_ci Edited October 3, 2017 by wwesn 0 Quote Link to comment Share on other sites More sharing options...
WebsiteIntegrations Posted October 3, 2017 Share Posted October 3, 2017 And yes i do have a ticket open for this but no reply yet. 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Nate Posted October 3, 2017 Share Posted October 3, 2017 @wsen the error: Smarty Error: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_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) Indicates a collation mismatch between your tables that prevents mysql from executing the JOIN query logged. Which collation do you intend to use for your database going forward? Once you know which you want to use, this help article shows how to adjust your database to normalize the collations across your database: http://help.whmcs.com/m/72132/l/797626 1 Quote Link to comment Share on other sites More sharing options...
WebsiteIntegrations Posted October 3, 2017 Share Posted October 3, 2017 Hi Thanks, I had done some googling and figured out how to fix it just a minute ago 0 Quote Link to comment Share on other sites More sharing options...
battles Posted October 3, 2017 Author Share Posted October 3, 2017 WHMCS gave me this query to run ALTER TABLE tblorders CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; and no dice. Still blank 0 Quote Link to comment Share on other sites More sharing options...
WebsiteIntegrations Posted October 3, 2017 Share Posted October 3, 2017 Mine was ALTER TABLE tblorders CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci; for some reason. 0 Quote Link to comment Share on other sites More sharing options...
battles Posted October 3, 2017 Author Share Posted October 3, 2017 Actually my error in logs was not the latin one: latin1_general_ci,IMPLICIT It was: 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 tblordersinner join tblorderstatuses on tblorders.status = tblorderstatuses.title where tblorderstatuses.showpending = 1) So the above query is supposedly the solution. 0 Quote Link to comment Share on other sites More sharing options...
WebsiteIntegrations Posted October 3, 2017 Share Posted October 3, 2017 Just make sure its the same for tblorders and tblordersstatuses 0 Quote Link to comment Share on other sites More sharing options...
johnnybgoodwin Posted October 4, 2017 Share Posted October 4, 2017 I have this exact same problem. When running the auto update it hung with this message: "Update Failed An error occurred that prevented the update from completing successfully. Database update completed successfully but was unable to remove the install directory post completion Please try again and if the issue persists, please contact support." The error in the activity log is the same as above: "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)" I don't know what, 21 hours ago, WHMCS Nate said: Which collation do you intend to use for your database going forward? means..... I will also Google for a fix. Sigh. More time wasted on computers. Don't ya just hate them?! Appreciate any help John 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Nate Posted October 4, 2017 Share Posted October 4, 2017 20 minutes ago, johnnybgoodwin said: means..... I will also Google for a fix. Sigh. More time wasted on computers. Don't ya just hate them?! Let me save you a bit of googling, this is the best answer I've found: https://stackoverflow.com/questions/766809/whats-the-difference-between-utf8-general-ci-and-utf8-unicode-ci when in doubt utf8_unicode_ci is the best thing to move to unless you're using mysql >5.5.3 in which case utf8mb4_unicode_ci is better. For some people that need to use different options (they typically know who they are) they will need to decide what to move too. Once you know that our article will help you make the change: http://help.whmcs.com/m/72132/l/797626 1 Quote Link to comment Share on other sites More sharing options...
lance Posted October 4, 2017 Share Posted October 4, 2017 Had the same issue, the link from WHMCS NAte resolved it first time - http://help.whmcs.com/m/72132/l/797626 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.