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

XF 1.3 mysql query needed

tsak76

Active member
#1
i imported custom profile fields from vb but had to make some changes.

i d like the query to delete all values from the db so users can re set their custom profile fields

user_field table is the table i need to change
 

Jake Bunce

XenForo moderator
Staff member
#2
Empty this table:

xf_user_field_value

Then rebuild the user cache:

Admin CP -> Tools -> Rebuild Caches

That should do it.
 

Brogan

XenForo moderator
Staff member
#4
You don't need a query to empty a table.
Just click on [Empty] in PhpMyAdmin for the table in question.

empty.png

Always take a backup first before doing any work on the database.