MYSQL ERROR: Table 'otserver.tile_store' doesn't exist (1146

[Ashbringer]

mysql_real_query(): SELECT `house_id`, `data` FROM `tile_store` WHERE `world_id` = 0 - MYSQL ERROR: Table 'otserver.tile_store' doesn't exist (1146)

 

[RosOT]

Execute this query into database. Should fix your problem btw use search / google it always helps on most of these error's/good day.

CREATE TABLE `tile_store`
(
`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;

 

[Ashbringer]

Execute this query into database. Should fix your problem btw use search / google it always helps on most of these error's/good day.

CREATE TABLE `tile_store`
(
`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;

thanks for trying but i get this error

CREATE TABLE `tile_store`
(
`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



MySQL said:

#1146 - Table 'otserver.tile_store' doesn't exist