• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

Tilles error MYSQL

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

DROP TABLE IF EXISTS tiles;
CREATE TABLE tiles
(
id INT UNSIGNED NOT NULL,
world_id TINYINT(4) UNSIGNED NOT NULL DEFAULT 0,
house_id INT UNSIGNED NOT NULL,
x INT(5) UNSIGNED NOT NULL,
y INT(5) UNSIGNED NOT NULL,
z TINYINT(2) UNSIGNED NOT NULL,
UNIQUE (id, world_id),
KEY (x, y, z),
FOREIGN KEY (house_id, world_id) REFERENCES houses(id, world_id) ON DELETE CASCADE
) ENGINE = InnoDB;
 
Back
Top