Jump to content
TrinityCore

"unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page


Apple
 Share

Recommended Posts

System info-

 

Processor: AMD Athlon 64 x2 Dual core 4000+ 2.10GHZ

 

Ram:2GB

 

System: Windows 7 32 bit

 

Server Revision: 4.3.4

 

DB: alpha TC 4.3.4 db 

 

 

Everytime i try putting the updates in from "world_updates.sql"  that you make from "merge_updates_windows.bat"  

i keep getting "SQL Error (1054) in statement #114: Unknown column 'id' in 'field list'" i have No idea why it is doing it, I have followed "  http://collab.kpsn.org/display/tc/How-To_Win+4.3.4 " to the letter and it's annoying me not knowing what is wrong. i have not been able to get it going. i decided to start clean due to other problems. and it was going good so far. But i have run into this issue. 

Link to comment
Share on other sites

Hey,

 

I have a problem with 4.4.3 TrinityCore with world database.

I compiled core from 4.4.3 branch repo.

I have uploaded database as described in: http://collab.kpsn.org/display/tc/How-To_Win+4.3.4#How-To_Win4.3.4-FillingTheDatabase

 

 

And server still wont start becouse table gameobject_queststarter doesn't exist :(

 

Please tell me where can I find some working world database 4.4.3? Or tell me with one update should I load to DB.

 

Thank you!

Regards

Edited by Lord
Link to comment
Share on other sites

--- Canned message start ---

Please Look in upper right hand corner of the forum, there is a button labeled search field, feel free to search for your issues first before posting, most questions like this one have already been answered.

If you still cannot find the answers you seek feel free to make a post and tell us the steps you took to resolve this issue and we will do our best to help you.

--- Canned message end ---

Link to comment
Share on other sites

Hey,

 

Like in the topic is that table needed for 4.3.4 core repo becouse my server wont start - that table doesn't exist...

I searched the whole forum but I have not found answers.

A lot of people says that we need to compile core from 4.3.4 branch and get FULL TDB (i take this one  TDB_full_434.05_2013_07_17.7z - http://www.trinitycore.org/f/files/file/9-tdb-full-434/) with updates from https://github.com/TrinityCore/TrinityCore_4.3.4_DB_Alpha marge made by merge_windows.bat of this repo tools dir.

 

Can anybody tell me with one *.sql should I load to resolve the problem?

 

I want upload the best database to later do not bother with amendments.

 

Maybe somebody who have this compiled yesterday or today have same problem or just test it for me please... :(

 

Just moderator please do not close this thread becouse I looked other threads and I am sure i do everything right like they said... and guys I realy belive you will help me :)

 

I will be very grateful for your help!!!

Regards

Link to comment
Share on other sites

The compile was quick and painless, my auth opens. but world does not. I read about this problem in the section I must read before posting. However, I have the correct db with the correct core. I just downloaded my 4.3.4 current tdb_full_434, and reapplied it (after dropping current world from mysql. of course.) and I still get.

 

"In mysql_stmt_prepare() id: 56, sql: "SELECT difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, exp_unk, faction_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, unit_flags2, dynamicflags, family, trainer_type, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, type_flags2, 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, Health_mod, Mana_mod, Mana_mod_extra, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?"

Unknown column 'unit_flags2' in 'field list'
DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to world database 127.0.0.1;3306;root;ascent;world"
 
Are you sure your current core and db updates are proper? and if so may I please have detailed info with links I need to add db properly? I know I have the latest core also. Please I am dying here, I just want to begin coding my own server, I am not daft, but it now is way harder to get the proper tools I need on 4.3.4. I am well educated and can follow simple instructions, however I have tried every solution and have nothing. Any help would be much appreciated. I would even like links for the newest 4.3.4 core, so I could just recompile and follow your every instruction (after compile that is.)
Edited by Midian
Link to comment
Share on other sites

Hi. 434 is not currently being supported in this forum. You're welcome to search existing topics (and there are many with the exact same problem as you).

 

Start here: http://www.trinitycore.org/f/topic/1518-trouble-with-your-trinity-install-readme-1st-faqs/#entry42704

 

434 is development and is provided as is, with only the guides that have already been published. If this is not sufficient, then you should not attempt 434 (at least not right now).

  • Upvote 1
Link to comment
Share on other sites

i have some problems with database (world) exacly [1146] Table 'world.creature_queststarter' doesn't exist or  'world.gameobject_queststarter' doesn't exist

 

so i read that

 

 If you get "unknown column" error it can be because 10 reasons:

1) You have cloned master repository (3.3.5a) and installed TDB, but you forgot to apply the files present on sql/updates/world you need to run those to properly start core.
2) You have updated your database, but you forgot to update your binary files, you usually can't run older cores with newer databases.
3) You have updated your core, but you forgot to update your database, you usually can't run older databases with newer cores.
4) You have download 4.3.4 database, but you cloned master repository (3.3.5a), you can't use 4.3.4 database with 3.3.5a core.
6) You have download 4.3.4 core and installed TDB 4.3.4 but you forgot to apply the sql files present on TrinityCore_4.3.4_DB_Alpha repository.
7) You have download 4.3.4 core and installed TDB 4.3.4 and the sql files present on TrinityCore_4.3.4_DB_Alpha repository but 4.3.4 DB repository needs to be updated, if you are on this issue you must clone the hash of the date of the last database sync (not for newbies).
8) You are trying to use a custom patch and you forgot to apply the sql files for it or they don't exist.
9) You are trying to use one sql for another project or deprecated sql files.
10) You are trying to apply the same update 2 times. 

 

