[SOLVED] locked out of my own forum!!

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning

[SOLVED] locked out of my own forum!!

Postby Adam D » Sat Feb 23, 2013 3:44 am

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! :(
Last edited by Adam D on Sun Feb 24, 2013 12:40 am, edited 2 times in total.
Adam D
Registered User
 
Posts: 4
Joined: Fri Feb 22, 2013 8:32 pm

Re: locked out of my own forum!!

Postby Oyabun1 » Sat Feb 23, 2013 4:50 am

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.
User avatar
Oyabun1
Support Team Member
Support Team Member
 
Posts: 16172
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: locked out of my own forum!!

Postby Adam D » Sat Feb 23, 2013 5:45 am

Oyabun1 wrote: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
Last edited by Adam D on Sun Feb 24, 2013 12:38 am, edited 1 time in total.
Adam D
Registered User
 
Posts: 4
Joined: Fri Feb 22, 2013 8:32 pm

Re: locked out of my own forum!!

Postby Oyabun1 » Sat Feb 23, 2013 7:22 am

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.
User avatar
Oyabun1
Support Team Member
Support Team Member
 
Posts: 16172
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: locked out of my own forum!!

Postby Adam D » Sat Feb 23, 2013 8:44 am

Oyabun1 wrote: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. :roll:

Here is what I get:
Selection_001.png
Adam D
Registered User
 
Posts: 4
Joined: Fri Feb 22, 2013 8:32 pm

Re: locked out of my own forum!!

Postby Oyabun1 » Sat Feb 23, 2013 10:05 am

Adam D wrote: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', 'admin@yourdomain.com', '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).
User avatar
Oyabun1
Support Team Member
Support Team Member
 
Posts: 16172
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: [SOLVED] locked out of my own forum!!

Postby Adam D » Sun Feb 24, 2013 12:39 am

Okay, that worked and I have everything fixed! :D Thanks a lot for the help!
Adam D
Registered User
 
Posts: 4
Joined: Fri Feb 22, 2013 8:32 pm

Re: [SOLVED] locked out of my own forum!!

Postby Edmondo » Thu Jan 23, 2014 3:51 pm

Thank you, it helped me too :)
Edmondo
Registered User
 
Posts: 3
Joined: Sun Mar 23, 2003 6:23 pm


Return to 3.0.x Support Forum

Who is online

Users browsing this forum: Google Adsense [Bot], kacper3355, PinkStar, uktrader6, Zoddo and 99 guests