Jump to content

whmcs admin login failed after upgrade


akboselk

Recommended Posts

I've upgraded from ver 5.17

 

Tried Pass reset, and it sent the Link to my email.

But when Click on the Link (within 10 Minutes I clicked it) it says Invalid link or Link has expired

 

Updated : followed the http://docs.whmcs.com/FAQs#Reset_Administrator_Password and still says Incorrect Password

 

After that I revert to Ver 5.1.7 installation and restored the DB, It works fine

Edited by akboselk
Link to comment
Share on other sites

Hi,

 

The same thing happened, exactly the same, upgraded from v5.1.7 to 5.2.5. Installation was successful. Then login to admin area was impossible; getting password reset in myphpadmin also did not work, neither the forget password.

 

Had to revert to 5.1.7 and it is working fine.

 

Now, how can I upgrade to 5.2.5? What went wrong?

 

Cleaned the cache of the browser and also the /templates_c, same problem.

 

Any advise?

Link to comment
Share on other sites

Hi all

 

Got answer from support.

 

The upgrade from v5.1.6 or v5.1.7 to v5.2.5 fails due to an upgrade failure. Some database update sentences are not executed proberly.

 

Solution:

 

To resolve this, use a tool like phpMyAdmin to connect to your WHMCS database and run the following SQL query immediately prior to the upgrade:

 

UPDATE tblconfiguration SET value='5.1.5' WHERE setting='Version';

 

You can then run the upgrade process and the upgrade to v5.2.5 should work correctly.

 

Regards,

Marco

Link to comment
Share on other sites

hmmmm...

 

Did you the recommended step which was provided by WHMCS?

 

To resolve this, use a tool like phpMyAdmin to connect to your WHMCS database and run the following SQL query immediately prior to the upgrade:

 

UPDATE tblconfiguration SET value='5.1.5' WHERE setting='Version';

 

If yes, please let me know to avoid wasting time with the planned upgrade from 5.1.7 to 5.2.5.

 

Thanks,

Marco

Link to comment
Share on other sites

Personally I hadn't done that as it's not part of the official documentation and to be fair, how much searching around should you need do to see if a release doesn't work? I'd purposely left it long enough to get most of the 5.2.x issues out of the way anyway. I'm also quite surprised that they've still not addressed this in the 5.2.5 download so it doesn't cause the same issue for anyone else, despite knowing the problem. To save reverting everything, I ended up running all of the differential SQL queries up to 5.2.5 from the install folder to manually upgrade the database, which Support have now confirmed would be the correct course of action. I'd like to see this addressed properly though and if anyone else has the same problem in the meantime, the fix is as above.

Link to comment
Share on other sites

Hi,

 

We have the same problem, we hace opened the ticket FTF-237711 and no answer at the moment, we are wating 3 hours ago. :(

 

Can anyone confirm if we execute the mysql updates of the directory install from our old version to the newest version the problem ire solved?

 

Regards

Lucas

Link to comment
Share on other sites

As per penguin's statement from above:

 

To save reverting everything, I ended up running all of the differential SQL queries up to 5.2.5 from the install folder to manually upgrade the database, which Support have now confirmed would be the correct course of action.

 

You can always revert should it not work as expected (if you have a backup...)

 

Regards

Marco

Link to comment
Share on other sites

Hi,

 

I solved executing all the sql files from directory install from our latest version to 5.2.5 and now works.

 

The only problem is we need to see every sentence to check if it has been executed previously with the upgrade process of the install.php or not.

 

We see we don't have the new tables and some modifications.

 

Is a problem of the actual version 5.2.5, we have the same problem in other installation 15 days ago and whmcs.com support department was correct but I don't know how, now I think they was executed the upgrades of install/*.sql from the latest version we have to the new like we make now.

 

Regards

Lucas

Link to comment
Share on other sites

I did the same to double check - it's pretty quick though to go through phpMyAdmin and check if the changes have been applied already or not. Most of the differential SQL patches are only for the version number anyway following security fixes, etc and so these don't need to be applied if that is the only query present.

 

As for backups, we certainly had these, however after all of the work that was done to upgrade templates, etc it would have been a shame to revert it all back again when it was a simple issue to address. I just wish that WHMCS would address this for others in the upgrade script. I'm glad though that I did address it myself as it was a day and a half for a response back to confirm that my changes were correct.

Link to comment
Share on other sites

  • 2 weeks later...

how actually to fix this problem..

 

i did upgrade with the latest package but still got error..

then i did

 

To resolve this, use a tool like phpMyAdmin to connect to your WHMCS database and run the following SQL query immediately prior to the upgrade:

 

UPDATE tblconfiguration SET value='5.1.5' WHERE setting='Version';

 

it disn't work for me..i still got same error

Link to comment
Share on other sites

  • 1 month later...

Thanks for the info. I ran into the same problem just now upgrading from 5.0.6. I just manually ran all the SQL updates myself and now its working. Its the constant sloppy work like this that I can't stand about WHMCS. This update issue should have been fixed months ago.

 

Hal

Link to comment
Share on other sites

  • 1 month later...
  • 2 weeks later...

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.

  • 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