XF 1.3 mysql query needed

[tsak76]

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]

Empty this table:

xf_user_field_value

Then rebuild the user cache:

Admin CP -> Tools -> Rebuild Caches

That should do it.

 

[tsak76]

Empty this table:

xf_user_field_value

Then rebuild the user cache:

Admin CP -> Tools -> Rebuild Caches

That should do it.

ok but whats the query to do so

 

[Paul B]

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.