[MaNGOS HELP] My server is crashing too much with SPELLS problems

[theheadlh]

Hi everyone!

I'm using STUDENT1 release 4300 and it is crashing more and more in every release when using some spells or learn some professions. For exemple, in Wailing Caverns instance, Lady Anaconda Boss, when she come to attack mangos crash. I think some spell of her is doing this.

Here some of this errors:

2007-08-11 14:23:00 `petcreateinfo_spell` table is empty!
2007-08-11 14:23:15 >> Table game_event is empty:
2007-08-11 14:23:17 Quest 8869 has `ReqSpellCast1` = 17044 but spell 17044 doesn't exist, quest can't be done.
2007-08-11 14:23:17 Quest 10850 has `RewSpell` = 38758 but spell 38758 doesn't exist, quest will not have a spell reward.
2007-08-11 14:23:17 Quest 9168 has `ReqSpellCast1` = 28300 but spell 28300 doesn't exist, quest can't be done.
2007-08-11 16:08:11 LoadTrainerSpells: Trainer(17750) has not learning spell(674).
2007-08-11 16:08:11 LoadTrainerSpells: Trainer(17750) has not learning spell(750).
2007-08-11 16:08:11 LoadTrainerSpells: Trainer(17750) has not learning spell(3127).
2007-08-11 16:08:11 LoadTrainerSpells: Trainer(17750) has not learning spell(7384).
2007-08-11 16:08:11 LoadTrainerSpells: Trainer(17750) has not learning spell(7887).
2007-08-11 16:08:11 LoadTrainerSpells: Trainer(17750) has not learning spell(11584).
2007-08-11 16:08:11 LoadTrainerSpells: Trainer(17750) has not learning spell(11585).
2007-08-11 19:38:40 Item RandomProperty / RandomSuffix id #205 used in `item_template` but it doesn't have records in `item_enchantment_template` table.
2007-08-11 19:38:40 Enchantment id #0 used but it doesn't have records in sItemRandomSuffixStore.
2007-08-12 01:11:33 Item RandomProperty / RandomSuffix id #205 used in `item_template` but it doesn't have records in `item_enchantment_template` table.
2007-08-12 01:11:33 Enchantment id #0 used but it doesn't have records in sItemRandomSuffixStore.
2007-08-12 17:08:52 `petcreateinfo_spell` table is empty!
2007-08-12 17:09:13 >> Table game_event is empty:
2007-08-12 17:09:16 Quest 8869 has `ReqSpellCast1` = 17044 but spell 17044 doesn't exist, quest can't be done.
2007-08-12 17:09:16 Quest 10850 has `RewSpell` = 38758 but spell 38758 doesn't exist, quest will not have a spell reward.
2007-08-12 17:09:16 Quest 9168 has `ReqSpellCast1` = 28300 but spell 28300 doesn't exist, quest can't be done.
2007-08-12 17:11:34 Item RandomProperty / RandomSuffix id #4294967295 used in `item_template` but it doesn't have records in `item_enchantment_template` table.
2007-08-12 17:11:34 Enchantment id #0 used but it doesn't have records in 'ItemRandomProperties.dbc'
2007-08-12 18:11:34 Item RandomProperty / RandomSuffix id #4294967295 used in `item_template` but it doesn't have records in `item_enchantment_template` table.
2007-08-12 18:11:34 Enchantment id #0 used but it doesn't have records in 'ItemRandomProperties.dbc'
2007-08-12 18:42:22 `petcreateinfo_spell` table is empty!
2007-08-12 18:42:34 >> Table game_event is empty:
2007-08-12 18:42:36 Quest 8869 has `ReqSpellCast1` = 17044 but spell 17044 doesn't exist, quest can't be done.
2007-08-12 18:42:36 Quest 10850 has `RewSpell` = 38758 but spell 38758 doesn't exist, quest will not have a spell reward.
2007-08-12 18:42:36 Quest 9168 has `ReqSpellCast1` = 28300 but spell 28300 doesn't exist, quest can't be done.
2007-08-12 18:46:30 `petcreateinfo_spell` table is empty!
2007-08-12 18:46:39 >> Table game_event is empty:
2007-08-12 18:46:41 Quest 8869 has `ReqSpellCast1` = 17044 but spell 17044 doesn't exist, quest can't be done.
2007-08-12 18:46:41 Quest 10850 has `RewSpell` = 38758 but spell 38758 doesn't exist, quest will not have a spell reward.
2007-08-12 18:46:41 Quest 9168 has `ReqSpellCast1` = 28300 but spell 28300 doesn't exist, quest can't be done.
2007-08-12 21:23:45 LoadTrainerSpells: Trainer(17750) has not learning spell(674).
2007-08-12 21:23:45 LoadTrainerSpells: Trainer(17750) has not learning spell(750).
2007-08-12 21:23:45 LoadTrainerSpells: Trainer(17750) has not learning spell(3127).
2007-08-12 21:23:45 LoadTrainerSpells: Trainer(17750) has not learning spell(7384).
2007-08-12 21:23:45 LoadTrainerSpells: Trainer(17750) has not learning spell(7887).
2007-08-12 21:23:45 LoadTrainerSpells: Trainer(17750) has not learning spell(11584).
2007-08-12 21:23:45 LoadTrainerSpells: Trainer(17750) has not learning spell(11585).
2007-08-13 04:09:48 Item RandomProperty / RandomSuffix id #205 used in `item_template` but it doesn't have records in `item_enchantment_template` table.
2007-08-13 04:09:48 Enchantment id #0 used but it doesn't have records in sItemRandomSuffixStore.

How can i fix this? Can someone send me only the SPELL tables?
Thx in advance!

[MentaL]

[Quakes69]

goto the above post of full scripts and get the Silvermoon Rev13 full in there you'll find the tables and scripts. Or redo all DB with a full repack

[SocialStudies]

i agree with the guy on top of me!

[howie]

I agree, but preferably without a guy on top of me :eek:

BTW SDB v 14.5 is out now.

and make sure you install the proper patches

[theheadlh]

I get v14 and copy all SPELL tables to my database. My old one doesnt have SPELL table, then i put, but still give me this error on mangosd.exe load:

2007-08-13 17:13:22 Quest 8869 has `ReqSpellCast1` = 17044 but spell 17044 doesn't exist, quest can't be done.
2007-08-13 17:13:22 Quest 10850 has `RewSpell` = 38758 but spell 38758 doesn't exist, quest will not have a spell reward.
2007-08-13 17:13:22 Quest 9168 has `ReqSpellCast1` = 28300 but spell 28300 doesn't exist, quest can't be done.

Normal (occurs with you too) or something is still wrong?

[theheadlh]

I set QUEST_TEMPLATE now and ok. But now items are wrong... omg :D Still working...