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

[snoopy5]

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

 

[Paul B]

This will change the state of all accounts to valid:

UPDATE xf_user SET user_state = 'valid';

This will change the state of moderated users only to valid:

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]

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