Items dont save

[Reese]

I'm using TFS (9.60), Melillandia map, and REM map editor.

I'm having a problem with items on the house floor disappearing after I shut down the server. Almost like they're not "houses" and just outside or something.

The error I get is:

[15/05/2013 16:12:11] mysql_real_query(): SELECT * FROM `tile_items` WHERE `tile_id` = 15844 ORDER BY `sid` DESC;: MYSQL ERROR: Table 'tibia.tile_items' doesn't exist
[15/05/2013 16:12:11] mysql_store_result(): SELECT * FROM `tile_items` WHERE `tile_id` = 15844 ORDER BY `sid` DESC;: MYSQL ERROR: Table 'tibia.tile_items' doesn't exist

Well, that is one of them. This spams my loader.

When I go to shut down the server is gives me this message:

[15/05/2013 16:15:26] mysql_real_query(): DELETE FROM `tile_items`;: MYSQL ERROR: Table 'tibia.tile_items' doesn't exist
[15/05/2013 16:15:26] Notice: Map save (relational) took : 0.151 s
[15/05/2013 16:15:26] mysql_real_query(): DELETE FROM `tile_items`;: MYSQL ERROR: Table 'tibia.tile_items' doesn't exist
[15/05/2013 16:15:26] Notice: Map save (relational) took : 0.152 s
[15/05/2013 16:15:27] mysql_real_query(): DELETE FROM `tile_items`;: MYSQL ERROR: Table 'tibia.tile_items' doesn't exist
[15/05/2013 16:15:27] Notice: Map save (relational) took : 0.147 s

I've tried to
-Take out the map and replace it with another one
-Take out the map and replace it with the same one, just unedited by me
-Have a new "house spawn"

In the map editor, the house squares are a light green on the map I edited (they are usually blue), but since I took the map I edited out, they're now blue again - still doesn't save.

I have a feeling the problem is with my localhost, but I have no idea how to fix this.
-

Edit:
I ended up making another DB for the server because I couldn't figure it out, but thank you all for helping me!

 

[averatec]

missing table tile_items in database

 

[Reese]

Any idea where I can find or get that?

 

[cbrm]

you don't seem to be really reading what the console tells you
but when it tells you that a table doesn't exist in database, you have to search the query that creates it either at /doc/schemas/ of your TFS or find the original script, and execute the sql query at your db

 

[Ninja]

CREATE TABLE `tile_items`
(
    `tile_id` INT UNSIGNED NOT NULL,
    `world_id` TINYINT(4) 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;

 

[Reese]

Ah, I feel silly, but I can't follow the help that you guys are trying to give me.

I'm trying to find out where to put the SQL Code, and I'm in my database, and I paste that code into the section that says "SQL query on database DBname"
But I get the error: "You have to choose at least one column to display"

 

[averatec]

PMA or do it by console

 

[Reese]

Oh, okay - Thank you. That helped a lot.

"#1146 - Table 'tibia.tile_items' doesn't exist"
I still can't seem to find tibia.tile_items, and I have no idea where it could be. I tried going into my OT files and "doc", but I see nothing.
I also tried making a new one to see if I could find the file that was missing, but none seem to be missing from the OT.

 

[cbrm]

/doc/schemas/mysql.sql
if it isn't there, you can find it at the svn(Subversion) repositories of tfs in this forum

 

[Reese]

Thank you.

I pasted what Ninja told me to in my schemas, and when I went to paste it into my DB as well I get:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"tile_items" ( "tile_id" INT UNSIGNED NOT NULL, "world_id" TINYINT(4)' at line 1

Instead of the other message. I tried to load up the server to see if having it only in the schemas would work, but the errors are still showing up.

Edit:

Ah, nevermind. Same message as before.

 

[Thez3rt3r]

And "Same message" means that You don't solved your problem, right?
Did You paste SQL code from Ninja's post tio your schema.mysql file in doc folder or executed it with phpMyAdmin like averatec posted? Or maybe You did both?