UseBB Community

Hi,

I cleaned out (deleted) every post from my board when I changed it to another forum and even though I only made 1 post, this shows in the stats box:

This board contains 1 posts in 3 topics and has 3 registered members (2 are test accounts).

In Profile, it says I have 2 and if I do a search member's post, it only shows 1 post.

On the index page, it shows 1 in both Topics and Posts.

Any ideas?

I corrected the values via phpmyadmin to the correct value of 1 in the two affected tables (stats and members) and now shows the correct values in the stats box and profile. Was this the right thing to do?

Best to run this in admin SQL Toolbox.

UPDATE usebb_stats SET content = 0 WHERE name = 'topics' OR name = 'posts'

Changing usebb to what you have.

Add: you can change post number in admin by edit members.

Something else that may come in handy
http://www.usebb.net/community/topic-931.html (last post, 2nd code area)

Also use in admin SQL toolbox.

Thanks William,

Even though I had corrected (reset) the posts and topics count using phpmyadmin, I still ran the above query.

Know of a way to reset the "Next Autoindex" in the posts table to 0? I don't have any posts in there and the next one will be # 16. Not that it's really important but what the heck...

I'm a darn darn perfectionist...
Gene

Guessing, would have to do...

Thanks! Worked great! Reset the topics count.

Gene

Guess i can do the same with the user number? I have 2 members (admin and test account) but if I register a new account, it shows id=16.

Gene

Yes, you'll have to reset the Auto-increment amount down

Yup, just use...

ALTER TABLE usebb_members AUTO_INCREMENT = 3

As long there is only 2 members.

Thanks William

I'm still learning... LOL!

Gene

I will read, check and eventually fix this bug (report) soon. No time for now, sorry.

No big deal, only a very small annoyance...

Thanks,
Gene

I quickly checked this bug but there doesn't seem to be any errors in the code concerning counting topics and posts. Just note that when pruning forums, user post counts are not recounted in v1.

Moved to Help & Support.