• 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


Active member
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
Empty this table:


Then rebuild the user cache:

Admin CP -> Tools -> Rebuild Caches

That should do it.


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


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