XF 1.2 Reset user profile fields

[Adam Howard]

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]

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.