Locked out of own site

[darkodin]

Your phpBB Version: 2.0.
phpBB Type: Standard phpBB
MODs: No
Your knowledge: Beginner
Board URL: [url]http://[/url]

PHP Version:
MySQL Version:


What was done before the problem appeared?
Logged into admin account with wrong password


What was done to try to solve the problem?




De.scription and Message

I had my new installation shut (Upgrading site) message.

I tried to login, used wrong password several times and cracker tracker went into visual confirm mode, but showed NO graphic...

Can't use forgot password because my site is locked down from earlier. I am not a wizz at php or sql and really need to access my admin but am totally stuck on how to do it. Can anyone please help me?

[Helter]

using phpmyadmin, open your database. go to phpbb_users. Find your username. choose edit and find the fields
user_active this should be "1"
ct_logintry this should be "0"
ct_unsucclogin this should be "0"
phpBBSecurity_login_tries this should be "0"
phpBBSecurity_pm_sent this should be "0"

do not try to change your password from here as they are encrypted
you should now be unlocked

[darkodin]

Thanks for that, but it didn't work. All the settings seem to be already what you said to change them too. Is a fresh install, anyway to quick way to reset the lot without a reinstall?

[Helter]

try deleting your browser cache and cookies for your site