• 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!
  • 2026 staff recruitment is open! Check it out and consider applying!

Windows MYSQL

3mR

3mR

Mapper
Joined
May 29, 2012
Messages
322
Reaction score
42
Hello OTland,
i got this error in my consle
[11:17:00.781] Owner has logged in.[11:17:13.109] Owner has logged out.[11:17:45.671] mysql_real_query(): UPDATE `players` SET `lastlogin` = 1415438220, `lastip` = 1677830336, `level` = 191, `group_id` = 6, `health` = 1100, `healthmax` = 1100, `experience` = 113147338, `lookbody` = 114, `lookfeet` = 0, `lookhead` = 0, `looklegs` = 0, `looktype` = 302, `lookaddons` = 3, `maglevel` = 84, `mana` = 5700, `manamax` = 5700, `manaspent` = 2187500, `soul` = 0, `town_id` = 5,`posx` = 32350, `posy` = 32229, `posz` = 6, `cap` = 2300, `sex` = 1, `balance`= 0, `stamina` = 151200000, `cast` = 0, `castViewers` = 0, `castDescription` = '', `skull` = 0, `skulltime` = 0, `promotion` = 0, `conditions` = '', `loss_experience` = 100, `loss_mana` = 100, `loss_skills` = 100, `loss_containers` = 100, `loss_items` = 100, `lastlogout` = 1415438233, `blessings` = 0, `marriage` = 0, `vocation` = 2 WHERE `id` = 7 LIMIT 1; - MYSQL ERROR: Unknown column 'cast' in 'field list' (1054)[11:17:45.718] mysql_real_query(): UPDATE `players` SET `lastlogin` = 1415438220, `lastip` = 1677830336, `level` = 191, `group_id` = 6, `health` = 1100, `healthmax` = 1100, `experience` = 113147338, `lookbody` = 114, `lookfeet` = 0, `lookhead` = 0, `looklegs` = 0, `looktype` = 302, `lookaddons` = 3, `maglevel` = 84, `mana` = 5700, `manamax` = 5700, `manaspent` = 2187500, `soul` = 0, `town_id` = 5,`posx` = 32350, `posy` = 32229, `posz` = 6, `cap` = 2300, `sex` = 1, `balance`= 0, `stamina` = 151200000, `cast` = 0, `castViewers` = 0, `castDescription` = '', `skull` = 0, `skulltime` = 0, `promotion` = 0, `conditions` = '', `loss_experience` = 100, `loss_mana` = 100, `loss_skills` = 100, `loss_containers` = 100, `loss_items` = 100, `lastlogout` = 1415438233, `blessings` = 0, `marriage` = 0, `vocation` = 2 WHERE `id` = 7 LIMIT 1; - MYSQL ERROR: Unknown column 'cast' in 'field list' (1054)[11:17:45.765] mysql_real_query(): UPDATE `players` SET `lastlogin` = 1415438220, `lastip` = 1677830336, `level` = 191, `group_id` = 6, `health` = 1100, `healthmax` = 1100, `experience` = 113147338, `lookbody` = 114, `lookfeet` = 0, `lookhead` = 0, `looklegs` = 0, `looktype` = 302, `lookaddons` = 3, `maglevel` = 84, `mana` = 5700, `manamax` = 5700, `manaspent` = 2187500, `soul` = 0, `town_id` = 5,`posx` = 32350, `posy` = 32229, `posz` = 6, `cap` = 2300, `sex` = 1, `balance`= 0, `stamina` = 151200000, `cast` = 0, `castViewers` = 0, `castDescription` = '', `skull` = 0, `skulltime` = 0, `promotion` = 0, `conditions` = '', `loss_experience` = 100, `loss_mana` = 100, `loss_skills` = 100, `loss_containers` = 100, `loss_items` = 100, `lastlogout` = 1415438233, `blessings` = 0, `marriage` = 0, `vocation` = 2 WHERE `id` = 7 LIMIT 1; - MYSQL ERROR: Unknown column 'cast' in 'field list' (1054)[11:17:45.812] Error while saving player: Owner.[11:17:46.250] Lucy has logged out.[11:17:46.265] mysql_real_query(): UPDATE `players` SET `lastlogin` = 1415438177, `lastip` = 1677830336, `level` = 222, `group_id` = 1, `health` = 1255, `healthmax` = 1255, `experience` = 178395429, `lookbody` = 94, `lookfeet` = 114, `lookhead` = 79, `looklegs` = 0, `looktype` = 155, `lookaddons` = 0, `maglevel` = 72,`mana` = 6455, `manamax` = 6455, `manaspent` = 1021133, `soul` = 100, `town_id`= 5, `posx` = 32346, `posy` = 32220, `posz` = 6, `cap` = 2575, `sex` = 0, `balance` = 0, `stamina` = 151200000, `cast` = 0, `castViewers` = 0, `castDescription`= '', `skull` = 0, `skulltime` = 0, `promotion` = 0, `conditions` = '', `loss_experience` = 100, `loss_mana` = 100, `loss_skills` = 100, `loss_containers` = 100, `loss_items` = 100, `lastlogout` = 1415438266, `blessings` = 0, `marriage` =0, `vocation` = 2 WHERE `id` = 8 LIMIT 1; - MYSQL ERROR: Unknown column 'cast' in 'field list' (1054)[11:17:46.312] mysql_real_query(): UPDATE `players` SET `lastlogin` = 1415438177, `lastip` = 1677830336, `level` = 222, `group_id` = 1, `health` = 1255, `healthmax` = 1255, `experience` = 178395429, `lookbody` = 94, `lookfeet` = 114, `lookhead` = 79, `looklegs` = 0, `looktype` = 155, `lookaddons` = 0, `maglevel` = 72,`mana` = 6455, `manamax` = 6455, `manaspent` = 1021133, `soul` = 100, `town_id`= 5, `posx` = 32346, `posy` = 32220, `posz` = 6, `cap` = 2575, `sex` = 0, `balance` = 0, `stamina` = 151200000, `cast` = 0, `castViewers` = 0, `castDescription`= '', `skull` = 0, `skulltime` = 0, `promotion` = 0, `conditions` = '', `loss_experience` = 100, `loss_mana` = 100, `loss_skills` = 100, `loss_containers` = 100, `loss_items` = 100, `lastlogout` = 1415438266, `blessings` = 0, `marriage` =0, `vocation` = 2 WHERE `id` = 8 LIMIT 1; - MYSQL ERROR: Unknown column 'cast' in 'field list' (1054)[11:17:46.359] mysql_real_query(): UPDATE `players` SET `lastlogin` = 1415438177, `lastip` = 1677830336, `level` = 222, `group_id` = 1, `health` = 1255, `healthmax` = 1255, `experience` = 178395429, `lookbody` = 94, `lookfeet` = 114, `lookhead` = 79, `looklegs` = 0, `looktype` = 155, `lookaddons` = 0, `maglevel` = 72,`mana` = 6455, `manamax` = 6455, `manaspent` = 1021133, `soul` = 100, `town_id`= 5, `posx` = 32346, `posy` = 32220, `posz` = 6, `cap` = 2575, `sex` = 0, `balance` = 0, `stamina` = 151200000, `cast` = 0, `castViewers` = 0, `castDescription`= '', `skull` = 0, `skulltime` = 0, `promotion` = 0, `conditions` = '', `loss_experience` = 100, `loss_mana` = 100, `loss_skills` = 100, `loss_containers` = 100, `loss_items` = 100, `lastlogout` = 1415438266, `blessings` = 0, `marriage` =0, `vocation` = 2 WHERE `id` = 8 LIMIT 1; - MYSQL ERROR: Unknown column 'cast' in 'field list' (1054)[11:17:46.406] Error while saving player: Lucy.
Click to expand...
 
Sort by date Sort by votes
Execute
Code: 
ALTER TABLE  `players` ADD  `cast` TINYINT NOT NULL DEFAULT  '0',
ADD  `castViewers` INT( 11 ) NOT NULL DEFAULT  '0',
ADD  `castDescription` VARCHAR( 255 ) NOT NULL
in mysql
 
Upvote 0 Downvote
Back
Top