• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.2 Reset user profile fields

Adam Howard

Well-known member
#1
Is there away to mass reset everyone's profile fields?

Don't want to delete all those fields and start over, just want to reset everyone's choices that they have already made.
 

Chris D

XenForo developer
Staff member
#2
Just with database queries, I think.

You'd need to TRUNCATE xf_user_field_value;

And UPDATE xf_user_profile SET custom_fields = '';

That removes all of the values from the table and removes the cached values from the user profile table.