MySQL error: Unknown column loss_experience

[tanii]

mysql_real_query(): SELECT `id`, `account_id`, `group_id`, `world_id`, `sex`, `vocation`, `experience`, `level`, `maglevel`, `health`, `healthmax`, `blessings`, `mana`, `manamax`, `manaspent`, `soul`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `posx`, `posy`, `posz`, `cap`, `lastlogin`, `lastlogout`, `lastip`, `conditions`, `skull`, `skulltime`, `guildnick`, `rank_id`, `town_id`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `marriage`, `promotion`, `description` FROM `players` WHERE `name` = 'GOD' AND `world_id` = 0 AND `deleted` = 0 LIMIT 1 - MYSQL ERROR: Unknown column 'loss_experience' in 'field list' (1054)

 

[Amiroslo]

Wrong section, next time post it here https://otland.net/forums/support.16/

try to add this in mysql

ALTER TABLE `players` ADD `loss_experience` VARCHAR( 500 ) NOT NULL ;

 

[WibbenZ]

Wrong section, next time post it here https://otland.net/forums/support.16/

try to add this in mysql

ALTER TABLE `players` ADD `loss_experience` VARCHAR( 500 ) NOT NULL ;

He is not doing it correctly, that is why he got that error.
To make it even easier for you, the file is here: http://skalski.at/files/files/thaiswar860_with_bots/view/war.sql
Do as the thread said IMPORT the schema insted of using your own.

 

[tanii]

Wrong section, next time post it here https://otland.net/forums/support.16/

try to add this in mysql

ALTER TABLE `players` ADD `loss_experience` VARCHAR( 500 ) NOT NULL ;

not working same problem