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

Results 1 to 6 of 6
  1. #1
    Member theheadlh is offline
    MemberRank
    Aug 2006 Join Date
    26Posts

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

    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:
    Code:
    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!


  2. #2
    Sorcerer Supreme Quakes69 is offline
    Member +Rank
    Jun 2007 Join Date
    327Posts

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

    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

  3. #3
    Infraction Banned SocialStudies is offline
    MemberRank
    Aug 2007 Join Date
    MXLocation
    40Posts

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

    i agree with the guy on top of me!

  4. #4
    Elite Member howie is offline
    Member +Rank
    Feb 2003 Join Date
    homeLocation
    218Posts

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

    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

  5. #5
    Member theheadlh is offline
    MemberRank
    Aug 2006 Join Date
    26Posts

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

    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:

    Code:
    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?

  6. #6
    Member theheadlh is offline
    MemberRank
    Aug 2006 Join Date
    26Posts

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

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



Advertisement