MyBB Community Forums

Full Version: Kooky database problem
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Had a hacker attack, filled all the forums and subs with junk posts.  I was able to delete all the posts via PHPmyadmin.  But the "post" count is still intact.

In other words, there are no more threads, but counts still show that there are "threads" and "posts" on each subforum as you can see by the attached screen shot. If you click on the subforum, there are no threads anymore

I searched the whole Schema for anything around thread and post counts, but couldn't find anything....

Any ideas?

I just want to truncate that particular index/table.

[attachment=34607]
(07-08-2015, 07:18 PM)gadgetadmin Wrote: [ -> ]I was able to delete all the posts via PHPmy admin.

Did you also delete the related threads via phpMyAdmin?

The auto increment value can be reset with:

ALTER TABLE table_name AUTO_INCREMENT = value;

You can find in the database what the highest post and thread numbers are, you must increment these with 1 for the "value" in the SQL guery above. Don't forget the table pefix with the table_name.
Thanks. Yes, thats what I meant.

I also solved my own problem Smile

I ran "UPDATE mybb_forums SET usepostcounts = '1'; ",

then did a recount/rebuild on the forum counters, and Voila! it was cleaned up.