Jump to content

DB Errors - Looking to find out how to fix.


Recommended Posts

The server install is:

2010-08-30 19:17:27 MaNGOS/0.17.0-DEV (* * Revision 10426 - *) for Win32 (little-endian) [world-daemon]

using UDB_0.12.0_mangos_9582_SD2_1639 for a database.

Followed http://getmangos.eu/community/viewtopic.php?id=13121 for the guide to install Mangos and database.

The server compiles with SD2 just find no errors.

Completed all the updates from c:\\Mangos\\sql\\updates for all three databases. mangos, realmd, and character. Again, using the instructions from http://getmangos.eu/community/viewtopic.php?id=13121 as a guide. I have no idea how to apply any required updates for ScriptDev2. If there is a guide for safely doing that please let me know.

I get a bunch of DB errors. I cant post the whole thing, but sample lines are:

2010-08-30 19:17:33 Spell 16954 listed in `spell_proc_event` is not first rank (16952) in chain

2010-08-30 19:17:33 Spell 16961 listed in `spell_proc_event` is not first rank (16958) in chain

2010-08-30 19:17:35 Item (Entry: 3034) has wrong item class (6) for disenchanting, remove disenchanting loot id.

2010-08-30 19:17:35 Item (Entry: 8840) has wrong item class (9) for disenchanting, remove disenchanting loot id.

2010-08-30 19:17:35 Item (Entry: 11825) not correct -1 material, must be 4 (still using DB value).

2010-08-30 19:17:35 Item (Entry: 11826) not correct -1 material, must be 4 (still using DB value).

2010-08-30 19:17:35 Item (Entry: 15196) not correct -1 material, must be 4 (still using DB value).

2010-08-30 19:17:35 Item (Entry: 15197) not correct -1 material, must be 4 (still using DB value).

2010-08-30 19:17:36 >> Loaded `reputation_reward_rate`, table is empty!

2010-08-30 19:17:36 >> Loaded `reputation_spillover_template`, table is empty!

2010-08-30 19:17:39 Creature (GUID: 71979) has wrong spell 66162 defined in `auras` field in `creature_addon`.

2010-08-30 19:17:42 Weekly Quest 236 not marked as repeatable in `SpecialFlags`, added.

2010-08-30 19:17:42 Weekly Quest 13153 not marked as repeatable in `SpecialFlags`, added.

2010-08-30 19:17:42 Weekly Quest 13154 not marked as repeatable in `SpecialFlags`, added.

2010-08-30 19:17:42 Table `areatrigger_tavern` has area trigger (ID:4776) not listed in `AreaTrigger.dbc`.

2010-08-30 19:17:46 Table 'spell_loot_template' entry 61500 (spell id (random item creating)) not exist but used as loot id in DB.

2010-08-30 19:17:46 Table `achievement_criteria_requirement`.`criteria_id` 8804 does not exist, ignoring.

2010-08-30 19:17:46 Table `achievement_criteria_requirement` is missing expected data for `criteria_id` 13308 (type: 0) for achievement 1104.

2010-08-30 19:17:46 Table `achievement_criteria_requirement` is missing expected data for `criteria_id` 13309 (type: 0) for achievement 1104.

2010-08-30 19:17:46 Table `achievement_criteria_requirement` is missing expected data for `criteria_id` 13310 (type: 0) for achievement 1768.

2010-08-30 19:17:46 Table `achievement_criteria_requirement` is missing expected data for `criteria_id` 13311 (type: 0) for achievement 1768.

010-08-30 19:17:49 Table creature_movement has waypoint for creature guid 326 (entry 1718), but MovementType is not WAYPOINT_MOTION_TYPE(2). Creature will not use this path.

2010-08-30 19:17:49 Table creature_movement has waypoint for creature guid 1012 (entry 705), but MovementType is not WAYPOINT_MOTION_TYPE(2). Creature will not use this path.

2010-08-30 19:17:49 Table creature_movement has waypoint for creature guid 3557 (entry 1199), but MovementType is not WAYPOINT_MOTION_TYPE(2). Creature will not use this path.

That is not the exhaustive list, but all the different categories of errors are listed. I have no clue as to where to begin to fix these. I am somewhat familiar with Quince, but I don't understand the table relations enough to know where to begin. Googling takes me to X-Reapers sites often, but still the results just come back to try again. This is attempt number 4 to at least come up with a database that I can clean up. Any advice?

Link to comment
Share on other sites

  • 40 years later...

Tried a couple other ways to put the database together. I still get this kind of error:

010-08-30 19:17:49 Table creature_movement has waypoint for creature guid 326 (entry 1718), but MovementType is not WAYPOINT_MOTION_TYPE(2). Creature will not use this path.

I just wish I knew where to begin looking for a way to fix it.

Link to comment
Share on other sites

as any DB error it can be 2 case: error exactly describe problem and then point to fix.

In this cases for above error you just need drop data from `creature_movement` fir creature guid 326

Or can be second case: error only indirect point to real bug. In this cases for creature in `creature` (or `creature_template`) set wrong movemend type and need set waypoint movement.

What from 2 ways correct dependent from creature itself.

Link to comment
Share on other sites

@VladimirMangos - Thank you very much. I used Quice to check on the MovementType of the guid's that were in error, and the ones that were either type 1 or 0 had their creature_movement entries removed using MySQL Workbench.

