Not a bug e-mail unauthorized removal of mysql

[htsumer]

Affected version

v2.1.0 Beta 6 (test)

e-mail I want to delete unauthorized members from the database

UPDATE xf_user SET user_state = REPLACE ( user_state, 'email_confirm', 'valid' )


I did it this way. But the new member is registering error

 

[Ozzy47]

You should never change users via SQL queries like that. Restore your backup and use the ACP to remove users.

 

[htsumer]

yes error occurred. The new member gave the error must be different from id


I don't know about acp

 

[htsumer]

user does not want to make valid e-mail not valid

 

[Ozzy47]

Right, by deleting/changing users via a SQL queries you have messed up the DB.

 

[htsumer]

yes but i got it back

solution?

this option does not exist in the bulk update

email_confirm to valid

 

[Chris D]

Not sure what you're trying to do, but sadly I think you're doing it wrong.

We wouldn't really be able to support you with modifying the database in this way (it's usually not needed unless we specifically instruct it) so if you have a specific issue you're trying to solve, please create a new Troubleshooting thread with information about that and we'll see if there's another way to solve it.

 

[htsumer]

My goal
e-mail not approved

admin approved

entry in
members can not see the forum.


Group Guest Permissions open


That's why


e-mail without your approval

 

[htsumer]

I can't close the guests because of this plugin

 

[htsumer]

e-mail I want to make the current ones unapproved

 

[Chris D]

I'm still not 100% sure what you're looking to do, but what you're pointing to in the screenshot doesn't appear to be anything within the software itself. It looks like an add-on or similar so that's not something we can support you with anyway.

 

[htsumer]

sign up
fake mail


reading messages

 

[htsumer]

UPDATE xf_user SET user_state ='valid' where user_state='email_confirm'


I wiped it that way.

user does not have this update