• 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!

Linux Spells crash server

Fiodor

Fiodor

Lua & Maps
Joined
Mar 14, 2009
Messages
400
Reaction score
10
Location
Poland
I downloaded 0.4 from here https://otland.net/threads/8-60-the-forgotten-server-0-4.240240/
I compiled it without problems, enabled server with default data files. And there is a problem: when paladin or knight uses any spell, server crashes without any bug info. Sorcerer and druid work fine

I also get this error when character dies
Code: 
 mysql_real_query(): UPDATE `players` SET `lastlogin` = 1472413217, `lastip` = 3147216671, `level` = 98, `group_id` = 1, `health` = 1085, `healthmax` = 1085, `experience` = 14986550, `lookbody` = 68, `lookfeet` = 76, `lookhead` = 78, `looklegs` = 39, `looktype` = 128, `lookaddons` = 0, `maglevel` = 89, `mana` = 1385, `manamax` = 1385, `manaspent` = 3114904033, `soul` = 100, `town_id` = 1, `posx` = 95, `posy` = 117, `posz` = 7, `cap` = 2235, `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` = 3 WHERE `id` = 3 LIMIT 1; - MYSQL ERROR: Out of range value for column 'manaspent' at row 1 (1264)
[21:40:27.013] mysql_real_query(): UPDATE `players` SET `lastlogin` = 1472413217, `lastip` = 3147216671, `level` = 98, `group_id` = 1, `health` = 1085, `healthmax` = 1085, `experience` = 14986550, `lookbody` = 68, `lookfeet` = 76, `lookhead` = 78, `looklegs` = 39, `looktype` = 128, `lookaddons` = 0, `maglevel` = 89, `mana` = 1385, `manamax` = 1385, `manaspent` = 3114904033, `soul` = 100, `town_id` = 1, `posx` = 95, `posy` = 117, `posz` = 7, `cap` = 2235, `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` = 3 WHERE `id` = 3 LIMIT 1; - MYSQL ERROR: Out of range value for column 'manaspent' at row 1 (1264)
[21:40:27.014] mysql_real_query(): UPDATE `players` SET `lastlogin` = 1472413217, `lastip` = 3147216671, `level` = 98, `group_id` = 1, `health` = 1085, `healthmax` = 1085, `experience` = 14986550, `lookbody` = 68, `lookfeet` = 76, `lookhead` = 78, `looklegs` = 39, `looktype` = 128, `lookaddons` = 0, `maglevel` = 89, `mana` = 1385, `manamax` = 1385, `manaspent` = 3114904033, `soul` = 100, `town_id` = 1, `posx` = 95, `posy` = 117, `posz` = 7, `cap` = 2235, `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` = 3 WHERE `id` = 3 LIMIT 1; - MYSQL ERROR: Out of range value for column 'manaspent' at row 1 (1264)
[21:40:27.014] Error while saving player: Paladiner.
could somebody help me?

tibia client 8.6
 
Sort by date Sort by votes
It connects to mysql properly, phpmyadmin works fine, I imported schema.mysql from 0.4 files, apache is up. Of course I may have missed something, I'm not sure
 
Upvote 0 Downvote
Back
Top