(Resolvido)Erro na hora de salvar

[junimvrb 20]

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 por junimvrb (veja o histórico de edições)

[Saintsbr 6]

vai na database, em players, exclue o player loucura

[Sr.Samuel 21]

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

[junimvrb 20]

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

 

Obgd

[Sr.Samuel 21]

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

[Rusherzin 527]

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

[junimvrb 20]

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

Parabéns, deu certinho.

Duvida sanada e tópico pode ser colocado como resolvido.

[lelyzinhoxd 0]

aonde eu tenho que colocar esse script ?

[PriisioneR 136]

Execute esse comendo no SQL da sua database  

[alexalex 2]

nao funfa o query

[RAJADAO 2]

[Error - mysql_real_query] Query: UPDATE `players` SET `level` = 8,`group_id` = 3,`vocation` = 1,`health` = 185,`healthmax` = 185,`experience` = 4200,`lookbody` = 106,`lookfeet` = 95,`lookhead` = 78,`looklegs` = 58,`looktype` = 75,`lookaddons` = 0,`maglevel` = 100,`mana` = 40,`manamax` = 4
Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '☺,`lastlogin` = 1681009915,`lastip` = 16777343,`conditions` = '',`skulltime` ...' at line 1
Error while saving player: ADMIN

 

estou com esse erro, alguém pode ajudar ??