• 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!

Database help - select clause not working

croix

Member
Joined
Aug 26, 2011
Messages
123
Reaction score
13
Please help me, I've tried adding
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 :D

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)
 
Back
Top