Error when character logs in

[Xeo]

Well its actually when its triying to log in :
We are using Nicaw's account page.We tested it making an account,then a character...all works fine..until you try to log in

a Message in the tibia client appears saying

Sorry

Your character could not be loaded.

And in the console of the server
(btw: its forgotten 0.3.4)

this error :

[08/10/2009 14:09:24] mysql_real_query(): INSERT INTO `server_motd` (`id`, `world_id`, `text`) VALUES (1, 0, 'Welcome to TibiaRox'); - MYSQL ERROR: Duplicate entry '1-0' for key 'id' (1062)
[08/10/2009 14:09:27] 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` = 'Felipe' AND `world_id` = 0 AND `deleted` = 0; - MYSQL ERROR: Unknown column 'redskulltime' in 'field list' (1054)
[08/10/2009 14:09:35] 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` = 'Lord\'Paulisthima' AND `world_id` = 0 AND `deleted` = 0; - MYSQL ERROR: Unknown column 'redskulltime' in 'field list' (1054)
its very frustrating.
=/
If someone knows how to fix this please reply
Thanks.

 

[XMarkoX]

Are you sure that you havent screwed up something from the MOTD, cuz it duplicates something, just a guess though, make sure you havent forgotten anythin from config

 

[Acubens]

Delete motd-> Welcome to TibiaRox in the table "server_motd" to fix the first error

and for this

[08/10/2009 01:33:33] mysql_real_query(): SELECT `id`, `account_id`, `group_id`, `sex`, `vocation`, `experience`, `level`, `maglevel`, `health`, `healthmax`, `blessings`, `mana`, `manamax`, `manaspent`, `soul`,

put complete the error

 

[Xeo]

This is the whole error

[08/10/2009 13:32:56] 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`, `guil

 

[Master-m]

This is the whole error

[08/10/2009 13:32:56] 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`, `guil

no it isn't. how can it end with "guil" ? ;S

 

[Xeo]

Sorry, this is the whole error

[08/10/2009 14:09:24] mysql_real_query(): INSERT INTO `server_motd` (`id`, `world_id`, `text`) VALUES (1, 0, 'Welcome to TibiaRox'); - MYSQL ERROR: Duplicate entry '1-0' for key 'id' (1062)
[08/10/2009 14:09:27] 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` = 'Felipe' AND `world_id` = 0 AND `deleted` = 0; - MYSQL ERROR: Unknown column 'redskulltime' in 'field list' (1054)
[08/10/2009 14:09:35] 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` = 'Lord\'Paulisthima' AND `world_id` = 0 AND `deleted` = 0; - MYSQL ERROR: Unknown column 'redskulltime' in 'field list' (1054)

 

[Master-m]

Update your sql table.