@crackm would it be of any benefit to have these deletions from creature_movement put into a script and sent to someone?

Link to comment
Share on other sites

I managed to get rid of all but a few:

2010-09-03 10:42:17 Spell 16954 listed in `spell_proc_event` is not first rank (16952) in chain

2010-09-03 10:42:17 Spell 16961 listed in `spell_proc_event` is not first rank (16958) in chain

2010-09-03 10:42:20 >> Loaded `reputation_spillover_template`, table is empty!

I imagine there is little if anything I can do with reputation_spillover_template, but is there any chance on getting any guidance in correcting spell_proc_event?

Link to comment
Share on other sites

  • 5 months later...
first 2 lines must be already fixed (it has been core problem)

last related to used DB. Just wait when it will filled by correct data.

i have mangos server running, but i have a little problem

2011-02-16 12:23:57 MaNGOS/0.17.0 (* * Revision 11157 - *) for Linux_x64 (little-endian) [world-daemon]

2011-02-16 12:23:57 <Ctrl-C> to stop.

MM MM MM MM MMMMM MMMM MMMMM

MM MM MM MM MMM MMM MM MM MMM MMM

MMM MMM MMM MM MMM MMM MM MM MMM

MM M MM MMMM MM MMM MM MM MMM

MM M MM MMMMM MM MMMM MMM MM MM MMM

MM M MM M MMM MM MMM MMMMMMM MM MM MMM

MM MM MMM MM MM MM MMM MM MM MMM

MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM

MM MM MM MMM MM MM MMMMMM MMMM MMMMM

MM MMM http://getmangos.eu

MMMMMM

2011-02-16 12:23:57 Using configuration file /opt/mangos/etc/mangosd.conf.

2011-02-16 12:23:57 World Database: 95.168.xxx.xx;3306;xxxxxxxx;xxxxxxxxx;mangos, total connections: 2

2011-02-16 12:23:57 MySQL client library: 5.0.51a

2011-02-16 12:23:57 MySQL server ver: 5.0.51a-3ubuntu5.8

2011-02-16 12:23:57 MySQL client library: 5.0.51a

2011-02-16 12:23:57 MySQL server ver: 5.0.51a-3ubuntu5.8

2011-02-16 12:23:57 Character Database: 95.168.xxx.xx;3306;xxxxxxx;xxxxxxxx;characters, total connections: 2

2011-02-16 12:23:57 MySQL client library: 5.0.51a

2011-02-16 12:23:57 MySQL server ver: 5.0.51a-3ubuntu5.8

2011-02-16 12:23:57 MySQL client library: 5.0.51a

2011-02-16 12:23:57 MySQL server ver: 5.0.51a-3ubuntu5.8

2011-02-16 12:23:57 Login Database: 95.168.xxx.xx;3306;xxxxxxxx;xxxxxx;realmd, total connections: 2

2011-02-16 12:23:57 MySQL client library: 5.0.51a

2011-02-16 12:23:57 MySQL server ver: 5.0.51a-3ubuntu5.8

2011-02-16 12:23:57 MySQL client library: 5.0.51a

2011-02-16 12:23:57 MySQL server ver: 5.0.51a-3ubuntu5.8

2011-02-16 12:23:57 Realm running as realm ID 1

2011-02-16 12:23:57 Using World DB: UDB 0.12.1 (393) for MaNGOS 10545 with SD2 SQL for rev. 1833

2011-02-16 12:23:57 Using creature EventAI: ACID 3.0.8 - Full Release for Mangos (3.3.5a Client)

2011-02-16 12:23:57 Using DataDir /opt/mangos/bin/

2011-02-16 12:23:57 WORLD: VMap support included. LineOfSight:1, getHeight:1, indoorCheck:1

2011-02-16 12:23:57 WORLD: VMap data directory is: /opt/mangos/bin/vmaps

2011-02-16 12:23:57

2011-02-16 12:23:57 Loading MaNGOS strings...

2011-02-16 12:23:57

2011-02-16 12:23:57 >> Loaded 762 MaNGOS strings from table mangos_string

2011-02-16 12:23:57 Initialize data stores...

2011-02-16 12:23:57

2011-02-16 12:23:57 >> Initialized 91 data stores

2011-02-16 12:23:57 Using frFR DBC Locale as default. All available DBC locales: frFR

2011-02-16 12:23:57

2011-02-16 12:23:57 Loading Script Names...

2011-02-16 12:23:57

2011-02-16 12:23:57 >> Loaded 875 Script Names

2011-02-16 12:23:57 Loading WorldTemplate...

2011-02-16 12:23:57 world_template table is empty!

2011-02-16 12:23:57 >> Loaded 0 World Template definitions

2011-02-16 12:23:57

2011-02-16 12:23:57 Loading InstanceTemplate...

2011-02-16 12:23:57 >> Loaded 81 Instance Template definitions

2011-02-16 12:23:57

2011-02-16 12:23:57 Loading SkillLineAbilityMultiMap Data...

2011-02-16 12:24:00

2011-02-16 12:24:00 >> Loaded 10219 SkillLineAbility MultiMap Data

2011-02-16 12:24:00 Cleaning up instances...

2011-02-16 12:24:00

2011-02-16 12:24:00 >> Instances cleaned up

