I am having issues with start up of the world server. I am getting sql errors when loading the character database, I have applied all updates from the git source.
I need to know where to get the sql statements to fix this. I am using the core build from git as of 3/12/13 all sql statements from build and the git db have been applied. this is a working build with users and characters. Please, help with the update sql (statements) in need to run or a working DB that I can import player info into
Thank you
Using configuration file /trinity/server//etc/worldserver.conf.
Using SSL version: OpenSSL 1.0.1 14 Mar 2012 (library: OpenSSL 1.0.1 14 Mar 2012)
Using ACE version: 6.0.3
TrinityCore rev. 9ae9277817ac 2013-03-11 14:46:38 +0000 (master branch) (Unix, Release) (worldserver-daemon)
<Ctrl-C> to stop.
______ __
/\__ _\ __ __/\ \__
\/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __
\ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
\ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
\ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \
\/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \
C O R E /\___/
http://TrinityCore.org \/__/
In mysql_stmt_prepare() id: 36, sql: "SELECT guid, account, name, race, class, gender, level, xp, money, playerBytes, playerBytes2, playerFlags, po$
Unknown column 'arenaPoints' in 'field list'
In mysql_stmt_prepare() id: 73, sql: "SELECT quest FROM character_queststatus_rewarded WHERE guid = ? AND active = 1"
Unknown column 'active' in 'where clause'
In mysql_stmt_prepare() id: 212, sql: "INSERT INTO corpse (corpseGuid, guid, posX, posY, posZ, orientation, mapId, displayId, itemCache, bytes1, by$
Unknown column 'guildId' in 'field list'
In mysql_stmt_prepare() id: 234, sql: "INSERT INTO characters (guid, account, name, race, class, gender, level, xp, money, playerBytes, playerBytes$
Unknown column 'arenaPoints' in 'field list'
In mysql_stmt_prepare() id: 235, sql: "UPDATE characters SET name=?,race=?,class=?,gender=?,level=?,xp=?,money=?,playerBytes=?,playerBytes2=?,playe$
Unknown column 'arenaPoints' in 'field list'
In mysql_stmt_prepare() id: 320, sql: "UPDATE characters SET arenaPoints = (arenaPoints + ?) WHERE guid = ?"
Unknown column 'arenaPoints' in 'field list'
In mysql_stmt_prepare() id: 375, sql: "UPDATE characters SET totalHonorPoints = ? WHERE guid = ?"
Unknown column 'totalHonorPoints' in 'field list'
In mysql_stmt_prepare() id: 376, sql: "UPDATE characters SET arenaPoints = ? WHERE guid = ?"
Unknown column 'arenaPoints' in 'field list'
In mysql_stmt_prepare() id: 386, sql: "INSERT IGNORE INTO character_queststatus_rewarded (guid, quest, active) VALUES (?, ?, 1)"
Unknown column 'active' in 'field list'
In mysql_stmt_prepare() id: 389, sql: "UPDATE character_queststatus_rewarded SET active = 1 WHERE guid = ?"
Unknown column 'active' in 'field list'
In mysql_stmt_prepare() id: 390, sql: "UPDATE character_queststatus_rewarded SET active = 0 WHERE quest = ? AND guid = ?"
Unknown column 'active' in 'field list'
In mysql_stmt_prepare() id: 396, sql: "INSERT INTO character_stats (guid, maxhealth, maxpower1, maxpower2, maxpower3, maxpower4, maxpower5, maxpowe$
Unknown column 'maxpower6' in 'field list'
In mysql_stmt_prepare() id: 401, sql: "INSERT INTO character_glyphs VALUES(?, ?, ?, ?, ?, ?, ?, ?)"
Column count doesn't match value count at row 1
In mysql_stmt_prepare() id: 211, sql: "SELECT posX, posY, posZ, orientation, mapId, displayId, itemCache, bytes1, bytes2, guildId, flags, dynFlags,$
Unknown column 'guildId' in 'field list'
In mysql_stmt_prepare() id: 430, sql: "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, curhappin$
Unknown column 'curhappiness' in 'field list'
In mysql_stmt_prepare() id: 431, sql: "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, curhappin$
Unknown column 'curhappiness' in 'field list'
In mysql_stmt_prepare() id: 432, sql: "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, curhappin$
Unknown column 'curhappiness' in 'field list'
In mysql_stmt_prepare() id: 422, sql: "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, curhappin$
Unknown column 'curhappiness' in 'field list'
In mysql_stmt_prepare() id: 211, sql: "SELECT posX, posY, posZ, orientation, mapId, displayId, itemCache, bytes1, bytes2, guildId, flags, dynFlags,$
Unknown column 'guildId' in 'field list'
In mysql_stmt_prepare() id: 430, sql: "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, curhappin$
Unknown column 'curhappiness' in 'field list'
In mysql_stmt_prepare() id: 431, sql: "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, curhappin$
Unknown column 'curhappiness' in 'field list'
In mysql_stmt_prepare() id: 432, sql: "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, curhappin$
Unknown column 'curhappiness' in 'field list'
In mysql_stmt_prepare() id: 422, sql: "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, curhappin$
Unknown column 'curhappiness' in 'field list'
In mysql_stmt_prepare() id: 211, sql: "SELECT posX, posY, posZ, orientation, mapId, displayId, itemCache, bytes1, bytes2, guildId, flags, dynFlags,$
Unknown column 'guildId' in 'field list'
In mysql_stmt_prepare() id: 430, sql: "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, curhappin$
Unknown column 'curhappiness' in 'field list'
In mysql_stmt_prepare() id: 431, sql: "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, curhappin$
Unknown column 'curhappiness' in 'field list'
In mysql_stmt_prepare() id: 432, sql: "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, curhappin$
Unknown column 'curhappiness' in 'field list'
In mysql_stmt_prepare() id: 422, sql: "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, curhappin$
Unknown column 'curhappiness' in 'field list'
DatabasePool characters-trinity NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to Character database 127.0.0.1;3306;root;1924;characters-trinity