Error while saving player Server 8.60

[Luanasar]

Player not saving when loggin out..

[14:50:08.955] Luana has logged out.
[14:50:08.956] mysql_real_query(): UPDATE `players` SET `lastlogin` = 1719856205, `lastip` = 1666138649, `level` = 8, `group_id` = 6, `health` = 185, `healthmax` = 185, `experience` = 4200, `lookbody` = 68, `lookfeet` = 76, `lookhead` = 78, `looklegs` = 39, `looktype` = 302, `lookaddons` = 0, `maglevel` = 0, `mana` = 35, `manamax` = 35, `manaspent` = 0, `soul` = 100, `town_id` = 1, `posx` = 156, `posy` = 49, `posz` = 7, `cap` = 435, `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` = 1719856208, `blessings` = 0, `marriage` = 0, `vocation` = 3 WHERE `id` = 2 LIMIT 1; - MYSQL ERROR: Unknown column 'cast' in 'field list' (1054)
[14:50:08.957] mysql_real_query(): UPDATE `players` SET `lastlogin` = 1719856205, `lastip` = 1666138649, `level` = 8, `group_id` = 6, `health` = 185, `healthmax` = 185, `experience` = 4200, `lookbody` = 68, `lookfeet` = 76, `lookhead` = 78, `looklegs` = 39, `looktype` = 302, `lookaddons` = 0, `maglevel` = 0, `mana` = 35, `manamax` = 35, `manaspent` = 0, `soul` = 100, `town_id` = 1, `posx` = 156, `posy` = 49, `posz` = 7, `cap` = 435, `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` = 1719856208, `blessings` = 0, `marriage` = 0, `vocation` = 3 WHERE `id` = 2 LIMIT 1; - MYSQL ERROR: Unknown column 'cast' in 'field list' (1054)
[14:50:08.959] mysql_real_query(): UPDATE `players` SET `lastlogin` = 1719856205, `lastip` = 1666138649, `level` = 8, `group_id` = 6, `health` = 185, `healthmax` = 185, `experience` = 4200, `lookbody` = 68, `lookfeet` = 76, `lookhead` = 78, `looklegs` = 39, `looktype` = 302, `lookaddons` = 0, `maglevel` = 0, `mana` = 35, `manamax` = 35, `manaspent` = 0, `soul` = 100, `town_id` = 1, `posx` = 156, `posy` = 49, `posz` = 7, `cap` = 435, `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` = 1719856208, `blessings` = 0, `marriage` = 0, `vocation` = 3 WHERE `id` = 2 LIMIT 1; - MYSQL ERROR: Unknown column 'cast' in 'field list' (1054)
[14:50:08.959] Error while saving player: Luana.

 

[Error 502]

two options

• remove the cast part in iologindata.cpp
• add a sql column called "cast"

 

[Luanasar]

View attachment 85782

two options

• remove the cast part in iologindata.cpp
• add a sql column called "cast"

I'm kinda new to sql.. Not sure how to add a column. Can you give an example, please?
Or how do I remove the cast part?

 

[Error 502]

test

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

Value	theoretical type	SQL
cast	numeric (int)	TINYINT(4)
castViewers	numeric(int)	INT(11)
castDescription	string (str)	VARCHAR(255)

 

[Luanasar]

test

View attachment 85786

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

Value	theoretical type	SQL
cast	numeric (int)	TINYINT(4)
castViewers	numeric(int)	INT(11)
castDescription	string (str)	VARCHAR(255)

It worked. Thanks!