[Trinity Core] Crashing

[Synyster]

Okay, so Ive spent the past week trying to make a server. I finally fixed my problem with maps, and now everything is running and nothing is instantly crashing. The [Trinity Core.exe] runs and loads everything up fine, but when it finishes it stays open for 2 minutes or so then crashes and gives me an SQL error, help would be appreciated.

Here is a copy of my Server.txt with the error in it and i will also provide a screenshot of the issue

2009-08-01 21:02:19 Using configuration file TrinityCore.conf.
2009-08-01 21:02:19 TrinityCore2 Rev: Archive Hash: be0323f8a37f (Win32,little-endian) (core-daemon)
2009-08-01 21:02:19 <Ctrl-C> to stop.

2009-08-01 21:02:19 ______ __
2009-08-01 21:02:19 /\__ _\ __ __/\ \__
2009-08-01 21:02:19 \/_/\ \/ _ __ /\_\ ___ /\_\ \ ,_\ __ __
2009-08-01 21:02:19 \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
2009-08-01 21:02:19 \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
2009-08-01 21:02:19 \ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \
2009-08-01 21:02:19 \/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \
2009-08-01 21:02:19 C O R E /\___/
2009-08-01 21:02:19 Trinity Core MMo Server Framework - Powered by vBulletin \/__/