2011-02-16 12:24:00 Packing instances...

2011-02-16 12:24:00 >> Instance numbers remapped, next instance id is 1

2011-02-16 12:24:00

2011-02-16 12:24:00 Packing groups...

2011-02-16 12:24:00 >> Group Ids remapped, next group id is 1

2011-02-16 12:24:00

2011-02-16 12:24:00

2011-02-16 12:24:00 Loading Page Texts...

2011-02-16 12:24:00 >> Loaded 1771 page texts

2011-02-16 12:24:00

2011-02-16 12:24:00 Loading Game Object Templates...

2011-02-16 12:24:01 >> Loaded 18898 game object templates

2011-02-16 12:24:01

2011-02-16 12:24:01 Loading Spell Chain Data...

2011-02-16 12:24:01

2011-02-16 12:24:01 >> Loaded 4635 spell chain records (2994 from DBC data with 2 req field updates, and 1641 loaded from table)

2011-02-16 12:24:01 Loading Spell Elixir types...

2011-02-16 12:24:02

2011-02-16 12:24:02 >> Loaded 132 spell elixir definitions

2011-02-16 12:24:02 Loading Spell Learn Skills...

2011-02-16 12:24:02

2011-02-16 12:24:02 >> Loaded 99 Spell Learn Skills from DBC

2011-02-16 12:24:02 Loading Spell Learn Spells...

2011-02-16 12:24:02

2011-02-16 12:24:02 >> Loaded 18 spell learn spells + 572 found in DBC

2011-02-16 12:24:02 Loading Spell Proc Event conditions...

2011-02-16 12:24:02

2011-02-16 12:24:02 >> Loaded 558 extra spell proc event conditions +58 custom proc (inc. +4 custom ranks)

2011-02-16 12:24:02 Loading Spell Bonus Data...

2011-02-16 12:24:02

2011-02-16 12:24:02 >> Loaded 139 extra spell bonus data

2011-02-16 12:24:02 Loading Spell Proc Item Enchant...

2011-02-16 12:24:03

2011-02-16 12:24:03 >> Loaded 8 proc item enchant definitions

2011-02-16 12:24:03 Loading Aggro Spells Definitions...

2011-02-16 12:24:03

2011-02-16 12:24:03 >> Loaded 110 spell threat entries

2011-02-16 12:24:03 Loading NPC Texts...

2011-02-16 12:24:03

2011-02-16 12:24:03 >> Loaded 5779 npc texts

2011-02-16 12:24:03 Loading Item Random Enchantments Table...

2011-02-16 12:24:06

2011-02-16 12:24:06 >> Loaded 28607 Item Enchantment definitions

2011-02-16 12:24:06 Loading Items...

2011-02-16 12:24:06 >> Loaded 36407 item prototypes

2011-02-16 12:24:06

2011-02-16 12:24:06 Loading Item converts...

2011-02-16 12:24:06

2011-02-16 12:24:06 ERROR:>> Loaded 0 Item converts . DB table `item_convert` is empty.

2011-02-16 12:24:06 Loading Creature Model Based Info Data...

2011-02-16 12:24:06 ERROR:Table `creature_model_info` has redundant modelid_other_gender model (11226) defined for model id 11226.

2011-02-16 12:24:06 ERROR:Table `creature_model_info` has redundant modelid_other_gender model (15552) defined for model id 15552.

2011-02-16 12:24:06 ERROR:Table `creature_model_info` has redundant modelid_other_gender model (20287) defined for model id 20287.

2011-02-16 12:24:06 ERROR:Table `creature_model_info` has redundant modelid_other_gender model (22511) defined for model id 22511.

2011-02-16 12:24:06 ERROR:Table `creature_model_info` has redundant modelid_other_gender model (22512) defined for model id 22512.

2011-02-16 12:24:06 >> Loaded 24155 creature model based info

2011-02-16 12:24:06

2011-02-16 12:24:06 Loading Equipment templates...

2011-02-16 12:24:07 >> Loaded 2289 equipment template

2011-02-16 12:24:07

2011-02-16 12:24:07 Loading Creature templates...

2011-02-16 12:24:07 >> Loaded 29920 creature definitions

2011-02-16 12:24:07

2011-02-16 12:24:07 Loading Creature Model for race...

2011-02-16 12:24:07

2011-02-16 12:24:07 >> Loaded 20 creature_model_race entries

2011-02-16 12:24:07 Loading SpellsScriptTarget...

2011-02-16 12:24:08

2011-02-16 12:24:08 >> Loaded 701 Spell Script Targets

2011-02-16 12:24:08 Loading ItemRequiredTarget...

2011-02-16 12:24:08

2011-02-16 12:24:08 >> Loaded 134 Item required targets

2011-02-16 12:24:08 Loading Reputation Reward Rates...

2011-02-16 12:24:08

2011-02-16 12:24:08 >> Loaded 14 reputation_reward_rate

2011-02-16 12:24:08 Loading Creature Reputation OnKill Data...

2011-02-16 12:24:08

2011-02-16 12:24:08 >> Loaded 1432 creature award reputation definitions

2011-02-16 12:24:08 Loading Reputation Spillover Data...

2011-02-16 12:24:08

2011-02-16 12:24:08 >> Loaded 26 reputation_spillover_template

