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

 

[BuffBillsMan90]

Thanks.........clear as mud :D

 

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

You Da Man AJ!!!

 

[WharfRat]

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

I understood it clumpy!