OregonCore icon indicating copy to clipboard operation
OregonCore copied to clipboard

A list of existing MySQL issues.

Open JustZerooo opened this issue 5 years ago • 0 comments

2019-09-28 17:06:39 Table `creature` has creature (GUID: 79007 Entry: 22987) with `MovementType`=0 (idle) have `spawndist`<>0, set to 0.
2019-09-28 17:06:39 Table `creature` has creature (GUID: 79008 Entry: 22987) with `MovementType`=0 (idle) have `spawndist`<>0, set to 0.
2019-09-28 17:06:39 Table `creature` has creature (GUID: 79009 Entry: 22987) with `MovementType`=0 (idle) have `spawndist`<>0, set to 0.
2019-09-28 17:06:39 Creature (Entry: 18946) has wrong auras data in creature_template_addon.
2019-09-28 17:06:39 Creature (GUID: 83939) does not exist but has a record in creature_addon
2019-09-28 17:06:40 Table `gameobject` has gameobject (GUID: 99901) with invalid gameobject entry 181046, skipped.
2019-09-28 17:06:40 Table `gameobject` has gameobject (GUID: 99905) with invalid gameobject entry 181050, skipped.
2019-09-28 17:06:40 Table `gameobject` has gameobject (GUID: 268876) with invalid gameobject entry 181052, skipped.
2019-09-28 17:06:40 Table `gameobject` has gameobject (GUID: 268880) with invalid gameobject entry 181096, skipped.
2019-09-28 17:06:40 Table gameobject_queststarter has data gameobject entry (51708) for quest 254, but GO is not GAMEOBJECT_TYPE_QUESTGIVER
2019-09-28 17:06:40 Table gameobject_questender has data gameobject entry (51708) for quest 254, but GO is not GAMEOBJECT_TYPE_QUESTGIVER
2019-09-28 17:06:40 Spell Effect -33897 listed in spell_linked_spell does not exist
2019-09-28 17:06:41 SourceEntry 28731 in `conditions` table, has ConditionType 31. Only CONDITION_SPELL_SCRIPT_TARGET(17) is valid for CONDITION_SOURCE_TYPE_SPELL_SCRIPT_TARGET(14), ignoring.
2019-09-28 17:06:41 SourceEntry 32958 in `conditions` table, has ConditionType 31. Only CONDITION_SPELL_SCRIPT_TARGET(17) is valid for CONDITION_SOURCE_TYPE_SPELL_SCRIPT_TARGET(14), ignoring.
2019-09-28 17:06:41 SourceEntry 37281 in `conditions` table, has ConditionType 31. Only CONDITION_SPELL_SCRIPT_TARGET(17) is valid for CONDITION_SOURCE_TYPE_SPELL_SCRIPT_TARGET(14), ignoring.
2019-09-28 17:06:41 SourceEntry 37281 in `conditions` table, has ConditionType 31. Only CONDITION_SPELL_SCRIPT_TARGET(17) is valid for CONDITION_SOURCE_TYPE_SPELL_SCRIPT_TARGET(14), ignoring.
2019-09-28 17:06:41 SourceEntry 38722 in `conditions` table, has ConditionType 31. Only CONDITION_SPELL_SCRIPT_TARGET(17) is valid for CONDITION_SOURCE_TYPE_SPELL_SCRIPT_TARGET(14), ignoring.
2019-09-28 17:06:41 SourceEntry 34303 in `conditions` table, has ConditionType 32. Only CONDITION_SPELL_SCRIPT_TARGET(17) is valid for CONDITION_SOURCE_TYPE_SPELL_SCRIPT_TARGET(14), ignoring.
2019-09-28 17:06:41 SourceEntry 36817 in `conditions` table, has ConditionType 31. Only CONDITION_SPELL_SCRIPT_TARGET(17) is valid for CONDITION_SOURCE_TYPE_SPELL_SCRIPT_TARGET(14), ignoring.
2019-09-28 17:06:41 SourceEntry 37204 in `conditions` table, has ConditionType 31. Only CONDITION_SPELL_SCRIPT_TARGET(17) is valid for CONDITION_SOURCE_TYPE_SPELL_SCRIPT_TARGET(14), ignoring.
2019-09-28 17:06:41 SourceEntry 37205 in `conditions` table, has ConditionType 31. Only CONDITION_SPELL_SCRIPT_TARGET(17) is valid for CONDITION_SOURCE_TYPE_SPELL_SCRIPT_TARGET(14), ignoring.
2019-09-28 17:06:41 SourceEntry 37206 in `conditions` table, has ConditionType 31. Only CONDITION_SPELL_SCRIPT_TARGET(17) is valid for CONDITION_SOURCE_TYPE_SPELL_SCRIPT_TARGET(14), ignoring.
2019-09-28 17:06:41 SourceEntry 38099 in `conditions` table, has ConditionType 31. Only CONDITION_SPELL_SCRIPT_TARGET(17) is valid for CONDITION_SOURCE_TYPE_SPELL_SCRIPT_TARGET(14), ignoring.
2019-09-28 17:06:41 SourceEntry 38100 in `conditions` table, has ConditionType 31. Only CONDITION_SPELL_SCRIPT_TARGET(17) is valid for CONDITION_SOURCE_TYPE_SPELL_SCRIPT_TARGET(14), ignoring.
2019-09-28 17:06:41 SourceEntry 38101 in `conditions` table, has ConditionType 31. Only CONDITION_SPELL_SCRIPT_TARGET(17) is valid for CONDITION_SOURCE_TYPE_SPELL_SCRIPT_TARGET(14), ignoring.
2019-09-28 17:06:41 SourceEntry 38102 in `conditions` table, has ConditionType 31. Only CONDITION_SPELL_SCRIPT_TARGET(17) is valid for CONDITION_SOURCE_TYPE_SPELL_SCRIPT_TARGET(14), ignoring.
2019-09-28 17:06:41 SourceEntry 38103 in `conditions` table, has ConditionType 31. Only CONDITION_SPELL_SCRIPT_TARGET(17) is valid for CONDITION_SOURCE_TYPE_SPELL_SCRIPT_TARGET(14), ignoring.
2019-09-28 17:06:41 SourceEntry 38104 in `conditions` table, has ConditionType 31. Only CONDITION_SPELL_SCRIPT_TARGET(17) is valid for CONDITION_SOURCE_TYPE_SPELL_SCRIPT_TARGET(14), ignoring.
2019-09-28 17:06:41 SourceEntry 38105 in `conditions` table, has ConditionType 31. Only CONDITION_SPELL_SCRIPT_TARGET(17) is valid for CONDITION_SOURCE_TYPE_SPELL_SCRIPT_TARGET(14), ignoring.
2019-09-28 17:06:41 SourceEntry 38106 in `conditions` table, has ConditionType 31. Only CONDITION_SPELL_SCRIPT_TARGET(17) is valid for CONDITION_SOURCE_TYPE_SPELL_SCRIPT_TARGET(14), ignoring.
2019-09-28 17:06:41 Aura condition has useless data in value3 (1)!
2019-09-28 17:06:41 Aura condition has useless data in value3 (1)!
2019-09-28 17:06:42 Table `db_script_string` has unused string id  2000000017
2019-09-28 17:06:42 Table `db_script_string` has unused string id  2000000018
2019-09-28 17:06:42 CreatureEventAI:  Event 20303 Action 1 param1 references invalid entry (-2) in texts table.
2019-09-28 17:06:42 CreatureEventAI:  Event 20303 Action 1 param2 references invalid entry (-2) in texts table.
2019-09-28 17:06:42 CreatureEventAI:  Event 20303 Action 1 param3 references invalid entry (-4) in texts table.
2019-09-28 17:06:42 CreatureEventAI:  Event 47603 Action 1 param1 references invalid entry (-2) in texts table.
2019-09-28 17:06:42 CreatureEventAI:  Event 47603 Action 1 param2 references invalid entry (-2) in texts table.
2019-09-28 17:06:42 CreatureEventAI:  Event 47603 Action 1 param3 references invalid entry (-4) in texts table.
2019-09-28 17:06:42 CreatureEventAI:  Event 156404 Action 1 param1 references invalid entry (-2) in texts table.
2019-09-28 17:06:42 CreatureEventAI:  Event 156404 Action 1 param2 references invalid entry (-2) in texts table.
2019-09-28 17:06:42 CreatureEventAI:  Event 156404 Action 1 param3 references invalid entry (-4) in texts table.
2019-09-28 17:06:42 CreatureEventAI:  Event 185402 Action 1 param1 references invalid entry (-2) in texts table.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 2206 has EventAI script but it has AIName SmartAI. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 2206 has EventAI script but it has AIName SmartAI. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 2206 has EventAI script but it has AIName SmartAI. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 2206 has EventAI script but it has AIName SmartAI. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 2206 has EventAI script but it has AIName SmartAI. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 2206 has EventAI script but it has AIName SmartAI. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 2206 has EventAI script but it has AIName SmartAI. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 2206 has EventAI script but it has AIName SmartAI. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI:  Event 319803 Action 1 param1 references invalid entry (-2) in texts table.
2019-09-28 17:06:42 CreatureEventAI:  Event 319803 Action 1 param2 references invalid entry (-2) in texts table.
2019-09-28 17:06:42 CreatureEventAI:  Event 319803 Action 1 param3 references invalid entry (-4) in texts table.
2019-09-28 17:06:42 CreatureEventAI:  Event 1191501 Action 1 param1 references invalid entry (-2) in texts table.
2019-09-28 17:06:42 CreatureEventAI:  Event 1191501 Action 1 param2 references invalid entry (-2) in texts table.
2019-09-28 17:06:42 CreatureEventAI:  Event 1191501 Action 1 param3 references invalid entry (-4) in texts table.
2019-09-28 17:06:42 CreatureEventAI:  Event 1191702 Action 1 param1 references invalid entry (-2) in texts table.
2019-09-28 17:06:42 CreatureEventAI:  Event 1191702 Action 1 param2 references invalid entry (-2) in texts table.
2019-09-28 17:06:42 CreatureEventAI:  Event 1191702 Action 1 param3 references invalid entry (-4) in texts table.
2019-09-28 17:06:42 CreatureEventAI:  Event 1191801 Action 1 param1 references invalid entry (-2) in texts table.
2019-09-28 17:06:42 CreatureEventAI:  Event 1191801 Action 1 param2 references invalid entry (-2) in texts table.
2019-09-28 17:06:42 CreatureEventAI:  Event 1191801 Action 1 param3 references invalid entry (-4) in texts table.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 17815 has EventAI script but it has AIName SmartAI. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 17815 has EventAI script but it has AIName SmartAI. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 17815 has EventAI script but it has AIName SmartAI. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 17815 has EventAI script but it has AIName SmartAI. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 17815 has EventAI script but it has AIName SmartAI. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 17815 has EventAI script but it has AIName SmartAI. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 17815 has EventAI script but it has AIName SmartAI. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 17815 has EventAI script but it has AIName SmartAI. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 17815 has EventAI script but it has AIName SmartAI. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 19218 has EventAI script but its AIName is empty. Set to EventAI as default.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 19218 has EventAI script but it also has C++ script. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 19218 has EventAI script but it also has C++ script. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 19218 has EventAI script but it also has C++ script. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 19218 has EventAI script but it also has C++ script. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 19218 has EventAI script but it also has C++ script. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 19218 has EventAI script but it also has C++ script. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 19218 has EventAI script but it also has C++ script. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 19218 has EventAI script but it also has C++ script. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 19219 has EventAI script but its AIName is empty. Set to EventAI as default.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 19219 has EventAI script but it also has C++ script. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 19219 has EventAI script but it also has C++ script. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 19219 has EventAI script but it also has C++ script. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 19219 has EventAI script but it also has C++ script. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 19219 has EventAI script but it also has C++ script. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 19219 has EventAI script but it also has C++ script. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 19219 has EventAI script but it also has C++ script. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 19219 has EventAI script but it also has C++ script. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 24938 has EventAI script but it has AIName SmartAI. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 24938 has EventAI script but it has AIName SmartAI. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 25063 has EventAI script but it has AIName SmartAI. EventAI script will be overriden.
2019-09-28 17:06:42 CreatureEventAI: Creature Entry 29093 has EventAI script but its AIName is empty. Set to EventAI as default.
2019-09-28 17:06:42 CreatureEventAI:  Entry -816 in table creature_ai_texts but not used in EventAI scripts.
2019-09-28 17:06:42 CreatureEventAI:  Entry -494 in table creature_ai_texts but not used in EventAI scripts.
2019-09-28 17:06:42 CreatureEventAI:  Entry -149 in table creature_ai_texts but not used in EventAI scripts.
2019-09-28 17:06:42 CreatureEventAI:  Entry -124 in table creature_ai_texts but not used in EventAI scripts.
2019-09-28 17:06:42 CreatureEventAI:  Entry -72 in table creature_ai_texts but not used in EventAI scripts.
2019-09-28 17:06:42 CreatureEventAI:  Entry -71 in table creature_ai_texts but not used in EventAI scripts.
2019-09-28 17:06:42 OSCR: Entry -1921940 in table script_texts has soundId 19954 but sound does not exist.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_bloodmaul_direwolf does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named go_prophecy does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_grishna_arakkoa does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_koikoi_spirit does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_raven_leafbeard does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_wyrmkult_zealot does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_wyrmkult_acolyte does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_baelmon does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_groc_trigger does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_goc does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_sabelian_human does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_sabelian_dragon does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_grimgut does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_onspiritswings_trigger does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_huffer does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_nexusprince_razaan does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_summon_circle_trigger does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_vimgol_circle_trigger does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_vimgol_the_vile does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named the_soulgrinder does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named skulloc_soulgrinder does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named helper_bunny_1 does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named helper_bunny_2 does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named helper_bunny_3 does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_felburn_trigger does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_wing_commander_dabiree does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_pathaleon_image does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_arrazius_the_cruel does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_dreghood_brute does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named trigger_beacon_fire does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_fel_cannon_haf does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_inactive_fel_reaver does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named gehenna_trigger does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named legion_aldor_trigger does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_socre_helper does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named legion_beam_trigger does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_captured_protectorate does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_oronok_tornheart does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_azaloth does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_sunfurywarlock does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named legion_infernal_summon_trigger does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named legion_infernal_summoner_trigger does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named legion_hold_device_trigger does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_zuluhed_the_whacked does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named teron_trigger does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named teron_gorefiend_event does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_artor_spirit does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_tiny_trigger does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_icarus_trigger does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_oronok does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_dirty_larry does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_skyguard_handler_deesak does not have ScriptName assigned in database.
2019-09-28 17:06:42 OSCR: RegisterSelf, but script named npc_terokk does not have ScriptName assigned in database.

This is just to have a clean list. Hope something will be fixxed step by step :)


Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

JustZerooo avatar Sep 28 '19 15:09 JustZerooo