[SOLVED] locked out of my own forum!!

[Adam D]

So I can't log into my own forums. I have no clue why.... maybe a typo when setting my password. After a few times it said "You exceeded the maximum allowed number of login attempts. In addition to your username and password you now also have to solve the CAPTCHA below." I waited a day and it still said that. If I choose "I forgot my password" is says "The e-mail/username information submitted could not be found."

I went into my database and deleted my past log in attempt records there (phpbb_login_attempts) and changed my password there (phpbb_users.)

I'm the site admin and I still cant get in! Please help!

[Oyabun1]

The database doesn't store the password only a hash of the password so if you changed to password there you probably entered an incorrect value.

In the phpbb_users table check that username you were using was correct and that the user_email value is current, then use the “I forgot my password” link on the login page.

If that doesn't work then please fill out the Support Request Template Generator and post it back here to enable us to assist you better.

[Adam D]

In the phpbb_users table check that username you were using was correct and that the user_email value is current, then use the “I forgot my password” link on the login page.

Yeah, it doesnt work. For some reason it says "The e-mail/username information submitted could not be found."

Here:
Support Request Template
What version of phpBB are you using? phpBB 3.0.10
What is your board's URL? http://**************.com/forums/
Who do you host your board with? Unknown
How did you install your board? I used a tool provided by my host
What is the most recent action performed on your board? Fresh Install
Is registration required to reproduce this issue? Yes
Do you have any MODs installed? No
What styles do you currently have installed? N/A
What language(s) is your board currently using? English
Which database type/version are you using? I Don't Know
What is your level of experience? New to PHP and phpBB
What username can be used to view this issue? My admin account.
What password can be used to view this issue? No answer given
When did your problem begin? Within the last few weeks.
Please describe your problem. I cannot log into the forums with my admin account. It doesnt let me reset password.
Generated by SRT Generator

[Oyabun1]

Run this SQL query and tell us the result

Code: Select all

SELECT user_id, username, username_clean FROM phpbb_users WHERE user_type = 3

Change phpbb_ if that is not your table prefix.

[Adam D]

Run this SQL query and tell us the result

Code: Select all

SELECT user_id, username, username_clean FROM phpbb_users WHERE user_type = 3

Change phpbb_ if that is not your table prefix.

Took me a little bit to figure out exactly how to run that query.

Here is what I get:

Selection_001.png (36.19 KiB) Viewed 3479 times

[Oyabun1]

Took me a little bit to figure out exactly how to run that query

Since you were already messing around in the database I assumed you knew how to at least run a query. You shouldn't make any changes directly to the database unless you know precisely what you are doing and the ramifications, because you can do serious damage to the board.

Provided you are using the username Adam and the email address is correct then the I forgot my password function should work.

If not, you can use this query, which will create an admin user named Admin1 with a password of admin. From that point you should be able to get into the ACP. Change your table prefix if it is not phpbb_.

Code: Select all

INSERT INTO phpbb_users (user_type, group_id, username, username_clean, user_regdate, user_password, user_email, user_lang, user_style, user_rank, user_colour, user_posts, user_permissions, user_ip, user_birthday, user_lastpage, user_last_confirm_key, user_post_sortby_type, user_post_sortby_dir, user_topic_sortby_type, user_topic_sortby_dir, user_avatar, user_sig, user_sig_bbcode_uid, user_from, user_icq, user_aim, user_yim, user_msnm, user_jabber, user_website, user_occ, user_interests, user_actkey, user_newpasswd) VALUES (3, 5, 'Admin1', 'admin1', 0, '21232f297a57a5a743894a0e4a801fc3', '[email protected]', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '', '', '', '', '', '', '', '', '');

As soon as you have done this, use the temporary admin account to update the details on the original admin account, then delete the temporary account.
This is because:

1. anyone could use that account to log in to your board if you didn’t change the password.
2. this temporary user has not been fully set up (e.g. it is not a member of the “Registered users” group, so it won’t have normal access to your forums).

[Adam D]

Okay, that worked and I have everything fixed! Thanks a lot for the help!

[Edmondo]

Thank you, it helped me too

[cedricthecat]

Found this thread as I have the same issue!

Just been forced to move server as the current hosts have closed down for no stated reason

I've got a copy of everything on the new server, files via Filezilla and DB via phpMyadmin, have changed the nameservers, but now I can't log on. I've tried the "forgotten password" link and got

The e-mail/username information submitted could not be found.

And I've also tried the solution above, creating a new user, but still no joy

I'm getting an error at the top of my header page, which could be linked?

[phpBB Debug] PHP Warning: in file [ROOT]/includes/utf/utf_tools.php on line 1828: strtr(): The second argument is not an array

Any suggestions gratefully received!

[stevemaury]

Please start your own topic.

[cedricthecat]

Sorry, I thought that as it was the same issue it would be OK to follow on from the same topic

I'll do a new topic.......