2009-08-01 21:02:19 MySQL client library: 5.0.56
2009-08-01 21:02:19 MySQL server ver: 5.1.36-community
2009-08-01 21:02:19 MySQL client library: 5.0.56
2009-08-01 21:02:19 MySQL server ver: 5.1.36-community
2009-08-01 21:02:19 MySQL client library: 5.0.56
2009-08-01 21:02:19 MySQL server ver: 5.1.36-community
2009-08-01 21:02:19 Realm running as realm ID 1
2009-08-01 21:02:19 Using World DB: UDB 380 For Trinity
2009-08-01 21:02:19 Using creature EventAI: Unknown creature EventAI.
2009-08-01 21:02:19 Will clear `logs` table of entries older than 1209600 seconds every 10 minutes.
2009-08-01 21:02:19 Visibility. Distance .Creature can't be greater 165.666656
2009-08-01 21:02:19 Visibility.Distance.Object can't be greater 156.666656
2009-08-01 21:02:19 Using DataDir ./
2009-08-01 21:02:19 ERROR: SQL: UPDATE `version` SET `core_version` = 'TrinityCore2 Rev: Archive Hash: be0323f8a37f (Win32,little-endian)', `core_revision` = 'Archive'
2009-08-01 21:02:19 WORLD: VMap support included. LineOfSight:1, getHeight:1
2009-08-01 21:02:19 WORLD: VMap data directory is: ./vmaps
2009-08-01 21:02:19 ERROR: SQL ERROR: Incorrect integer value: 'Archive' for column 'core_revision' at row 1
2009-08-01 21:02:19 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2009-08-01 21:02:19
2009-08-01 21:02:19 Loading Trinity strings...
2009-08-01 21:02:19
2009-08-01 21:02:19 >> Loaded 783 Trinity strings from table trinity_string
2009-08-01 21:02:19 Initialize data stores...
2009-08-01 21:02:20
2009-08-01 21:02:20 >> Initialized 79 data stores
2009-08-01 21:02:20 Using enUS DBC Locale as default. All available DBC locales: enUS
2009-08-01 21:02:20
2009-08-01 21:02:20 Loading Script Names...
2009-08-01 21:02:20
2009-08-01 21:02:20 >> Loaded 822 Script Names
2009-08-01 21:02:20 Loading InstanceTemplate...
2009-08-01 21:02:20 >> Loaded 74 Instance Template definitions
2009-08-01 21:02:20
2009-08-01 21:02:20 Loading SkillLineAbilityMultiMap Data...
2009-08-01 21:02:20
2009-08-01 21:02:20 >> Loaded 9973 SkillLineAbility MultiMap Data
2009-08-01 21:02:20 Cleaning up instances...
2009-08-01 21:02:20
2009-08-01 21:02:20 >> Initialized 0 instances
2009-08-01 21:02:20 Packing instances...
2009-08-01 21:02:20 >> Instance numbers remapped, next instance id is 1
2009-08-01 21:02:20
2009-08-01 21:02:20
2009-08-01 21:02:20 Loading Localization strings...
2009-08-01 21:02:20
2009-08-01 21:02:20 >> Loaded 0 creature locale strings. DB table `locales_creature` is empty.
2009-08-01 21:02:20
2009-08-01 21:02:20 >> Loaded 0 gameobject locale strings. DB table `locales_gameobject` is empty.
2009-08-01 21:02:20
2009-08-01 21:02:20 >> Loaded 0 Item locale strings. DB table `locales_item` is empty.
2009-08-01 21:02:20
2009-08-01 21:02:20 >> Loaded 0 Quest locale strings. DB table `locales_quest` is empty.
2009-08-01 21:02:20
2009-08-01 21:02:20 >> Loaded 0 NpcText locale strings. DB table `locales_npc_text` is empty.
2009-08-01 21:02:20
2009-08-01 21:02:20 >> Loaded 0 PageText locale strings. DB table `locales_page_text` is empty.
2009-08-01 21:02:20
2009-08-01 21:02:20 >> Loaded 0 npc_option locale strings. DB table `locales_npc_option` is empty.
2009-08-01 21:02:20
2009-08-01 21:02:20 >> Loaded 0 points_of_interest locale strings. DB table `locales_points_of_interest` is empty.
2009-08-01 21:02:20 >>> Localization strings loaded
2009-08-01 21:02:20
2009-08-01 21:02:20 Loading Page Texts...
2009-08-01 21:02:20 >> Loaded 1628 page texts
2009-08-01 21:02:20
2009-08-01 21:02:20 Loading Player info in cache...
2009-08-01 21:02:20 ERROR: Loading Player Cache failed.
2009-08-01 21:02:20 Loading Game Object Templates...
2009-08-01 21:02:21 >> Loaded 17860 game object templates
2009-08-01 21:02:21
2009-08-01 21:02:21 Loading Spell Chain Data...
2009-08-01 21:02:21
2009-08-01 21:02:21 >> Loaded 1113 spell chains
2009-08-01 21:02:21 Loading Spell Required Data...
2009-08-01 21:02:21
2009-08-01 21:02:21 >> Loaded 0 spell required records
2009-08-01 21:02:21 ERROR: `spell_required` table is empty!
2009-08-01 21:02:21 Loading Spell Elixir types...
2009-08-01 21:02:22
2009-08-01 21:02:22 >> Loaded 99 spell elixir definitions
2009-08-01 21:02:22 Loading Spell Learn Skills...
2009-08-01 21:02:22
2009-08-01 21:02:22 >> Loaded 99 Spell Learn Skills from DBC
2009-08-01 21:02:22 Loading Spell Learn Spells...
2009-08-01 21:02:22
2009-08-01 21:02:22 >> Loaded 31 spell learn spells + 554 found in DBC
2009-08-01 21:02:22 Loading Spell Proc Event conditions...
2009-08-01 21:02:22
2009-08-01 21:02:22 >> Loaded 897 extra spell proc event conditions +42 custom
2009-08-01 21:02:22 Loading Spell Bonus Data...
2009-08-01 21:02:22
2009-08-01 21:02:22 >> Loaded 0 extra spell bonus data
2009-08-01 21:02:22 Loading Aggro Spells Definitions...
2009-08-01 21:02:22 >> Loaded 89 aggro generating spells
2009-08-01 21:02:22
2009-08-01 21:02:22 Loading NPC Texts...
2009-08-01 21:02:22
2009-08-01 21:02:22 >> Loaded 5220 npc texts
2009-08-01 21:02:22 Loading Enchant Spells Proc datas...
2009-08-01 21:02:22 >> Loaded 9 enchant proc data definitions
2009-08-01 21:02:22 Loading Item Random Enchantments Table...
2009-08-01 21:02:23
2009-08-01 21:02:23 >> Loaded 28575 Item Enchantment definitions
2009-08-01 21:02:23 Loading Items...
2009-08-01 21:02:25 >> Loaded 32671 item prototypes
2009-08-01 21:02:25
2009-08-01 21:02:25 Loading Item Texts...
2009-08-01 21:02:25
2009-08-01 21:02:25 >> Loaded 0 item pages
2009-08-01 21:02:25 Loading Creature Model Based Info Data...
2009-08-01 21:02:25 >> Loaded 23046 creature model based info
2009-08-01 21:02:25
2009-08-01 21:02:25 Loading Equipment templates...
2009-08-01 21:02:25 >> Loaded 1807 equipment template
2009-08-01 21:02:25
2009-08-01 21:02:25 Loading Creature templates...
2009-08-01 21:02:27 >> Loaded 27352 creature definitions
2009-08-01 21:02:27
2009-08-01 21:02:27 Loading SpellsScriptTarget...
2009-08-01 21:02:27
2009-08-01 21:02:27 >> Loaded 711 Spell Script Targets
2009-08-01 21:02:27 Loading ItemRequiredTarget...
2009-08-01 21:02:27
2009-08-01 21:02:27 >> Loaded 63 Item required targets
2009-08-01 21:02:27 Loading Creature Reputation OnKill Data...
2009-08-01 21:02:27
2009-08-01 21:02:27 >> Loaded 1414 creature award reputation definitions
2009-08-01 21:02:27 Loading Points Of Interest Data...
2009-08-01 21:02:27
2009-08-01 21:02:27 >> Loaded 125 Points of Interest definitions
2009-08-01 21:02:27 Loading Creature Data...
2009-08-01 21:02:30 ERROR: Table `creature` has creature (GUID: 400080) with non existing creature entry 400000, skipped.
2009-08-01 21:02:31 ERROR: Table `creature` have creature (GUID: 423812 Entry: 32517) with `MovementType`=1 (random movement) but with `spawndist`=0, replace by idle movement type (0).
2009-08-01 21:02:31
2009-08-01 21:02:31 >> Loaded 131414 creatures
2009-08-01 21:02:31 Loading Creature Linked Respawn...
2009-08-01 21:02:31
2009-08-01 21:02:31 >> Loaded 1 linked respawns
2009-08-01 21:02:31 Loading pet levelup spells...
2009-08-01 21:02:31
2009-08-01 21:02:31 >> Loaded 1152 pet levelup and default spells for 38 families
2009-08-01 21:02:31 Loading pet default spell additional to levelup spells...
2009-08-01 21:02:31
2009-08-01 21:02:31 >> Loaded addition spells for 109 pet spell data entries and 319 summonable creature templates
2009-08-01 21:02:31 Loading Creature Addon Data...
2009-08-01 21:02:31
2009-08-01 21:02:31 >> Loaded 4514 creature template addons
2009-08-01 21:02:31
2009-08-01 21:02:32 >> Loaded 80801 creature addons
2009-08-01 21:02:32
2009-08-01 21:02:32 >>> Creature Addon Data loaded
2009-08-01 21:02:32
2009-08-01 21:02:32 Loading Creature Respawn Data...
2009-08-01 21:02:32 >> Loaded 3475 creature respawn times
2009-08-01 21:02:32
2009-08-01 21:02:32 Loading Gameobject Data...
2009-08-01 21:02:35
2009-08-01 21:02:35 >> Loaded 66362 gameobjects
2009-08-01 21:02:35 Loading Gameobject Respawn Data...
2009-08-01 21:02:35
2009-08-01 21:02:35 >> Loaded 0 gameobject respawn time.
2009-08-01 21:02:35 Loading Objects Pooling Data...
2009-08-01 21:02:35
2009-08-01 21:02:35 >> Loaded 419 objects pools
2009-08-01 21:02:35
2009-08-01 21:02:35 >> Loaded 576 creatures in pools
2009-08-01 21:02:35
2009-08-01 21:02:35 >> Loaded 977 gameobject in pools
2009-08-01 21:02:35
2009-08-01 21:02:35 >> Loaded 0 pools in pools
2009-08-01 21:02:35 Loading Game Event Data...
2009-08-01 21:02:35
2009-08-01 21:02:35
2009-08-01 21:02:35 >> Loaded 51 game events
2009-08-01 21:02:35
2009-08-01 21:02:35 >> Loaded 1 game event saves in game events
2009-08-01 21:02:35
2009-08-01 21:02:35 >> Loaded 16 game event prerequisites in game events
2009-08-01 21:02:35
2009-08-01 21:02:35 >> Loaded 2463 creatures in game events
2009-08-01 21:02:35
2009-08-01 21:02:35 >> Loaded 16347 gameobjects in game events
2009-08-01 21:02:35
2009-08-01 21:02:35 >> Loaded 10 model/equipment changes in game events
2009-08-01 21:02:35
2009-08-01 21:02:35 >> Loaded 38 quests additions in game events
2009-08-01 21:02:35
2009-08-01 21:02:35 >> Loaded 0 go quests additions in game events
2009-08-01 21:02:35
2009-08-01 21:02:35 >> Loaded 11 quest event conditions in game events
2009-08-01 21:02:35
2009-08-01 21:02:35 >> Loaded 15 conditions in game events
2009-08-01 21:02:35
2009-08-01 21:02:35 >> Loaded 0 condition saves in game events
2009-08-01 21:02:35
2009-08-01 21:02:35 >> Loaded 1 npcflags in game events
2009-08-01 21:02:35
2009-08-01 21:02:35 >> Loaded 57 vendor additions in game events
2009-08-01 21:02:35
2009-08-01 21:02:35 >> Loaded 10 npc gossip textids in game events
2009-08-01 21:02:35
2009-08-01 21:02:35 >> Loaded 4 battleground holidays in game events
2009-08-01 21:02:35
2009-08-01 21:02:35 >> Loaded 0 pools in game events
2009-08-01 21:02:35 >>> Game Event Data loaded
2009-08-01 21:02:35
2009-08-01 21:02:35 Loading Weather Data...
2009-08-01 21:02:35
2009-08-01 21:02:35 >> Loaded 35 weather definitions
2009-08-01 21:02:35 Loading Quests...
2009-08-01 21:02:36
2009-08-01 21:02:36 >> Loaded 8423 quests definitions
2009-08-01 21:02:36 Loading Quests Relations...
2009-08-01 21:02:36
2009-08-01 21:02:36
2009-08-01 21:02:36 >> Loaded 321 quest relations from gameobject_questrelation
2009-08-01 21:02:36
2009-08-01 21:02:36 >> Loaded 247 quest relations from gameobject_involvedrelation
2009-08-01 21:02:37
2009-08-01 21:02:37 >> Loaded 7211 quest relations from creature_questrelation
2009-08-01 21:02:37
2009-08-01 21:02:37 >> Loaded 7405 quest relations from creature_involvedrelation
2009-08-01 21:02:37 >>> Quests Relations loaded
2009-08-01 21:02:37
2009-08-01 21:02:37 Loading UNIT_NPC_FLAG_SPELLCLICK Data...
2009-08-01 21:02:37
2009-08-01 21:02:37 >> Loaded 15 spellclick definitions
2009-08-01 21:02:37 Loading SpellArea Data...
2009-08-01 21:02:37
2009-08-01 21:02:37 >> Loaded 116 spell area requirements
2009-08-01 21:02:37 Loading AreaTrigger definitions...
2009-08-01 21:02:37
2009-08-01 21:02:37 >> Loaded 199 area trigger teleport definitions
2009-08-01 21:02:37 Loading Access Requirements...
2009-08-01 21:02:37
2009-08-01 21:02:37 >> Loaded 199 access requirement definitions
2009-08-01 21:02:37 Loading Quest Area Triggers...
2009-08-01 21:02:37
2009-08-01 21:02:37 >> Loaded 51 quest trigger points
2009-08-01 21:02:37 Loading Tavern Area Triggers...
2009-08-01 21:02:37
2009-08-01 21:02:37 >> Loaded 102 tavern triggers
2009-08-01 21:02:37 Loading AreaTrigger script names...
2009-08-01 21:02:37
2009-08-01 21:02:37 >> Loaded 4 areatrigger scripts
2009-08-01 21:02:37 Loading Graveyard-zone links...
2009-08-01 21:02:37
2009-08-01 21:02:37 >> Loaded 680 graveyard-zone links
2009-08-01 21:02:37 Loading Spell target coordinates...
2009-08-01 21:02:37
2009-08-01 21:02:37 >> Loaded 249 spell teleport coordinates
2009-08-01 21:02:37 Loading SpellAffect definitions...
2009-08-01 21:02:37
2009-08-01 21:02:37 >> Loaded 1 custom spell affect definitions
2009-08-01 21:02:37 Loading spell pet auras...
2009-08-01 21:02:37
2009-08-01 21:02:37 >> Loaded 44 spell pet auras
2009-08-01 21:02:37 Loading spell extra attributes...(TODO)
2009-08-01 21:02:37 Loading enchant custom attributes...
2009-08-01 21:02:37 Loading linked spells...
2009-08-01 21:02:38
2009-08-01 21:02:38 >> Loaded 115 linked spells
2009-08-01 21:02:38 Loading Player Create Info & Level Stats...
2009-08-01 21:02:38
2009-08-01 21:02:38
2009-08-01 21:02:38 >> Loaded 62 player create definitions
2009-08-01 21:02:38
2009-08-01 21:02:38 >> Loaded 0 custom player create items
2009-08-01 21:02:38
2009-08-01 21:02:38 >> Loaded 2789 player create spells
2009-08-01 21:02:38
2009-08-01 21:02:38 >> Loaded 437 player create actions
2009-08-01 21:02:38
2009-08-01 21:02:38 >> Loaded 800 level health/mana definitions
2009-08-01 21:02:38
2009-08-01 21:02:38 >> Loaded 4960 level stats definitions
2009-08-01 21:02:38
2009-08-01 21:02:38 >> Loaded 79 xp for level definitions
2009-08-01 21:02:38 >>> Player Create Info & Level Stats loaded
2009-08-01 21:02:38
2009-08-01 21:02:38 Loading Exploration BaseXP Data...
2009-08-01 21:02:38
2009-08-01 21:02:38 >> Loaded 71 BaseXP definitions
2009-08-01 21:02:38 Loading Pet Name Parts...
2009-08-01 21:02:38
2009-08-01 21:02:38 >> Loaded 313 pet name parts
2009-08-01 21:02:38 Loading the max pet number...
2009-08-01 21:02:38
2009-08-01 21:02:38 >> Loaded the max pet number: 0
2009-08-01 21:02:38 Loading pet level stats...
2009-08-01 21:02:38
2009-08-01 21:02:38 >> Loaded 2480 level pet stats definitions
2009-08-01 21:02:38 Loading Player Corpses...
2009-08-01 21:02:38
2009-08-01 21:02:38 >> Loaded 0 corpses
2009-08-01 21:02:38 Loading Disabled Spells...
2009-08-01 21:02:38
2009-08-01 21:02:38 >> Loaded 0 disabled spells
2009-08-01 21:02:38 Loading Loot Tables...
2009-08-01 21:02:38
2009-08-01 21:02:38 creature_loot_template :
2009-08-01 21:02:40 ERROR: Table 'creature_loot_template' entry 16193 item 16193: item entry not listed in `item_template` - skipped
2009-08-01 21:02:41 ERROR: Table 'creature_loot_template' entry 31533 group 1 has total chance > 100% (132.000000)
2009-08-01 21:02:41 ERROR: Table 'creature_loot_template' entry 31536 group 1 has total chance > 100% (132.000000)
2009-08-01 21:02:41 ERROR: Table 'creature_loot_template' entry 31537 group 1 has total chance > 100% (130.000000)
2009-08-01 21:02:41 ERROR: Table 'creature_loot_template' entry 31538 group 1 has total chance > 100% (181.000000)
2009-08-01 21:02:41
2009-08-01 21:02:41 >> Loaded 329362 loot definitions (7434 templates)
2009-08-01 21:02:41 ERROR: Table 'creature_loot_template' entry 16193 (creature entry) not exist but used as loot id in DB.
2009-08-01 21:02:41 ERROR: Table 'creature_loot_template' entry 16193 (creature entry) not exist but used as loot id in DB.
2009-08-01 21:02:41 ERROR: Table 'creature_loot_template' entry 16034 isn't creature entry and not referenced from loot, and then useless.
2009-08-01 21:02:41 ERROR: Table 'creature_loot_template' entry 16036 isn't creature entry and not referenced from loot, and then useless.
2009-08-01 21:02:41 ERROR: Table 'creature_loot_template' entry 16037 isn't creature entry and not referenced from loot, and then useless.
2009-08-01 21:02:41 ERROR: Table 'creature_loot_template' entry 16146 isn't creature entry and not referenced from loot, and then useless.
2009-08-01 21:02:41 ERROR: Table 'creature_loot_template' entry 16297 isn't creature entry and not referenced from loot, and then useless.
2009-08-01 21:02:41 ERROR: Table 'creature_loot_template' entry 29278 isn't creature entry and not referenced from loot, and then useless.
2009-08-01 21:02:41 fishing_loot_template :
2009-08-01 21:02:41
2009-08-01 21:02:41 >> Loaded 231 loot definitions (214 templates)
2009-08-01 21:02:41 gameobject_loot_template :
2009-08-01 21:02:41 ERROR: Table 'gameobject_loot_template' entry 24524 group 1 has total chance > 100% (168.000000)
2009-08-01 21:02:41
2009-08-01 21:02:41 >> Loaded 18429 loot definitions (1062 templates)
2009-08-01 21:02:41 ERROR: Table 'gameobject_loot_template' entry 15954 isn't gameobject entry and not referenced from loot, and then useless.
2009-08-01 21:02:41 item_loot_template :
2009-08-01 21:02:41
2009-08-01 21:02:41 >> Loaded 4831 loot definitions (249 templates)
2009-08-01 21:02:41 milling_loot_template :
2009-08-01 21:02:41
2009-08-01 21:02:41 >> Loaded 44 loot definitions (44 templates)
2009-08-01 21:02:41 pickpocketing_loot_template :
2009-08-01 21:02:41
2009-08-01 21:02:41 >> Loaded 10603 loot definitions (2445 templates)
2009-08-01 21:02:41 skinning_loot_template :
2009-08-01 21:02:41
2009-08-01 21:02:41 >> Loaded 3362 loot definitions (941 templates)
2009-08-01 21:02:42 disenchant_loot_template :
2009-08-01 21:02:42
2009-08-01 21:02:42 >> Loaded 121 loot definitions (54 templates)
2009-08-01 21:02:42 prospecting_loot_template :
2009-08-01 21:02:42
2009-08-01 21:02:42 >> Loaded 84 loot definitions (9 templates)
2009-08-01 21:02:42 quest_mail_loot_template :
2009-08-01 21:02:42
2009-08-01 21:02:42 >> Loaded 65 loot definitions (65 templates)
2009-08-01 21:02:42 spell_loot_template :
2009-08-01 21:02:42
2009-08-01 21:02:42 >> Loaded 101 loot definitions (8 templates)
2009-08-01 21:02:42 ERROR: Table 'spell_loot_template' entry 57844 (spell id (random item creating)) not exist but used as loot id in DB.
2009-08-01 21:02:42 ERROR: Table 'spell_loot_template' entry 58160 (spell id (random item creating)) not exist but used as loot id in DB.
2009-08-01 21:02:42 ERROR: Table 'spell_loot_template' entry 58165 (spell id (random item creating)) not exist but used as loot id in DB.
2009-08-01 21:02:42 ERROR: Table 'spell_loot_template' entry 58168 (spell id (random item creating)) not exist but used as loot id in DB.
2009-08-01 21:02:42 ERROR: Table 'spell_loot_template' entry 58172 (spell id (random item creating)) not exist but used as loot id in DB.
2009-08-01 21:02:42 ERROR: Table 'spell_loot_template' entry 60445 (spell id (random item creating)) not exist but used as loot id in DB.
2009-08-01 21:02:42 ERROR: Table 'spell_loot_template' entry 60893 (spell id (random item creating)) not exist but used as loot id in DB.
2009-08-01 21:02:42 ERROR: Table 'spell_loot_template' entry 61177 (spell id (random item creating)) not exist but used as loot id in DB.
2009-08-01 21:02:42 ERROR: Table 'spell_loot_template' entry 61288 (spell id (random item creating)) not exist but used as loot id in DB.
2009-08-01 21:02:42 ERROR: Table 'spell_loot_template' entry 61898 (spell id (random item creating)) not exist but used as loot id in DB.
2009-08-01 21:02:42 ERROR: Table 'spell_loot_template' entry 64202 (spell id (random item creating)) not exist but used as loot id in DB.
2009-08-01 21:02:42 reference_loot_template :
2009-08-01 21:02:42
2009-08-01 21:02:42 >> Loaded 7557 loot definitions (451 templates)
2009-08-01 21:02:42 ERROR: Table 'reference_loot_template' entry 34040 isn't reference id and not referenced from loot, and then useless.
2009-08-01 21:02:42 ERROR: Table 'reference_loot_template' entry 34041 isn't reference id and not referenced from loot, and then useless.
2009-08-01 21:02:42 ERROR: Table 'reference_loot_template' entry 34042 isn't reference id and not referenced from loot, and then useless.
2009-08-01 21:02:42 ERROR: Table 'reference_loot_template' entry 34043 isn't reference id and not referenced from loot, and then useless.
2009-08-01 21:02:42 ERROR: Table 'reference_loot_template' entry 34044 isn't reference id and not referenced from loot, and then useless.
2009-08-01 21:02:42 >>> Loot Tables loaded
2009-08-01 21:02:42
2009-08-01 21:02:42 Loading Skill Discovery Table...
2009-08-01 21:02:42
2009-08-01 21:02:42 >> Loaded 194 skill discovery definitions
2009-08-01 21:02:42 Loading Skill Extra Item Table...
2009-08-01 21:02:42
2009-08-01 21:02:42 >> Loaded 160 spell specialization definitions
2009-08-01 21:02:42 Loading Skill Fishing base level requirements...
2009-08-01 21:02:42
2009-08-01 21:02:42 >> Loaded 87 areas for fishing base skill level
2009-08-01 21:02:42 Loading Achievements...
2009-08-01 21:02:42
2009-08-01 21:02:42
2009-08-01 21:02:42 >> Loaded 43 achievement references.
2009-08-01 21:02:43
2009-08-01 21:02:43 >> Loaded 796 achievement criteria.
2009-08-01 21:02:43
2009-08-01 21:02:43 >> Loaded 1317 additional achievement criteria data (187 disabled).
2009-08-01 21:02:43
2009-08-01 21:02:43 >> Loaded 51 achievement rewards
2009-08-01 21:02:43
2009-08-01 21:02:43 >> Loaded 0 achievement reward locale strings. DB table `locales_achievement_reward` is empty.
2009-08-01 21:02:43
2009-08-01 21:02:43 >> Loaded 0 realm completed achievements . DB table `character_achievement` is empty.
2009-08-01 21:02:43 >>> Achievements loaded
2009-08-01 21:02:43
2009-08-01 21:02:43 Loading Auctions...
2009-08-01 21:02:43
2009-08-01 21:02:43
2009-08-01 21:02:43 >> Loaded 0 auction items
2009-08-01 21:02:43
2009-08-01 21:02:43 >> Loaded 0 auctions. DB table `auctionhouse` is empty.
2009-08-01 21:02:43 >>> Auctions loaded
2009-08-01 21:02:43
2009-08-01 21:02:43 Loading Guilds...
2009-08-01 21:02:43
2009-08-01 21:02:43 >> Loaded 0 guild definitions
2009-08-01 21:02:43 Loading ArenaTeams...
2009-08-01 21:02:43
2009-08-01 21:02:43 >> Loaded 0 arenateam definitions
2009-08-01 21:02:43 Loading Groups...
2009-08-01 21:02:43
2009-08-01 21:02:43 >> Loaded 0 group definitions
2009-08-01 21:02:43 Loading ReservedNames...
2009-08-01 21:02:43
2009-08-01 21:02:43 >> Loaded 0 reserved player names
2009-08-01 21:02:43 Loading GameObjects for quests...
2009-08-01 21:02:43
2009-08-01 21:02:43 >> Loaded 1070 GameObjects for quests
2009-08-01 21:02:43 Loading BattleMasters...
2009-08-01 21:02:43
2009-08-01 21:02:43 >> Loaded 71 battlemaster entries
2009-08-01 21:02:43 Loading GameTeleports...
2009-08-01 21:02:43
2009-08-01 21:02:43 >> Loaded 1409 GameTeleports
2009-08-01 21:02:43 Loading Npc Text Id...
2009-08-01 21:02:43
2009-08-01 21:02:43 >> Loaded 3357 NpcTextId
2009-08-01 21:02:43 Loading Npc Options...
2009-08-01 21:02:43
2009-08-01 21:02:43 >> Loaded 48 npc_option entries
2009-08-01 21:02:43 Loading Vendors...
2009-08-01 21:02:43
2009-08-01 21:02:43 >> Loaded 30815 Vendors
2009-08-01 21:02:43 Loading Trainers...
2009-08-01 21:02:45
2009-08-01 21:02:45 >> Loaded 70429 Trainers
2009-08-01 21:02:45 Loading Waypoints...
2009-08-01 21:02:45
2009-08-01 21:02:51 Loading Creature Formations...
2009-08-01 21:02:51
2009-08-01 21:02:51 >> Loaded 2 creatures in formations
2009-08-01 21:02:51
2009-08-01 21:02:51 Loading GM tickets...
2009-08-01 21:02:51
>> GM Tickets table is empty, no tickets were loaded.

