F fredrikse Active member Aug 3, 2012 #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?
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?
B borbole Well-known member Aug 3, 2012 #2 fredrikse said: 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? Click to expand... 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. Upvote 1 Downvote
fredrikse said: 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? Click to expand... 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.
B borbole Well-known member Aug 3, 2012 #4 fredrikse said: Thanks a lot! Click to expand... You are welcome Upvote 0 Downvote
Toxic Member Sep 2, 2012 #5 is this possible to reset just one User Group - say the registered users? Upvote 0 Downvote
B borbole Well-known member Sep 2, 2012 #6 Toxic said: is this possible to reset just one User Group - say the registered users? Click to expand... Yes, I replied to your other post. Upvote 0 Downvote
Toxic said: is this possible to reset just one User Group - say the registered users? Click to expand... Yes, I replied to your other post.