Activation User Problem !
 

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.

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.

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.