When start server show some erros like: IOMapSerialize::loadTile.....

[Tera1000]

Hello everybody, like 3 weeks a go i back to play a otserv, i download one, based on tfs but other version compiled by gesior and other things by other people, have a nice map and now i want use a new version of tfs because of the new features and etc... I want be upadated, thats it... But now i got that problem i change the map to 8.22 with remeres (the map is running for 8.22, but say that map is for other version... all right) but when i start the otserv now with the new compiled tfs i got this errors, lots of, I will post just some of. The otserver is running fine, i cant find other problems... but i got about 480 lines! of this errors what i need to do to fix that?

Thank you all, sorry my english i never learn that in school before, just internet english... C ya o/

WARNING: IOMapSerialize::loadTile() - NULL item at ( 00068 / 00074 / 007 ) (type
= 8811, sid = 2, pid = 0).
WARNING: IOMapSerialize::loadTile() - NULL item at ( 00053 / 00070 / 007 ) (type
= 8795, sid = 1, pid = 0).
WARNING: IOMapSerialize::loadTile() - NULL item at ( 00055 / 00070 / 007 ) (type
= 8817, sid = 1, pid = 0).
WARNING: IOMapSerialize::loadTile() - NULL item at ( 00045 / 00071 / 007 ) (type
= 8816, sid = 2, pid = 0).
WARNING: IOMapSerialize::loadTile() - NULL item at ( 00045 / 00071 / 007 ) (type
= 8795, sid = 1, pid = 0).
WARNING: IOMapSerialize::loadTile() - NULL item at ( 00048 / 00071 / 007 ) (type
= 8795, sid = 1, pid = 0).
WARNING: IOMapSerialize::loadTile() - NULL item at ( 00047 / 00075 / 007 ) (type
= 8816, sid = 1, pid = 0).
WARNING: IOMapSerialize::loadTile() - NULL item at ( 00057 / 00082 / 007 ) (type
= 8836, sid = 1, pid = 0).
WARNING: IOMapSerialize::loadTile() - NULL item at ( 00059 / 00083 / 007 ) (type
= 8795, sid = 1, pid = 0).
WARNING: IOMapSerialize::loadTile() - NULL item at ( 00061 / 00082 / 007 ) (type
= 8798, sid = 2, pid = 0).

EDIT:

Problem solved running that command,
DELETE FROM `tile_items` WHERE `itemtype` >= 8000
DELETE FROM `player_items` WHERE `itemtype` >= 8000
DELETE FROM `player_depotitems` WHERE `itemtype` >= 8000

Lots of ids are diferent now in this version, and lot of itens are wrong... Thats it i have lots of work yet to make the server updated.. C ya all o/

 

[derkonsito]

BUMP someone help me with this !! I need to solve same problem !!


@Limos bro this guys says he solved running a command but can you explain me how i do that?

 

[derkonsito]

Bump please helpp!!!!

 

[Limos]

http://otland.net/threads/mysql-how-to-run-a-query.177833/

But if the items are only on the map and not in your database, then running a query won't solve that.
If changing map version didn't solve it, you can also try to go to the positions in the errors and delete the items there.