error in console tfs 0.4

[Yaboihunna]

i need the query to add guild stuff in sql i think

[6:18:15.542] > Trigger: oncreate_guilds does not exist, creating it...
[6:18:15.586] mysql_real_query(): CREATE TRIGGER oncreate_guilds AFTER INSERT ON guilds FOR EACH ROW BEGIN INSERT INTO guild_ranks (name, level, guild_id) VALUES ('Leader', 3, NEW.id); INSERT INTO guild_ranks (name, level, guild_id) VALUES ('Vice-Leader', 2, NEW.id); INSERT INTO guild_ranks (name, level, guild_id) VALUES ('Member', 1, NEW.id); END; - MYSQL ERROR: Table 'venorewar.guilds' doesn't exist (1146)
[6:18:16.376] > Trigger: ondelete_guilds does not exist, creating it...
[6:18:16.475] mysql_real_query(): CREATE TRIGGER ondelete_guilds BEFORE DELETE ON guilds FOR EACH ROW BEGIN UPDATE players SET guildnick = '', rank_id = 0 WHERE rank_id IN (SELECT id FROM guild_ranks WHERE guild_id = OLD.id); END; - MYSQL ERROR: Table 'venorewar.guilds' doesn't exist (1146)

 

[Znote]

You are missing the guilds table. Have you imported the correct mysql schema to your database?

 

[Yaboihunna]

yeah I did ;p I think I can execute a query in sql to fix? player loses vocation on logout with that error

 

[Catalyst]

yeah I did ;p I think I can execute a query in sql to fix? player loses vocation on logout with that error

DROP TRIGGER IF EXISTS oncreate_guilds;

CREATE TRIGGER oncreate_guilds AFTER INSERT ON guilds
FOR EACH ROW BEGIN
INSERT INTO guild_ranks (name, level, guild_id) VALUES ('the Leader', 3, NEW.id);
INSERT INTO guild_ranks (name, level, guild_id) VALUES ('a Vice-Leader', 2, NEW.id);
INSERT INTO guild_ranks (name, level, guild_id) VALUES ('a Member', 1, NEW.id);
END


Try this.