vBulletin 3 is end of life and will not be receiving future development. Warning: vBulletin 3.8.11 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.
I need to delete all profile messages on my board but there is no option to delete them on admincp. How can I get rid of them? It takes time to delete them one by one.
truncate visitormessage;
truncate visitormessage_hash;
update user set vmunreadcount = 0, vmmoderatedcount = 0;
Make sure that you add your prefix if one is defined in your config.php. It would go before the table names.
You can run queries within the vBulletin Admin Control Panel by going to Maintenance -> Execute SQL Queries.
To run Queries in the Admin Control Panel you need to edit your config.php file and add your user ID to the Can Run Queries section. It looks like:
// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = '';
Comment