I need an sql command to delete unactivated users.
Thx!
ACP > Configurations > User Pruning > and Select "On" in "Prune unactivated users?" option.
I guess its this, not sure though:
DELETE FROM mybb_users where usergroup = '5'
DELETE FROM mybb_users where usergroup = '5' <
This one correct, sorry for the first post...
(2011-07-26, 12:11 PM)nadlerz Wrote: [ -> ]DELETE FROM mybb_users where usergroup = '5' <
This one correct, sorry for the first post...
Whats wrong with mine then?
(2011-07-26, 11:51 AM)crazy4cs Wrote: [ -> ]I guess its this, not sure though:
DELETE FROM mybb_users where usergroup = '5'
(2011-07-26, 11:51 AM)crazy4cs Wrote: [ -> ]I guess its this, not sure though:
DELETE FROM mybb_users where usergroup = '5'
Don't run that. There are a few other places to also remove. Just use the Pruning option in the settings.
^I've already done that before your reply and i've truncated the awaiting activations table too.
How can i delete unactivated user's userfields?
All unactivated users now deleted, so i don't know how to do it.
Just use the default User Pruning tool that comes with MyBB.