Vendeliko
Banned User
- Joined
- Dec 3, 2011
- Messages
- 3,087
- Reaction score
- 90
Hey guys,tried adding war system today to my server and when inviting a player I get
and nothing happens in game.
When trying to execute required db stuff I get this
and in guild_wars there is only 3 tables, id,guild_id and enemy_id and I can not delete them or the whole guild_wars
because it says it was succesful but they are still there.
Hope someone can please help me quickly.
Thanks in advance,
Vendeliko.
Code:
[19:47:37.974] mysql_real_query(): SELECT `guild_id`, `status` FROM `guild_wars` WHERE `guild_id` IN (3,4) AND `enemy_id` IN (4,3) AND `status` IN (0, 1) - MYSQL ERROR: Unknown column 'status' in 'field list' (1054)
[19:47:37.974] [Error - TalkAction Interface]
[19:47:37.974] data/talkactions/scripts/war.lua:onSay
[19:47:37.974] Description:
[19:47:37.974] data/talkactions/scripts/war.lua:133: attempt to call field 'executeQuery' (a nil value)
[19:47:37.974] stack traceback:
[19:47:37.974] data/talkactions/scripts/war.lua:133: in function <data/talkactions/scripts/war.lua:1>
and nothing happens in game.
When trying to execute required db stuff I get this
Code:
Error
Zapytanie SQL:
ALTER TABLE `guild_wars` ADD CONSTRAINT `guild_wars_ibfk_1` FOREIGN KEY ( `guild_id` ) REFERENCES `guilds` ( `id` ) ON DELETE CASCADE ,
ADD CONSTRAINT `guild_wars_ibfk_2` FOREIGN KEY ( `enemy_id` ) REFERENCES `guilds` ( `id` ) ON DELETE CASCADE ;
MySQL zwrócił komunikat: Dokumentacja
#1005 - Can't create table 'prodatebasename.#sql-5c9_1586' (errno: 121) (Szczegóły...)
and in guild_wars there is only 3 tables, id,guild_id and enemy_id and I can not delete them or the whole guild_wars
because it says it was succesful but they are still there.
Hope someone can please help me quickly.
Thanks in advance,
Vendeliko.