croix
Member
- Joined
- Aug 26, 2011
- Messages
- 123
- Reaction score
- 13
Please help me, I've tried adding
But then I just get a new error lol
Code:
CREATE TABLE `tiles`
(
`house_id` INT UNSIGNED NOT NULL,
`world_id` TINYINT(4) UNSIGNED NOT NULL DEFAULT 0,
`data` LONGBLOB NOT NULL,
FOREIGN KEY (`house_id`) REFERENCES `houses` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB;
But then I just get a new error lol
Lua:
[17/12/2020 23:12:27] mysql_real_query(): SELECT * FROM `tiles` WHERE `house_id` = 1 AND `world_id` = 0 - MYSQL ERROR: Table 'otserv.tiles' doesn't exist (1146)
[17/12/2020 23:12:27] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 980 AND `y` = 1002 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'otserv.tiles' doesn't exist (1146)
[17/12/2020 23:12:27] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 981 AND `y` = 1002 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'otserv.tiles' doesn't exist (1146)
[17/12/2020 23:12:27] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 981 AND `y` = 1003 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'otserv.tiles' doesn't exist (1146)
[17/12/2020 23:12:27] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 982 AND `y` = 1002 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'otserv.tiles' doesn't exist (1146)
[17/12/2020 23:12:27] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 982 AND `y` = 1003 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'otserv.tiles' doesn't exist (1146)
[17/12/2020 23:12:27] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 983 AND `y` = 1002 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'otserv.tiles' doesn't exist (1146)
[17/12/2020 23:12:27] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 983 AND `y` = 1003 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'otserv.tiles' doesn't exist (1146)
[17/12/2020 23:12:27] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 984 AND `y` = 1002 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'otserv.tiles' doesn't exist (1146)
[17/12/2020 23:12:27] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 984 AND `y` = 1003 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'otserv.tiles' doesn't exist (1146)
[17/12/2020 23:12:27] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 985 AND `y` = 1002 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'otserv.tiles' doesn't exist (1146)
[17/12/2020 23:12:27] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 985 AND `y` = 1003 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'otserv.tiles' doesn't exist (1146)
[17/12/2020 23:12:27] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 986 AND `y` = 1002 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'otserv.tiles' doesn't exist (1146)
[17/12/2020 23:12:27] mysql_real_query(): SELECT `id` FROM `tiles` WHERE `x` = 986 AND `y` = 1003 AND `z` = 7 AND `world_id` = 0 LIMIT 1 - MYSQL ERROR: Table 'otserv.tiles' doesn't exist (1146)