2011-02-16 12:24:08 Loading Points Of Interest Data...

2011-02-16 12:24:08

2011-02-16 12:24:08 >> Loaded 446 Points of Interest definitions

2011-02-16 12:24:08 Loading Creature Data...

2011-02-16 12:24:10

2011-02-16 12:24:10 >> Loaded 138708 creatures

2011-02-16 12:24:10 Loading pet levelup spells...

2011-02-16 12:24:10

2011-02-16 12:24:10 >> Loaded 1634 pet levelup and default spells for 39 families

2011-02-16 12:24:10 Loading pet default spell additional to levelup spells...

2011-02-16 12:24:10

2011-02-16 12:24:10 >> Loaded addition spells for 111 pet spell data entries and 291 summonable creature templates

2011-02-16 12:24:10 Loading Creature Addon Data...

2011-02-16 12:24:10

2011-02-16 12:24:10 >> Loaded 4661 creature template addons

2011-02-16 12:24:10

2011-02-16 12:24:10 >> Loaded 87099 creature addons

2011-02-16 12:24:10

2011-02-16 12:24:10 ERROR:Creature (GUID 112378) has unknown sheath state (252) defined in `creature_addon`.

2011-02-16 12:24:10 >>> Creature Addon Data loaded

2011-02-16 12:24:10

2011-02-16 12:24:10 Loading Creature Respawn Data...

2011-02-16 12:24:10

2011-02-16 12:24:10 >> Loaded 0 creature respawn time.

2011-02-16 12:24:10 Loading Gameobject Data...

2011-02-16 12:24:12

2011-02-16 12:24:12 >> Loaded 90565 gameobjects

2011-02-16 12:24:12 Loading Gameobject Respawn Data...

2011-02-16 12:24:12

2011-02-16 12:24:12 >> Loaded 0 gameobject respawn time.

2011-02-16 12:24:12 Loading Objects Pooling Data...

2011-02-16 12:24:12

2011-02-16 12:24:12 >> Loaded 4176 objects pools

2011-02-16 12:24:12

2011-02-16 12:24:12 >> Loaded 639 creatures in pools

2011-02-16 12:24:12

2011-02-16 12:24:12 >> Loaded 28076 gameobject in pools

2011-02-16 12:24:12

2011-02-16 12:24:12 >> Loaded 3630 pools in mother pools

2011-02-16 12:24:12 Loading Weather Data...

2011-02-16 12:24:13

2011-02-16 12:24:13 >> Loaded 35 weather definitions

2011-02-16 12:24:13 Loading Quests...

2011-02-16 12:24:13 ERROR:Spell (id: 33824) have SPELL_EFFECT_QUEST_COMPLETE for quest 10162 , but quest does not have SpecialFlags QUEST_SPECIAL_FLAG_EXPLORATION_OR_EVENT (2) set. Quest SpecialFlags should be corrected to enable this objective.

2011-02-16 12:24:13

2011-02-16 12:24:13 >> Loaded 9063 quests definitions

2011-02-16 12:24:13 Loading Quest POI

2011-02-16 12:24:14

2011-02-16 12:24:14 >> Loaded 18459 quest POI definitions

2011-02-16 12:24:14 Loading Quests Relations...

2011-02-16 12:24:14

2011-02-16 12:24:14

2011-02-16 12:24:14 >> Loaded 367 quest relations from gameobject_questrelation

2011-02-16 12:24:16

2011-02-16 12:24:16 >> Loaded 295 quest relations from gameobject_involvedrelation

2011-02-16 12:24:16

2011-02-16 12:24:16 >> Loaded 7620 quest relations from creature_questrelation

2011-02-16 12:24:16

2011-02-16 12:24:16 >> Loaded 7841 quest relations from creature_involvedrelation

2011-02-16 12:24:16 >>> Quests Relations loaded

2011-02-16 12:24:16

2011-02-16 12:24:16 Loading Game Event Data...

2011-02-16 12:24:16

2011-02-16 12:24:18

2011-02-16 12:24:18 >> Loaded 39 game events

2011-02-16 12:24:18

2011-02-16 12:24:18 >> Loaded 3085 creatures in game events

2011-02-16 12:24:18

2011-02-16 12:24:18 >> Loaded 22020 gameobjects in game events

2011-02-16 12:24:18

2011-02-16 12:24:18 >> Loaded 10 creature reactions at game events

2011-02-16 12:24:18 ERROR:`game_event_quest` game event id (9) not exist in `game_event`

2011-02-16 12:24:18

2011-02-16 12:24:18 >> Loaded 30 quest additions in game events

2011-02-16 12:24:20

2011-02-16 12:24:20 >> Loaded 0 start/end game event mails

2011-02-16 12:24:20 >>> Game Event Data loaded

2011-02-16 12:24:20

2011-02-16 12:24:20 Loading UNIT_NPC_FLAG_SPELLCLICK Data...

2011-02-16 12:24:20

2011-02-16 12:24:20 >> Loaded 19 spellclick definitions

2011-02-16 12:24:20 Loading SpellArea Data...

2011-02-16 12:24:20

2011-02-16 12:24:20 >> Loaded 123 spell area requirements

2011-02-16 12:24:20 Loading AreaTrigger definitions...

2011-02-16 12:24:20

2011-02-16 12:24:20 >> Loaded 224 area trigger teleport definitions

2011-02-16 12:24:20 Loading Quest Area Triggers...

2011-02-16 12:24:27

2011-02-16 12:24:27 >> Loaded 51 quest trigger points

2011-02-16 12:24:27 Loading Tavern Area Triggers...

2011-02-16 12:24:27

2011-02-16 12:24:27 >> Loaded 101 tavern triggers

2011-02-16 12:24:27 Loading AreaTrigger script names...

2011-02-16 12:24:27

2011-02-16 12:24:27 >> Loaded 32 areatrigger scripts

2011-02-16 12:24:27 Loading event id script names...

2011-02-16 12:24:27

2011-02-16 12:24:27 >> Loaded 9 scripted event id

2011-02-16 12:24:27 Loading Graveyard-zone links...

2011-02-16 12:24:27

2011-02-16 12:24:27 >> Loaded 687 graveyard-zone links

2011-02-16 12:24:27 Loading Spell target coordinates...

2011-02-16 12:24:28

2011-02-16 12:24:28 >> Loaded 388 spell teleport coordinates

2011-02-16 12:24:28 Loading spell pet auras...

2011-02-16 12:24:28

2011-02-16 12:24:28 >> Loaded 45 spell pet auras

2011-02-16 12:24:28 Loading Player Create Info & Level Stats...

2011-02-16 12:24:28

2011-02-16 12:24:28

2011-02-16 12:24:28 >> Loaded 62 player create definitions

2011-02-16 12:24:28

2011-02-16 12:24:28 >> Loaded 0 custom player create items

2011-02-16 12:24:28

2011-02-16 12:24:28 >> Loaded 2851 player create spells

2011-02-16 12:24:28

2011-02-16 12:24:28 >> Loaded 355 player create actions

2011-02-16 12:24:32

2011-02-16 12:24:32 >> Loaded 800 level health/mana definitions

2011-02-16 12:24:32

2011-02-16 12:24:32 >> Loaded 4960 level stats definitions

2011-02-16 12:24:32

2011-02-16 12:24:32 >> Loaded 79 xp for level definitions

2011-02-16 12:24:32 >>> Player Create Info & Level Stats loaded

2011-02-16 12:24:32

2011-02-16 12:24:32 Loading Exploration BaseXP Data...

2011-02-16 12:24:32

2011-02-16 12:24:32 >> Loaded 71 BaseXP definitions

2011-02-16 12:24:32 Loading Pet Name Parts...

2011-02-16 12:24:32

2011-02-16 12:24:32 >> Loaded 313 pet name parts

2011-02-16 12:24:32 Cleaning character database...

2011-02-16 12:24:32 Loading the max pet number...

2011-02-16 12:24:32

2011-02-16 12:24:32 >> Loaded the max pet number: 0

2011-02-16 12:24:32 Loading pet level stats...

2011-02-16 12:24:32

2011-02-16 12:24:32 >> Loaded 2480 level pet stats definitions

2011-02-16 12:24:32 Loading Player Corpses...

2011-02-16 12:24:32

2011-02-16 12:24:32 >> Loaded 0 corpses

2011-02-16 12:24:32 Loading Player level dependent mail rewards...

2011-02-16 12:24:33

2011-02-16 12:24:33 >> Loaded 24 level dependent mail rewards,

2011-02-16 12:24:33 Loading Loot Tables...

2011-02-16 12:24:33

2011-02-16 12:24:33 creature_loot_template :

2011-02-16 12:24:34

2011-02-16 12:24:34 >> Loaded 258564 loot definitions (7517 templates)

2011-02-16 12:24:34 fishing_loot_template :

2011-02-16 12:24:34

2011-02-16 12:24:34 >> Loaded 244 loot definitions (216 templates)

2011-02-16 12:24:34 gameobject_loot_template :

2011-02-16 12:24:34

2011-02-16 12:24:34 >> Loaded 17889 loot definitions (1111 templates)

2011-02-16 12:24:34 item_loot_template :

2011-02-16 12:24:34

2011-02-16 12:24:34 >> Loaded 5054 loot definitions (286 templates)

2011-02-16 12:24:34 ERROR:Table 'item_loot_template' entry 5523 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2011-02-16 12:24:34 ERROR:Table 'item_loot_template' entry 5524 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2011-02-16 12:24:34 ERROR:Table 'item_loot_template' entry 6712 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2011-02-16 12:24:34 ERROR:Table 'item_loot_template' entry 7973 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2011-02-16 12:24:34 ERROR:Table 'item_loot_template' entry 15874 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2011-02-16 12:24:34 ERROR:Table 'item_loot_template' entry 24476 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

2011-02-16 12:24:34 mail_loot_template :

2011-02-16 12:24:34

2011-02-16 12:24:34 >> Loaded 66 loot definitions (65 templates)

2011-02-16 12:24:34 milling_loot_template :

2011-02-16 12:24:35

2011-02-16 12:24:35 >> Loaded 46 loot definitions (46 templates)

2011-02-16 12:24:35 ERROR:Table 'milling_loot_template' entry 36902 isn't item entry (herb) and not referenced from loot, and then useless.

2011-02-16 12:24:35 pickpocketing_loot_template :

2011-02-16 12:24:35

2011-02-16 12:24:35 >> Loaded 10997 loot definitions (2549 templates)

