WHMCS is Stuck in Maintenance Mode

[epretorious]

This morning, after an upgrade (5.2.13 -> 5.2.15), we weren't able to access the WHMCS Administrative interface to disable maintenance mode.

 

A quick check of Google revealed that a few other users on this forum ran into this problem a few years ago (here and here) but the solution was so vague as to not be useful...

 

It means the version of the files you have uploaded don't match the version of the database. They need to be the same otherwise you will see this error.

 

Your version number in the database and file set that you are using do not match make ether the version number in the D/B table comfig matches or you have only run the upgraded SQL and not run the install upgraded.

... so I thought that I'd document the fix here.

 

What WHMCS John & thehost5968 mean to say is: [use a tool like phpMyAdmin or the mysql command-line tool to] Update the tblconfiguration table of the whmcs database to reflect the new version.

 

UPDATE `whmcs_abc123`.`tblconfiguration` SET `value` = '5.2.15' WHERE `tblconfiguration`.`setting` = 'Version' ;

 

HTH,

[bear]

If it hasn't updated the database, then changing the values manually might not reveal there are missing values from some portion of the update that didn't fire/run. If it happened to me, I'd be looking into why it didn't update instead of just editing that value.

[epretorious]

If it happened to me, I'd be looking into why it didn't update instead of just editing that value.

 

Thanks for sharing your opinion, Bear. I'm satisfied that WHMCS 5.2.15 is working and I've moved on.

[strannik]

Thanks for sharing your opinion, Bear. I'm satisfied that WHMCS 5.2.15 is working and I've moved on.

 

I upgraded from 5.2.5 to 5.2.16 and I am having the same problem. The first time I rolled back to the previous version of the database and tried again. In both instances the script ran with no errors, telling me to delete the install directory and giving me a link to access the admin section, but when I click on it, I just get maintenance mode. I followed all instructions for a full upgrade twice. I think there must be a bug in the script. If the above fix works, I don't see any alternative.

 

[--- updated ---]

 

I am having the same problem, upgrading from 5.2.5 to 5.2.16. I have rolled back and reinstalled twice. In each case, the upgrade script ran with no errors, and gave me a link to access the admin area. In each case, I was stuck in maintenance mode. It sounds like a bug to me. The fix suggested by epretorius did not work for me, so I restored the value to 5.2.5.