Queria saber se alguem de vocês conhece esse erro :

[20:50:55.456] Error while saving player: Loucura.

[20:50:55.452] mysql_real_query(): UPDATE `players` SET `lastlogin` = 1405903847, `lastip` = 2907103674, `level` = 8, `group_id` = 1, `health` = 185, `healthmax` = 185, `experience` = 4200, `lookbody` = 68, `lookfeet` = 76, `lookhead` = 78, `looklegs` = 39, `looktype` = 128, `lookaddons` = 0, `maglevel` = 0, `mana` = 35, `manamax` = 35, `manaspent` = 0, `soul` = 100, `town_id` = 1, `posx` = 157, `posy` = 54, `posz` = 7, `cap` = 435, `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` = 1405903855, `blessings` = 0, `marriage` = 0, `vocation` = 2 WHERE `id` = 19 LIMIT 1; - MYSQL ERROR: Unknown column 'castViewers' in 'field list' (1054)
[20:50:55.454] mysql_real_query(): UPDATE `players` SET `lastlogin` = 1405903847, `lastip` = 2907103674, `level` = 8, `group_id` = 1, `health` = 185, `healthmax` = 185, `experience` = 4200, `lookbody` = 68, `lookfeet` = 76, `lookhead` = 78, `looklegs` = 39, `looktype` = 128, `lookaddons` = 0, `maglevel` = 0, `mana` = 35, `manamax` = 35, `manaspent` = 0, `soul` = 100, `town_id` = 1, `posx` = 157, `posy` = 54, `posz` = 7, `cap` = 435, `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` = 1405903855, `blessings` = 0, `marriage` = 0, `vocation` = 2 WHERE `id` = 19 LIMIT 1; - MYSQL ERROR: Unknown column 'castViewers' in 'field list' (1054)
[20:50:55.456] mysql_real_query(): UPDATE `players` SET `lastlogin` = 1405903847, `lastip` = 2907103674, `level` = 8, `group_id` = 1, `health` = 185, `healthmax` = 185, `experience` = 4200, `lookbody` = 68, `lookfeet` = 76, `lookhead` = 78, `looklegs` = 39, `looktype` = 128, `lookaddons` = 0, `maglevel` = 0, `mana` = 35, `manamax` = 35, `manaspent` = 0, `soul` = 100, `town_id` = 1, `posx` = 157, `posy` = 54, `posz` = 7, `cap` = 435, `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` = 1405903855, `blessings` = 0, `marriage` = 0, `vocation` = 2 WHERE `id` = 19 LIMIT 1; - MYSQL ERROR: Unknown column 'castViewers' in 'field list' (1054)
[20:50:55.456] Error while saving player: Loucura.

-

 

Meu servidor é linux e deu esse erro depois que troquei a DB , parece que faltam colunas. Ai quando desloga o char no game ele não salva e fica tudo voltando do começo.

Editado Julho 21, 2014 10 anos por junimvrb (veja o histórico de edições)

vai na database, em players, exclue o player loucura

Ta faltando query veja isso: http://www.tibiaking.com/forum/topic/33611-tutorial-resolvendo-qualquer-erro-na-data-base/

MYSQL ERROR: Unknown column 'castViewers' in 'field list' (1054) . Meu erro é esse, não encontrei no link esse erro. 

 

Obgd

Problema no sistema castsystem para php se tera que revisar o erro e arrumar.