Jump to content

Recommended Posts

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?

Share this post


Link to post
Share on other sites

we've kept up with all upgrades and this is first blank dashboard issues we've encountered.

Share this post


Link to post
Share on other sites

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.

WHMCS_7.3.PNG

Share this post


Link to post
Share on other sites

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)

Share this post


Link to post
Share on other sites

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. 

Share this post


Link to post
Share on other sites

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 by wwesn

Share this post


Link to post
Share on other sites

@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

  • Thanks 1

Share this post


Link to post
Share on other sites

WHMCS gave me this query to run
 

ALTER TABLE tblorders CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

and no dice. Still blank

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

 

Share this post


Link to post
Share on other sites
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

  • Thanks 1

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • By vinc1402
      Hello WHMCS, 
       
      I've done the update to V7.7, now there is the End User License Agreement screen.
      I can accept this 10 times and the page keeps coming back leaving me unable to get into the admin area.
       
      Any help would be appreciated.
       
    • By web2008
      Seeing that the order of the products will be a bit random, on the Upgrade Package/Products page ( upgrade.php ). 
      Anyone who knows how to change the order of the products?
    • By Brandwise
      I am new to WHMCS and so I am not sure I have the same problem via installation, but I am having the Blank Screen when I try to place/complete an order to for domain names. I am using OpenSRS' Domain Pro module to connect to OpenSRS. When I try to add OpenSRSPro or complete and order it just hangs and I am told this blank screen is a PHP issue. I am wondering if deleting the above php files will help me or if the above advice is only good for the upgrade mentioned above.

      I tried to turn on error reporting and reproduce the error so I can get a better idea what the error is, but it still is going to blank screen. I am not getting any error reporting in the module either. I am not sure what else to check. Any tips would be appreciated.
    • By xyzulu
      Just a small issue I noted with the upgrade.. /downloads.php wasn't updated during the auto upgrade.. the file that remained wasn't encoded with the newer ioncube loaders so I had to replace it with the downloads.php file from the full install before I could use php 7.1/7/2
       
      Apart from that, so far so good.
      Good work WHMCS and all the testers!
    • By linux4me
      I just did the upgrade from 7.4.2 to 7.5 on a system running PHP 7.0 and Ioncube Loader 10.1.0-22.17. I did have to upgrade Ioncube Loader prior to running the automatic upgrade, because I was using an older version. The upgrade said it completed successfully, and there were no error messages; however, now when I try to log on to WHMCS, I get a white screen with only this:
      Starting
      Loaded English Language File
      Loaded Other Language Files
      and then nothing. There are no error messages in the error logs, and no errors in the file where WHMCS is installed. Naturally, since I get nothing when I log in, I can't go into Setup -> General -> Other, and tick the box to display errors. I've tried clearing my cache, closed my browser completely and restarted, but all I can do is log in and then get the same screen.
      I used phpMyAdmin to go into tblconfiguration and set DisplayErrors to 1, but I don't get any error output on the page.
      I've gone through the list of articles on the troubleshooting page, and none seem to apply.
  • Recently Browsing   0 members

    No registered users viewing this page.

×

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated