Points not recording...

[WharfRat]

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]

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 , the problem is fixed. :cool:

[Clumpy]

Thanks.........clear as mud

[WharfRat]

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 , the problem is fixed. :cool:

You Da Man AJ!!!

[WharfRat]

Originally posted by clumpedplatelet
Thanks.........clear as mud

I understood it clumpy!