MyBB Community Forums

Full Version: Accidentally high post count
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi

I was coding around a bit, and I made this post through the database with post id/pid 9999991. The next topic automatically appears as pidĀ 9999992. I tried to delete all the 999999x posts AND topics, but it still leads 9's when making a new one. How can I make the count go back down?

I'm pretty advanced in server side coding, but your script is BIGĀ  Blush
Locate the highest numbered pid from mybb_posts, add 1 to it, then run this, where X is your +1 value. Do the same thing for mybb_threads if that has the same problem.
ALTER TABLE mybb_posts AUTO_INCREMENT = X;
Thank you Big Grin