XF 1.4 Clear all signatures & avatars


Well-known member
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

XenForo developer
Staff member
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