Post count error "16777215"

skylergray · Post by **skylergray** » Sun May 13, 2007 5:51 am

Hello. I have done a search of your boards and while a couple of things come close to answering my question, none of them are exactly what I need.

I have been made a forum admin for an official Game forum. I do not have founder status, and I do not have direct access to teh database, or the server.

The problem is that some random members have had their post count jump to 16777215. There seems to be no resynchronizing option that I can find, nor a way to directly change the post count in pgpBB 3.0 B5. Is there any way I can do either of theeses things with the access that I have?

Its not a huge bothering bug, but the company seems to not care, and it just slightly bothers me, as it seems unprofessional.

Thanks for your help guys.

pentapenguin · Post by **pentapenguin** » Sun May 13, 2007 6:21 am

Hi and welcome.

Did you try the "Resynchronise post counts" option in the main page of the ACP?

skylergray · Post by **skylergray** » Sun May 13, 2007 6:24 am

Ah, its on the MAIN page. I thought it was user specific, and I could not find the option to do so. I did it, and it worked for all but two. strange.

EDIT: just noticed that those two have not actually posted yet. Strange.

pentapenguin · Post by **pentapenguin** » Sun May 13, 2007 6:27 am

You might want to try using the latest CVS version (UNsupported by the way) and see if that's been fixed. If not file a bug report with as much detail as you can.

skylergray · Post by **skylergray** » Sun May 13, 2007 6:37 am

Well they had 0 posts and had not logged in in two months, so I jsut deleted them lol. problem solved. Thanks for your help.

Ida · Post by **Ida** » Sun May 13, 2007 3:25 pm

skylergray wrote: The problem is that some random members have had their post count jump to 16777215.

I'd venture the guess that the post count is stored in a 3-bytes unsigned variable (strange but why not...), that they had 0 posts, and that the forum remorselessly tried to decrement the post count. ( -1 == 16777215 [3 bytes]) (I don't know PHP, but I assume it deals with out-of-range assignments the same way C++ does)

Maybe they had only posted in a forum where the posts are not counted, then you moved their posts, and deleted one of them. Or something of the kind...

It would be interesting to try and reproduce that bug, although it has probably be found and fixed in CVS. I hope. If it has not, it definitely qualifies for a bug report.

skylergray · Post by **skylergray** » Sun May 13, 2007 4:32 pm

The thing is, there were people as you described, but then there were also those with hundreds of post that were affected as well. Now the resynching of post counts worked with those that had posts, but those that had 0 posts, it did not work, and they had to bed deleted.. I think I will go see if I can reporduce the error.

CosmicD · Post by **CosmicD** » Mon Jul 23, 2007 10:29 am

I've got this error as well with several users (lucky i'ts less than 10).

I tried to 'resyncronize posts count ' but that doesn't seem to help.
another idea ?

A_Jelly_Doughnut · Post by **A_Jelly_Doughnut** » Mon Jul 23, 2007 1:21 pm

The only reason I've seen for this error is when a user is in the moderation queue. You could try disabling that to prevent the issue from happening to additional users.

This bug should be fixed in RC4.

And yes, Ida's explanation is correct.