XF 1.2 Reset user profile fields

Adam Howard

Well-known member
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
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.