Hello,
i got problem when running worldserver for first time :
In mysql_stmt_prepare() id: 31, sql: “SELECT casterGuid, spell, effectMask, recalculateMask, stackCount, amount0, amount1, amount2, base_amount0, base_amount1, base_amount2, maxDuration, remainTime, remainCharges, critChance, applyResilience FROM character_aura WHERE guid = ?”
Unknown column ‘amount0’ in ‘field list’
In mysql_stmt_prepare() id: 77, sql: “INSERT INTO auctionhouse (id, houseid, itemguid, itemowner, buyoutprice, time, buyguid, lastbid, startbid, deposit) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)”
Unknown column ‘houseid’ in ‘field list’
In mysql_stmt_prepare() id: 166, sql: “INSERT INTO character_aura (guid, casterGuid, spell, effectMask, recalculateMask, stackCount, amount0, amount1, amount2, base_amount0, base_amount1, base_amount2, maxDuration, remainTime, remainCharges, critChance, applyResilience) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)”
Unknown column ‘amount0’ in ‘field list’
In mysql_stmt_prepare() id: 412, sql: “REPLACE INTO calendar_events (id, creator, title, description, type, dungeon, eventtime, flags, time2) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)”
Unknown column ‘id’ in ‘field list’
In mysql_stmt_prepare() id: 413, sql: “DELETE FROM calendar_events WHERE id = ?”
Unknown column ‘id’ in ‘where clause’
In mysql_stmt_prepare() id: 414, sql: “REPLACE INTO calendar_invites (id, event, invitee, sender, status, statustime, rank, text) VALUES (?, ?, ?, ?, ?, ?, ?, ?)”
Unknown column ‘id’ in ‘field list’
In mysql_stmt_prepare() id: 415, sql: “DELETE FROM calendar_invites WHERE id = ?”
Unknown column ‘id’ in ‘where clause’
Could not prepare statements of the Character database, see log for details.
i was try to drop world database and got same error.