2400 Users Awaiting Approval

[alkahf]

how can i Approve them ?

 

[Jake Bunce]

Run this query on your database to approve all users who are currently awaiting approval:

UPDATE xf_user
SET user_state = 'valid'
WHERE user_state = 'moderated';

 

[alkahf]

2409 rows affected. ( Query took 0.1493 sec )
Thank U so much Jake

alkahf

 

[cjwinternet]

Could someone please supply the various user state names please to use in SQL.

Ta.

 

[Paul B]

I believe this is related to your other thread, which I responded to.

However, the possible states are: 'valid','email_confirm','email_confirm_edit','moderated','email_bounce'

 

[Fred.]

Interesting to know.

Just because I can't add tags here and I want to be able to find this back.

Update user state

 

[Allan]

Run this query on your database to approve all users who are currently awaiting approval:

UPDATE xf_user
SET user_state = 'valid'
WHERE user_state = 'moderated';

Thank you