Normal Servidor não salva player (erro na database ?)

[King Ragnar 2]

Boa tarde galera , tou com o seguinte problema :

Citar

[20:37:43.937] > SAVE: Complete in 0.305 seconds using relational house storage.
[20:37:47.514] [ADM] Supreme has logged out.
[20:37:47.514] mysql_real_query(): UPDATE `players` SET `lastlogin` = 1473701854, `lastip` = 3905969585, `level` = 1, `group_id` = 6, `health` = 150, `healthmax` = 150, `experience` = 0, `lookbody` = 0, `lookfeet` = 0, `lookhead` = 0, `looklegs` = 0, `looktype` = 302, `lookaddons` = 0, `maglevel` = 0, `mana` = 0, `manamax` = 0, `manaspent` = 0, `soul` = 0, `town_id` = 1, `posx` = 160, `posy` = 57, `posz` = 7, `cap` = 400, `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` = 1473701867, `blessings` = 0, `marriage` = 0, `guildnick` = '', `rank_id` = 0, `vocation` = 4 WHERE `id` = 13 LIMIT 1; - MYSQL ERROR: Unknown column 'cast' in 'field list' (1054)
[20:37:47.514] mysql_real_query(): UPDATE `players` SET `lastlogin` = 1473701854, `lastip` = 3905969585, `level` = 1, `group_id` = 6, `health` = 150, `healthmax` = 150, `experience` = 0, `lookbody` = 0, `lookfeet` = 0, `lookhead` = 0, `looklegs` = 0, `looktype` = 302, `lookaddons` = 0, `maglevel` = 0, `mana` = 0, `manamax` = 0, `manaspent` = 0, `soul` = 0, `town_id` = 1, `posx` = 160, `posy` = 57, `posz` = 7, `cap` = 400, `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` = 1473701867, `blessings` = 0, `marriage` = 0, `guildnick` = '', `rank_id` = 0, `vocation` = 4 WHERE `id` = 13 LIMIT 1; - MYSQL ERROR: Unknown column 'cast' in 'field list' (1054)
[20:37:47.515] mysql_real_query(): UPDATE `players` SET `lastlogin` = 1473701854, `lastip` = 3905969585, `level` = 1, `group_id` = 6, `health` = 150, `healthmax` = 150, `experience` = 0, `lookbody` = 0, `lookfeet` = 0, `lookhead` = 0, `looklegs` = 0, `looktype` = 302, `lookaddons` = 0, `maglevel` = 0, `mana` = 0, `manamax` = 0, `manaspent` = 0, `soul` = 0, `town_id` = 1, `posx` = 160, `posy` = 57, `posz` = 7, `cap` = 400, `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` = 1473701867, `blessings` = 0, `marriage` = 0, `guildnick` = '', `rank_id` = 0, `vocation` = 4 WHERE `id` = 13 LIMIT 1; - MYSQL ERROR: Unknown column 'cast' in 'field list' (1054)
[20:37:47.515] Error while saving player: [ADM] Supreme.
[20:37:50.232] [ADM] Supreme has logged in.
 

 

Eu uso uma VPS Linux Ubuntu 12.04 , ao sair dar Logout , o servidor não salva o player , portanto quando ele retorna está tudo igual ao começo , perde todos os itens e level. 

 

Obs : Já colequei o script save.lua e outros , mesmo dando o comando /save , ele não salva.

[otmanager 24]

Olá, boa noite.

 

É só você executar as querys SQL abaixo:

 

ALTER TABLE  `players` ADD  `cast` TINYINT NOT NULL DEFAULT  '0';
ALTER TABLE  `players` ADD  `castViewers` INT( 11 ) NOT NULL DEFAULT  '0';
ALTER TABLE  `players` ADD  `castDescription` VARCHAR( 255 ) NOT NULL;

 

[King Ragnar 2]

18 horas atrás, otmanager disse:

Olá, boa noite.

 

É só você executar as querys SQL abaixo:

 

ALTER TABLE  `players` ADD  `cast` TINYINT NOT NULL DEFAULT  '0';
ALTER TABLE  `players` ADD  `castViewers` INT( 11 ) NOT NULL DEFAULT  '0';
ALTER TABLE  `players` ADD  `castDescription` VARCHAR( 255 ) NOT NULL;

 

 

Muito obrigado mesmo , deu certo , REP +

[Jhonjhon775 2]

Em 12/09/2016 em 19:06, otmanager disse:

Olá, boa noite.

 

É só você executar as querys SQL abaixo:

 

ALTER TABLE  `players` ADD  `cast` TINYINT NOT NULL DEFAULT  '0';
ALTER TABLE  `players` ADD  `castViewers` INT( 11 ) NOT NULL DEFAULT  '0';
ALTER TABLE  `players` ADD  `castDescription` VARCHAR( 255 ) NOT NULL;

 

 

como executo esse comando alguem pode me ajudar urgente ???? to desisperado! e no php my admin ou no puttygne ?