TFS 1.2 4294967295 maglevel bug?

[Tbol]

Hello,
found a weird issue that happens but its hard to replicate this bug it happens really rare so for some reason i have few characters that are stuck to 129 mag level and when they reach 130 they maglevel goes back too 129, so i though maybe its issue in vocation.xml but then i noticed that everything is fine they created exactly the same how other characters are made and other people with same characters dont have this issue, so its really weird. The only think i noticed is that they have same manaspent in dabatabase which is 4294967295

Any ideas how to fix it?

 

[Astir Lotus]

This is the maximum number of a unsigned 32 bit integer. Meaning it can't get any higher.
Changing the column to a 64 bit integer (bigint) will fix the problem. The max value of this is 18446744073709551615

This SO post is having the same issue

mysql database insert is changing all IDs to 4294967295

Something really weird is going on with my database. I am using PHP to insert data into my database and I have been doing this for the past 2 years without any problems. When a customer makes a pay...

stackoverflow.com

This query should do the trick.
ALTER TABLE table_name
MODIFY manaspent bigint unsigned;

 

[Tbol]

This is the maximum number of a unsigned 32 bit integer. Meaning it can't get any higher.
Changing the column to a 64 bit integer (bigint) will fix the problem. The max value of this is 18446744073709551615

This SO post is having the same issue

mysql database insert is changing all IDs to 4294967295

Something really weird is going on with my database. I am using PHP to insert data into my database and I have been doing this for the past 2 years without any problems. When a customer makes a pay...

stackoverflow.com

This query should do the trick.
ALTER TABLE table_name
MODIFY manaspent bigint unsigned;

So you saying too change manespent column type from INT to a BIGNIT?

 

[Astir Lotus]

So you saying too change manespent column type from INT to a BIGNIT?

Exactly