PandemonBR
New Member
- Joined
- Mar 7, 2019
- Messages
- 2
- Reaction score
- 0
I have the error in msyql every time it reloads the server goes into maintenance, or every time you reboot it does not close and it does appear a lot of error so
TILES Cannot add or update a parent row: a foreign key constraint fails MYSQL
tiles and my table is using this
TILES Cannot add or update a parent row: a foreign key constraint fails MYSQL
tiles and my table is using this
DROP TABLE IF EXISTStiles;
CREATE TABLEtiles
(
idINT UNSIGNED NOT NULL,
world_idTINYINT(4) UNSIGNED NOT NULL DEFAULT 0,
house_idINT UNSIGNED NOT NULL,
xINT(5) UNSIGNED NOT NULL,
yINT(5) UNSIGNED NOT NULL,
zTINYINT(2) UNSIGNED NOT NULL,
UNIQUE (id,world_id),
KEY (x,y,z),
FOREIGN KEY (house_id,world_id) REFERENCEShouses(id,world_id) ON DELETE CASCADE
) ENGINE = InnoDB;