[Solved] I got errors on mangos Rel19 starting.

[xiazai]

hi guys,I refresh my database with the newest data.and I got errors like below:

NO1.

Loading Creature templates...

2014-07-14 00:21:39 >> Loaded 9092 creature definitions

2014-07-14 00:21:39

2014-07-14 00:21:39 ERROR:Creature (Entry: 6), Class(1), level(1) has no data in `creature_template_classlevelstats`

2014-07-14 00:21:39 ERROR:Creature (Entry: 247), Class(1), level(1) has no data in `creature_template_classlevelstats`

2014-07-14 00:21:39 ERROR:Creature (Entry: 299), Class(1), level(1) has no data in `creature_template_classlevelstats`

2014-07-14 00:21:39 ERROR:Creature (Entry: 356), Class(1), level(1) has no data in `creature_template_classlevelstats`

2014-07-14 00:21:39 ERROR:Creature (Entry: 359), Class(1), level(1) has no data in `creature_template_classlevelstats`

NO2. this kind of errors i have got when I start Rel18 mangos.

2014-07-14 00:22:54 Loading CreatureEventAI Summons...

2014-07-14 00:22:54

2014-07-14 00:22:54 >> Loaded 20 CreatureEventAI summon definitions

2014-07-14 00:22:54 Loading CreatureEventAI Scripts...

2014-07-14 00:22:54 ERROR CreatureEventAI: Event 43101 Action1 uses incorrect Target type 6 for event-type 12

2014-07-14 00:22:54 ERROR CreatureEventAI: Event 58702 Action1 uses incorrect Target type 6 for event-type 13

2014-07-14 00:22:54 ERROR CreatureEventAI: Event 154004 Action1 uses incorrect Target type 6 for event-type 13

2014-07-14 00:22:54 ERROR CreatureEventAI: Event 166404 Action1 uses incorrect Target type 6 for event-type 13

2014-07-14 00:22:54 ERROR CreatureEventAI: Event 178703 Action1 uses incorrect Target type 6 for event-type 12

2014-07-14 00:22:54 ERROR CreatureEventAI: Event 193701 Action1 uses incorrect Target type 1 for event-type 10 (can not be used OOC)

2014-07-14 00:22:54 ERROR CreatureEventAI: Event 193801 Action1 uses incorrect Target type 1 for event-type 10 (can not be used OOC)

2014-07-14 00:22:54 ERROR CreatureEventAI: Event 195201 Action1 uses incorrect Target type 1 for event-type 10 (can not be used OOC)

2014-07-14 00:22:54 ERROR CreatureEventAI: Event 212101 Action1 uses incorrect Target type 1 for event-type 10 (can not be used OOC)

NO3: i am sorry,i did not find out which tabel that the field EFLAG_REPEATABLE belongs to.so i can't modify it.

2014-07-14 00:22:55 ERROR CreatureEventAI: Creature 12143 has EFLAG_REPEATABLE set. Event can never be repeatable. Removing flag for event 1214301.

2014-07-14 00:22:55 ERROR CreatureEventAI: Creature 15215 has EFLAG_REPEATABLE set. Event can never be repeatable. Removing flag for event 1521501.

2014-07-14 00:22:55 ERROR CreatureEventAI: EventAI not has script for creature entry (4509), but AIName = 'EventAI'.

NO4:

2014-07-14 00:22:57 SD2: Loading C++ scripts

2014-07-14 00:22:57 <SD2 ERROR>: Script registering but ScriptName boss_arugal is not assigned in database. Script will not be used.

2014-07-14 00:22:57 <SD2 ERROR>: Script registering but ScriptName npc_onyxian_warder is not assigned in database. Script will not be used.

the way I used to refresh my database is import those .sql files:

1.create_mysql.sql

2.characters.sql

3.mangos_blank_noNPCs.sql

4. I used database_master/_tools/MaNGOSdb_Installer.bat to import mangos's data in the /_full_db.(import mangos_full_db.sql I got errors everytime,so I use mangosdb_installer.bat to instead)

5.mangos_spell_check.sql

6.realmd.sql

7.mangos_scriptname_clear.sql

8.mangos_scriptname_full.sql

9.scriptdev2_create_database.sql

10.scriptdev2_create_structure_mysql.sql

11.scriptdev2_script_full.sql

12.mangos_optional_generic_creature.sql

do i miss some files to import?

thanks.

best regards.

[antz]

hi guys,I refresh my database with the newest data.and I got errors like below:

NO1.

