PDA

View Full Version : Points not recording...



WharfRat
03-31-2003, 02:07 AM
I've been "stuck" at 32767 points... but have posted several times... is there a cap on the amount you can have?

I notice that 39 and I both have the exact same amount....

just wondering...

FinHeavenAJ
03-31-2003, 08:45 AM
Oook, it's been fixed... Here's the reason for the error...

In the database, I was using smallint for the field "points." Anyone that knows databases, knows that smallint can only go up to 32767. So, I went in and changed it to mediumint, which can go as high as 8,388,607. The only drawback is size, as mediumint is 4 bytes, compared to 3 bytes with smallint.

Ok, enough tech talk :D , the problem is fixed. :cool:

Clumpy
03-31-2003, 10:25 AM
Thanks.........clear as mud :D

WharfRat
03-31-2003, 12:14 PM
Originally posted by FinHeavenAJ
Oook, it's been fixed... Here's the reason for the error...

In the database, I was using smallint for the field "points." Anyone that knows databases, knows that smallint can only go up to 32767. So, I went in and changed it to mediumint, which can go as high as 8,388,607. The only drawback is size, as mediumint is 4 bytes, compared to 3 bytes with smallint.

Ok, enough tech talk :D , the problem is fixed. :cool:

You Da Man AJ!!!

WharfRat
03-31-2003, 12:15 PM
Originally posted by clumpedplatelet
Thanks.........clear as mud :D

I understood it clumpy! ;)