2009-08-01 21:02:51 Returning old mails...
2009-08-01 21:02:51
2009-08-01 21:02:51 >> Only expired mails (need to be return or delete) or DB table `mail` is empty.
2009-08-01 21:02:51 Loading Scripts...
2009-08-01 21:02:51
2009-08-01 21:02:51 quest_start_scripts :
2009-08-01 21:02:51
2009-08-01 21:02:51 >> Loaded 220 script definitions
2009-08-01 21:02:51 quest_end_scripts :
2009-08-01 21:02:51
2009-08-01 21:02:51 >> Loaded 201 script definitions
2009-08-01 21:02:51 spell_scripts :
2009-08-01 21:02:51
2009-08-01 21:02:51 >> Loaded 10 script definitions
2009-08-01 21:02:51 gameobject_scripts :
2009-08-01 21:02:51
2009-08-01 21:02:51 >> Loaded 53 script definitions
2009-08-01 21:02:51 event_scripts :
2009-08-01 21:02:51
2009-08-01 21:02:51 >> Loaded 411 script definitions
2009-08-01 21:02:51 waypoint_scripts :
2009-08-01 21:02:52
2009-08-01 21:02:52 >> Loaded 516 script definitions
2009-08-01 21:02:52 >>> Scripts loaded
2009-08-01 21:02:52
2009-08-01 21:02:52 Loading Scripts text locales...
2009-08-01 21:02:52
2009-08-01 21:02:52 >> Loaded 290 string templates from db_script_string
2009-08-01 21:02:52 Loading CreatureEventAI Texts...
2009-08-01 21:02:52
2009-08-01 21:02:52 >> Loaded 559 string templates from creature_ai_texts
2009-08-01 21:02:52 Loading EventAI Texts additional data...
2009-08-01 21:02:52
2009-08-01 21:02:52 >> Loaded 559 additional CreatureEventAI Texts data.
2009-08-01 21:02:52 Loading CreatureEventAI Summons...
2009-08-01 21:02:52
2009-08-01 21:02:52 >> Loaded 8 CreatureEventAI summon definitions
2009-08-01 21:02:52 Loading CreatureEventAI Scripts...
2009-08-01 21:02:53
2009-08-01 21:02:53 >> Loaded 10393 CreatureEventAI scripts
2009-08-01 21:02:53 Initializing Scripts...
2009-08-01 21:02:53
2009-08-01 21:02:53 >>> Scripts Library TrinityScript.dll was successfully loaded.

