MySql Error

[RunarM]

I get this erron on my Forgottenserver.exe:
Im using the forgotten server 0.3.4 PL2

[08/08/2009 15:46:59] 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` = 'Maku' AND `world_id` = 0 AND `deleted` = 0; - MYSQL ERROR: Unknown column 'redskulltime' in 'field list' (1054)
[08/08/2009 15:47:02] 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` = 'Maku the third' AND `world_id` = 0 AND `deleted` = 0; - MYSQL ERROR: Unknown column 'redskulltime' in 'field list' (1054)

Also i get this:

[08/08/2009 15:53:36] Lua Script Error: [GlobalEvent Interface] 
[08/08/2009 15:53:36] data/globalevents/scripts/shop.lua:onThink

[08/08/2009 15:53:36] luaResultFree(). Result not found.

[08/08/2009 15:53:36] Lua Script Error: [GlobalEvent Interface] 
[08/08/2009 15:53:36] data/globalevents/scripts/broadcast.lua:onThink

[08/08/2009 15:53:36] luaResultFree(). Result not found.

How can i fix that oO?

Thanks for the help,
Runarm.

 

[Red]

Try dropping your database and re-importing it via SQL Query.. unless your server is already running, then that'd be bad.

 

[RunarM]

My server is already running xD
Can it be that i tried to make the server 8.5 and then changed back to 8.42?

 

[Kayan]

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

Add back column redskulltime.

 

[GMBear]

post the scripts like this

in this kinda php thingyu

then i can see why those dont work

 

[Xonorc]

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