Post count going into Billions for some users!

[RobFerrari]

I have about 20 users now that post count has gone to numbers right around 4,294,967,282. Most are within a few posts of that. I have only had this problem since 3.8. I checked these users and most are inactive users that haven't even posted, although most do appear to be subscribed. Some do have just a couple posts. So there are no existing posts for this count. I first suspected mods who for fun in past have copied threads in way to get users post count up to millions, but then you can just delete the copied threads to fix. This appears to be a hack or more likely a bug. Anyone hear of this? Thanks.

[Steve Machol]

That specific problem is due to an add-on. You need to remove your add-ons. Then try rebuilding the thread and forum counters in that order:

Admin CP -> Maintenance -> Update Counters

[Ryan Ashbrook]

Same issue as here: http://www.vbulletin.com/forum/showthread.php?t=270649

I can't remember how this issue comes about though... though I do remember seeing a few threads about it.

[Steve Machol]

Every time I have seen this problem it has been due to an add-on. IME there has never been any vB 'bug' that caused this. Do you have any add-ons installed?

[RobFerrari]

Every time I have seen this problem it has been due to an add-on. IME there has never been any vB 'bug' that caused this. Do you have any add-ons installed?

yes... photoPost Classifieds, Inferno Quiz, vB Blog, Sigma Chat, and vB Ad Management.

The problem only happened after upgrade to 3.8, but I will agree the problem is with an add on. Anyone have an idea which one? All the users affected appear to be Paid Subscribed users, which is required to post ads, participate in quiz, blog, and chat.

I can't rerun the post count with vB because I moved from Discusware before there was a conversion and I manually added the previous post count of users.

[Steve Machol]

Unfortunately I don't know which add-on or add-ons can cause this. You might want to try searching over at www.vbulletin.org.

[RobFerrari]

I think related, but Repair/Optimize is hanging up. Both from vB and phpMyAdmin.

postindex is crashed, so forum is shut down to new posts.

repair on just postindex seems to hang up the same way.

is postindex out of wack because of those 25 users with 4 B+ posts, although there are really no posts behind the count?

how can I get postindex back up so the forum works again?

Thanks.

[glennybee]

Try manually setting each user to 0 posts in admincp then try to repair the database again.

[RobFerrari]

Try manually setting each user to 0 posts in admincp then try to repair the database again.

I corrected all those users to proper post count. Repair on postindex still hanging.

rebuilding threads and post cache, but I don't think that will do anything.

[Carnage-]

If i remember right, there is an option to rebuild the post index... (I personally don't have the post index as i use full text search)

[Wayne Luke]

is postindex out of wack because of those 25 users with 4 B+ posts, although there are really no posts behind the count?

The postindex table has nothing to do with user post counts and would not affect this.

how can I get postindex back up so the forum works again?

Run these queries:

truncate postindex;
truncate word;

If it won't truncate you will have to repair it from the command line using myisamchk.

After you empty those two tables, convert your forums to fulltext search under vBulletin Options -> Search Type or rebuild your search index under Maintenance -> Update Counters.

You can get the proper post counts for individual user's by running a query like:
SELECT count(*) FROM post WHERE userid=XXX

Once you have the valid count then you can update the user record with:
UPDATE user SET posts = YYY

XXX would be the user's id and YYY would be the result from the first query.

[RobFerrari]

Thanks everyone for the help. Forum is back up and running, all well.

So maybe users with 4 Billion+ post counts wasn't related to the postindex problems.

I manually fixed the users with these post counts, but expect the problem to return until I can find which add on programs is causing the problem in 3.8.

Problem with postindex is the same old same old, my tmp is only 1 GB and repairs hang on that table. Opened up some more space and repairs completed successfully and forum back up 100%.

[aquariumpros]

I'm experiencing this same issue.

Have you (or anyone) figured out the cause and/or fix?

Thanks in advance,

[RobFerrari]

I'm experiencing this same issue.

Have you (or anyone) figured out the cause and/or fix?

Thanks in advance,

not sure I have figured out, but no problems since 3.8.0 and getting rid of photo post classifieds.

[aquariumpros]

not sure I have figured out, but no problems since 3.8.0 and getting rid of photo post classifieds.

Unfortunately PP-Classifieds is an integral part of my site and can't be removed...