Unserialization of invalid tiles at position problem!

[Kaywin]

Hello everyone, when i finally got my console almost bugg-less then i decide to remove a part of the costum places that was built on my RL map to make it smaller. BUT when I removed everything houses/dp/tempel/spawns ect (and I also removed all houses in the map edtior for that city) some errors are is loaded in my console.

HERE IS MY ERRORS:

REP WILL BE GIVING LIKE ALWAYS!

 

[Sonical]

Check what kind of tiles they are, remove them if possible.

 

[Dassnung]

or just put them back

 

[Kaywin]

The problem is I don't know what tiels it is and when i go to the cordinates there is just black sqm becouse i delited everyting there so what can be the problem be then?

 

[Nefs]

after you delete these tiles, you see if these tiles got any unique/action id?

 

[samff]

Concerning your pm, yes I got it fixed. Here's how:

SQL query:

DELETE FROM `tile_items` WHERE `itemtype` = NULL

 

[Kaywin]

Concerning your pm, yes I got it fixed. Here's how:

SQL query:

DELETE FROM `tile_items` WHERE `itemtype` = NULL

oh thank you mate! You got my rep! But just one thing,

 DELETE FROM `tile_items` WHERE `itemtype` = NULL

As you can see WHERE? how do I put the cordinates can I write like this for exampel:

DELETE FROM `tile_items` 33333, 33333, 5 `itemtype` = NULL

 

[samff]

no need for coordinates. just execute the query

 

[Kaywin]

no need for coordinates. just execute the query

ok then thanks you!

 

[abad]

i dont Understand Plz Help Me

 

[Ghazer]

How I can execute this query? I use sqlite

 

[Loney]

To SQLite:

Relace all the ` for a "

 

[seleo]

create a new database
or do as Samff told you

 

[trixet]

To clear it out.
You get this error because there is an item that is suppose to "spawn" on a tile that does not exist.
This item is stored in your database.
Access your database (phpmyadmin or other tool) and exequte the SQL query that Samff gave above.