MyBB Community Forums

Hi,

I imported the users from my phpBB into my MyBB, but not the posts. But the problem is that the postcounter still uses the number of posts from the phpBB. So my problem is: how can I reset the postcounter for users ? I've checked phpMyAdmin, and it looks like the only solution is resetting it manually for each user, but I'm not really keen on doing that for 1300 users

Thanks!

If it's simply a case of setting the post count to 0 for all users, you can run this query from phpMyAdmin.

UPDATE mybb_users SET postnum='0';

Remember to change mybb_ in the code above with the prefix of your MyBB tables.

Yep, works. Thanks a lot !!

That works or you should be able to use the Recount tool in the ACP for future reference.

ACP > Maintenance > Recount & Rebuild > Recount User Post Counts

Christian Wrote:That works or you should be able to use the Recount tool in the ACP for future reference.

ACP > Maintenance > Recount & Rebuild > Recount User Post Counts

It gives the server a lot more work than necessary to reset all user posts counts to zero.

DennisTT Wrote:It gives the server a lot more work than necessary to reset all user posts counts to zero.

Good point.