"Member awaiting approval" has gotten stuck ... Database command to fix this?

[crash56]

Greetings!

This is (hopefully) a one-time event.  I've never had trouble with this before.

I've got a "one member awaiting approval" stuck in my User Info area.  My forum is set so it requires an approval when someone deletes their account.  Someone left the forum this evening, I approved their departure, and the statistic got stuck there.

I've tried recounting all forum totals and statistics in the Maintenance Area, and it won't clear.  I also tried searching for a solution here, and didn't find anything ... but I tend to stink at search terms, so I apologize in advance if I've overlooked a thread with a solution.

Forum:  www.terrafirmascapers.com

SMF Version:  1.1.11

Modification Packages:

1. Create Topic on Report to Moderator 0.2.1 
2. Wrap Text Around Image 1.0
3. Spoiler Tag 0.3.2 
4. FavIcon 1.1 
5. Googlebot & Spiders Mod 2.0.3 
6. View_Email_Permission 1.0 
7. Disable_Decrease_Post_Count_Option 1.0
8. SMF 1.0.13 / 1.1.5 / 2.0 b3.1 Update 1.0 
9. SMF 1.0.14 / 1.1.6 Update 1.0 
10. SMF 1.0.15 / 1.1.7 Update 1.0 
11. RemoveQuotedImages 1.0 
12. SMF 1.0.16 / 1.1.8 Update 1.0
13. reCAPTCHA for SMF 0.9.5.4a
14. Stop Spammer 2.2
15. Anti Bot: Are You Human/Bot? 2.1 
16. SMF 1.0.17 / 1.1.9 / 2.0 RC1 Update 1.0
17. SMF 1.0.18 / 1.1.10 / 2.0 RC1-2 Update 1.0 
18. SMF 1.0.19 / 1.1.11 Update 1.0
19. YouTube BBCode 2.5.1

We use some custom themes that are nothing more than the Babylon theme with different colors.  I tried switching to the SMF Default theme.  That didn't do anything.

Can someone tell me how to get this incorrect message out of there?

[jaystv]

I have the same problem for weeks now, using SMF 1.1.11 . Hope a solution is found it is annoying.

[Aleksi "Lex" Kilpinen]

Just a thought, but have you tried if simply changing the registration to immediate for a second, and then back again would do anything? Or if registering and approving a new member would help this?

If not, and it's stuck like that - and the maintanance options won't help, then probably it will have to be fixed through the database,

[crash56]

Yup, I tried changing the method of registration/deleting an account, and even registered a nick and deleted it, hoping it would clear.  No luck.  Also tried recounting after I did that.

Can someone provide the database command to get this to clear out?  (Use tiny words please.  I don't have a lot of experience messing with the database.)

Oh, and just to be clear, this was a member awaiting deletion, not a new member registering ... in case it makes any difference with the command for the database.


Edited to add:  I know the deleted member's ID number, and I was able to check the database to make sure she has really been deleted.  (It has.)

[crash56]

Anyone know if there is a database command to fix this?  Help, please? 

[Nick Whetstone]

Try running this SQL query:

Code Select Expand

UPDATE `databasename`.`dbprefix_settings` SET `value` = '0' WHERE CONVERT( `dbprefix_settings`.`variable` USING utf8 ) = 'unapprovedMembers' LIMIT 1 ;

Of course replacing "databasename" and both instances of "dbprefix" with the appropriate values.

[crash56]

Thanks Ha2!  I'll give it a try.  <fingers crossed>

[Matthew K.]

Note that that query will approve ALL members currently not approved.

[Nick Whetstone]

According to his first post, he has only one member waiting approval though, so it should be a non-issue.

I've got a "one member awaiting approval" stuck in my User Info area.  My forum is set so it requires an approval when someone deletes their account.  Someone left the forum this evening, I approved their departure, and the statistic got stuck there.

[crash56]

I have no one actually awaiting approval.  I approved the member deletion, and their account is gone.  It's just the statistic that's stuck.

[crash56]

I didn't wind up using your suggestion Ha2.  But not because I didn't trust it. 

All I needed was to reset the counter.  The status of the members were fine.  It finally occurred to me to get in touch with a member of our forum who works with MySQL databases all the time.

Here's the command he suggested, which did exactly what we needed (just reset that stupid counter):

Code Select Expand

UPDATE smf_settings SET value = '0' WHERE variable = 'unapprovedMembers';


Marking this one as solved. 

[Aleksi "Lex" Kilpinen]

Glad to hear you got it sorted

[crash56]

We're very happy.  It is SUCH a minor thing (not affecting forum function at all) but it was driving all of the Mods NUTS!!!  (Which implies that we're not nuts already ... which might not be accurate. )

[ButtKoWitz]

I didn't wind up using your suggestion Ha2.  But not because I didn't trust it. 

All I needed was to reset the counter.  The status of the members were fine.  It finally occurred to me to get in touch with a member of our forum who works with MySQL databases all the time.

Here's the command he suggested, which did exactly what we needed (just reset that stupid counter):

Code Select Expand

UPDATE smf_settings SET value = '0' WHERE variable = 'unapprovedMembers';


Marking this one as solved. 

Thanks for this info, it worked perfectly for me (SMF v2.0) with this issue. I used phpMyAdmin to edit the value of the variable, so that might be an easier method for those hesitant to muck around with their DB. I've a feeling StopSpammer's mod (which rocks!) might have been the cause of my infinite "3 members awaiting approval" message, although I'm not positive on that.