Jump to content


  • Posts

  • Joined

  • Last visited

Zeni's Achievements


Newbie (1/14)



  1. `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.
  2. 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 ?
  3. [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.
  • Create New...