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

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

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Similar Content

    • By WevrLabs
      Hi everyone!
      Since I spend most of my time during the day on the WHMCS admin dashboard, answering tickets, activating services, following up with stuff, etc. I wanted to keep eye strain to a minimum, so I recently created this CSS file to turn our admin area into a dark look and feel.

      -------

       
      Today, I'd like to share with you steps to achieve that.
      The file is compatible with Blend theme of v7.9.2 of WHMCS, I haven't tested it on the other versions yet.
      The process is pretty simple and straightforward  IF YOU HAVEN'T MADE ANY CUSTOMIZATIONS to your Blend theme already.
      So just download the attached file (blend-dark.zip) and extract it anywhere in your computer.
       

       
      Next, open the folder and then the "images" folder to locate the (logo-dark.psd) file to edit it by placing your own logo there. Then save it as "logo-dark.gif" replacing the already existing file.
       

       
      Now you should end up with a file tree like this ...
      blend |__ css | |__ admin-dark.css | | |__ images | |__ logo-dark.gif | |__ logo-dark.psd | |__ header.tpl  
      Now back top and compress your "blend" folder ... Name it something memorable, like "blend-2222.zip" in this example.
       

       
      Next navigate to the "admin" folder inside your WHMCS installation, and open the "templates" folder (based on your customizations, the "admin" folder name may differ, so this here presumes the default setting).
      /path/to/whmcs/admin/templates/  
      Next make sure to ZIP and backup your current Blend theme folder (name it something like "blend-original.zip).
       

       
      Next, upload the "blend-2222.zip" you compressed earlier to the "templates" folder and unzip it, and you should be all set and ready!
       

       
      If you have any notes or additions, please feel free to add!
      Also, any mistakes or errors are unintentional, please feel free to share and highlight them.
      Wishing everyone a good day!
      - Mohamed
       
    • By J-B
      I updated to the latest version today and I find a new bug.
      In the Language Files are links for example:
      The link really shows up to https://mydomain/submitticket.php and not corretly to https://mydomain/whmcs/submitticket.php. I have try with 
      <a href=\"{$WEB_ROOT}/submitticket.php\"> but no luck. If I try:
      <a href=\"whmcs/submitticket.php\"> it makes https://mydomain/whmcs/whmcs/submitticket.php 
       
      I hope you understand the problem 🙂
    • By omega1
      Hello,
      I am trying to upgrade from 7.7.1 to 7.8.3 and I keep on getting this error.
      I have checked the file permissions and even provisionally tried setting them to 777 but I still get this error. 
      Not quite sure what to try now...
      If anyone could advise what I should try next?
      Thank you in advance.
       
      Update Failed An error occurred that prevented the update from completing successfully.
      Insufficient File Permissions (Help Documentation)
      Error: Could not delete /var/www/html/billing/vendor/whmcs/whmcs:
    • By Mark_J
      So we recently tried to activate Stripe running 7.8.2 and got the error below. We then updated WHMCS to 7.8.3 from 7.8.2 and are still seeing this error;
       
      We are not using custom templates for the clients (we're using the default Supreme Comparison template) but we're using Lara for the Admin panel, I don't think we should be seeing this error as all the template files were updated on 9/3 when we upgraded to 7.8.1. 
      I saw that there were quite a few people experiencing this error in the past but almost all of them were related to template changes they made which is not the case for our install. Anyone have a suggestion on where to start troubleshooting this issue?
    • 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.
       
  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...

Important Information

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