Activation User Problem !

[Naan-Kadavul]

Hi all,

Some prob in my forum. Actually I enabled the option as activate email after registration under USER REGISTRATION OPTIONS in vBoptions. After that due to some server issues the mail was not sent successfully.

Now there are 150 members in my site (150 Users Awaiting Email Confirmation)
do I have to activate them one by one or can I do it in one shot ? I am able to do one by one but I don't have any idea on how to do it one shot.. Please help..!!


Regards,
NK

[BirdOPrey5]

You should be able to execute a mysql query on the users table to update every record where usergroupid = 3 (awaiting confirmation) to usergroupid = 2 (registered users)... I would recommend backing up before making any database changes, just in case.

[Boofo]

If you still want to verify them first, you can do them one by one in the user profile in the Admin CP with the Email Activation Codes link in the Quick User Links drop-down.

[BirdOPrey5]

There is also a mod for 3.6 that works with 3.8 that will auto re-email the activation codes a few times before deleting the users altogether so if you have email working now that might save you some serious time.