Zeni

`itemEntry` mediumint(8) unsigned NOT NULL DEFAULT '0', => I suspect this is the cause . It's in the characters_database.sql . Need to delete this entry from the item_instance related query. Any hints please ? LE : Fixed it. Just drop the item_instance table and rebuild it with the itemEntry column in it.

I used Jayzee's query (Thank you btw ) replacing it with my linked_respawn fields. Now, after ./worldserver, this happens : [ERROR]: In mysql_stmt_prepare() id: 27, sql: "SELECT creatorGuid, giftCreatorGuid, count, duration, charges, flags, enchantments, randomPropertyId, durability, playedTime, text, bag, slot, item, itemEntry FROM character_inventory ci JOIN item_instance ii ON ci.item = ii.guid WHERE ci.guid = ? ORDER BY bag, slot" [ERROR]: Unknown column 'itemEntry' in 'field list' Abracadabra ! Any reappearances on this one ?

Are you talking about Jayzee's post ? Hm...a bit harder with linked_respawn table.

[ERROR]: In mysql_stmt_prepare() id: 1, sql: "DELETE FROM linked_respawn WHERE guid = ?" [ERROR]: Table 'linked_respawn' doesn't exist Same problem here. A little help would be great. Thanks in advance.