2011-02-16 12:24:35 skinning_loot_template :

2011-02-16 12:24:35

2011-02-16 12:24:35 >> Loaded 3362 loot definitions (941 templates)

2011-02-16 12:24:35 disenchant_loot_template :

2011-02-16 12:24:36

2011-02-16 12:24:36 >> Loaded 123 loot definitions (55 templates)

2011-02-16 12:24:36 prospecting_loot_template :

2011-02-16 12:24:36

2011-02-16 12:24:36 >> Loaded 103 loot definitions (10 templates)

2011-02-16 12:24:36 spell_loot_template :

2011-02-16 12:24:36

2011-02-16 12:24:36 >> Loaded 161 loot definitions (21 templates)

2011-02-16 12:24:36 reference_loot_template :

2011-02-16 12:24:38

2011-02-16 12:24:38 >> Loaded 9234 loot definitions (537 templates)

2011-02-16 12:24:38 >>> Loot Tables loaded

2011-02-16 12:24:38

2011-02-16 12:24:38 Loading Skill Discovery Table...

2011-02-16 12:24:38

2011-02-16 12:24:38 >> Loaded 348 skill discovery definitions

2011-02-16 12:24:38 Loading Skill Extra Item Table...

2011-02-16 12:24:38

2011-02-16 12:24:38 >> Loaded 206 spell specialization definitions

2011-02-16 12:24:38 Loading Skill Fishing base level requirements...

2011-02-16 12:24:40

2011-02-16 12:24:40 >> Loaded 88 areas for fishing base skill level

2011-02-16 12:24:40 Loading Achievements...

2011-02-16 12:24:40

2011-02-16 12:24:40

2011-02-16 12:24:40 >> Loaded 43 achievement references.

2011-02-16 12:24:40

2011-02-16 12:24:40 >> Loaded 1105 achievement criteria.

2011-02-16 12:24:40

2011-02-16 12:24:40 >> Loaded 1853 additional achievement criteria data (247 disabled).

2011-02-16 12:24:41

2011-02-16 12:24:41 >> Loaded 93 achievement rewards

2011-02-16 12:24:41

2011-02-16 12:24:41 >> Loaded 0 achievement reward locale strings. DB table `locales_achievement_reward` is empty.

2011-02-16 12:24:41

2011-02-16 12:24:41 >> Loaded 0 realm completed achievements . DB table `character_achievement` is empty.

2011-02-16 12:24:41 >>> Achievements loaded

2011-02-16 12:24:41

2011-02-16 12:24:41 Loading Npc Text Id...

2011-02-16 12:24:41

2011-02-16 12:24:41 >> Loaded 3368 NpcTextId

2011-02-16 12:24:41 Loading Gossip scripts...

2011-02-16 12:24:41 gossip_scripts :

2011-02-16 12:24:41

2011-02-16 12:24:41 >> Loaded 19 script definitions

2011-02-16 12:24:41 Loading Gossip menus...

2011-02-16 12:24:44

2011-02-16 12:24:44 >> Loaded 2078 gossip_menu entries

2011-02-16 12:24:44 ERROR:Creature (Entry: 3921) has gossip_menu_id = 3033 for nonexistent menu

2011-02-16 12:24:44 Loading Gossip menu options...

2011-02-16 12:24:44 ERROR:Gossip menu option (MenuId: 2343 Id: 2) have action_menu_id = 11422 for nonexistent menu

2011-02-16 12:24:44 ERROR:Gossip menu option (MenuId: 2343 Id: 3) have action_menu_id = 11422 for nonexistent menu

2011-02-16 12:24:44 ERROR:Table gossip_menu_option for menu 5602, id 0 has `npc_option_npcflag` = 1 but creatures using this menu does not have corresponding`npcflag`. Option will not accessible in game.

2011-02-16 12:24:44 ERROR:Table gossip_menu_option for menu 10662, id 0 has `npc_option_npcflag` = 1048576 but creatures using this menu does not have corresponding`npcflag`. Option will not accessible in game.

2011-02-16 12:24:44

2011-02-16 12:24:44 >> Loaded 1449 gossip_menu_option entries

2011-02-16 12:24:44 Loading Vendors...

2011-02-16 12:24:44

2011-02-16 12:24:44 >> Loaded `npc_vendor_template`, table is empty!

2011-02-16 12:24:44

2011-02-16 12:24:44 >> Loaded 35555 vendor items

2011-02-16 12:24:44 Loading Trainers...

2011-02-16 12:24:44

2011-02-16 12:24:44 >> Loaded `npc_trainer_template`, table is empty!

2011-02-16 12:24:47

2011-02-16 12:24:47 >> Loaded 74407 trainer spells

2011-02-16 12:24:47 Loading Waypoint scripts...

2011-02-16 12:24:47 creature_movement_scripts :

2011-02-16 12:24:47

2011-02-16 12:24:47 >> Loaded 26 script definitions

2011-02-16 12:24:47 Loading Waypoints...

2011-02-16 12:24:47

2011-02-16 12:24:47

2011-02-16 12:24:47 >> Paths loaded

2011-02-16 12:24:49

2011-02-16 12:24:49 >> Waypoints and behaviors loaded

2011-02-16 12:24:49

2011-02-16 12:24:49 >>> Loaded 2290 paths, 48680 nodes and 614 behaviors

2011-02-16 12:24:49

2011-02-16 12:24:49 >> Path templates loaded

2011-02-16 12:24:49

2011-02-16 12:24:49 >> Waypoint templates loaded

2011-02-16 12:24:49

2011-02-16 12:24:49 >>> Loaded 30 path templates with 915 nodes and 5 behaviors

2011-02-16 12:24:49 Loading Localization strings...

2011-02-16 12:24:49

2011-02-16 12:24:49 >> Loaded 0 creature locale strings. DB table `locales_creature` is empty.

2011-02-16 12:24:49

2011-02-16 12:24:49 >> Loaded 0 gameobject locale strings. DB table `locales_gameobject` is empty.

2011-02-16 12:24:49

2011-02-16 12:24:49 >> Loaded 0 Item locale strings. DB table `locales_item` is empty.

2011-02-16 12:24:49

2011-02-16 12:24:49 >> Loaded 0 Quest locale strings. DB table `locales_quest` is empty.

2011-02-16 12:24:50

2011-02-16 12:24:50 >> Loaded 0 Quest locale strings. DB table `locales_npc_text` is empty.

2011-02-16 12:24:50

2011-02-16 12:24:50 >> Loaded 0 PageText locale strings. DB table `locales_page_text` is empty.

2011-02-16 12:24:50

2011-02-16 12:24:50 >> Loaded 0 gossip_menu_option locale strings. DB table `locales_gossip_menu_option` is empty.

2011-02-16 12:24:50

2011-02-16 12:24:50 >> Loaded 0 points_of_interest locale strings. DB table `locales_points_of_interest` is empty.

2011-02-16 12:24:50 >>> Localization strings loaded

2011-02-16 12:24:50

2011-02-16 12:24:50 Loading Auctions...

2011-02-16 12:24:50

2011-02-16 12:24:50

2011-02-16 12:24:50 >> Loaded 0 auction items

2011-02-16 12:24:50

2011-02-16 12:24:50 >> Loaded 0 auctions. DB table `auction` is empty.

2011-02-16 12:24:50 >>> Auctions loaded

2011-02-16 12:24:50

2011-02-16 12:24:50 Loading Guilds...

2011-02-16 12:24:50

2011-02-16 12:24:50 >> Loaded 0 guild definitions

2011-02-16 12:24:50 Loading ArenaTeams...

2011-02-16 12:24:50

2011-02-16 12:24:50 >> Loaded 0 arenateam definitions

2011-02-16 12:24:50 Loading Groups...

2011-02-16 12:24:50

2011-02-16 12:24:50 >> Loaded 0 group definitions

2011-02-16 12:24:50 Loading ReservedNames...

2011-02-16 12:24:50

2011-02-16 12:24:50 >> Loaded 0 reserved player names

2011-02-16 12:24:50 Loading GameObjects for quests...

2011-02-16 12:24:50

2011-02-16 12:24:50 >> Loaded 1496 GameObjects for quests

2011-02-16 12:24:50 Loading BattleMasters...

2011-02-16 12:24:53

2011-02-16 12:24:53 >> Loaded 136 battlemaster entries

2011-02-16 12:24:53 Loading BattleGround event indexes...

2011-02-16 12:24:53

2011-02-16 12:24:53 >> Loaded 1236 battleground eventindexes

2011-02-16 12:24:53 Loading GameTeleports...

2011-02-16 12:24:53

2011-02-16 12:24:53 >> Loaded 1421 GameTeleports

2011-02-16 12:24:53 Loading GM tickets...

2011-02-16 12:24:53

2011-02-16 12:24:53 >> Loaded `character_ticket`, table is empty.

2011-02-16 12:24:53 Returning old mails...

2011-02-16 12:24:53

2011-02-16 12:24:53 >> Only expired mails (need to be return or delete) or DB table `mail` is empty.

2011-02-16 12:24:53 Loading Scripts...

2011-02-16 12:24:53

2011-02-16 12:24:53 quest_start_scripts :

2011-02-16 12:24:54

2011-02-16 12:24:54 >> Loaded 235 script definitions

2011-02-16 12:24:54 quest_end_scripts :

2011-02-16 12:24:54

2011-02-16 12:24:54 >> Loaded 310 script definitions

2011-02-16 12:24:54 spell_scripts :

2011-02-16 12:24:54

2011-02-16 12:24:54 >> Loaded 17 script definitions

2011-02-16 12:24:54 gameobject_scripts :

2011-02-16 12:24:56

2011-02-16 12:24:56 >> Loaded 54 script definitions

2011-02-16 12:24:56 event_scripts :

2011-02-16 12:24:56

2011-02-16 12:24:56 >> Loaded 442 script definitions

2011-02-16 12:24:56 >>> Scripts loaded

2011-02-16 12:24:56

2011-02-16 12:24:56 Loading Scripts text locales...

2011-02-16 12:24:56

2011-02-16 12:24:56 >> Loaded 399 string templates from db_script_string

2011-02-16 12:24:56 Loading CreatureEventAI Texts...

2011-02-16 12:24:56

2011-02-16 12:24:56 >> Loaded 1133 string templates from creature_ai_texts

2011-02-16 12:24:58 Loading EventAI Texts additional data...

2011-02-16 12:24:58