and i stop on frist step on ( apply the files present on sql/updates/world) i cant update my db(http://www.trinitycore.org/f/files/getdownload/563-tdb-full-434/)  http://www.trinitycore.org/f/files/download/9-tdb-full-434/ (last download)

when i apply world db  (sql/updates/world) i have output error

 

Query:
DELETE FROM `creature_ai_scripts` WHERE `creature_id` = @WOLF
 
Error occured at:2013-08-09 20:48:31
Line no.:271
Error Code: 1146 - Table 'worlds.creature_ai_scripts' doesn't exist
 
 
 
Query:
DELETE FROM `creature_ai_scripts` WHERE `creature_id` = @WOLF
 
Error occured at:2013-08-09 20:48:53
Line no.:271
Error Code: 1146 - Table 'worlds.creature_ai_scripts' doesn't exist
 
 
 
Query:
DELETE FROM `creature_ai_scripts` WHERE `creature_id` = @WOLF
 
Error occured at:2013-08-09 21:07:51
Line no.:271
Error Code: 1146 - Table 'worlds.creature_ai_scripts' doesn't exist
 
so i think something not right so i download TrinityCore_4.3.4_DB_Alpha repository. but i have still errors and i cant update(sql/updates/world)
 

 

 

Link to comment
Share on other sites

--- Canned message start ---

Read http://www.trinitycore.org/f/topic/1518-trouble-with-your-trinity-install-readme-1st-faqs/

Also please Look in upper right hand corner of the forum, there is a button labeled search field, feel free to search for your issues first before posting, most questions like this one have already been answered.

If you still cannot find the answers you seek feel free to make a post and tell us the steps you took to resolve this issue and we will do our best to help you.

--- Canned message end ---

Link to comment
Share on other sites

Hello all, 

To begin excuse me for my bad english i'm french.

 

I need your help because i try to make a 4.3.4 trinity server(using this: http://collab.kpsn.org/display/tc/How-To_Win+4.3.4; but i have a problem when starting the worldserver.exe.

 

I'm on Windows 8, Core revision: 2daa8ed56f43  and DB version: 5

 

So i make all the step of the tutorial, i finish with installing DB and making updates. But now i'm starting the worldserver.exe and i have this message:

 

 

[1146] Table 'world.gameobject_queststarter' doesn't exist

Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.

 

 

 

 

I have apply all the updates but when i open my DB with heidiSQL i see with "gameobject" the table 

 

-gameobject

-gameobject_involvedrelation

-gameobject_loot_template

-gameobject_questrelation

gameobject_template

 

 

But in this page(http://collab.kpsn.org/display/tc/Database%3A+World) i see that i have to have;

 

-gameobject

-gameobject_loot_template

-gameobject_questrender

-gameobject_queststarter

-gameobject_scripts

-gameobject_template

 

i don't know from where come the problem and i wish you can help me.

I give you the all worldserver message if it can help you to help me:

 

 

Using configuration file worldserver.conf.
Using SSL version: OpenSSL 1.0.1e 11 Feb 2013 (library: OpenSSL 1.0.1e 11 Feb 2013)
Using ACE version: 6.1.4
TrinityCore rev. 2daa8ed56f43 2013-08-07 20:07:05 +0200 (4.3.4 branch) (Win32, Release) (worldserver-daemon)
<Ctrl-C> to stop.
 
 ______                       __
/__  _       __          __/ __
/_/ / _ __ /_    ___ /_ , _  __  __
    /`'__/ /' _ `/ / / /
    / / / _ _
      _ _   _ _ _ _ __/`____
      /_//_/   /_//_//_//_//__/ `/___/>
                                 C O R E  /___/
http://TrinityCore.org                    /__/
 
Realm running as realm ID 1
Using World DB: TDB 434.05
Using enUS DBC Locale
Will clear `logs` table of entries older than 1209600 seconds every 10 minutes.
Using DataDir ./
WORLD: MMap data directory is: ./mmaps
VMap support included. LineOfSight: 1, getHeight: 1, indoorCheck: 1
VMap data directory is: ./vmaps
Loading Trinity strings...
>> Loaded 1082 Trinity strings from table trinity_string in 6 ms
Initialize data stores...
spelldifficulty_dbc: spell 42636 at field id:2202 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 45433 at field id:2203 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 90120 at field id:3251 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 92943 at field id:3251 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 90059 at field id:3255 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 92948 at field id:3255 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 89289 at field id:3258 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 92951 at field id:3258 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 75621 at field id:3523 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 94991 at field id:3523 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 75708 at field id:3579 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 95858 at field id:3579 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 92666 at field id:3582 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 95884 at field id:3582 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 98192 at field id:3741 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 98846 at field id:3741 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 98900 at field id:3749 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 99288 at field id:3749 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 98899 at field id:3752 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 99551 at field id:3752 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 99877 at field id:3764 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 99878 at field id:3764 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 107352 at field id:4343 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 108859 at field id:4343 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 110615 at field id:4343 at spellid2 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 110614 at field id:4343 at spellid3 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 110035 at field id:4444 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 110034 at field id:4444 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 110033 at field id:4444 at spellid2 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 110032 at field id:4444 at spellid3 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 103179 at field id:4469 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
spelldifficulty_dbc: spell 110515 at field id:4469 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
>> Initialized 141 DBC data stores in 245 ms
Loading SpellInfo store...
>> Loaded SpellInfo store in 70 ms
Loading SpellInfo corrections...
>> Loaded SpellInfo corrections in 5 ms
Loading SkillLineAbilityMultiMap Data...
>> Loaded 8384 SkillLineAbility MultiMap Data in 1 ms
Loading SpellInfo custom attributes...
>> Loaded SpellInfo custom attributes in 28 ms
Loading GameObject models...
Loading Script Names...
>> Loaded 2325 Script Names in 99 ms
Loading Instance Template...
>> Loaded 99 instance templates in 1 ms
Loading instances...
>> Loaded instances in 3 ms
Loading Localization strings...
>> Localization strings loaded in 2 ms
Loading Account Roles and Permissions...
>> Loaded 47 permission definitions, 39 role definitions and 4 group definitions in 2 ms
Loading Page Texts...
>> Loaded 1876 page texts in 14 ms
Loading Game Object Templates...
GameObject (Entry: 126337 GoType: 8) have data0=2061 but SpellFocus (Id: 2061) not exist.
GameObject (Entry: 126338 GoType: 8) have data0=2061 but SpellFocus (Id: 2061) not exist.
GameObject (Entry: 126339 GoType: 8) have data0=2061 but SpellFocus (Id: 2061) not exist.
GameObject (Entry: 126340 GoType: 8) have data0=2061 but SpellFocus (Id: 2061) not exist.
GameObject (Entry: 126341 GoType: 8) have data0=2061 but SpellFocus (Id: 2061) not exist.
GameObject (Entry: 126345 GoType: 8) have data0=2061 but SpellFocus (Id: 2061) not exist.
GameObject (Entry: 151951 GoType: 8) have data0=2061 but SpellFocus (Id: 2061) not exist.
Gameobject (Entry: 181105 GoType: 22) have data0=27873 but Spell (Entry 27873) not exist.
Gameobject (Entry: 181106 GoType: 22) have data0=27874 but Spell (Entry 27874) not exist.
Gameobject (Entry: 181165 GoType: 22) have data0=28276 but Spell (Entry 28276) not exist.
Gameobject (Entry: 183510 GoType: 22) have data0=34149 but Spell (Entry 34149) not exist.
Gameobject (Entry: 183511 GoType: 22) have data0=34150 but Spell (Entry 34150) not exist.
GameObject (Entry: 126342 GoType: 8) have data0=2061 but SpellFocus (Id: 2061) not exist.
GameObject (Entry: 191300 GoType: 8) have data0=2061 but SpellFocus (Id: 2061) not exist.
Gameobject (Entry: 193171 GoType: 22) have data0=58898 but Spell (Entry 58898) not exist.
Gameobject (Entry: 193169 GoType: 22) have data0=58890 but Spell (Entry 58890) not exist.
Gameobject (Entry: 193170 GoType: 22) have data0=58896 but Spell (Entry 58896) not exist.
Gameobject (Entry: 202357 GoType: 2) have data0=0 but lock (Id: 0) not found.
Gameobject (Entry: 188192 GoType: 3) have data7=188187 but GO (Entry 188187) have not GAMEOBJECT_TYPE_TRAP (6) type.
Gameobject (Entry: 205273 GoType: 22) have data0=84506 but Spell (Entry 84506) not exist.
Gameobject (Entry: 205272 GoType: 22) have data0=84505 but Spell (Entry 84505) not exist.
Gameobject (Entry: 207691 GoType: 22) have data0=90245 but Spell (Entry 90245) not exist.
Gameobject (Entry: 207690 GoType: 22) have data0=90244 but Spell (Entry 90244) not exist.
Gameobject (Entry: 209081 GoType: 22) have data0=84506 but Spell (Entry 84506) not exist.
Gameobject (Entry: 209080 GoType: 22) have data0=84505 but Spell (Entry 84505) not exist.
Gameobject (Entry: 206195 GoType: 22) have data0=86761 but Spell (Entry 86761) not exist.
Gameobject (Entry: 207078 GoType: 22) have data0=89691 but Spell (Entry 89691) not exist.
Gameobject (Entry: 207073 GoType: 22) have data0=89685 but Spell (Entry 89685) not exist.
Gameobject (Entry: 204422 GoType: 22) have data0=81358 but Spell (Entry 81358) not exist.
Gameobject (Entry: 208325 GoType: 22) have data0=96364 but Spell (Entry 96364) not exist.
Gameobject (Entry: 205877 GoType: 22) have data0=85892 but Spell (Entry 85892) not exist.
Gameobject (Entry: 205876 GoType: 22) have data0=85891 but Spell (Entry 85891) not exist.
>> Loaded 24332 game object templates in 305 ms
Loading Spell Rank Data...
>> Loaded 172 spell rank records in 1 ms
Loading Spell Required Data...
>> Loaded 22 spell required records in 0 ms
Loading Spell Group types...
Spell 25898 listed in `spell_group` does not exist
Spell 25899 listed in `spell_group` does not exist
>> Loaded 408 spell group definitions in 1 ms
Loading Spell Learn Skills...
>> Loaded 129 Spell Learn Skills from DBC in 3 ms
Loading Spell Learn Spells...
>> Loaded 19 spell learn spells, 510 found in Spell.dbc and 31 from TalentTab.dbc in 4 ms
Loading Spell Proc Event conditions...
Spell 34487 listed in `spell_proc_event` already has its first rank in table.
Spell 34486 listed in `spell_proc_event` already has its first rank in table.
Spell 64129 listed in `spell_proc_event` already has its first rank in table.
Spell 64127 listed in `spell_proc_event` already has its first rank in table.
Spell 47570 listed in `spell_proc_event` already has its first rank in table.
Spell 47569 listed in `spell_proc_event` already has its first rank in table.
Spell 85114 listed in `spell_proc_event` already has its first rank in table.
Spell 85113 listed in `spell_proc_event` already has its first rank in table.
Spell 19573 listed in `spell_proc_event` already has its first rank in table.
Spell 19572 listed in `spell_proc_event` already has its first rank in table.
Spell 56336 listed in `spell_proc_event` already has its first rank in table.
Spell 56333 listed in `spell_proc_event` already has its first rank in table.
Spell 56343 listed in `spell_proc_event` already has its first rank in table.
Spell 56342 listed in `spell_proc_event` already has its first rank in table.
Spell 34485 listed in `spell_proc_event` already has its first rank in table.
>> Loaded 708 extra spell proc event conditions in 7 ms
Loading Spell Proc conditions and data...
>> Loaded 0 spell proc conditions and data. DB table `spell_proc` is empty.
Loading Spell Bonus Data...
Spell 61840 listed in `spell_bonus_data` does not exist
>> Loaded 249 extra spell bonus data in 2 ms
Loading Aggro Spells Definitions...
>> Loaded 40 SpellThreatEntries in 0 ms
Loading Spell Group Stack Rules...
SpellGroup id 1120 listed in `spell_group_stack_rules` does not exist
>> Loaded 50 spell group stack rules in 0 ms
Loading Spell Phase Dbc Info...
>> Loaded 0 spell dbc infos. DB table `spell_phase` is empty.
Loading NPC Texts...
>> Loaded 7867 npc texts in 217 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 51 ms
Loading Disables
>> Loaded 5129 disables in 16 ms
Loading Items...
>> Loaded 54085 item templates from Item-sparse.db2 and 182 from database in 111 ms
Loading Item set names...
>> Loaded 622 item addon templates in 1 ms
>> Loaded 17 item script names in 0 ms
Loading Creature Model Based Info Data...
>> Loaded 31773 creature model based info in 58 ms
Loading Creature templates...
Creature (Entry: 13441) has different `npcflag` in difficulty 3 mode (Entry: 37313).
Creature (Entry: 17976) has different `npcflag` in difficulty 1 mode (Entry: 21551).
Creature (Entry: 14026, class 2) has different `unit_class` in difficulty 1 mode (Entry: 22581, class 1).
Creature (Entry: 33355, class 2) has different `unit_class` in difficulty 1 mode (Entry: 33737, class 1).
Creature (Entry: 13176) has different `npcflag` in difficulty 3 mode (Entry: 37401).
Creature (Entry: 20885) has different `npcflag` in difficulty 1 mode (Entry: 21590).
Creature (Entry: 19220) has different `npcflag` in difficulty 1 mode (Entry: 21537).
Creature (Entry: 14030, class 2) has different `unit_class` in difficulty 1 mode (Entry: 22585, class 1).
Creature (Entry: 33823, class 1) has different `unit_class` in difficulty 1 mode (Entry: 33832, class 2).
Creature (Entry: 14186) has different `npcflag` in difficulty 3 mode (Entry: 37374).
Creature (Entry: 13180) has different `npcflag` in difficulty 3 mode (Entry: 37481).
Creature (Entry: 13219) has different `npcflag` in difficulty 1 mode (Entry: 22682).
Creature (Entry: 12096) has different `npcflag` in difficulty 1 mode (Entry: 22658).
Creature (Entry: 11675, class 2) has different `unit_class` in difficulty 3 mode (Entry: 37404, class 1).
Creature (Entry: 11948) has different `npcflag` in difficulty 1 mode (Entry: 22644).
Creature (Entry: 13617) has different `npcflag` in difficulty 1 mode (Entry: 22577).
Creature (Entry: 29308) has different `npcflag` in difficulty 1 mode (Entry: 31469).
Creature (Entry: 13816) has different `npcflag` in difficulty 3 mode (Entry: 37372).
Creature (Entry: 37017, class 4) has different `unit_class` in difficulty 1 mode (Entry: 38078, class 1).
Creature (Entry: 19513) has different `npcflag` in difficulty 1 mode (Entry: 21560).
Creature (Entry: 20870) has different `npcflag` in difficulty 1 mode (Entry: 21626).
Creature (Entry: 4255) has different `npcflag` in difficulty 1 mode (Entry: 22646).
Creature (Entry: 30248) has different `npcflag` in difficulty 1 mode (Entry: 31749).
Creature (Entry: 13438) has different `npcflag` in difficulty 1 mode (Entry: 22698).
Creature (Entry: 34705) has different `npcflag` in difficulty 1 mode (Entry: 36088).
Creature (Entry: 13442, class 2) has different `unit_class` in difficulty 3 mode (Entry: 37239, class 1).
Creature (Entry: 37497, class 8) has different `unit_class` in difficulty 1 mode (Entry: 37603, class 1).
Creature (Entry: 17977) has different `npcflag` in difficulty 1 mode (Entry: 21582).
Creature (Entry: 14027, class 2) has different `unit_class` in difficulty 1 mode (Entry: 22584, class 1).
Creature (Entry: 13099, class 2) has different `unit_class` in difficulty 3 mode (Entry: 37331, class 1).
Creature (Entry: 13216) has different `npcflag` in difficulty 3 mode (Entry: 37315).
Creature (Entry: 13797) has different `npcflag` in difficulty 3 mode (Entry: 37367).
Creature (Entry: 20886) has different `npcflag` in difficulty 1 mode (Entry: 21624).
Creature (Entry: 14031, class 2) has different `unit_class` in difficulty 1 mode (Entry: 22586, class 1).
Creature (Entry: 33824, class 4) has different `unit_class` in difficulty 1 mode (Entry: 33831, class 2).
Creature (Entry: 14187) has different `npcflag` in difficulty 3 mode (Entry: 37240).
Creature (Entry: 3343) has different `npcflag` in difficulty 3 mode (Entry: 37318).
Creature (Entry: 12097) has different `npcflag` in difficulty 1 mode (Entry: 22648).
Creature (Entry: 11949, class 2) has different `unit_class` in difficulty 3 mode (Entry: 37243, class 1).
Creature (Entry: 13236, class 2) has different `unit_class` in difficulty 3 mode (Entry: 37371, class 1).
Creature (Entry: 30284) has different `npcflag` in difficulty 1 mode (Entry: 31451).
Creature (Entry: 19865) has different `npcflag` in difficulty 1 mode (Entry: 21562).
Creature (Entry: 36948) has different `npcflag` in difficulty 1 mode (Entry: 38157).
Creature (Entry: 11657, class 2) has different `unit_class` in difficulty 3 mode (Entry: 37366, class 1).
Creature (Entry: 13439) has different `npcflag` in difficulty 3 mode (Entry: 37484).
Creature (Entry: 13443, class 2) has different `unit_class` in difficulty 3 mode (Entry: 37284, class 1).
Creature (Entry: 13096, class 2) has different `unit_class` in difficulty 3 mode (Entry: 37264, class 1).
Creature (Entry: 37498, class 2) has different `unit_class` in difficulty 1 mode (Entry: 37605, class 1).
Creature (Entry: 17978) has different `npcflag` in difficulty 1 mode (Entry: 21581).
Creature (Entry: 13447) has different `npcflag` in difficulty 3 mode (Entry: 37278).
Creature (Entry: 13798) has different `npcflag` in difficulty 3 mode (Entry: 37345).
Creature (Entry: 14188) has different `npcflag` in difficulty 3 mode (Entry: 37281).
Creature (Entry: 11946) has different `npcflag` in difficulty 3 mode (Entry: 37283).
Creature (Entry: 2225) has different `npcflag` in difficulty 3 mode (Entry: 37486).
Creature (Entry: 37666, class 1) has different `unit_class` in difficulty 1 mode (Entry: 38479, class 8).
Creature (Entry: 11677, class 2) has different `unit_class` in difficulty 3 mode (Entry: 37431, class 1).
Creature (Entry: 5134) has different `npcflag` in difficulty 1 mode (Entry: 22651).
Creature (Entry: 3625) has different `npcflag` in difficulty 1 mode (Entry: 22654).
Creature (Entry: 13116, class 2) has different `unit_class` in difficulty 3 mode (Entry: 37236, class 1).
Creature (Entry: 10367) has different `npcflag` in difficulty 1 mode (Entry: 22655).
Creature (Entry: 36551, class 2) has different `unit_class` in difficulty 1 mode (Entry: 37564, class 1).
Creature (Entry: 34461, class 2) has different `unit_class` in difficulty 1 mode (Entry: 35743, class 1).
Creature (Entry: 30285) has different `npcflag` in difficulty 1 mode (Entry: 31457).
Creature (Entry: 4257) has different `npcflag` in difficulty 3 mode (Entry: 37349).
Creature (Entry: 13089) has different `npcflag` in difficulty 1 mode (Entry: 22730).
Creature (Entry: 34703) has different `npcflag` in difficulty 1 mode (Entry: 36087).
Creature (Entry: 13284, class 2) has different `unit_class` in difficulty 3 mode (Entry: 37308, class 1).
Creature (Entry: 35557) has different `npcflag` in difficulty 1 mode (Entry: 35560).
Creature (Entry: 17975) has different `npcflag` in difficulty 1 mode (Entry: 21558).
Creature (Entry: 33818, class 2) has different `unit_class` in difficulty 1 mode (Entry: 33827, class 1).
Creature (Entry: 33354, class 2) has different `unit_class` in difficulty 1 mode (Entry: 33729, class 1).
Creature (Entry: 13097) has different `npcflag` in difficulty 1 mode (Entry: 22734).
Creature (Entry: 19219) has different `npcflag` in difficulty 1 mode (Entry: 21533).
Creature (Entry: 13448) has different `npcflag` in difficulty 3 mode (Entry: 37398).
Creature (Entry: 14029, class 2) has different `unit_class` in difficulty 1 mode (Entry: 22582, class 1).
Creature (Entry: 33822, class 1) has different `unit_class` in difficulty 1 mode (Entry: 33828, class 2).
Creature (Entry: 14185) has different `npcflag` in difficulty 3 mode (Entry: 37370).
Creature (Entry: 13179) has different `npcflag` in difficulty 3 mode (Entry: 37479).
Creature (Entry: 13218) has different `npcflag` in difficulty 3 mode (Entry: 37320).
Creature (Entry: 13257) has different `npcflag` in difficulty 1 mode (Entry: 22567).
Creature (Entry: 11600, class 2) has different `unit_class` in difficulty 3 mode (Entry: 37337, class 1).
Creature (Entry: 13577) has different `npcflag` in difficulty 3 mode (Entry: 37422).
Creature (Entry: 5135) has different `npcflag` in difficulty 3 mode (Entry: 37427).
Creature (Entry: 10364) has different `npcflag` in difficulty 1 mode (Entry: 22660).
Creature (Entry: 11604, class 2) has different `unit_class` in difficulty 3 mode (Entry: 37470, class 1).
Creature (Entry: 13117, class 2) has different `unit_class` in difficulty 3 mode (Entry: 37323, class 1).
Creature (Entry: 5139) has different `npcflag` in difficulty 1 mode (Entry: 22652).
Creature (Entry: 20912) has different `npcflag` in difficulty 1 mode (Entry: 21601).
Creature (Entry: 13437) has different `npcflag` in difficulty 3 mode (Entry: 37480).
Creature (Entry: 19598) has different `npcflag` in difficulty 1 mode (Entry: 21561).
>> Loaded 46627 creature definitions in 1111 ms
Loading Equipment templates...
>> Loaded 10050 equipment templates in 30 ms
Loading Creature template addons...
Creature (Entry: 33292) has wrong spell 63029 defined in `auras` field in `creature_template_addon`.
>> Loaded 14212 creature template addons in 35 ms
Loading Reputation Reward Rates...
>> Loaded 14 reputation_reward_rate in 0 ms
Loading Creature Reputation OnKill Data...
>> Loaded 2002 creature award reputation definitions in 5 ms
Loading Reputation Spillover Data...
>> Loaded 28 reputation_spillover_template in 0 ms
Loading Points Of Interest Data...
>> Loaded 490 Points of Interest definitions in 1 ms
Loading Creature Base Stats...
>> Loaded 400 creature base stats in 8 ms
Loading Creature Data...
Table `creature` has creature (GUID: 223809) with non existing creature entry 61081, skipped.
Table `creature` have creature (GUID: 25 Entry: 6124) with `phaseMask`=0 (not visible for anyone), set to 1.
>> Loaded 173756 creatures in 1598 ms
Loading Temporary Summon Data...
>> Loaded 132 temp summons in 2 ms
Loading pet levelup spells...
>> Loaded 263 pet levelup and default spells for 50 families in 6 ms
Loading pet default spells additional to levelup spells...
>> Loaded addition spells for 0 pet spell data entries in 4 ms
Loading summonable creature templates...
>> Loaded 345 summonable creature templates in 5 ms
Loading Creature Addon Data...
Creature (GUID: 52542) does not exist but has a record in `creature_addon`
Creature (GUID: 23467) does not exist but has a record in `creature_addon`
Creature (GUID: 23466) does not exist but has a record in `creature_addon`
Creature (GUID: 23130) does not exist but has a record in `creature_addon`
Creature (GUID: 7690) does not exist but has a record in `creature_addon`
Creature (GUID: 14459) does not exist but has a record in `creature_addon`
Creature (GUID: 14458) does not exist but has a record in `creature_addon`
Creature (GUID: 14456) does not exist but has a record in `creature_addon`
Creature (GUID: 14449) does not exist but has a record in `creature_addon`
Creature (GUID: 14448) does not exist but has a record in `creature_addon`
>> Loaded 16440 creature addons in 43 ms
Loading Gameobject Data...
Table `gameobject` has gameobject (GUID: 1235 Entry: 20651) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 1234 Entry: 20649) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 1233 Entry: 20650) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 1232 Entry: 20652) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 1231 Entry: 20654) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 1230 Entry: 20653) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 1229 Entry: 20656) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 1228 Entry: 20655) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 1227 Entry: 20657) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 1209 Entry: 152614) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 1208 Entry: 205080) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 1207 Entry: 205079) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 1206 Entry: 152614) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 1195 Entry: 149046) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 1194 Entry: 149045) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 9339 Entry: 20651) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 9338 Entry: 20649) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 9337 Entry: 20650) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 9336 Entry: 20653) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 9335 Entry: 20652) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 9334 Entry: 20654) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 9333 Entry: 20656) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 9332 Entry: 20655) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 9331 Entry: 20657) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 9312 Entry: 152614) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 9310 Entry: 205080) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 9309 Entry: 205079) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 9307 Entry: 152614) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 9299 Entry: 149046) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 9298 Entry: 149045) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 82509 Entry: 149045) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 82508 Entry: 149046) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 82505 Entry: 205080) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 82504 Entry: 205079) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 82503 Entry: 152614) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 82502 Entry: 152614) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 82475 Entry: 20651) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 82474 Entry: 20649) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 82473 Entry: 20650) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 82472 Entry: 20657) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 82471 Entry: 20655) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 82470 Entry: 20656) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 82469 Entry: 20653) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 82468 Entry: 20652) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 82467 Entry: 20654) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 937 Entry: 152614) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 897 Entry: 4171) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 896 Entry: 4170) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 895 Entry: 47297) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 894 Entry: 47296) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 891 Entry: 204246) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 888 Entry: 204245) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 887 Entry: 152614) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 884 Entry: 206609) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 878 Entry: 207889) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 877 Entry: 204244) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 876 Entry: 204243) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 875 Entry: 196837) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 874 Entry: 11898) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 873 Entry: 11899) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 789) with non existing gameobject entry 205033, skipped.
Table `gameobject` has gameobject (GUID: 99716) with non existing gameobject entry 300242, skipped.
Table `gameobject` has gameobject (GUID: 5428 Entry: 149045) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 5429 Entry: 149046) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 5431 Entry: 152614) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 5432 Entry: 205079) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 5433 Entry: 205080) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 5434 Entry: 152614) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 5461 Entry: 20657) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 5462 Entry: 20655) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 5463 Entry: 20656) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 5464 Entry: 20654) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 5465 Entry: 20652) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 5466 Entry: 20653) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 5467 Entry: 20650) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 5468 Entry: 20649) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 5469 Entry: 20651) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 3279 Entry: 20651) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 3278 Entry: 20649) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 3277 Entry: 20650) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 3276 Entry: 20653) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 3275 Entry: 20652) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 3274 Entry: 20654) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 3273 Entry: 20656) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 3272 Entry: 20655) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 3271 Entry: 20657) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 3244 Entry: 205080) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 3243 Entry: 205079) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 3242 Entry: 152614) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 3241 Entry: 152614) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 3239 Entry: 149045) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 3238 Entry: 149046) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 48067 Entry: 152614) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 48036 Entry: 4171) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 48035 Entry: 4170) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 48034 Entry: 11898) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 48033 Entry: 11899) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 48032 Entry: 47296) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 48031 Entry: 47297) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 48014 Entry: 204245) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 48012 Entry: 204244) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 48009 Entry: 204246) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 48007 Entry: 204243) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 48006 Entry: 152614) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 48005 Entry: 196837) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 48004 Entry: 207889) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 77 Entry: 206610) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 76 Entry: 206608) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 47997 Entry: 206609) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 79512 Entry: 20654) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 79513 Entry: 20652) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 79514 Entry: 20653) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 79515 Entry: 20656) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 79516 Entry: 20655) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 79517 Entry: 20657) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 79518 Entry: 20650) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 79519 Entry: 20649) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 79520 Entry: 20651) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 79523 Entry: 152614) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 79525 Entry: 152614) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 79526 Entry: 205079) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 79527 Entry: 205080) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 79529 Entry: 149046) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 79530 Entry: 149045) with invalid `state` (24) value, skip
Table `gameobject` has gameobject (GUID: 164245 Entry: 207547) with invalid `state` (24) value, skip
Gameobject (GUID: 7083 Entry 190191 GoType: 8) has an invalid displayId (1287), not loaded.
Gameobject (GUID: 576 Entry 190557 GoType: 8) has an invalid displayId (1287), not loaded.
Gameobject (GUID: 574 Entry 190557 GoType: 8) has an invalid displayId (1287), not loaded.
Gameobject (GUID: 573 Entry 190557 GoType: 8) has an invalid displayId (1287), not loaded.
Gameobject (GUID: 572 Entry 190557 GoType: 8) has an invalid displayId (1287), not loaded.
Gameobject (GUID: 571 Entry 190557 GoType: 8) has an invalid displayId (1287), not loaded.
Gameobject (GUID: 570 Entry 190557 GoType: 8) has an invalid displayId (1287), not loaded.
Gameobject (GUID: 569 Entry 190557 GoType: 8) has an invalid displayId (1287), not loaded.
Gameobject (GUID: 568 Entry 190557 GoType: 8) has an invalid displayId (1287), not loaded.
Gameobject (GUID: 567 Entry 190557 GoType: 8) has an invalid displayId (1287), not loaded.
Gameobject (GUID: 566 Entry 190557 GoType: 8) has an invalid displayId (1287), not loaded.
Gameobject (GUID: 565 Entry 190557 GoType: 8) has an invalid displayId (1287), not loaded.
Gameobject (GUID: 564 Entry 190557 GoType: 8) has an invalid displayId (1287), not loaded.
>> Loaded 57847 gameobjects in 640 ms
Loading Creature Linked Respawn...
>> Loaded 5319 linked respawns in 11 ms
Loading Weather Data...
>> Loaded 35 weather definitions in 1 ms
Loading Quests...
Quest 13547 has `RewardSpellCast` = 62095 but spell 62095 does not exist, quest will not have a spell reward.
Quest 28314 has `RewardSpellCast` = 89848 but spell 89848 does not exist, quest will not have a spell reward.
Quest 14070 has `RewardSpellCast` = 91182 but spell 91182 does not exist, quest will not have a spell reward.
Quest 25719 has `RewardSpellCast` = 79032 but spell 79032 does not exist, quest will not have a spell reward.
Quest 14012 has `RewardSpellCast` = 90062 but spell 90062 does not exist, quest will not have a spell reward.
Quest 28440 has `RewardSpellCast` = 98867 but spell 98867 does not exist, quest will not have a spell reward.
Quest 14109 has `RewardSpellCast` = 66766 but spell 66766 does not exist, quest will not have a spell reward.
Quest 28140 has `RewardSpellCast` = 89762 but spell 89762 does not exist, quest will not have a spell reward.
Quest 24993 has `RewardSpellCast` = 73219 but spell 73219 does not exist, quest will not have a spell reward.
Quest 24964 has `RewardSpellCast` = 73421 but spell 73421 does not exist, quest will not have a spell reward.
Quest 24974 has `RewardSpellCast` = 73435 but spell 73435 does not exist, quest will not have a spell reward.
Quest 11466 has `RequiredSourceItemId2` = 34117 but item with entry 34117 does not exist, quest can't be done.
Quest 28034 has `RewardSpellCast` = 88469 but spell 88469 does not exist, quest will not have a spell reward.
Quest 25807 has `RewardSpellCast` = 87523 but spell 87523 does not exist, quest will not have a spell reward.
Quest 28712 has `RewardSpellCast` = 95203 but spell 95203 does not exist, quest will not have a spell reward.
Quest 28315 has `RewardSpellCast` = 89848 but spell 89848 does not exist, quest will not have a spell reward.
Quest 14071 has `RewardSpellCast` = 66607 but spell 66607 does not exist, quest will not have a spell reward.
Quest 25139 has `RewardSpellCast` = 73663 but spell 73663 does not exist, quest will not have a spell reward.
Quest 14013 has `RewardSpellCast` = 90062 but spell 90062 does not exist, quest will not have a spell reward.
Quest 26088 has `RewardSpellCast` = 78492 but spell 78492 does not exist, quest will not have a spell reward.
Quest 28228 has `RewardSpellCast` = 89669 but spell 89669 does not exist, quest will not have a spell reward.
Quest 25691 has `RewardSpellCast` = 79034 but spell 79034 does not exist, quest will not have a spell reward.
Quest 28170 has `RewardSpellCast` = 94552 but spell 94552 does not exist, quest will not have a spell reward.
Quest 14110 has `RewardSpellCast` = 66766 but spell 66766 does not exist, quest will not have a spell reward.
Quest 27744 has `RewardSpellCast` = 87003 but spell 87003 does not exist, quest will not have a spell reward.
Quest 24965 has `RewardSpellCast` = 73421 but spell 73421 does not exist, quest will not have a spell reward.
Quest 25149 has `RewardSpellCast` = 73663 but spell 73663 does not exist, quest will not have a spell reward.
Quest 24520 has `RewardSpellCast` = 91182 but spell 91182 does not exist, quest will not have a spell reward.
Quest 28219 has `RewardSpellCast` = 89550 but spell 89550 does not exist, quest will not have a spell reward.
Quest 28316 has `RewardSpellCast` = 90372 but spell 90372 does not exist, quest will not have a spell reward.
Quest 27038 has `RewardSpellCast` = 83737 but spell 83737 does not exist, quest will not have a spell reward.
Quest 26186 has `RewardSpellCast` = 79032 but spell 79032 does not exist, quest will not have a spell reward.
Quest 28326 has `RewardSpellCast` = 89249 but spell 89249 does not exist, quest will not have a spell reward.
Quest 24966 has `RewardSpellCast` = 73421 but spell 73421 does not exist, quest will not have a spell reward.
Quest 25731 has `RewardSpellCast` = 79204 but spell 79204 does not exist, quest will not have a spell reward.
Quest 14121 has `RewardSpellCast` = 91203 but spell 91203 does not exist, quest will not have a spell reward.
Quest 25189 has `RewardSpellCast` = 73750 but spell 73750 does not exist, quest will not have a spell reward.
Quest 27329 has `RewardSpellCast` = 95940 but spell 95940 does not exist, quest will not have a spell reward.
Quest 28278 has `RewardSpellCast` = 98867 but spell 98867 does not exist, quest will not have a spell reward.
Quest 28220 has `RewardSpellCast` = 89550 but spell 89550 does not exist, quest will not have a spell reward.
Quest 28346 has `RewardSpellCast` = 89978 but spell 89978 does not exist, quest will not have a spell reward.
Quest 25141 has `RewardSpellCast` = 73663 but spell 73663 does not exist, quest will not have a spell reward.
Quest 28414 has `RewardSpellCast` = 91127 but spell 91127 does not exist, quest will not have a spell reward.
Quest 24967 has `RewardSpellCast` = 73421 but spell 73421 does not exist, quest will not have a spell reward.
Quest 14122 has `RewardSpellCast` = 91203 but spell 91203 does not exist, quest will not have a spell reward.
Quest 30109 has `NextQuestIdChain` = 30113 but quest 30113 does not exist, quest chain will not work.
Quest 30109 has PrevQuestId 30108, but no such quest
Quest 27330 has `RewardSpellCast` = 95940 but spell 95940 does not exist, quest will not have a spell reward.
Quest 28279 has `RewardSpellCast` = 98867 but spell 98867 does not exist, quest will not have a spell reward.
Quest 28221 has `RewardSpellCast` = 89781 but spell 89781 does not exist, quest will not have a spell reward.
Quest 27369 has `RewardSpellCast` = 94998 but spell 94998 does not exist, quest will not have a spell reward.
Quest 11934 has `RequiredItemId1` = 37103 but item with entry 37103 does not exist, quest can't be done.
Quest 905 has `ReqSpellCast4` = 5316 and RequiredNpcOrGo4 = 0 but spell 5316 does not have SPELL_EFFECT_QUEST_COMPLETE or SPELL_EFFECT_SEND_EVENT effect for this quest, quest can't be done.
Quest 24503 has `RewardSpellCast` = 91127 but spell 91127 does not exist, quest will not have a spell reward.
Quest 29519 has `RequiredNpcOrGo1` = -209276 but gameobject 209276 does not exist, quest can't be done.
Quest 24968 has `RewardSpellCast` = 73421 but spell 73421 does not exist, quest will not have a spell reward.
Quest 25520 has `RewardSpellCast` = 87477 but spell 87477 does not exist, quest will not have a spell reward.
Quest 25704 has `RewardSpellCast` = 76875 but spell 76875 does not exist, quest will not have a spell reward.
Quest 25491 has `RewardSpellCast` = 87477 but spell 87477 does not exist, quest will not have a spell reward.
Quest 14123 has `RewardSpellCast` = 91203 but spell 91203 does not exist, quest will not have a spell reward.
Quest 27089 has `RewardSpellCast` = 84205 but spell 84205 does not exist, quest will not have a spell reward.
Quest 24736 has `RewardSpellCast` = 72533 but spell 72533 does not exist, quest will not have a spell reward.
Quest 14007 has `RewardSpellCast` = 90062 but spell 90062 does not exist, quest will not have a spell reward.
Quest 27060 has `RewardSpellCast` = 83854 but spell 83854 does not exist, quest will not have a spell reward.
Quest 28222 has `RewardSpellCast` = 89781 but spell 89781 does not exist, quest will not have a spell reward.
Quest 24707 has `RewardSpellCast` = 72955 but spell 72955 does not exist, quest will not have a spell reward.
Quest 25143 has `RewardSpellCast` = 73663 but spell 73663 does not exist, quest will not have a spell reward.
Quest 13988 has `RewardSpellCast` = 94641 but spell 94641 does not exist, quest will not have a spell reward.
Quest 24688 has `SourceItemId` = 50770 but item with entry 50770 does not exist, quest can't be done.
Quest 24688 has `RequiredItemId1` = 50770 but item with entry 50770 does not exist, quest can't be done.
Quest 24969 has `RewardSpellCast` = 73421 but spell 73421 does not exist, quest will not have a spell reward.
Quest 14124 has `RewardSpellCast` = 91203 but spell 91203 does not exist, quest will not have a spell reward.
Quest 25192 has `RewardSpellCast` = 73751 but spell 73751 does not exist, quest will not have a spell reward.
Quest 27516 has `RewardSpellCast` = 85448 but spell 85448 does not exist, quest will not have a spell reward.
Quest 27090 has `RewardSpellCast` = 84205 but spell 84205 does not exist, quest will not have a spell reward.
Quest 14008 has `RewardSpellCast` = 90062 but spell 90062 does not exist, quest will not have a spell reward.
Quest 25502 has `RewardSpellCast` = 87477 but spell 87477 does not exist, quest will not have a spell reward.
Quest 25202 has `RewardSpellCast` = 73915 but spell 73915 does not exist, quest will not have a spell reward.
Quest 28446 has `RewardSpellCast` = 90404 but spell 90404 does not exist, quest will not have a spell reward.
Quest 25193 has `RewardSpellCast` = 73752 but spell 73752 does not exist, quest will not have a spell reward.
Quest 14435 has `RewardSpellCast` = 95818 but spell 95818 does not exist, quest will not have a spell reward.
Quest 14009 has `RewardSpellCast` = 90062 but spell 90062 does not exist, quest will not have a spell reward.
Quest 13980 has `RewardSpellCast` = 94710 but spell 94710 does not exist, quest will not have a spell reward.
Quest 24864 has `RewardSpellCast` = 83137 but spell 83137 does not exist, quest will not have a spell reward.
Quest 29328 has `RewardSpellCast` = 99730 but spell 99730 does not exist, quest will not have a spell reward.
Quest 27372 has `RewardSpellCast` = 94998 but spell 94998 does not exist, quest will not have a spell reward.
Quest 25203 has `RewardSpellCast` = 73915 but spell 73915 does not exist, quest will not have a spell reward.
Quest 14474 has `RewardSpellCast` = 68685 but spell 68685 does not exist, quest will not have a spell reward.
Quest 25145 has `RewardSpellCast` = 73663 but spell 73663 does not exist, quest will not have a spell reward.
Quest 28447 has `RewardSpellCast` = 90404 but spell 90404 does not exist, quest will not have a spell reward.
Quest 29338 has `RewardSpellCast` = 100562 but spell 100562 does not exist, quest will not have a spell reward.
Quest 14242 has `RewardSpellCast` = 69082 but spell 69082 does not exist, quest will not have a spell reward.
Quest 26017 has `RewardSpellCast` = 78492 but spell 78492 does not exist, quest will not have a spell reward.
Quest 13884 has `RewardSpellCast` = 65167 but spell 65167 does not exist, quest will not have a spell reward.
Quest 26143 has `RewardSpellCast` = 79052 but spell 79052 does not exist, quest will not have a spell reward.
Quest 14010 has `RewardSpellCast` = 90062 but spell 90062 does not exist, quest will not have a spell reward.
Quest 29203 has `RewardSpellCast` = 101170 but spell 101170 does not exist, quest will not have a spell reward.
Quest 28448 has `RewardSpellCast` = 90372 but spell 90372 does not exist, quest will not have a spell reward.
Quest 25243 has `RewardSpellCast` = 73962 but spell 73962 does not exist, quest will not have a spell reward.
Quest 25611 has `RewardSpellCast` = 77462 but spell 77462 does not exist, quest will not have a spell reward.
Quest 14001 has `RewardSpellCast` = 68685 but spell 68685 does not exist, quest will not have a spell reward.
Quest 25195 has `RewardSpellCast` = 73753 but spell 73753 does not exist, quest will not have a spell reward.
Quest 26938 has `RewardSpellCast` = 84192 but spell 84192 does not exist, quest will not have a spell reward.
Quest 14011 has `RewardSpellCast` = 90062 but spell 90062 does not exist, quest will not have a spell reward.
Quest 28439 has `RewardSpellCast` = 98867 but spell 98867 does not exist, quest will not have a spell reward.
Quest 25147 has `RewardSpellCast` = 73663 but spell 73663 does not exist, quest will not have a spell reward.
Quest 28449 has `RewardSpellCast` = 89249 but spell 89249 does not exist, quest will not have a spell reward.
Quest 25244 has `RewardSpellCast` = 73962 but spell 73962 does not exist, quest will not have a spell reward.
Quest 25612 has `RewardSpellCast` = 77462 but spell 77462 does not exist, quest will not have a spell reward.
Quest 26164 has `RewardSpellCast` = 79034 but spell 79034 does not exist, quest will not have a spell reward.
>> Loaded 14987 quests definitions in 652 ms
Checking Quest Disables
>> Checked 5123 quest disables in 0 ms
Loading Quest POI
>> Loaded 22136 quest POI definitions in 190 ms
Loading Quests Starters and Enders...
Loading GO Start Quest Data...
[1146] Table 'world.gameobject_queststarter' doesn't exist
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.
 

 

 

