Mysql request error (REEEP ++) with pic

[Calon]

i got a problem with mysql here is pic

Imageshack - eroor.png

I GIVE REp

 

[DextaaH]

Its something about guild lines in your database, idk what it is :/ But maybe if you add again just guild file in database?

 

[Calon]

so how i can fix it ?

 

[lol94]

I think this is the correct script:

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;

 

[Calon]

I think this is the correct script:

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;

#1050 - Table 'guild_invites' already exists

 

[Don Shotta]

Remove the old table of guild_invites and then do that query

 

[Korrex]

#1050 - Table 'guild_invites' already exists

DELETE TABLE `guild_invites`;

Run this before.

 

[Calon]

DELETE TABLE `guild_invites`;

Run this before.

still not working im getting same bug

 

[Kayan]

it's a reference to guilds, read the error, drop all related with guilds e create the tables again.