firedraken

okay what about the revision?

Okay, so I started from scratch and applied the base sql files, then the TDB_full_434.05_2013_07_17 file then the updates from github.com/TrinityCore/TrinityCore_4.3.4_DB_Alpha.git. I followed the guide at http://collab.kpsn.org/pages/viewpage.action?pageId=1704351 and didn't import the updates from TrinityCore/sql/updates/world as instructed in the guide. Now I get the following: TrinityCore rev. e08efb89e470 2014-08-26 18:27:31 +0100 (master branch) (Unix, Release) (worldserver-daemon) <Ctrl-C> to stop. ______ __ /__ _ __ __/ __ /_/ / _ __ /_ ___ /_ , _ __ __ /`'__/ /' _ `/ / / / / / / _ _ _ _ _ _ _ _ __/`____ /_//_/ /_//_//_//_//__/ `/___/> C O R E /___/ http://TrinityCore.org /__/ Using configuration file /home/trinity/server/etc/worldserver.conf. Using SSL version: OpenSSL 1.0.1f 6 Jan 2014 (library: OpenSSL 1.0.1f 6 Jan 2014) Using Boost version: 1.54.0 In mysql_stmt_prepare() id: 16, sql: "UPDATE creature_template SET faction = ? WHERE entry = ?" Unknown column 'faction' in 'field list' DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Read wiki at http://collab.kpsn.org/display/tc/TrinityCore+Home Cannot connect to world database I am at a loss. I think I am missing an update somewhere I just don't know where. This is a 4.3.4 from the master branch on github

Okay I have read all the stickies and double checked that everything was installed to the database. I have installed everything in the /TrinityCore/sql folder and TDB_full_434.05_2013_07_17.sql along with all the august updates in the update folder in the core/sql directory. I still get the below output when I try to start my world server. What updates am I missing, everything I have has been installed? I am at a total loss please, help me out here. TrinityCore rev. e08efb89e470 2014-08-26 18:27:31 +0100 (master branch) (Unix, Release) (worldserver-daemon) <Ctrl-C> to stop. ______ __ /__ _ __ __/ __ /_/ / _ __ /_ ___ /_ , _ __ __ /`'__/ /' _ `/ / / / / / / _ _ _ _ _ _ _ _ __/`____ /_//_/ /_//_//_//_//__/ `/___/> C O R E /___/ http://TrinityCore.org /__/ Using configuration file /home/trinity/server/etc/worldserver.conf. Using SSL version: OpenSSL 1.0.1f 6 Jan 2014 (library: OpenSSL 1.0.1f 6 Jan 2014) Using Boost version: 1.54.0 In mysql_stmt_prepare() id: 29, sql: "SELECT point, position_x, position_y, position_z, orientation, move_type, delay, action, action_chance FROM waypoint_data WHERE id = ? ORDER BY point" Unknown column 'move_type' in 'field list' In mysql_stmt_prepare() id: 34, sql: "SELECT id, point, delay, move_type, action, action_chance FROM waypoint_data WHERE wpguid = ?" Unknown column 'move_type' in 'field list' In mysql_stmt_prepare() id: 54, sql: "SELECT entry, difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, faction, npcflag, speed_walk, speed_run, scale, rank, dmgschool, BaseAttackTime, RangeAttackTime, BaseVariance, RangeVariance, unit_class, unit_flags, unit_flags2, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, type, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, InhabitType, HoverHeight, HealthModifier, ManaModifier, ArmorModifier, DamageModifier, ExperienceModifier, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?" Unknown column 'BaseVariance' in 'field list' DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Read wiki at http://collab.kpsn.org/display/tc/TrinityCore+Home Cannot connect to world database

I applied all the TDB update that applied and the DB that I imported is only about a month old. the columns that appear in the code list are columns that the core are looking for and not finding in the database. Again the columns that are listed in the post do not appear in the db tables.

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