["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

What was used to insert the database..?

`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.

["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

no these two

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 ?

["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

Did you read the entire thread Zeni...?

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

["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

[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.