Mysql Debug

[malakam]

Hi İ Have A Problem With Real Map

İ have a real map and website i opened a character in website and when i want to login in my ot "Your Character Could Not Be Loaded" <<<


and
[31/01/2010 14:45:21] mysql_real_query(): SELECT `id`, `account_id`, `group_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`, `redskulltime`, `redskull`, `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` = 'Baba' AND `world_id` = 0 AND `deleted` = 0; - MYSQL ERROR: Unknown column 'redskulltime' in 'field list' (1054)

Please HElp ME ! !

 

[AchTung]

MYSQL ERROR: Unknown column 'redskulltime' in 'field list' (1054)

Doesn't it say all???

 

[malakam]

yes

 

[lollimpo]

Your character could not be loaded...
help!!!

 

[Cronox]

goto yourip/phpmyadmin
SQL and use this querys

ALTER TABLE `players` ADD `redskulltime` BIGINT NOT NULL DEFAULT 0; 
ALTER TABLE `players` ADD `redskull` SMALLINT NOT NULL DEFAULT 0;