Loading Creature templates...

2014-07-14 00:21:39 >> Loaded 9092 creature definitions

2014-07-14 00:21:39

2014-07-14 00:21:39 ERROR:Creature (Entry: 6), Class(1), level(1) has no data in `creature_template_classlevelstats`

2014-07-14 00:21:39 ERROR:Creature (Entry: 247), Class(1), level(1) has no data in `creature_template_classlevelstats`

2014-07-14 00:21:39 ERROR:Creature (Entry: 299), Class(1), level(1) has no data in `creature_template_classlevelstats`

2014-07-14 00:21:39 ERROR:Creature (Entry: 356), Class(1), level(1) has no data in `creature_template_classlevelstats`

2014-07-14 00:21:39 ERROR:Creature (Entry: 359), Class(1), level(1) has no data in `creature_template_classlevelstats`

NO2. this kind of errors i have got when I start Rel18 mangos.

2014-07-14 00:22:54 Loading CreatureEventAI Summons...

2014-07-14 00:22:54

2014-07-14 00:22:54 >> Loaded 20 CreatureEventAI summon definitions

2014-07-14 00:22:54 Loading CreatureEventAI Scripts...

2014-07-14 00:22:54 ERROR CreatureEventAI: Event 43101 Action1 uses incorrect Target type 6 for event-type 12

2014-07-14 00:22:54 ERROR CreatureEventAI: Event 58702 Action1 uses incorrect Target type 6 for event-type 13

2014-07-14 00:22:54 ERROR CreatureEventAI: Event 154004 Action1 uses incorrect Target type 6 for event-type 13

2014-07-14 00:22:54 ERROR CreatureEventAI: Event 166404 Action1 uses incorrect Target type 6 for event-type 13

2014-07-14 00:22:54 ERROR CreatureEventAI: Event 178703 Action1 uses incorrect Target type 6 for event-type 12

2014-07-14 00:22:54 ERROR CreatureEventAI: Event 193701 Action1 uses incorrect Target type 1 for event-type 10 (can not be used OOC)

2014-07-14 00:22:54 ERROR CreatureEventAI: Event 193801 Action1 uses incorrect Target type 1 for event-type 10 (can not be used OOC)

2014-07-14 00:22:54 ERROR CreatureEventAI: Event 195201 Action1 uses incorrect Target type 1 for event-type 10 (can not be used OOC)

2014-07-14 00:22:54 ERROR CreatureEventAI: Event 212101 Action1 uses incorrect Target type 1 for event-type 10 (can not be used OOC)

NO3: i am sorry,i did not find out which tabel that the field EFLAG_REPEATABLE belongs to.so i can't modify it.

2014-07-14 00:22:55 ERROR CreatureEventAI: Creature 12143 has EFLAG_REPEATABLE set. Event can never be repeatable. Removing flag for event 1214301.

2014-07-14 00:22:55 ERROR CreatureEventAI: Creature 15215 has EFLAG_REPEATABLE set. Event can never be repeatable. Removing flag for event 1521501.

2014-07-14 00:22:55 ERROR CreatureEventAI: EventAI not has script for creature entry (4509), but AIName = 'EventAI'.

NO4:

2014-07-14 00:22:57 SD2: Loading C++ scripts

2014-07-14 00:22:57 <SD2 ERROR>: Script registering but ScriptName boss_arugal is not assigned in database. Script will not be used.

2014-07-14 00:22:57 <SD2 ERROR>: Script registering but ScriptName npc_onyxian_warder is not assigned in database. Script will not be used.

the way I used to refresh my database is import those .sql files:

1.create_mysql.sql

2.characters.sql

3.mangos_blank_noNPCs.sql

4. I used database_master/_tools/MaNGOSdb_Installer.bat to import mangos's data in the /_full_db.(import mangos_full_db.sql I got errors everytime,so I use mangosdb_installer.bat to instead)

5.mangos_spell_check.sql

6.realmd.sql

7.mangos_scriptname_clear.sql

8.mangos_scriptname_full.sql

9.scriptdev2_create_database.sql

10.scriptdev2_create_structure_mysql.sql

11.scriptdev2_script_full.sql

12.mangos_optional_generic_creature.sql

do i miss some files to import?

thanks.

best regards.

Currently there are some startup errors, this is normal.

Steps 7-12 are no longer required.

Then apply all updates from _updates/Rel19

[xiazai]

antz,thank you very much! have a good day!

[antz]

Can you take a look through the mangos logs and see if there is anymore information that could be useful