|
|
Joined: Feb 2001
Posts: 2,268
Junior Member
|
|
Junior Member
Joined: Feb 2001
Posts: 2,268 |
Someone registered on my board, didn't get the confirmation email for whatever reason, and now when they try to log in they get an error saying that they have not confirmed their email address. I don't see the user name in the database (so I can't delete it). Any ideas on what I can do to fix this one?
|
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
UPDATE w3t_Users SET U_Approved = 'yes' WHERE U_Email = ' [email protected]' Should do the trick. 
|
|
|
|
|
Joined: Feb 2001
Posts: 2,268
Junior Member
|
|
Junior Member
Joined: Feb 2001
Posts: 2,268 |
Thanks! Odd that the user name / email addy didn't get purged after it was 24 hours old...
|
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
Hmmmm That's a 6.2.1 bug in adduser.php not expiring the old unconfirmed users when it runs. You might check that you updated adduser from the 6.2.3 distribution.
|
|
|
|
|
Joined: Feb 2001
Posts: 2,268
Junior Member
|
|
Junior Member
Joined: Feb 2001
Posts: 2,268 |
The size of the adduser.php file in the 6.2.3 zip and the one I had on my server were the same, but just in case I uploaded the file from the zip. Thanks Josh! 
|
|
|
|
|
Joined: Apr 2002
Posts: 1,768
Addict
|
|
Addict
Joined: Apr 2002
Posts: 1,768 |
Unverified users are purged by adduser.php. If no new users register, then unverified users will remain in the database indefinitely.
|
|
|
|
|
Joined: Feb 2001
Posts: 2,268
Junior Member
|
|
Junior Member
Joined: Feb 2001
Posts: 2,268 |
Thanks!
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
|
Posts: 449
Joined: February 2008
|
|
|
Forums63
Topics37,575
Posts293,932
Members13,824
| |
Most Online6,139
Sep 21st, 2024
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
