[Error] GuildWars

[spinna]

mysql_real_query(): SELECT `id` FROM `guilds` WHERE `in_war_with` > 0 - MYSQL ER
ROR: Unknown column 'in_war_with' in 'where clause' (1054)

[Error - GlobalEvent Interface]
buffer:onThink
Description:
data/lib/database.lua:60: [Result:getDataInt] Result not set!
stack traceback:
        [C]: in function 'error'
        data/lib/database.lua:60: in function 'getDataInt'
        data/lib/050-function.lua:945: in function 'getGuildsWithWar'
        [string "loadBuffer"]:3: in function <[string "loadBuffer"]:2>
[Error - GlobalEvents::think] Couldn't execute event: wars

version:

The Forgotten Server, version 0.3.6_SVN (Crying Damson)
Compiled with GNU C++ version 3.4.5 (mingw special) at Dec 19 2009, 09:10:06.
A server developed by Elf, slawkens, Talaturen, KaczooH, Lithium, Kiper, Kornhol
ijo.
Visit our forum for updates, support and resources: http://otland.net.

>> Loading config (config.lua)
> Using plaintext encryption
>> Checking software version... outdated, please consider updating!
> Current version information - version: 0.3.6_SVN, patch: 0, build: 0, timestam
p: 0.
> Latest version information - version: 0.3.6, patch: 0, build: 3293,~

 

[chojrak]

Here's the answer:

ROR: Unknown column 'in_war_with' in 'where clause' (1054)

 

[spinna]

and what do i do with said answer, is there an easy fix? say enter in sql and be done?

 

[chojrak]

Just add that field in table ;p.

 

[spinna]

ive never done that successfully lol
point me to a short tutorial! haha just kidding, now to search -.-


server need to be off to fix?

 

[chojrak]

not really ;p

 

[spinna]

ok i added table, got any idea how long it takes the server to execute this guildwars? i know its a little while after being online

 

[chojrak]

Depends what type of event is it.

 

[spinna]

> Broadcasted message: "Server saved".
> Saving server...
> SAVE: Complete in 3.734 seconds using binary house storage.
> Broadcasted message: "Information: Remember to visit the forum for the latest
information about released patches".
mysql_real_query(): SELECT `id` FROM `guilds` WHERE `in_war_with` > 0 - MYSQL ER
ROR: Unknown column 'in_war_with' in 'where clause' (1054)

[Error - GlobalEvent Interface]
buffernThink
Description:
data/lib/database.lua:60: [Result:getDataInt] Result not set!
stack traceback:
[C]: in function 'error'
data/lib/database.lua:60: in function 'getDataInt'
data/lib/050-function.lua:945: in function 'getGuildsWithWar'
[string "loadBuffer"]:3: in function <[string "loadBuffer"]:2>
[Error - GlobalEvents::think] Couldn't execute event: wars

 

[chojrak]

You're doing it wrong lol;p

 

[Chriistian.L.B]

Error topic, sorry !

 

[spinna]

@ up..
@ topic: like I said, ive never done it.. im thinking of just removing the xml and move on lol