Template(s) used: Acid by Hedonism
Any and all MODs: PHPBB Admin ToolKit 2.1
Do you use a port of phpBB: What? I downloaded from the phpbb site and uploaded files to mine.
Version of phpBB: 2.0.22
Version of PHP: Server version: 5.0.51-log
Which database server and version: MySQL client version: 4.1.15
Did someone install this for you/who: No
Is this an upgrade/from what to what: No
Is this a conversion/from what to what: No
Have you searched for your problem: Yes
If so, what terms did you try: various combinations of optimize, pruning, deleting, size, database
Do you have a test account for us: Sorry, cannot.
State the nature of your problem:
Forum got spammed with over 150,000 posts and 5,000 not activated users. All posts were deleted with the prune feature and all not-activated users were deleted with the ToolKit.
Forum now has fewer than 200 posts and under 100 users, but the size is 1730MB. No posts have attachments. All the posts and users currently did not use anywhere near 1GB before the spam...not sure exactly, but way, way less.
After the spam hit, db size went to 3500MB. Why has it reduced to only 1730MB after cleaning up?
I have resynched the forums...in fact, I've deleted almost everything but a small set of threads that I need to backup.
What is going on? How can I force phpBB to clean up the database? The PHPBB Toolkit shows one user "Anonymous" with over 150,000 posts, but I cannot delete him (says "Anonymous" is required).
Last edited by 3BB
on Mon Oct 13, 2008 2:16 pm, edited 1 time in total.