Solved Table tiles doesn't exist

[simson361]

got this error and the server starts up but this error keep coming in 1 minit then it starts :/

 

[vTune]

Sorry to small/bad quality picture cant read the error

 

[simson361]

Hur göt jag den större? :/ har du skype?

- - - Updated - - -

 

[vTune]

Hur göt jag den större? :/ har du skype?

- - - Updated - - -

Try uploading the pic to imgur and edit the first post with URL

 

[simson361]

thats better? ^^

 

[vTune]

Yes its better^^

You need to add table tibiaot.tiles

But I searched on the forum on this error and from what I could see it's easier for you to just change engine...

 

[simson361]

i have another engine but u know how to make a new table like that? (im new on this) and is it very important to have that table if i dont have it what will happen?

 

[vTune]

Try run this query

CREATE TABLE `tiles`
(
	`id` INT UNSIGNED NOT NULL,
	`world_id` TINYINT(2) 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;
 
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;

 

[simson361]

i FUCKING love you and will forever love you brother. thax for the help! <3

- - - Updated - - -

by the way it worked fine! epic thx alot.!! ^^

 

[vTune]

i FUCKING love you and will forever love you brother. thax for the help! <3

- - - Updated - - -

by the way it worked fine! epic thx alot.!! ^^

np glad I could help

 

[simson361]

indeed you did! and it worked just fine now big thx to you my friend! :w00t:

- - - Updated - - -

can you help me find a table for house aswell? :/ says this


- - - Updated - - -

can you help me fix table for house /i think its what it needs atleast

- - - Updated - - -


can u fix table for house aswell? ^_^

 

[seleo]

this is for house_lists

CREATE TABLE `house_lists`
(
	`house_id` INT UNSIGNED NOT NULL,
	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
	`listid` INT NOT NULL,
	`list` TEXT NOT NULL,
	UNIQUE (`house_id`, `world_id`, `listid`),
	FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE
) ENGINE = InnoDB;