Confirmation Email Problems / SQL command?


Well-known member
We've had quite a few users complain about not getting confirmation emails. Whilst we sort it out, is there a simple SQL command that will change their status from "awaiting email confirmation" to "valid"?

It looks like we had quite a lot of users from before our import from VB which were in that state which is confusing matters so getting everyone "valid" seems like the best course so we can investigate it more.

Jake? ;-)