2011-02-16 12:24:58 >> Loaded 1133 additional CreatureEventAI Texts data.

2011-02-16 12:24:58 Loading CreatureEventAI Summons...

2011-02-16 12:24:58

2011-02-16 12:24:58 >> Loaded 15 CreatureEventAI summon definitions

2011-02-16 12:24:58 Loading CreatureEventAI Scripts...

2011-02-16 12:24:58

2011-02-16 12:24:58 >> Loaded 24976 CreatureEventAI scripts

2011-02-16 12:24:58 Initializing Scripts...

2011-02-16 12:24:58

2011-02-16 12:24:58 MMM MMM MM

2011-02-16 12:24:58 M MM M M M M

2011-02-16 12:24:58 MM M M M

2011-02-16 12:24:58 MMM M M M

2011-02-16 12:24:59 MM M M MMMM

2011-02-16 12:24:59 MM M M M

2011-02-16 12:24:59 MMM MMM http://www.scriptdev2.com

2011-02-16 12:24:59

2011-02-16 12:24:59 SD2: Using configuration file /opt/mangos/etc/scriptdev2.conf

2011-02-16 12:24:59

2011-02-16 12:24:59 MySQL client library: 5.0.51a

2011-02-16 12:24:59 MySQL server ver: 5.0.51a-3ubuntu5.8

2011-02-16 12:24:59 MySQL client library: 5.0.51a

2011-02-16 12:24:59 MySQL server ver: 5.0.51a-3ubuntu5.8

2011-02-16 12:24:59 SD2: ScriptDev2 database at 95.168.xxx.xx;3306;xxxxxxxx;xxxxxxxx;scriptdev2 initialized.

2011-02-16 12:24:59

2011-02-16 12:24:59 Loading ScriptDev2 (for MaNGOS 11136+) Revision [1978] 2011-02-13 17:52:50 (Unix)

2011-02-16 12:24:59

2011-02-16 12:24:59 SD2: Loading Script Texts...

2011-02-16 12:25:01

2011-02-16 12:25:01 >> Loaded 2755 string templates from script_texts

2011-02-16 12:25:01 SD2: Loading Script Texts additional data...

2011-02-16 12:25:01

2011-02-16 12:25:01 >> Loaded 2755 additional Script Texts data.

2011-02-16 12:25:01 SD2: Loading Custom Texts...

2011-02-16 12:25:01

2011-02-16 12:25:01 >> Loaded 0 string templates. DB table `custom_texts` is empty.

2011-02-16 12:25:01 SD2: Loading Custom Texts additional data...

2011-02-16 12:25:01

2011-02-16 12:25:01 >> Loaded 0 additional Custom Texts data. DB table `custom_texts` is empty.

2011-02-16 12:25:01 SD2: Loading Gossip Texts...

2011-02-16 12:25:01

2011-02-16 12:25:01 >> Loaded 36 string templates from gossip_texts

2011-02-16 12:25:01 SD2: Loading Script Waypoints for 63 creature(s)...

2011-02-16 12:25:03

2011-02-16 12:25:03 >> Loaded 1722 Script Waypoint nodes.

2011-02-16 12:25:03 SD2: Loading C++ scripts

2011-02-16 12:25:03

2011-02-16 12:25:03 ERROR:SD2: Script registering but ScriptName npc_barrett_ramsey is not assigned in database. Script will not be used.

2011-02-16 12:25:03 ERROR:SD2: Script registering but ScriptName mob_shadowy_construct is not assigned in database. Script will not be used.

2011-02-16 12:25:03 >> Loaded 864 C++ Scripts.

2011-02-16 12:25:03 Scripting library loaded.

2011-02-16 12:25:03 DEBUG:: Initialize game time and timers

2011-02-16 12:25:03 Starting Map System

2011-02-16 12:25:03 Starting BattleGround System

2011-02-16 12:25:03

2011-02-16 12:25:03 >> Loaded 13 battlegrounds

2011-02-16 12:25:03 Loading Transports...

2011-02-16 12:25:03

2011-02-16 12:25:03 >> Loaded 20 transports

2011-02-16 12:25:03 Deleting expired bans...

2011-02-16 12:25:03 Calculate next daily quest reset time...

2011-02-16 12:25:03 Calculate next weekly quest reset time...

2011-02-16 12:25:03 Calculate next monthly quest reset time...

2011-02-16 12:25:03 Starting objects Pooling system...

2011-02-16 12:25:03 Starting Game Event system...

2011-02-16 12:25:03 GameEvent 16 "Gurubashi Arena Booty Run" started.

2011-02-16 12:25:03 GameEvent 27 "Nights" started.

2011-02-16 12:25:03 GameEvent 31 "Edge of Madness, Renataki" started.

2011-02-16 12:25:03 Player::DeleteOldChars: Deleting all characters which have been deleted 30 days before...

2011-02-16 12:25:03 WORLD: World initialized

2011-02-16 12:25:03 SERVER STARTUP TIME: 1 minutes 6 seconds

2011-02-16 12:25:03

2011-02-16 12:25:03 Starting Remote access listner on port 3443 on 95.168.xxx.xx

2011-02-16 12:25:03 MaNGOSsoap: bound to http://95.168.xxx.xx:7878

can you fix for that? give me a detail answer because i'm newbie.....thanks:)

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use