• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Mysql Error Out of range value for column 'manaspent' at row 1 (1264)

Thundercraft

New Member
Joined
Dec 5, 2010
Messages
67
Reaction score
0
Hi everyone,

There is one player who can't die because of this bug..

Can anyone tell me how to fix it please?
Code:
mysql_real_query(): UPDATE `players` SET `lastlogin` = 1343260140, `lastip` = 1548571475, `level` = 123, `group_id` = 1, `health` = 1910, `healthmax` = 1910, `experience` = 29837922, `lookbody` = 94, `lookfeet` = 88, `lookhead` = 114, `looklegs` = 0, `looktype` = 128, `lookaddons` = 0, `maglevel` = 14, `mana` = 610, `manamax` = 610, `manaspent` = 3283678671, `soul` = 100, `town_id` = 1, `posx` = 1000, `posy` = 1000, `posz` = 7, `cap` = 3310, `sex` = 1, `balance` = 0, `stamina` = 151200000, `skull` = 0, `skulltime` = 0, `promotion` = 0, `conditions` = '', `loss_experience` = 100, `loss_mana` = 100, `loss_skills` = 100, `loss_containers` = 100, `loss_items` = 100, `lastlogout` = 0, `blessings` = 0, `marriage` = 0, `guildnick` = '', `rank_id` = 0, `vocation` = 4 WHERE `id` = 89 LIMIT 1; - MYSQL ERROR: Out of range value for column 'manaspent' at row 1 (1264)


Thanks in advance,

Thundercraft
 
hmm try add colum manaspent in table players
execute in your phpmyadmin this query:
SQL:
ALTER TABLE `players` ADD `manaspent` int(11) NOT NULL DEFAULT 0;
 
I know it's outdated but i just had this error and fixed it quick, so for future help here is answer.
You need to change structure of table manaspent from int(11) to bigint(20), because int is too small for information that server is trying to save.
 
You need to change structure of table manaspent from int(11) to bigint(20), because int is too small for information that server is trying to save.
Bigint is too small too, it need to be bigint unsigned because sooner or later mysql will be complain about that one bit difference.
Aside from manaspent "experience" and "onlinetime" have different datatypes from server too(experience needs to be bigint unsigned while it is bigint(already someone on this forum has a problem with it) and onlinetime should be bigint while is int(there were problem with this variable as well)).
 
Back
Top