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

Solved [SQL] Problem creating table tile_items

sharpy

New Member
Joined
Jan 4, 2010
Messages
77
Reaction score
0
I am using TFS 0.3.6 and on server save i get these errors:

Code:
[11/07/2013 18:15:42] mysql_real_query(): DELETE FROM `tile_items` WHERE `world_id` = 0 - MYSQL ERROR: Table 'ksdunlapotserv.tile_items' doesn't exist (1146)
[11/07/2013 18:15:42] mysql_real_query(): DELETE FROM `tile_items` WHERE `world_id` = 0 - MYSQL ERROR: Table 'ksdunlapotserv.tile_items' doesn't exist (1146)
[11/07/2013 18:15:42] mysql_real_query(): DELETE FROM `tile_items` WHERE `world_id` = 0 - MYSQL ERROR: Table 'ksdunlapotserv.tile_items' doesn't exist (1146)

here is the sql query to create the table from subversion but it does not work for me..

Code:
CREATE TABLE `tile_items`
(
        `tile_id` INT UNSIGNED NOT NULL,
        `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
        `sid` INT NOT NULL,
        `pid` INT NOT NULL DEFAULT 0,
        `itemtype` INT NOT NULL,
        `count` INT NOT NULL DEFAULT 0,
        `attributes` BLOB NOT NULL,
        UNIQUE (`tile_id`, `world_id`, `sid`), KEY (`sid`),
        FOREIGN KEY (`tile_id`) REFERENCES `tiles`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;


i keep getting error #1005 - Can't create table 'ksdunlapotserv.tile_items' (errno: 150) (Supports transactions, row-level locking, and foreign keys)

*edit SOLVED
 
Last edited:
Back
Top