jaideejung007 Publish time 2016-04-22 04:05

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

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 Publish time 2016-04-28 20:42

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 Publish time 2016-04-23 19:57

Try this bro~

In ACP
Global » Register/Access »

change New user registration validation :

Email validation to None

jaideejung007 Publish time 2016-05-03 03:51

static/image/common/user_online.gif vot static/image/common/clock.gif 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.
Pages: [1]
View full version: How can Un-Freeze (unverified) user by manual in MySQL query?