Linux Missing tile_store table

[Vrotz]

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

???

 

[Loney]

Query:

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;

By the way: this is the last thread title that I edit for you, next time your post will be deleted without any notification.

 

[Vrotz]

Ahh, excuse for my error. In the near one Im going to specify, was with a lot sleep when I placed.. kkkk

#1005 - Can't create table 'enforced.tile_store' (errno: 150)
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;