XF 1.4 Clear all signatures & avatars

[rwm1962]

DB stuff is not my strong point so I need some help please.

Could someone provide a query to clear our all avatars & signatures?

They are part of our subscription package & we are starting anew when we go live on XF.

Thanks in advance.

 

[Chris D]

Don't use DB queries to do it.

Use the Batch Update Users function which has an option to remove both the Avatars and Signatures for a batch of users.

Admin CP > Users > Batch Update Users > Search for the users (or click Search for all users) > Check Delete Avatars and check Delete Signatures > Update Users

 

[rwm1962]

Brilliant. Another tick on the do-list!

Many thanks!