[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
Adam D
Registered User
Posts: 4
Joined: Fri Feb 22, 2013 8:32 pm

[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.

User avatar
Oyabun1
Support Team Member
Support Team Member
Posts: 20474
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

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.
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests

Adam D
Registered User
Posts: 4
Joined: Fri Feb 22, 2013 8:32 pm

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.

User avatar
Oyabun1
Support Team Member
Support Team Member
Posts: 20474
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

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.
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests

Adam D
Registered User
Posts: 4
Joined: Fri Feb 22, 2013 8:32 pm

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
Selection_001.png (36.19 KiB) Viewed 1553 times

User avatar
Oyabun1
Support Team Member
Support Team Member
Posts: 20474
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

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).
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests

Adam D
Registered User
Posts: 4
Joined: Fri Feb 22, 2013 8:32 pm

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!

Edmondo
Registered User
Posts: 3
Joined: Sun Mar 23, 2003 6:23 pm

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

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

Thank you, it helped me too :)

cedricthecat
Registered User
Posts: 207
Joined: Sun May 03, 2009 4:02 pm
Name: Dave

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

Postby cedricthecat » Sat Feb 28, 2015 6:12 pm

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!

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 44777
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

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

Postby stevemaury » Sat Feb 28, 2015 6:35 pm

Please start your own topic.
For REALLY good and VERY inexpensive hosting CLICK HERE

All unsolicited PMs will be ignored.

cedricthecat
Registered User
Posts: 207
Joined: Sun May 03, 2009 4:02 pm
Name: Dave

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

Postby cedricthecat » Sat Feb 28, 2015 6:43 pm

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.......


Return to “3.0.x Support Forum”

Who is online

Users browsing this forum: alexandr47, Bing [Bot] and 132 guests