Hello, i want to update my otserver to tfs 0.4 ( i use tfs 0.3.6 ), but, when i starts the otserver i have an error in the table tile_store, the items of the houses doesn't appears.
I'm using tables of my server, with uses tfs 0.3.6, when i use this tables on tfs 0.4 e get this error.
error:
When i try create tile_store in mysql, i have this error:
and when i try create tiles, i have this error:
Who can i use my tables ( of tfs 0.3.6 ) on tfs 0.4 ? Only problem is on tile_store
I'm using tables of my server, with uses tfs 0.3.6, when i use this tables on tfs 0.4 e get this error.
error:
When i try create tile_store in mysql, i have this error:
#1050 - Table '`otserv`.`tile_store`' already exists
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;
and when i try create tiles, i have this error:
#1050 - Table 'tiles' already exists
CREATE TABLE `tiles` (
`id` INT UNSIGNED NOT NULL ,
`world_id` TINYINT( 4 ) UNSIGNED NOT NULL DEFAULT 0,
`house_id` INT UNSIGNED NOT NULL ,
`x` INT( 5 ) UNSIGNED NOT NULL ,
`y` INT( 5 ) UNSIGNED NOT NULL ,
`z` TINYINT( 2 ) UNSIGNED NOT NULL ,
UNIQUE (
`id` ,
`world_id`
),
KEY ( `x` , `y` , `z` ) ,
FOREIGN KEY ( `house_id` , `world_id` ) REFERENCES `houses` ( `id` , `world_id` ) ON DELETE CASCADE
) ENGINE = INNODB
Who can i use my tables ( of tfs 0.3.6 ) on tfs 0.4 ? Only problem is on tile_store
Last edited: