Solved MYSQL Problem.

[kostas136]

When a player dies this comes up in console i use tfs 3884 8.60
-----------------------------------------------------------------------------------------REP+++ For help!

2:3:54.769] mysql_real_query(): UPDATE `players` SET `lastlogin` = 1455843809, `lastip` = 191
4656514, `level` = 12, `group_id` = 1, `health` = 205, `healthmax` = 205, `experience` = 22272
, `lookbody` = 114, `lookfeet` = 114, `lookhead` = 114, `looklegs` = 114, `looktype` = 134, `l
ookaddons` = 1, `maglevel` = 52, `mana` = 155, `manamax` = 155, `manaspent` = 91077, `soul` =
100, `town_id` = 1, `posx` = 999, `posy` = 999, `posz` = 7, `cap` = 475, `sex` = 1, `balance`
= 0, `stamina` = 151200000, `cast` = 0, `castViewers` = 0, `castDescription` = '', `skull` = 0
, `skulltime` = 0, `promotion` = 1, `conditions` = '', `loss_experience` = 70, `loss_mana` = 0
, `loss_skills` = 100, `loss_containers` = 0, `loss_items` = 0, `lastlogout` = 1455768316, `bl
essings` = 0, `marriage` = 0, `vocation` = 1 WHERE `id` = 88 LIMIT 1; - MYSQL ERROR: Unknown c
olumn 'castViewers' in 'field list' (1054)
[2:3:54.772] mysql_real_query(): UPDATE `players` SET `lastlogin` = 1455843809, `lastip` = 191
4656514, `level` = 12, `group_id` = 1, `health` = 205, `healthmax` = 205, `experience` = 22272
, `lookbody` = 114, `lookfeet` = 114, `lookhead` = 114, `looklegs` = 114, `looktype` = 134, `l
ookaddons` = 1, `maglevel` = 52, `mana` = 155, `manamax` = 155, `manaspent` = 91077, `soul` =
100, `town_id` = 1, `posx` = 999, `posy` = 999, `posz` = 7, `cap` = 475, `sex` = 1, `balance`
= 0, `stamina` = 151200000, `cast` = 0, `castViewers` = 0, `castDescription` = '', `skull` = 0
, `skulltime` = 0, `promotion` = 1, `conditions` = '', `loss_experience` = 70, `loss_mana` = 0
, `loss_skills` = 100, `loss_containers` = 0, `loss_items` = 0, `lastlogout` = 1455768316, `bl
essings` = 0, `marriage` = 0, `vocation` = 1 WHERE `id` = 88 LIMIT 1; - MYSQL ERROR: Unknown c
olumn 'castViewers' in 'field list' (1054)

 

[godoyxd]

here is your error MYSQL ERROR: Unknown c
olumn 'castViewers' in 'field list' (1054)

do you have castViewers column in the players table?
if you don't you should add it

 

[kostas136]

how do i get it and where do i add it?

 

[Codex NG]

how do i get it and where do i add it?

https://otland.net/threads/sample-error.218733/#post-2100814

 

[narko]

Run this query:

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

 

[Codex NG]

Run this query:

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

That will generate an error, it should just be this

ALTER TABLE  `players` ADD `castViewers` INT( 11 ) NOT NULL DEFAULT  '0';

Of course what you posted is what I linked to, but I wanted them to read the remaining of the thread

 

[kostas136]

thx everyone aldrey fixed.