*URGENT HELP* needed please about postcount and 64k limit

[DaveRobbo]

OK so it may not be urgent to you guys but its urgent to me and one member especially

I have a member who has posted more than 65,535 messages (don't ask) :surprised:

He's noticed that his post count is no longer increasing

I've done a quick search here - can't find anything obvious. Would it be enough to just change the postcount field in the user table to a bigger "int" .. or do I need some code changes too?

Still running a fully patched (and heavily hacked) vB 2.8

Fast answers very much appreciated

[Andreas]

Seeing as posts is defined as unsigned smallint (max. 65.535), changing the column type should help.

[DaveRobbo]

Originally Posted by KirbyDE

Seeing as posts is defined as unsigned smallint (max. 65.535), changing the column type should help.

Yes it *should* .. but does anyone know if I may need any code changes too?

The fact that his post count didn't go back to 1 suggests to me there may be code that KNOWS it's only a 16-bit quantity - and doesn't "wrap" but doesn't get any higher either

[calorie]

Change SMALLINT to MEDIUMINT (that should keep him busy).

[Andreas]

mySQL itself prevent an overflow, just tested it:

A table with a smallint column, only 1 record with 65535 - update +1 results in 0 affected rows

[DaveRobbo]

Thanks guys - I'll check it out

[Marco van Herwaarden]

There is no code that needs any change for this. The limitation is only the size of the column in the database.

[high]* Marco van Herwaarden Makes a mental note to go check the number of posts made by Steve MAchol at vb.com, could be fun [/high]

[DaveRobbo]

Thank you everyone for the prompt reassurance. I tried the suggestion and it seems to have worked fine

Thanks once again