Lua arenaroom & guild invites, help!

[Glidarn]

Hello, so this is my problem i don't really know what it is but maybe you know how to solve it?

http://img51.imageshack.us/i/guildinvites.png/

tried

CREATE TABLE `guild_invites`
(
	`player_id` INT NOT NULL DEFAULT 0,
	`guild_id` INT NOT NULL DEFAULT 0,
	UNIQUE (`player_id`, `guild_id`),
	FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE,
	FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

but then i got this

#1050 - Table 'guild_invites' already exists

anyone?

 

[Glidarn]

Bring
Up
My
Post

 

[Cykotitan]

The player has been invited to a non-existent guild, perhaps?

 

[Glidarn]

The player has been invited to a non-existent guild, perhaps?

kinda figured it was something like that, but its spamming my console and shouldnt that query be working then?

 

[Glidarn]

bump

 

[Glidarn]

bump :/

 

[Glidarn]

bump

 

[Cykotitan]

Create a guild with the correct id, or delete the invites for that player.