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:
here is the sql query to create the table from subversion but it does not work for me..
i keep getting error #1005 - Can't create table 'ksdunlapotserv.tile_items' (errno: 150) (Supports transactions, row-level locking, and foreign keys)
*edit SOLVED
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: