Report "unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page in Help and Support Posted February 1, 2013 Hello, I have installed trinitycore with db 335.50 and all world update, but i have a problem : Using configuration file /home/wowserv/server/etc/worldserver.conf. Using SSL version: OpenSSL 0.9.8o 01 Jun 2010 (library: OpenSSL 0.9.8o 01 Jun 2010) Using ACE version: 6.0.3 TrinityCore rev. 2013-01-01 21:17:48 +0100 (87368cab45b8) (Unix, Release) (worldserver-daemon) <Ctrl-C> to stop. ______ __ /__ _ __ __/ __ /_/ / _ __ /_ ___ /_ , _ __ __ /`'__/ /' _ `/ / / / / / / _ _ _ _ _ _ _ _ __/`____ /_//_/ /_//_//_//_//__/ `/___/> C O R E /___/ http://TrinityCore.org /__/ Realm running as realm ID 1 Using World DB: TDB 335.50 Will clear `logs` table of entries older than 1209600 seconds every 10 minutes. Using DataDir ./ VMap support included. LineOfSight:1, getHeight:1, indoorCheck:1 PetLOS:1 VMap data directory is: ./vmaps Loading Trinity strings... >> Loaded 993 Trinity strings from table trinity_string in 2 ms Initialize data stores... >> Initialized 96 data stores in 161 ms Using frFR DBC Locale as default. All available DBC locales: frFR Loading spell dbc data corrections... >> Loaded spell dbc data corrections in 3 ms Loading SpellInfo store... >> Loaded spell custom attributes in 24 ms Loading SkillLineAbilityMultiMap Data... >> Loaded 10219 SkillLineAbility MultiMap Data in 2 ms Loading spell custom attributes... >> Loaded spell custom attributes in 15 ms Loading GameObject models... >> Loaded 2321 GameObject models in 1 ms Loading Script Names... >> Loaded 2147 Script Names in 58 ms Loading Instance Template... >> Loaded 83 instance templates in 0 ms Loading instances... >> Loaded instances in 2 ms Loading Localization strings... >> Localization strings loaded in 2 ms Loading Page Texts... >> Loaded 1834 page texts in 2 ms Loading Game Object Templates... >> Loaded 19061 game object templates in 130 ms Loading Spell Rank Data... >> Loaded 5593 spell rank records in 5 ms Loading Spell Required Data... >> Loaded 41 spell required records in 0 ms Loading Spell Group types... >> Loaded 461 spell group definitions in 1 ms Loading Spell Learn Skills... >> Loaded 99 Spell Learn Skills from DBC in 1 ms Loading Spell Learn Spells... >> Loaded 8 spell learn spells + 572 found in DBC in 2 ms Loading Spell Proc Event conditions... >> Loaded 1085 extra and 59 custom spell proc event conditions in 3 ms Loading Spell Proc conditions and data... >> Loaded 0 spell proc conditions and data. DB table `spell_proc` is empty. Loading Spell Bonus Data... >> Loaded 332 extra spell bonus data in 1 ms Loading Aggro Spells Definitions... >> Loaded 106 SpellThreatEntries in 0 ms Loading Spell Group Stack Rules... >> Loaded 53 spell group stack rules in 0 ms Loading NPC Texts... >> Loaded 6044 npc texts in 84 ms Loading Enchant Spells Proc datas... >> Loaded 42 enchant proc data definitions in 0 ms Loading Item Random Enchantments Table... >> Loaded 28607 Item Enchantment definitions in 25 ms Loading Disables >> Loaded 801 disables in 1 ms Loading Items... >> Loaded 37293 item templates in 815 ms Loading Item set names... >> Loaded 2481 item set names in 3 ms Loading Creature Model Based Info Data... >> Loaded 24142 creature model based info in 35 ms Loading Equipment templates... >> Loaded 2493 equipment templates in 2 ms Loading Creature templates... >> Loaded 29923 creature definitions in 506 ms Loading Creature template addons... >> Loaded 7567 creature template addons in 11 ms Loading Reputation Reward Rates... >> Loaded 14 reputation_reward_rate in 1 ms Loading Creature Reputation OnKill Data... >> Loaded 2002 creature award reputation definitions in 3 ms Loading Reputation Spillover Data... >> Loaded 26 reputation_spillover_template in 0 ms Loading Points Of Interest Data... >> Loaded 453 Points of Interest definitions in 2 ms Loading Creature Base Stats... >> Loaded 400 creature base stats in 2 ms Loading Creature Data... >> Loaded 143518 creatures in 1143 ms Loading pet levelup spells... >> Loaded 993 pet levelup and default spells for 39 families in 4 ms Loading pet default spells additional to levelup spells... >> Loaded addition spells for 111 pet spell data entries in 1 ms Loading summonable creature templates... >> Loaded 375 summonable creature templates in 2 ms Loading Creature Addon Data... >> Loaded 34646 creature addons in 47 ms Loading Gameobject Data... >> Loaded 82581 gameobjects in 706 ms Loading Creature Linked Respawn... >> Loaded 5547 linked respawns in 4 ms Loading Weather Data... >> Loaded 35 weather definitions in 1 ms Loading Quests... >> Loaded 9464 quests definitions in 221 ms Checking Quest Disables >> Checked 651 quest disables in 0 ms Loading Quest POI >> Loaded 18759 quest POI definitions in 75 ms Loading Quests Relations... Loading GO Start Quest Data... >> Loaded 520 quest relations from gameobject_questrelation in 1 ms Loading GO End Quest Data... >> Loaded 450 quest relations from gameobject_involvedrelation in 1 ms Loading Creature Start Quest Data... >> Loaded 7505 quest relations from creature_questrelation in 10 ms Loading Creature End Quest Data... >> Loaded 7853 quest relations from creature_involvedrelation in 10 ms Loading Objects Pooling Data... >> Loaded 3024 objects pools in 2 ms Loading Creatures Pooling Data... >> Loaded 904 creatures in pools in 1 ms Loading Gameobject Pooling Data... >> Loaded 24080 gameobject in pools in 30 ms Loading Mother Pooling Data... >> Loaded 2290 pools in mother pools in 6 ms Loading Quest Pooling Data... >> Loaded 133 quests in pools in 1 ms Starting objects pooling system... Loading Game Event Data... >> Loaded 64 game events in 0 ms Loading Game Event Saves Data... >> Loaded 15 game event saves in game events in 0 ms Loading Game Event Prerequisite Data... >> Loaded 15 game event prerequisites in game events in 0 ms Loading Game Event Creature Data... >> Loaded 8259 creatures in game events in 12 ms Loading Game Event GO Data... >> Loaded 19799 gameobjects in game events in 27 ms Loading Game Event Model/Equipment Change Data... >> Loaded 10 model/equipment changes in game events in 1 ms Loading Game Event Quest Data... >> Loaded 217 quests additions in game events in 0 ms Loading Game Event GO Quest Data... >> Loaded 78 quests additions in game events in 0 ms Loading Game Event Quest Condition Data... >> Loaded 11 quest event conditions in game events in 0 ms Loading Game Event Condition Data... >> Loaded 15 conditions in game events in 1 ms Loading Game Event Condition Save Data... >> Loaded 0 condition saves in game events. DB table `game_event_condition_save` is empty. Loading Game Event NPCflag Data... >> Loaded 6 npcflags in game events in 0 ms Loading Game Event Seasonal Quest Relations... >> Loaded 614 quests additions in game events in 0 ms Loading Game Event Vendor Additions Data... >> Loaded 71 vendor additions in game events in 1 ms Loading Game Event Battleground Data... >> Loaded 6 battleground holidays in game events in 0 ms Loading Game Event Pool Data... >> Loaded 8 pools for game events in 0 ms Loading UNIT_NPC_FLAG_SPELLCLICK Data... >> Loaded 258 spellclick definitions in 1 ms Loading Vehicle Template Accessories... >> Loaded 116 Vehicle Template Accessories in 1 ms Loading Vehicle Accessories... >> Loaded 0 Vehicle Accessories in 0 ms Loading SpellArea Data... >> Loaded 425 spell area requirements in 1 ms Loading AreaTrigger definitions... >> Loaded 224 area trigger teleport definitions in 1 ms Loading Access Requirements... >> Loaded 121 access requirement definitions in 0 ms Loading Quest Area Triggers... >> Loaded 59 quest trigger points in 0 ms Loading Tavern Area Triggers... >> Loaded 113 tavern triggers in 1 ms Loading AreaTrigger script names... >> Loaded 72 areatrigger scripts in 0 ms Loading LFG entrance positions... >> Loaded 16 lfg entrance positions in 0 ms Loading Dungeon boss data... >> Loaded 612 instance encounters in 1 ms Loading LFG rewards... [1054] Unknown column 'firstMoneyVar' in 'field list' Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders. Thx in advance.
"unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page
in Help and Support
Posted
Thx in advance.