2009-08-01 21:02:53 _____ _ _ _ ____ _ _
2009-08-01 21:02:53 |_ _| __(_)_ __ (_) |_ _ _/ ___| ___ _ __(_)_ __ | |_
2009-08-01 21:02:53 | || '__| | '_ \| | __| | | \___ \ / __| '__| | '_ \| __|
2009-08-01 21:02:53 | || | | | | | | | |_| |_| |___) | (__| | | | |_) | |_
2009-08-01 21:02:53 |_||_| |_|_| |_|_|\__|\__, |____/ \___|_| |_| .__/ \__|
2009-08-01 21:02:53 |___/ |_|
2009-08-01 21:02:53 Trinity Script initializing TrinityScript
2009-08-01 21:02:53
2009-08-01 21:02:53 TSCR: Using configuration file TrinityCore.conf
2009-08-01 21:02:53
2009-08-01 21:02:53 MySQL client library: 5.0.56
2009-08-01 21:02:53 MySQL server ver: 5.1.36-community
2009-08-01 21:02:53 TSCR: TrinityScript database: 127.0.0.1;3306;root;internal;world
2009-08-01 21:02:53 TSCR: Database version is: ACID 0.1.0 - Full Release
2009-08-01 21:02:53
2009-08-01 21:02:53 TSCR: Loading Script Texts...
2009-08-01 21:02:54
2009-08-01 21:02:54 >> Loaded 1556 string templates from script_texts
2009-08-01 21:02:54 TSCR: Loading Script Texts additional data...
2009-08-01 21:02:54
2009-08-01 21:02:54 >> TSCR: Loaded 1556 additional Script Texts data.
2009-08-01 21:02:54 TSCR: Loading Custom Texts...
2009-08-01 21:02:54
2009-08-01 21:02:54 >> Loaded 0 string templates. DB table `custom_texts` is empty.
2009-08-01 21:02:54 TSCR: Loading Custom Texts additional data...
2009-08-01 21:02:54
2009-08-01 21:02:54 >> Loaded 0 additional Custom Texts data. DB table `custom_texts` is empty.
2009-08-01 21:02:54 TSCR: Loading Script Waypoints for 27 creature(s)...
2009-08-01 21:02:54
2009-08-01 21:02:54 >> Loaded 609 Script Waypoint nodes.
2009-08-01 21:02:54 TSCR: Loading C++ scripts
2009-08-01 21:02:54
2009-08-01 21:02:54 >> Loaded 783 C++ Scripts.
2009-08-01 21:02:54 >> Load Overriden SQL Data.
2009-08-01 21:02:54 >> Load Overriden DBC Data.
2009-08-01 21:02:54 Checking DB...
2009-08-01 21:02:54 Starting Map System
2009-08-01 21:02:54 Starting Game Event system...
2009-08-01 21:02:54 GameEvent 16 "Gurubashi Arena Booty Run" started.
2009-08-01 21:02:54 GameEvent 18 "Call to Arms: Alterac Valley!" started.
2009-08-01 21:02:54 GameEvent 30 "Edge of Madness, Hazza'rah" started.
2009-08-01 21:02:54 GameEvent 35 "Shattered Sun Offensive: Phase 1 - Reclaiming the Sanctum" started.
2009-08-01 21:02:54 Starting BattleGround System
2009-08-01 21:02:54
2009-08-01 21:02:54 >> Loaded 11 battlegrounds
2009-08-01 21:02:54 Starting Outdoor PvP System
2009-08-01 21:02:54 Loading Transports...
2009-08-01 21:02:54
2009-08-01 21:02:54 >> Loaded 19 transports
2009-08-01 21:02:54 Loading Transports Events...
2009-08-01 21:02:54
>> Transport events table is empty

2009-08-01 21:02:54 Deleting expired bans...
2009-08-01 21:02:54 Calculate next daily quest reset time...
2009-08-01 21:02:54 Starting objects Pooling system...
2009-08-01 21:02:54 Initialize AuctionHouseBot...
2009-08-01 21:02:55 AuctionHouseBot:
2009-08-01 21:02:55 loaded 9 grey trade goods
2009-08-01 21:02:55 loaded 556 white trade goods
2009-08-01 21:02:55 loaded 82 green trade goods
2009-08-01 21:02:55 loaded 45 blue trade goods
2009-08-01 21:02:55 loaded 10 purple trade goods
2009-08-01 21:02:55 loaded 2 orange trade goods
2009-08-01 21:02:55 loaded 0 yellow trade goods
2009-08-01 21:02:55 loaded 1288 grey items
2009-08-01 21:02:55 loaded 3756 white items
2009-08-01 21:02:55 loaded 8386 green items
2009-08-01 21:02:55 loaded 5076 blue items
2009-08-01 21:02:55 loaded 3571 purple items
2009-08-01 21:02:55 loaded 14 orange items
2009-08-01 21:02:55 loaded 3 yellow items
2009-08-01 21:02:55 AuctionHouseBot by Paradox (original by ChrisK) has been loaded.
2009-08-01 21:02:55 AuctionHouseBot now includes AHBuyer by Kerbe and Paradox
2009-08-01 21:02:55 WORLD: World initialized
2009-08-01 21:02:55 TrinityCore process priority class set to HIGH
2009-08-01 21:02:55
2009-08-01 21:02:55
2009-08-01 21:04:00 ERROR: SQL: SELECT guid, data, name, position_x, position_y, position_z, map, totaltime, leveltime, at_login, zone, level FROM characters WHERE guid = '9'
2009-08-01 21:04:00 ERROR: query ERROR: Unknown column 'level' in 'field list'

and here is a screenshot of the issue,

Help would be greatly appreciated and +Rep will be awarded to whoever does

[Jotox]

Clearly a database problem. Your characters table is incorrect.

Imo, drop the database and re-download it from trinitycore/mangos

[Synyster]

I've tried that, i cant find a database that executes properly without any errors. (I'm using Navicat, dont know if thats the problem?)

[Sorayazlawl]

Navicat isn't the problem.

[Synyster]

Navicat isn't the problem.

okay, then how about a solution to the problem? _-_

[The-Eradicator]

I've tried that, i cant find a database that executes properly without any errors. (I'm using Navicat, dont know if thats the problem?)

You should be using Unified Database, with all updatepacks applied, and then running the SQLs from the SQL folder in your TrinityCore checkout. You should have "characters.sql" and "realmd.sql" in your SQL folder. Those are what you're looking for.

Navicat isn't the problem.

Actually, Navicat has been known to skip queries in SQL batch before. I'd recommend using SQLyog, just in case.

[Synyster]

You should be using Unified Database, with all updatepacks applied, and then running the SQLs from the SQL folder in your TrinityCore checkout. You should have "characters.sql" and "realmd.sql" in your SQL folder. Those are what you're looking for.



Actually, Navicat has been known to skip queries in SQL batch before. I'd recommend using SQLyog, just in case.

Okay, i did what you said and the SQL error fixed, now im getting no errors at all and its just crashing after a minute of being open.. i have no idea what to do sense there is no error.

Edit: I tried disabling my firewall / avg to see if that was blocking it somehow but it is still crashing.

[The-Eradicator]

Okay, i did what you said and the SQL error fixed, now im getting no errors at all and its just crashing after a minute of being open.. i have no idea what to do sense there is no error.

Edit: I tried disabling my firewall / avg to see if that was blocking it somehow but it is still crashing.

Do you have a crash log? (Separate from server logs, these would be found in the CrashLog folder.)

[Synyster]

yes i do, i tried reading through them to find something but i did not find anything.. do you have msn that i could add you? would be alot easier.. i cant seem to fix this =\ dont even have a place to start looking for a fix at either.
if you have msn add me at
[email protected]