Windows Guild wars error in console!

[jo31]

i get this error in console when 2 people from different guilds is in guild wars and killing eachother.

[Error - mysql_store_result] Query: SELECT `id` FROM `znote_guild_wars` WHERE `status` = 1 AND ((`guild1` = 1 AND `guild2` = 3) OR (`guild1` = 3 AND `guild2` = 1))
Message: Unknown column 'status' in 'where clause'

TFS 1.3
Znote AAC, Phpmyadmin

 

[jo31]

And also on my website i see 0-0 in killings between the guilds even if they has been killing eachother.

 

[jo31]

Bump!

Post automatically merged: Apr 20, 2020

@Znote
I use ZnoteAAC aswell.
Can you help?

 

[jo31]

@Anciaveus

 

[jo31]

Bump!

 

[jo31]

@roriscrave

Post automatically merged: May 1, 2020

[Error - mysql_real_query] Query: SELECT `id` FROM `znote_guild_wars` WHERE `status` = 1 AND ((`guild1` = 1 AND `guild2` = 3) OR (`guild1` = 3 AND `guild2` = 1))
Message: Unknown column 'status' in 'where clause'
[Error - mysql_store_result] Query: SELECT `id` FROM `znote_guild_wars` WHERE `status` = 1 AND ((`guild1` = 1 AND `guild2` = 3) OR (`guild1` = 3 AND `guild2` = 1))
Message: Unknown column 'status' in 'where clause'
After Sorcerer has logged out.

Lua Script Error: [Main Interface]
in a timer event called from:
(Unknown scriptfile)
data/creaturescripts/scripts/randomstats.lua:138: attempt to index local 'it_u' (a nil value)
stack traceback:
        [C]: in function '__index'
        data/creaturescripts/scripts/randomstats.lua:138: in function 'assign_loot_Stat'
        data/creaturescripts/scripts/randomstats.lua:140: in function 'assign_loot_Stat'
        data/creaturescripts/scripts/randomstats.lua:252: in function <data/creaturescripts/scripts/randomstats.lua:247>

I get this error in console when players in Guild Wars kill eachother

 

[Adorius Black]

try execute this code in your database:

ALTER TABLE `where clause` ADD `status` tinyint(2) NOT NULL DEFAULT '0';

 

[Softman]

Adorius Black
Do you can help Me about Guild war
have a problem 2 day no one can help me?