Iglesia Arboles de Justicia ChurchCRM admin locked out account.

[ChurchCRMBugReport]

My admin account is locked after one of my delegates unsuccessfully tried to log in several times. I know the user name and password, but she did not know I changed it earlier. Good thing I created a login for someone to enter information, which is working for her.
I want to customize the site and have no access as Admin to that. It's been several days already with this issue, I thought it was going to go away in 48-72 hrs.
How can I unlock the admin account?

Collected Value Title	Data
Page Name	/Menu.php
Screen Size	900x1440
Window Size	766x1440
Page Size	1750x1440
Platform Information	Linux web18.us.cloudlogin.co 4.4.214-xeon-hst #4 SMP Tue Feb 18 15:55:38 UTC 2020 x86_64
PHP Version	7.3.17
SQL Version	5.7.23
ChurchCRM Version	4.0.2
Reporting Browser	Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.122 Safari/537.36
Prerequisite Status	Missing Prerequisites: ["Mod Rewrite"]
Integrity check status	{"status":"failure","message":"One or more files failed signature validation","files":[{"filename":".htaccess","status":"Hash Mismatch","expectedhash":"33745659badf55b25f7a178d0ad64a8ca36594de","actualhash":"da39a3ee5e6b4b0d3255bfef95601890afd80709"}]}

[MrClever]

Please review and follow the instruction from our Wiki on how to recover a locked out admin account:
https://github.com/ChurchCRM/CRM/wiki/Reset-Password

[MrClever]

Per instructions in Dev chat, please run the following SQL against your ChurchCRM database:

UPDATE `user_usr` 
    SET `usr_FailedLogins` = 0
    WHERE usr_per_ID = 1
    AND usr_UserName = 'Admin';

Please let us know if this corrects the problem for you so we can close this one out.

[MrClever]

I believe this has been rectified with the reset of usr_FailedLogins.

[faithwc]

Hi, I have a similar problem. For some reason, we can no longer log into our Admin account. I do have access to PHPMyAdmin and MySQL, but I don't know enough about these things to do the update described here. Would you be able to take me step by step through the process to reset the Admin password?

Thanks!

[MrClever]

@faithwc - please open a new ticket with your problem description etc. Feel. free to refer to the ticket if you think it is related. This is a closed ticket.

[faithwc]

MrClever, thanks for replying. I actually figured it out. I continued to research the issue and found that people who had older versions of ChurchCRM were having trouble logging in after one of the PHP updates. I had to edit the bootstrap.php file and that fixed the issue. Thanks, though. If I run into another issue, I'll be sure to open a new ticket instead of hopping on an old one.