Post count

Simka · January 6th, 2011, 04:17 PM

Hi.

When I delete an ad from Expired queue in admin panel, then the users post count is set to: 4.294.967.295 in vbulletin.

I have to manually change users post count to 0 everytime.

How do I fix that?

Chuck S · January 6th, 2011, 05:42 PM

I have tested this in my vb and do not see any issues. The file calls this

Code:

Content visible to verified customers only.

That just passes a function line the word minus and a userid which does this code in your forum integration

Code:

Content visible to verified customers only.

It is a very simplistic function

If your minus out one post your simply issuing a query in vbulletin like this

Code:

Content visible to verified customers only.

Thats an example of say a query that would be issued for a particular user. I see no how a users post count could get messed up with that query as all that says is essentially user posts is going to be set to user posts minus 1.

I think there would have to be more to the story here.

Like for instance try doing a query like right above with say your userid with your specific site info and see if your vb posts count works right. If it doesnt then I think you have a mysql bug with your specfic mysql. I dont think there is anything unsound query wise.

Simka · January 7th, 2011, 03:58 PM

And if the user have 0 posts, then what happens?

Chuck S · January 7th, 2011, 05:13 PM

The user would never happen a user have 0 posts I think as there post count would have to been increased when they posted the ad if your using post increment. If your not using the post increment feature then nothing would be altered.

so what happens on your server if you issue such a query. Nothing happens on mine. What we are trying to get here is there some type of mysql bug in your mysql version. The query is valid in the software.

Simka · January 9th, 2011, 09:00 AM

If I run this query on a user with 0 posts, then he get post count: 4.294.967.295

UPDATE user SET posts=posts-1 WHERE userid=1234

Simka · January 9th, 2011, 09:00 AM

I dont increase users post count when the create an ad, so I have lots of users with 0 posts.

Chuck S · January 9th, 2011, 09:12 AM

Hmm maybe try line 620 of adm-misc.php which is this

Code:

Content visible to verified customers only.

change to this

Code:

Content visible to verified customers only.

Simka · January 9th, 2011, 09:18 AM

That was already there:

Code:

Content visible to verified customers only.

Chuck S · January 9th, 2011, 09:31 AM

your looking at line 69 not 620 search for inc_user again

Simka · January 9th, 2011, 09:31 AM

Sorry, it wasnt line 620 :-)

I have changed it now, and testing

Simka · January 9th, 2011, 09:34 AM

Quote:

Originally Posted by Chuck S

your looking at line 69 not 620 search for inc_user again

Thx, it is working now

Chuck S · January 9th, 2011, 10:07 AM

enjoy your weekend.

creativepart · August 14th, 2011, 12:24 PM

Wow, I've had this problem for YEARS -- in fact I was looking to hire a coder to create a cron job to reset all these posts counts to zero. But I've had to manually reset these post counts counts for 4 or more years. I complained about it here a long time ago.

This has been a plague that I ALWAYS thought was caused by PP Classifieds but only just recently proved it on my website.

I didn't have the exact same original coding as Chuck S. detailed in his fix. I had the following at line 620 of adm-misc.php:

Code:

Content visible to verified customers only.

I changed my coding as shown above. I'm hoping and praying that his has fixed the issue.

I'm tired of having to fix all these posts counts every week. Earlier this year I forgot to deal with this issue for a couple of months and I had over 150 members with post counts of 4,294,967,295 and I had to manually go through and fix each of them.

Chuck S · August 14th, 2011, 03:11 PM

I do not ever see in this thread that there was ever an issue we found in our product the line is correct all it does is minus a post

Ramses · September 4th, 2011, 09:17 AM

Have the same issue, now I just disabled increment of post count, hope this helps.

Chuck S · September 4th, 2011, 10:36 AM

That is what that option is for to disable that feature

Ramses · September 5th, 2011, 05:32 PM

Quote:

Originally Posted by Chuck S

That is what that option is for to disable that feature

Yep, and if all of the fixes above not work the only solution to surround this bug.

Chuck S · September 5th, 2011, 07:24 PM

well the only bug would be not having the if clause around the line and this was a fixed issue some time back.

creativepart · September 16th, 2011, 02:32 PM

Just reporting back that I had this issue for years. I had the post count increment turned off the entire time but still had this issue. I changed the coding as I posted above in post #13 (referencing the original fix in line #7) and it has fixed my problem long term now.

It's been a whole month and I've had no members with 4 billion posts.

Chuck S · September 16th, 2011, 08:49 PM

enjoy your weekend.