Is user requesting new password the only way to clear login attempt counter?

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
JohnW63
Registered User
Posts: 163
Joined: Tue Jul 12, 2011 2:37 am
Name: John Williamson

Is user requesting new password the only way to clear login attempt counter?

Post by JohnW63 »

I did some searching and it looks like I , as the Admin, can not clear the users login attempts. Is that still the case? The threads I found were not very new?

I have a user who can't get logged in even when they make a new account. I suspect some confirmation e-mail is going to their spam folder and they miss it. But I looked to clear their login attempts so I could change their password and login as them to test the account. No luck.
Last edited by Mick on Thu Dec 01, 2022 9:22 am, edited 1 time in total.
Reason: Solved.
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 52768
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Is user requesting new password the only way to clear login attempt counter?

Post by stevemaury »

You can do it in phpMyAdmin. Executing SQL Queries in phpMyAdmin

Code: Select all

UPDATE phpbb_users SET user_login_attempts = 0 WHERE username = "the username"
If your table prefix is not phpbb_, change accordingly.
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
JohnW63
Registered User
Posts: 163
Joined: Tue Jul 12, 2011 2:37 am
Name: John Williamson

Re: Is user requesting new password the only way to clear login attempt counter?

Post by JohnW63 »

Cool, I'll give that a look.
JohnW63
Registered User
Posts: 163
Joined: Tue Jul 12, 2011 2:37 am
Name: John Williamson

Re: Is user requesting new password the only way to clear login attempt counter?

Post by JohnW63 »

Sorry it's been so long, but I just got back around to checking into this.

The only _user table is in the acl prefix. None in the rest of the forum tables. Did something change in the most recent version?

I have also found that when I click on some of the tables to open them in phpMyAdmin, I get errors. Such as:

mysqli_connect(): (HY000/2002): Connection refused

mysqli_real_connect(): (HY000/2002): Connection refused

and

Failed to set configured collation connection!

I tried a quick " Repair database, but that didn't fix the issue.

On occasion I will get SQL errors just using the forum. Generally a reload get me past it. My server host had to "reindex" my database a few weeks ago. Clearly, that didn't fix the issue.
JohnW63
Registered User
Posts: 163
Joined: Tue Jul 12, 2011 2:37 am
Name: John Williamson

Re: Is user requesting new password the only way to clear login attempt counter?

Post by JohnW63 »

Here are the details under the errors:


Notice in ./libraries/classes/Config.php#909
Undefined index: collation_connection

Backtrace

./libraries/classes/Config.php#1022: PhpMyAdmin\Config->_setConnectionCollation()
./libraries/common.inc.php#457: PhpMyAdmin\Config->loadUserPreferences()
./sql.php#21: require_once(./libraries/common.inc.php)
Notice in ./libraries/classes/DatabaseInterface.php#1536
Undefined index: charset_connection

Backtrace

./libraries/classes/Config.php#911: PhpMyAdmin\DatabaseInterface->setCollation(string 'utf8mb4_unicode_ci')
./libraries/classes/Config.php#1022: PhpMyAdmin\Config->_setConnectionCollation()
./libraries/common.inc.php#457: PhpMyAdmin\Config->loadUserPreferences()
./sql.php#21: require_once(./libraries/common.inc.php)


I checked the database root and my collation is "latin1_swedish_ci", but when I can get it to let me see the list of all table info, all of them say "utf8_bin"

If I click on browse for a table, I get

" Error

SQL query: Edit Edit

SET FOREIGN_KEY_CHECKS = OFF;
"
User avatar
KevC
Support Team Member
Support Team Member
Posts: 72339
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Is user requesting new password the only way to clear login attempt counter?

Post by KevC »

JohnW63 wrote: Tue Nov 29, 2022 3:33 am The only _user table is in the acl prefix.
You definitely have a _users table. The board wouldn't be working at all otherwise. Are you sure you scrolled all the way to the bottom of the tables list? There is often a 'page 2' drop list at the top of the table list. There are around 60 tables in the full database.
JohnW63 wrote: Mon Oct 10, 2022 11:20 pm But I looked to clear their login attempts so I could change their password and login as them to test the account.
You can change their password in
manage users > their username
-:|:- Support Request Template -:|:-
Image
"Step up to red alert. Sir, are you absolutely sure? It does mean changing the bulb"
JohnW63
Registered User
Posts: 163
Joined: Tue Jul 12, 2011 2:37 am
Name: John Williamson

Re: Is user requesting new password the only way to clear login attempt counter?

Post by JohnW63 »

KevC,

You were right. I didn't know I had next page arrows at the top of the page.

Steve,

It was easy enough to just go to the users info and change one field to 0.


What about all the errors I get? I don't like having a database that lets my web page work that kicks off errors on phpmyadmin or when I use the forum.
JohnW63
Registered User
Posts: 163
Joined: Tue Jul 12, 2011 2:37 am
Name: John Williamson

Re: Is user requesting new password the only way to clear login attempt counter?

Post by JohnW63 »

Should I start a new thread about the SQL errors?
User avatar
Mick
Support Team Member
Support Team Member
Posts: 26502
Joined: Fri Aug 29, 2008 9:49 am

Re: Is user requesting new password the only way to clear login attempt counter?

Post by Mick »

Yes, please start a new topic for each issue, it makes following the subject easier.
  • "The more connected we get the more alone we become" - Kyle Broflovski©
  • "The good news is hell is just the product of a morbid human imagination.
    The bad news is, whatever humans can imagine, they can usually create.
    " - Harmony Cobel
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 52768
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Is user requesting new password the only way to clear login attempt counter?

Post by stevemaury »

JohnW63 wrote: Wed Nov 30, 2022 12:32 am KevC,

\
Steve,

It was easy enough to just go to the users info and change one field to 0.
Except there was never a need to go to that table or to edit it. Paste the SQL, click Go, Done.
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
JohnW63
Registered User
Posts: 163
Joined: Tue Jul 12, 2011 2:37 am
Name: John Williamson

Re: Is user requesting new password the only way to clear login attempt counter?

Post by JohnW63 »

By the time I verified the User table was there and that I could open it without errors, as I mentioned in another thread, I was already looking at the field that needed changing. It was just as easy to click, type 0, and then hit save.
Post Reply

Return to “[3.3.x] Support Forum”