Reset signatures with help of SQL query?

[fredrikse]

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]

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

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.

 

[fredrikse]

Thanks a lot!

 

[borbole]

Thanks a lot!

You are welcome

 

[Toxic]

is this possible to reset just one User Group - say the registered users?

 

[borbole]

is this possible to reset just one User Group - say the registered users?

Yes, I replied to your other post.