XF 2.1 Change via phpmyadmin status from "awaiting approval" to "valid"

snoopy5

Well-known member
Hi,

I am testing some imports from phpBB 3.3 to XF 2.1. The XF import script works fine. Only one issue.

In my testimport all users have now the user state "awaiting approval". Obviously this is wrong. I want to change this now with a mysql command to user state "valid" with phpmyadmin.

Does anybody know the textline for this? I am unfortunaley not a coder.

Thanks in advance
 

Brogan

XenForo moderator
Staff member
This will change the state of all accounts to valid:
SQL:
UPDATE xf_user SET user_state = 'valid';


This will change the state of moderated users only to valid:
SQL:
UPDATE xf_user SET user_state = 'valid' WHERE user_state = 'moderated';


However, it would be better to resolve this in the source database, if those user accounts are actually valid.
 

sonnb

Well-known member
1. Update the xf_user table and set user_state to valid
2. Remove records from xf_approval_queue which has content_type = user

(Assuming this is a new XF2.1 instance so no query condition check is provided)

Edit: Hacked by Brogan :D
 
Top