Lua Problem with players_killers

[bolero]

How I can delete all rows of this tables without delete the table called players_killers? ^_^

Help urgent pls.

 

[Sonical]

First

DROP TABLE IF EXISTS `player_killers`;

and then

CREATE TABLE `player_killers`
(
	`kill_id` INT NOT NULL,
	`player_id` INT NOT NULL,
	FOREIGN KEY (`kill_id`) REFERENCES `killers`(`id`) ON DELETE CASCADE,
	FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

<<REP++>>

 

[bolero]

 DROP TABLE IF EXISTS `players_killers`;
[Err] 1217 - Cannot delete or update a parent row: a foreign key constraint fails

 

[VirrageS]

Hmm try this:

DELETE FROM player_killers WHERE 0<player_id<1246468428;

 

[Sonical]

 DROP TABLE IF EXISTS `players_killers`;
[Err] 1217 - Cannot delete or update a parent row: a foreign key constraint fails[/QUOTE]
 
Then drop it manually, btw. your server must be offline! For me it works.

 

[bolero]

Ok, this worked, but now I need remove the table called "killers" bro :/

Say this:

 DROP TABLE IF EXISTS `killers`;
[Err] 1217 - Cannot delete or update a parent row: a foreign key constraint fails

 

[VirrageS]

Are you trying to drop it manualy ???

 

[president vankk]

TRUNCATE TABLE `player_killers`

or drop it manualy

 

[bolero]

I have navicat for mysql, I delete the table and I can't .. Look

 

[VirrageS]

Select table "killers" and click button "Delete Table". Maybe it will works.

 

[Sonical]

Drop it manually and then

CREATE TABLE `killers`
(
	`id` INT NOT NULL AUTO_INCREMENT,
	`death_id` INT NOT NULL,
	`final_hit` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,
	`unjustified` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,
	PRIMARY KEY (`id`),
	FOREIGN KEY (`death_id`) REFERENCES `player_deaths`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

 

[bolero]

I CAN'T DELETEEEEEEEE!!! SAY ERROR ...........


Look the photo :S

 

[VirrageS]

So I don't know

Try:

DELETE FROM killers WHERE 0<=unjustified<2;

DROP TABLE IF EXISTS `killers`;

 

[Sonical]

I CAN'T DELETEEEEEEEE!!! SAY ERROR ...........


Look the photo :S

How did you deleted the first one then?

 

[bolero]

Now My web doesn't work and the server crash by this:
[16:46:00.743] mysql_real_query(): INSERT INTO `killers` (`death_id`, `final_hit`, `unjustified`, `war`) VALUES (1, 1, 0, 0) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`mistic`.`killers`, CONSTRAINT `killers_ibfk_1` FOREIGN KEY (`death_id`) REFERENCES `players_killers` (`id`) ON DELETE CASCADE) (1452)