Windows MYSQL

[3mR]

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.

 

[Keno]

MYSQL ERROR: Unknown column 'cast' in 'field list' (1054)

Add column cast to table players.

 

[Imfreezing]

Execute

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