??: Account Disabled after users click validation link
I dont know if this is related too your problem but.
We updated a 2.3 to 4.1 version and lost about 20% of the users.
They would get the message you attached.
It took a while but I found that email confermation puts a u into field waiting.
Further testing found that all users with a "a" in the waiting field had the problem.
I changed all a to empty field and they work now.
I have never seen a chart of what all the tables and fields do.
In 2.3 evry thing worked and I dont know how the a got into waiting but when I took it out all worked fine.
Hope this helps - Emmett