Dunvii Posted November 9, 2018 Report Share Posted November 9, 2018 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. Link to comment Share on other sites More sharing options...
Dunvii Posted November 9, 2018 Author Report Share Posted November 9, 2018 Problem solve. I was used master files. Link to comment Share on other sites More sharing options...
Aokromes Posted November 9, 2018 Report Share Posted November 9, 2018 --- Canned message start --- It appears the issue in the original post was solved, so this thread shall be closed. Should you encounter any other difficulties, please open a new thread. --- Canned message end --- Link to comment Share on other sites More sharing options...
Recommended Posts