Fli
05-06-2024, 08:30 AM
If vBulletin (4) has unwanted posts of some "user" who actually is not user but is marked as a Guest, then it is possible that this user has been deleted before so the vBulletin no longer finds their account and offers no way to delete user and their content.
WORKAROUND:
If the user is Guest (has no account - possibly has been deleted), one can use these SQL commands:
DELETE FROM post WHERE username = 'spammername';DELETE FROM thread WHERE postusername = 'spammername';
After that, go to Admin CP -> Import & Maintenance -> Update Counters
- Rebuild Thread Information
- Rebuild Forum Information
- Remove Orphan Posts
Then to re-claim the disk space, optimize the database: Admin CP -> Import & Maintenance -> Repair / optimize tables (selecting tables with big overhead or all)
WORKAROUND:
If the user is Guest (has no account - possibly has been deleted), one can use these SQL commands:
DELETE FROM post WHERE username = 'spammername';DELETE FROM thread WHERE postusername = 'spammername';
After that, go to Admin CP -> Import & Maintenance -> Update Counters
- Rebuild Thread Information
- Rebuild Forum Information
- Remove Orphan Posts
Then to re-claim the disk space, optimize the database: Admin CP -> Import & Maintenance -> Repair / optimize tables (selecting tables with big overhead or all)