Phpmyadmin problem

[Samaster]

Hey guys, i have a problem when importing my database (0.3) to Uniserver and this error comes up:
"
Error
SQL query:

DROP TABLE IF EXISTS `houses` ;

MySQL said:

#1217 - Cannot delete or update a parent row: a foreign key constraint fails
"

Can someone help me solve this please?

 

[Samaster]

Pls?

 

[Elvang]

SET FOREIGN_KEY_CHECKS=0;

before: DROP TABLE IF EXISTS `houses` ;

 

[Samaster]

what are you suggesting i do to fix it?

 

[seleo]

just use this command in your phpmyadmin page
choose sql and send this commands

SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `houses`;
SET FOREIGN_KEY_CHECKS=1;

 

[Samaster]

SQL query:

CREATE TABLE `house_auctions` (

`house_id` INT UNSIGNED NOT NULL ,
`world_id` TINYINT( 2 ) UNSIGNED NOT NULL DEFAULT 0,
`player_id` INT NOT NULL ,
`bid` INT UNSIGNED NOT NULL DEFAULT 0,
`limit` INT UNSIGNED NOT NULL DEFAULT 0,
`endtime` BIGINT UNSIGNED NOT NULL DEFAULT 0,
UNIQUE (
`house_id` ,
`world_id`
),
FOREIGN KEY ( `house_id` , `world_id` ) REFERENCES `houses` ( `id` , `world_id` ) ON DELETE CASCADE ,
FOREIGN KEY ( `player_id` ) REFERENCES `players` ( `id` ) ON DELETE CASCADE)ENGINE=INNODB;



MySQL said:

#1050 - Table 'house_auctions' already exists



damn these errors:<

 

[Samaster]

okay i fixed it but when i open theforgottenserver64bit and gets to load SQL (or whatever) my program 'stops working' ??

 

[Samaster]

dont worry i have fixed it, SOLVED