thanks a lot to read me and thank to try to help me.

Edited by rommni
Link to comment
Share on other sites

--- Canned message start ---

Read http://www.trinitycore.org/f/topic/1518-trouble-with-your-trinity-install-readme-1st-faqs/

Also please Look in upper right hand corner of the forum, there is a button labeled search field, feel free to search for your issues first before posting, most questions like this one have already been answered.

If you still cannot find the answers you seek feel free to make a post and tell us the steps you took to resolve this issue and we will do our best to help you.

--- Canned message end ---

Link to comment
Share on other sites

hi i cant find answer for me here http://www.trinitycore.org/f/topic/1518-trouble-with-your-trinity-install-readme-1st-faqs/

my error is missing tables ([1146] Table 'world.gameobject_queststarter' doesn't exist)

 

i have lasted db 4.3.4 (http://www.trinitycore.org/f/files/file/9-tdb-full-434/)

and update from https://github.com/TrinityCore/TrinityCore_4.3.4_DB_Alpha

core to 4.3.4 lasted version

 

please help me thx.

Edited by riptide
Link to comment
Share on other sites

  • 2 weeks later...

Hello,

I wanted to compile 4.3.4 trinitycore server but I got worldserver error i've been trying to fix few days.I already had 4.3.4 server before but i didn't have this problem.I have 3.5.5a one too.

 

Let's start:

I cloned 4.3.4 branch

Cmake 

Visual studio build

Made maps/vmaps/dbc

Edited configs

Created db

Downloaded latest TDB

Added updates from TrinityCore_4.3.4_DB_Alpha-master/updates

 

And for result I got Authserver working perfectly but worldserver keeps getting error:

 

Server:

 

Using configuration file worldserver.conf.

Using SSL version: OpenSSL 1.0.1e 11 Feb 2013 (library: OpenSSL 1.0.1e 11 Feb 2013)
Using ACE version: 6.1.4
TrinityCore rev. f16f427c48cb 2013-08-18 18:13:14 +0200 (4.3.4 branch) (Win32, Release) (worldserver-daemon)
<Ctrl-C> to stop.
 
 ______                       __
/__  _       __          __/ __
/_/ / _ __ /_    ___ /_ , _  __  __
    /`'__/ /' _ `/ / / /
    / / / _ _
      _ _   _ _ _ _ __/`____
      /_//_/   /_//_//_//_//__/ `/___/>
                                 C O R E  /___/
http://TrinityCore.org                    /__/
 
In mysql_stmt_prepare() id: 56, sql: "SELECT difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, exp_unk, faction_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, unit_flags2, dynamicflags, family, trainer_type, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, type_flags2, 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, Health_mod, Mana_mod, Mana_mod_extra, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?"
Unknown column 'unit_flags2' in 'field list'
DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to world database 127.0.0.1;3306;root;ascent;world

 

 

My MySQL username and password are right.If they aren't authserver wouldn't work.

 

 

DB Errors:

In mysql_stmt_prepare() id: 56, sql: "SELECT difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, exp_unk, faction_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, unit_flags2, dynamicflags, family, trainer_type, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, type_flags2, 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, Health_mod, Mana_mod, Mana_mod_extra, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?"

Unknown column 'unit_flags2' in 'field list'

Thanks in advance.

I saw some issues like mine but I did not download 3.5.5a branch and added 4.3.4 db or opposite.

Edited by Snickers
Link to comment
Share on other sites

 Share

  • Recently Browsing   0 members

    No registered users viewing this page.


  • Similar Content

    • By xgamerninjax
      Hello all, first time posting here and it's really got me scratching my head.
      I've compiled everything on my own computer, and then transferred everything to a host computer so the server can stay live. The server was running fine for a month or so and then suddenly it just crashes when it hits "Loading C++ scripts", exiting saying "caught signal 22"
      I tried setting up the host computer from scratch and transferred everything over fresh and it's still happening for some reason. (Note, I can run the server perfectly on my personal pc where I compiled it.)
      Any help would be greatly appreciated, thanks!
      3d7e3a40e2b3+_worldserver.exe_[1-4_15-19-45].dmp 3d7e3a40e2b3+_worldserver.exe_[1-4_15-19-45].txt
    • By Rochet2
      A lot of people have asked how to debug so I made this short guide on how to set up debugging.
      This guide only tells you how to actually set up debugging in TrinityCore on Windows and Linux.
      This will not explain the basics of debugging. You can google those or play around with the debugger to learn.
      Here are a few videos that explain how to actually debug after setting debugging up on visual studio: https://youtu.be/0ebzPwixrJA and linux: https://www.youtube.com/watch?v=sCtY--xRUyI

      This guide contains multiple guides. Each list of bullet points is it's own guide.
      Make sure you can run the server normally before trying to debug.

      Windows:
      On Windows before anything you should check these
      - Before debugging or making crashlogs etc. with Visual Studio you must compile the core in "Debug" instead of "Release". You can select this in "Build>Configuration Manager" or at the top of Visual Studio window http://i.imgur.com/5oHd59j.png
      - You also need to move the new pdb files generate by compiling in debug mode on Visual Studio from the compile output folder (bin) to your server folder - these files contain information needed for debugging.
      - It is assumed that Solution Explorer is open. Open it by selecting "View>Solution Explorer" in Visual Studio http://i.imgur.com/hkW6Gk0.png
      -- You may want to click on the Home icon to reset the view on Solution Explorer http://i.imgur.com/N8UPwDh.png
      - You can place breakpoints in Visual Studio editor by right clicking a line of code and selecting "Breakpoint>Insert Breakpoint" http://i.imgur.com/L2TxBVG.png
      - At the top of the window you should see controls for stepping and continuing when you have started to debug.
      - Here is a video showing the basic Visual Studio functionality https://www.youtube.com/watch?v=Ijdk4z8-2OI
      Fastest way to debug on windows. This is the easiest way to start up debugging a script.
      - Start the authserver and worldserver normally
      - Open TrinityCore.sln in Visual Studio. This is what you usually open when you want to compile the core
      - In Visual Studio at the top select "Debug>Attach to process...>worldserver.exe" and click "Attach" http://i.imgur.com/jDEI2Hq.png
      - You are now debugging
       
      The second slower way of debugging on windows. This is useful for debugging something that occurs in the startup of the server.
      - Open TrinityCore.sln in Visual Studio. This is what you usually open when you want to compile the core
      - In solution explorer right click on worldserver and select "Set as StartUp Project" http://i.imgur.com/wvMzeRA.png
      - In solution explorer right click on worldserver and select "Properties" http://i.imgur.com/rTNEF9O.png
      -- In Properties you should go to "Configuration Properties>Debugging" and edit "Working Directory" to point to the server folder. For me this is the default compile folder so I use "$(OutDir)" http://i.imgur.com/aRI29fB.png
      - Start the authserver normally
      - Start the worldserver by selecting "Debug>Start Debugging". The server will start with debugging attached from the beginning http://i.imgur.com/cg1KJNw.png
      - You are now debugging
      Crashlogs on windows. Once you have a way to reproduce a crash you can get a crashlog that can help you resolve it.
      - After compiling the core in "Debug" instead of "Release" start up the worldserver and authserver
      - Reproduce the crash you have
      - In the server folder there is now a folder called Crashes that contains txt and dmp files. http://i.imgur.com/9eQIdql.png
      - You can open the txt files in text editors http://i.imgur.com/EH6R17E.png
      -- At the top of a txt file there is some information about your system and below it there is the Call Stack and below that there are Variables of each part of the call stack
      -- The Call Stack will tell you at the top what was the last function call before crashing and what function calls led to that function call.
      -- Next to the function names there is the file that the function is defined in and the line number the code was executing in that function.
      -- In the Variables section you can inspect variables that were present at each function call.
      -- Based on this information you are often able to see what crashed or get a better view of what you need to inspect more in your code.
      - The dmp file can be opened in Visual Studio
      -- Open TrinityCore.sln in Visual Studio. This is what you usually open when you want to compile the core
      -- Drag and drop the dmp file to Visual Studio
      -- In the window that opens click to "Debug with Native Only" http://i.imgur.com/OgyU2kM.png
      -- In the window popup click "Break" http://i.imgur.com/4jDzqRn.png
      -- You are now in a state like you would have hit a break point in the code or a crash while debugging. You can inspect the call stack and the variables.
      Edit and continue on windows. When debugging this allows you to change the code and without restarting the server apply those changes so they actually work ingame.
      - Open TrinityCore.sln in Visual Studio. This is what you usually open when you want to compile the core
      - In solution explorer right click on worldserver and select "Properties" http://i.imgur.com/rTNEF9O.png
      -- In Properties select "Configuration Properties>Linker>General" and set "Enable Incremental Linking" to "Yes". http://i.imgur.com/caQqwN5.png
      -- In Properties select "Configuration Properties>Linker>Advanced" and set "Image Has Safe Exception Handlers" to "No". http://i.imgur.com/FYzN8Ks.png
      -- In Properties select "Configuration Properties>C/C++>General" and set "Debug Information Format" to "Program Database for Edit And Continue". http://i.imgur.com/pxQ6I8N.png
      - At the top of the window select "Tools>Options". In the Options select "Debugging>General" and in there select "Enable Edit and Continue", "Enable Native Edit and Continue" and "Require source files to exactly match the original version".
      - Compile the server for the changes to take effect.
      - Set up "The second slower way of debugging" (I did not test edit and continue on other configurations)
      - Start the authserver normally
      - Start the worldserver by selecting "Debug>Start Debugging".
      - Try edit a cpp file a little and save it.
      - At top of Visual Studio window select "Debug>Apply Code Changes" and wait until the changes are applied. Warning: it can take considerable amount of time for the changes to be applied. http://i.imgur.com/77pb58E.png
      - If you have issues, be sure to check the error messages in Output. You can view it by selecting "View>Output" http://i.imgur.com/4cIznW9.png
      - This guide was written based on https://msdn.microsoft.com/en-us/library/esaeyddf.aspx and https://blogs.msdn.microsoft.com/vcblog/2015/07/22/c-edit-and-continue-in-visual-studio-2015/
      Linux:
      First we need to compile the server in debug mode.
      - Compile the server with the cmake flag -DCMAKE_BUILD_TYPE=Debug

      Debugging on linux. You can debug on linux by using GDB.
      - Here is a good video about it: https://www.youtube.com/watch?v=sCtY--xRUyI
      - Basically you
      -- Start the authserver
      -- Start the worldserver by using "gdb ./worldserver"
      -- Enter breakpoints by using break command on gdb
      -- Use the run command on gdb to start the server
      -- You are now debugging
      - You may also be interested in using VScode or some other more visual debuggers. https://www.youtube.com/watch?v=B0xTgyCwsAo
      Crashlogs on linux. Once you have a way to reproduce a crash you can get a crashlog that can help you resolve it.
      - Take crashreport.gdb from /contrib/debugger from source folder and place it to your server folder
      - Start the authserver
      - Start the worldserver by using "gdb -x crashreport.gdb ./worldserver"
      - Reproduce your crash
      - There should be a backtrace.log in your server folder that contains information about the crash like the callstack and variables in each function call in the call stack
      - This guide was written based on https://github.com/TrinityCore/TrinityCore/blob/master/contrib/debugger/README
      Running valgrind on linux. This helps you find memory errors like invalid reads and writes and memory leaks.
      - Here is a good video about it: https://www.youtube.com/watch?v=fvTsFjDuag8
      - Basically you
      -- Start the authserver
      -- Start the worldserver by using "valgrind ./worldserver"
      -- Run your code that you want to analyze and close the server
      -- The console or an output log should contain the valgrind log
    • By reyne
      Hey there!

      I've followed a few threads here about map extraction, and am still having issues. Originally, I was having the issue described here.
      After following the advice given in that thread (creating characters of both BC races and running around for a bit), I am no longer getting that error, however now I get the following error while trying to extract maps:

      `Error loading World\Maps\Expansion01\Expansion01_42_6.adt`

      This repeats for every line in Expansion01, and then the extractor crashes.

      I'm not sure where else to go from here.

      Thanks for your help

      Edit: I've created an 85 on an i85 server and flown all around Outland now, same issue.
    • By Uee
      I recently found the Trinity Cataclsym Preservation Project and thought I will try it out.
      I am already running 3.3.5a and Master - both server run great
      Pulled 4.3.4 down using Git and built it same way as others:
      boost_1_73_0 cmake 3.17.2 Mysql 5.7.30 VS Community 2019 Built fine - no issue. Used 'Extractor.bat' to run all the map extractors - worked great!
      Noticed there was extra file 'connection_patcher.exe`, ran that - worked great! Now have "wow_patched" and use this to launch client
      MySQL runs in standalone mode, -initialize, added base sql files, imported, auth and character sql files
      Configured both the .conf files and passwords, IPs etc are all in place.
      Note: When loading the exe and built conf file, bnetserver complain about these items missing, so I add them:
      Updates.AutoSetup = 1 Updates.EnableDatabases = 0 LoginDatabase.SynchThreads = 1 Load up Mysql - loads fine
      Load up bnetserver and appears to load ok - last few lines look like this:
      Connected to MySQL database at 127.0.0.1
      DatabasePool 'auth' opened successfully. 2 total connections running.
      Started auth database connection pool.
      Listening on connections from worldservers on port 1118...
      Load up worldserver and it adds the FULL world and hotfixes, then applied all updates (confirmed archived in SQL) - last few lines look like this:
      Calculate next monthly quest reset time...
      Calculate random battleground reset time...
      Calculate guild limitation(s) reset time...
      Calculate next currency reset time...
      World initialized in 0 minutes 13 seconds
      TrinityCore rev. d0c7bbab40bc 2020-05-06 00:01:21 +0200 (master branch) (Win64, RelWithDebInfo, Static) (worldserver-daemon) ready...
       
      There are no db errors in logs.
      Config.wtf contain portal, realmlist as remote server and patchlist as localhost.
      When I try to connecting using "user@local" and password I get immediately disconnected.
      What I did noticed different is that the bnetserver doesnt add "Added realm "Battle for Azeroth" at 192.168.10.213:8085." (From my Master log) 
      3.3.5a also have this line as last line in authserver - but 4.3.4 is not giving me this one.
      Realmlist table is accurate with right information.
      Anyone know why bnetserver is not starting me realm?
       
    • By Deer_Hunter
      Hello all,
      I just updated from the latest Git 
      Trinity Core REV. ac6baa547376 + 2020-02-21  3.3.5 Branch.
      I'm getting this error after crash.
      Problem signature:
        Problem Event Name:    APPCRASH
        Application Name:    worldserver.exe
        Application Version:    0.0.0.0
        Application Timestamp:    5e50a462
        Fault Module Name:    StackHash_f12f
        Fault Module Version:    6.3.9600.19629
        Fault Module Timestamp:    5e2fdc0d
        Exception Code:    c0000374
        Exception Offset:    PCH_9E_FROM_ntdll+0x0000000000090D0A
        OS Version:    6.3.9600.2.0.0.272.7
        Locale ID:    1033
        Additional Information 1:    f12f
        Additional Information 2:    f12f0934d3e965f73c68e60f20f2cd40
        Additional Information 3:    7595
        Additional Information 4:    7595e4d8d703db9dcd3d2f6ea540e357
      the exception code says its a Heap error,  I'm not sure how to troubleshoot this.
      Thanks
×
×
  • Create New...