So I need to clear out all of the signatures on my community. I know there's an SQL query code I need to use, but I don't remember the query. Can someone help me out here?
Thanks in advance for any help you can offer.
vBulletin 4.2.5 is end of life and will not be receiving any future development. Warning: vBulletin 4.2.5 is not compatible with PHP 7.2.0 or higher.
Welcome to the vBulletin support forums! In our community forums you can receive professional support and assistance with any issues you might have with your vBulletin Products.
Useful Links for Guests:
If you are having problems posting in the relevant areas for your software, please see this topic.
Telephone Sales and Support Status
Due to the Independence Day Holiday in the United States, our telephone services will be closed on July 4th. This includes both the Sales and Support lines. Service will resume again during normal business hours on July 5th.
Email support services will be open. We apologize for any inconvenience this may cause.
UPDATE usertextfield SET signature = '';
DELETE FROM customavatar USING customavatar LEFT JOIN user ON (user.userid = customavatar.userid);
$config['SpecialUsers']['canrunqueries'] = 'x';
UPDATE usertextfield SET signature = '';
DELETE FROM customavatar USING customavatar LEFT JOIN user ON (user.userid = customavatar.userid);
$config['SpecialUsers']['canrunqueries'] = 'x';
UPDATE {table-prefix}usertextfield SET signature = '';
UPDATE vb_usertextfield SET signature = '';
Comment