Restore mass users?

New Member Joined: Dec 03, 2004 Posts: 5

Hi again! Loving the script! Wink

I do have a rather biggie problem... upon install, 346 of my users were marked as suspended accounts, even though I have chosen Never(0) as when to suspend users.

So, as you can imagine, I'm beginning to get emails, etc.

Any quick & dirty way to clear this up?

Much thanks in advance for any ideas!
Nikki

Posted: Sat Dec 04, 2004 12:07 pm

Make a database backup first!
Then from phpmyadmin run
UPDATE nuke_users SET user_active = '1' AND user_level = '1';

When I tested it only changed where the levels where 0 but I can't say for sure you will get the same results.

Please let me know if you find where this was caused I have seen no one else report anything so bazaar. Even when (If Terms of Service are new or changed) is set to yes the userlevel and status are not changed.

Posted: Sat Dec 04, 2004 12:21 pm

As a followup could you send me a structure dump of you database so that I might investigate further and verify there isn't something specific to your configuration?

Posted: Sat Dec 04, 2004 3:04 pm

hmmmm..... I tried the above, but I'm still showing the following on my summary page:

Active Users: (166)
Regular Users: (512)
Deactivated Users: (1)
Suspended Users: (345)
Waiting Users: (2)

I am PM'ing you the db structure dump of the nuke_users table - thanks a LOT for taking a look!

Thanks in advance -
Nikki

Posted: Sun Dec 05, 2004 9:37 am

The only way I see for this to happen (not too far fetched) would be if you set autosuspend on to check it out and Auto suspend user in all pageview
(yes) it sets all expired users to inactive. Then when it is switched back there is no way to "mass restore" their status they remain inactive.

Try this I made an error with the last one sorry.
UPDATE nuke_users SET user_active = '1' WHERE user_active = '0';
UPDATE nuke_users SET user_level = '1' WHERE user_level = '0';

I'll see if I can add some way to change all suspended users in the next version it should be pretty simple to add.

If you don't think the above scenerio caused your users status to change let me know and we can work through it one way or another.

Posted: Sun Dec 05, 2004 1:52 pm

Hey - thanks so much! That did it in the tables...

As for the scenario - you may be right. I didn't *think* I'd done that, but I was getting interrupted quite frequently - it's a possibility for sure!

Thanks again for your help!
Best to you,
Nikki