Lua Otserver.tiles Problem!

[manninho]

when i try open my server, i get this

mysql_real_query():SELECT´id'FROM'tiles'WHERE`x` =1007 AND `Y`956 AND 7 world_id otserver.tiles doesnt not exist!

i get that loads of times, spamming my consol!

Help please! I will rep!

 

[Grehy]

Delete that tile in your map editor

 

[Simoria]

i have the same problem any know how to fix it ?

 

[TGYoshi]

That table doesn't exist in your mysql database. Run the creation query of the tiles table from the scheme's file.

 

[Simoria]

I have test . But when I make a new tiles It stands that it allreaddy exist . and when I try to drop It stands that it dont exist :S

 

[Simoria]

#1050 - Table '`Maxat`.`tiles`' already exists

when I try to make a new . :S

 

[TGYoshi]

Your server uses the database 'otserver', not the database 'Maxat'. You might want to change this in the config.lua file.

 

[Simoria]

Now I use maxat . But I posted here Cuz he had the same problem. But Idk :s I cant se the tiles On my database :S And cant add Cuz it stands its allreaddy there .

 

[Ryan6554]

1. CREATE TABLE `tiles`
2. (
3. `id` INT UNSIGNED NOT NULL,
4. `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
5. `house_id` INT UNSIGNED NOT NULL,
6. `x` INT(5) UNSIGNED NOT NULL,
7. `y` INT(5) UNSIGNED NOT NULL,
8. `z` TINYINT(2) UNSIGNED NOT NULL,
9. UNIQUE (`id`, `world_id`),
10. KEY (`x`, `y`, `z`),
11. FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE
12. ) ENGINE = InnoDB;
13. 
    
14. CREATE TABLE `tile_items`
15. (
16. `tile_id` INT UNSIGNED NOT NULL,
17. `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
18. `sid` INT NOT NULL,
19. `pid` INT NOT NULL DEFAULT 0,
20. `itemtype` INT NOT NULL,
21. `count` INT NOT NULL DEFAULT 0,
22. `attributes` BLOB NOT NULL,
23. UNIQUE (`tile_id`, `world_id`, `sid`), KEY (`sid`),
24. FOREIGN KEY (`tile_id`) REFERENCES `tiles`(`id`) ON DELETE CASCADE
25. ) ENGINE = InnoDB;