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?
I have the same problem for weeks now, using SMF 1.1.11 . Hope a solution is found it is annoying.
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,
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.)
Anyone know if there is a database command to fix this? Help, please?
Try running this SQL query:
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.
Thanks Ha2! I'll give it a try. <fingers crossed>
Note that that query will approve ALL members currently not approved.
According to his first post, he has only one member waiting approval though, so it should be a non-issue.
Quote from: HimI'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 have no one actually awaiting approval. I approved the member deletion, and their account is gone. It's just the statistic that's stuck.
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):
UPDATE smf_settings SET value = '0' WHERE variable = 'unapprovedMembers';
Marking this one as solved. ;)
Glad to hear you got it sorted :)
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. ;) )
Quote from: crash56 on January 06, 2010, 03:51:34 PM
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):
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.