Windows MySql

[3mR]

mysql_real_query(): SELECT `id`, `account_id`, `group_id`, `world_id`, `sex`, `v
ocation`, `experience`, `level`, `maglevel`, `health`, `healthmax`, `mana`, `man
amax`, `manaspent`, `soul`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `loo
ktype`, `lookaddons`, `posx`, `posy`, `posz`, `cap`, `lastlogin`, `lastlogout`,
`lastip`, `conditions`, `guildnick`, `rank_id`, `town_id`, `balance`, `kills`, `
deaths`, `assists`, `marriage`, `promotion`, `description` FROM `players` WHERE
`name` = 'Sex' AND `world_id` = 0 AND `deleted` = 0 LIMIT 1 - MYSQL ERROR: Unkno
wn column 'kills' in 'field list' (1054)
mysql_real_query(): SELECT `id`, `account_id`, `group_id`, `world_id`, `sex`, `v
ocation`, `experience`, `level`, `maglevel`, `health`, `healthmax`, `mana`, `man
amax`, `manaspent`, `soul`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `loo
ktype`, `lookaddons`, `posx`, `posy`, `posz`, `cap`, `lastlogin`, `lastlogout`,
`lastip`, `conditions`, `guildnick`, `rank_id`, `town_id`, `balance`, `kills`, `
deaths`, `assists`, `marriage`, `promotion`, `description` FROM `players` WHERE
`name` = 'Sex' AND `world_id` = 0 AND `deleted` = 0 LIMIT 1 - MYSQL ERROR: Unkno
wn column 'kills' in 'field list' (1054)
mysql_real_query(): SELECT `id`, `account_id`, `group_id`, `world_id`, `sex`, `v
ocation`, `experience`, `level`, `maglevel`, `health`, `healthmax`, `mana`, `man
amax`, `manaspent`, `soul`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `loo
ktype`, `lookaddons`, `posx`, `posy`, `posz`, `cap`, `lastlogin`, `lastlogout`,
`lastip`, `conditions`, `guildnick`, `rank_id`, `town_id`, `balance`, `kills`, `
deaths`, `assists`, `marriage`, `promotion`, `description` FROM `players` WHERE
`name` = 'Sex' AND `world_id` = 0 AND `deleted` = 0 LIMIT 1 - MYSQL ERROR: Unkno
wn column 'kills' in 'field list' (1054)
mysql_real_query(): SELECT `id`, `account_id`, `group_id`, `world_id`, `sex`, `v
ocation`, `experience`, `level`, `maglevel`, `health`, `healthmax`, `mana`, `man
amax`, `manaspent`, `soul`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `loo
ktype`, `lookaddons`, `posx`, `posy`, `posz`, `cap`, `lastlogin`, `lastlogout`,
`lastip`, `conditions`, `guildnick`, `rank_id`, `town_id`, `balance`, `kills`, `
deaths`, `assists`, `marriage`, `promotion`, `description` FROM `players` WHERE
`name` = 'Owner' AND `world_id` = 0 AND `deleted` = 0 LIMIT 1 - MYSQL ERROR: Unk
nown column 'kills' in 'field list' (1054)

 

[Ninja]

ALTER TABLE `players` ADD `kills` INT NOT NULL DEFAULT 0;

 

[3mR]

Same

Bumb

 

[Ninja]

Remove the field kills from your script if the query you executed in phpMyAdmin didn't work.