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

Reset signatures with help of SQL query?

fredrikse

Active member
#1
Hi,

I would like to reset the signature field in xenForo after migration from vB is completed. What would the SQL query for that be?
 

borbole

Well-known member
#2
Hi,

I would like to reset the signature field in xenForo after migration from vB is completed. What would the SQL query for that be?
By resetting you mean to truncate/delete all signatures for everyone? If so run this query at the SQL box in phpmyadmin

Code:
UPDATE xf_user_profile
SET signature = '';
If you are using another prefix for your tables, replace xf_ with your custom prefix at the queries above. Hope it helps.