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

Error in table tile_store and tiles

bobmateus

New Member
Joined
Aug 7, 2012
Messages
15
Reaction score
0
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:erro.jpg

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:
Back
Top