How can Un-Freeze (unverified) user by manual in MySQL query?

jaideejung007

When a user was logged on/off more than 90 days since the last Log in, the account became the "unverified" status. A user can verify his mailbox or complaint the thaw account.

BUT now, Mailer in my site is down, can be fix by manual or MySQL query?

and, some user can't appear in admin.php?action=moderate&operation=members

Thanks.

vot

PhpMyAdmin:
1) Go to pre_common_member_validate.
Remove a record with uid = freezed_member_uid

2) Go to pre_common_member.
find a row with uid = freezed_member_uid
Update that record:
SET 'freeze' = 0

rameshkiran114

Try this bro~

In ACP
Global » Register/Access »

change New user registration validation :

Email validation to None

jaideejung007

vot 2016-4-29 00:42
PhpMyAdmin:
1) Go to pre_common_member_validate.
Remove a record with uid = freezed_member_uid

WORKING!!!

Thanks you so much.