error problem

Newbie Spellweaver
Joined
Jan 30, 2007
Messages
30
Reaction score
0
can some1 tell me why when i try to import some updates in my server i have many errors and then the server fuck up ? i use MANGOS Server v3083,the mangos platinum project based.
 
2007-02-05 20:43:16 World Database: 127.0.0.1;3306;root;mangos;mangos
2007-02-05 20:43:16 Login Database: 127.0.0.1;3306;root;mangos;realmd
2007-02-05 20:43:16 Realm running as realm ID 1
2007-02-05 20:43:16 Using DataDir .\DATA/ ...
2007-02-05 20:43:16 Initialize data stores...
2007-02-05 20:43:16
2007-02-05 20:43:16 >> Loaded 28 data stores
2007-02-05 20:43:16
2007-02-05 20:43:16 Loading Game Object Templates...
2007-02-05 20:43:16 >> Loaded 3695 game object templates
2007-02-05 20:43:16
2007-02-05 20:43:16 Loading player create info & level stats...
2007-02-05 20:43:16
2007-02-05 20:43:16 >> Loaded 0 player create definitions
2007-02-05 20:43:16 ERROR:Error loading `playercreateinfo` table or table empty.



that's what happened when i imported some of the updates from the updates folder.
 
Well, it says that you're either missing the palyercreateinfo table, or it just empty. BTW, DON'T use the updates in the folder, just download an SDB.

well ? can some 1 answer me ?
In the future, please don't do this. It's extremely annoying and makes you look nothing but impatient.
 
damn! i found the updates for my exact mangos version from , but whan i imported them i got these errors :

MiscHandler :

Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 1299
STR: ::
SQL: /*
* Copyright (C) 2005,2006 MaNGOS <http://www.mangosproject.org/>
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/

#include "Common.h"
#include "Database/DatabaseEnv.h"
#include "WorldPacket.h"
#include "Opcodes.h"
#include "Log.h"
#include "Player.h"
#include "World.h"
#include "ObjectMgr.h"
#include "WorldSession.h"
#include "Auth/BigNumber.h"
#include "Auth/Sha1.h"
#include "UpdateData.h"
#include "LootMgr.h"
#include "Chat.h"
#include "ScriptCalls.h"
#include <zlib/zlib.h>
#include "MapManager.h"
#include "ObjectAccessor.h"
#include "Object.h"
#include "BattleGround.h"
#include "SpellAuras.h"

void WorldSession::HandleRepopRequestOpcode( WorldPacket & recv_data )
{
sLog.outDebug( "WORLD: Recvd CMSG_REPOP_REQUEST Message" );


SQL query:

/* * Copyright (C) 2005,2006 MaNGOS * * This program is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 2 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */ #include "Common.h" #include "Database/DatabaseEnv.h" #include "WorldPacket.h" #include "Opcodes.h" #include "Log.h" #include "Player.h" #include "World.h" #include "ObjectMgr.h" #include "WorldSession.h" #include "Auth/BigNumber.h" #include "Auth/Sha1.h" #include "UpdateData.h" #include "LootMgr.h" #include "Chat.h" #include "ScriptCalls.h" #include #include "MapManager.h" #include "ObjectAccessor.h" #include "Object.h" #include "BattleGround.h" #include "SpellAuras.h" void WorldSession::HandleRepopRequestOpcode( WorldPacket & recv_data ) { sLog.outDebug( "WORLD: Recvd CMSG_REPOP_REQUEST Message" );

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'void WorldSession::HandleRepopRequestOpcode( WorldPacket & recv_data )
{
sLo' at line 1


Pet :

Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 1105
STR: //
SQL: /*
* Copyright (C) 2005,2006 MaNGOS <http://www.mangosproject.org/>
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/

#include "Common.h"
#include "Database/DatabaseEnv.h"
#include "Log.h"
#include "WorldSession.h"
#include "WorldPacket.h"
#include "ObjectMgr.h"
#include "Pet.h"
#include "MapManager.h"
#include "Formulas.h"

char const* petTypeSuffix[MAX_PET_TYPE] =
{
"'s Minion", // SUMMON_PET
"'s Pet", // HUNTER_PET
"'s Guardian", // GUARDIAN_PET
"'s Pet" // MINI_PET
};


SQL query:

/* * Copyright (C) 2005,2006 MaNGOS * * This program is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 2 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */ #include "Common.h" #include "Database/DatabaseEnv.h" #include "Log.h" #include "WorldSession.h" #include "WorldPacket.h" #include "ObjectMgr.h" #include "Pet.h" #include "MapManager.h" #include "Formulas.h" char const* petTypeSuffix[MAX_PET_TYPE] = { "'s Minion", // SUMMON_PET "'s Pet", // HUNTER_PET "'s Guardian", // GUARDIAN_PET "'s Pet" // MINI_PET };

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'char const* petTypeSuffix[MAX_PET_TYPE] =
{
"'s Minion", ' at line 1


SpellEffects:

Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 1549
STR: ::
SQL: /*
* Copyright (C) 2005,2006 MaNGOS <http://www.mangosproject.org/>
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/

#include "Common.h"
#include "Database/DatabaseEnv.h"
#include "WorldPacket.h"
#include "WorldSession.h"
#include "Opcodes.h"
#include "Log.h"
#include "UpdateMask.h"
#include "World.h"
#include "ObjectMgr.h"
#include "Player.h"
#include "Unit.h"
#include "CreatureAI.h"
#include "Spell.h"
#include "DynamicObject.h"
#include "SpellAuras.h"
#include "Group.h"
#include "UpdateData.h"
#include "MapManager.h"
#include "ObjectAccessor.h"
#include "RedZoneDistrict.h"
#include "CellImpl.h"
#include "SharedDefines.h"
#include "Pet.h"
#include "GameObject.h"
#include "GossipDef.h"
#include "Creature.h"
#include "Totem.h"
#include "CreatureAI.h"
#include "GridNotifiers.h"
#include "GridNotifiersImpl.h"

pEffect SpellEffects[TOTAL_SPELL_EFFECTS]=
{
&Spell::EffectNULL, //nothing
&Spell::EffectInstaKill, //SPELL_EFFECT_INSTAKILL = 1
&Spell::EffectSchoolDMG, //SPELL_EFFECT_SCHOOL_DAMAGE = 2
&Spell::EffectDummy, //SPELL_EFFECT_DUMMY = 3
&Spell::EffectNULL, //SPELL_EFFECT_PORTAL_TELEPORT = 4
&Spell::EffectTeleportUnits, //SPELL_EFFECT_TELEPORT_UNITS = 5
&Spell::EffectApplyAura, //SPELL_EFFECT_APPLY_AURA = 6
&Spell::EffectSchoolDMG, //SPELL_EFFECT_ENVIRONMENTAL_DAMAGE =7
&Spell::EffectManaDrain, //SPELL_EFFECT_MANA_DRAIN = 8
&Spell::EffectHealthLeach, //SPELL_EFFECT_HEALTH_LEECH = 9
&Spell::EffectHeal, //SPELL_EFFECT_HEAL = 10
&Spell::EffectNULL, //SPELL_EFFECT_BIND = 11
&Spell::EffectNULL, //SPELL_EFFECT_PORTAL = 12
&Spell::EffectNULL, //SPELL_EFFECT_RITUAL_BASE = 13
&Spell::EffectNULL, //SPELL_EFFECT_RITUAL_SPECIALIZE = 14
&Spell::EffectNULL, //SPELL_EFFECT_RITUAL_ACTIVATE_PORTAL = 15
&Spell::EffectQuestComplete, //SPELL_EFFECT_QUEST_COMPLETE = 16
&Spell::EffectWeaponDmg, //SPELL_EFFECT_WEAPON_DAMAGE_NOSCHOOL = 17
&Spell::EffectResurrect, //SPELL_EFFECT_RESURRECT = 18
&Spell::EffectNULL, //SPELL_EFFECT_ADD_EXTRA_ATTACKS = 19
&Spell::EffectNULL, //SPELL_EFFECT_DODGE = 20
&Spell::EffectNULL, //SPELL_EFFECT_EVADE = 21
&Spell::EffectParry, //SPELL_EFFECT_PARRY = 22
&Spell::EffectNULL, //SPELL_EFFECT_BLOCK = 23
&Spell::EffectCreateItem, //SPELL_EFFECT_CREATE_ITEM = 24
&Spell::EffectNULL, //SPELL_EFFECT_WEAPON = 25
&Spell::EffectNULL, //SPELL_EFFECT_DEFENSE = 26
&Spell::EffectPersistentAA, //SPELL_EFFECT_PERSISTENT_AREA_AURA = 27
&Spell::EffectSummon, //SPELL_EFFECT_SUMMON = 28
&Spell::EffectMomentMove, //SPELL_EFFECT_LEAP = 29
&Spell::EffectEnergize, //SPELL_EFFECT_ENERGIZE = 30
&Spell::EffectWeaponDmg, //SPELL_EFFECT_WEAPON_PERCENT_DAMAGE = 31
&Spell::EffectNULL, //SPELL_EFFECT_TRIGGER_MISSILE = 32 //Useless
&Spell::EffectOpenLock, //SPELL_EFFECT_OPEN_LOCK = 33
&Spell::EffectSummonChangeItem, //SPELL_EFFECT_SUMMON_CHANGE_ITEM = 34
&Spell::EffectApplyAA, //SPELL_EFFECT_APPLY_AREA_AURA = 35
&Spell::EffectLearnSpell, //SPELL_EFFECT_LEARN_SPELL = 36
&Spell::EffectNULL, //SPELL_EFFECT_SPELL_DEFENSE = 37 //Useless
&Spell::EffectDispel, //SPELL_EFFECT_DISPEL = 38
&Spell::EffectNULL, //SPELL_EFFECT_LANGUAGE = 39
&Spell::EffectDualWield, //SPELL_EFFECT_DUAL_WIELD = 40
&Spell::EffectSummonWild, //SPELL_EFFECT_SUMMON_WILD = 41
&Spell::EffectSummonWild, //SPELL_EFFECT_SUMMON_GUARDIAN = 42
&Spell::EffectTeleUnitsFaceCaster, //SPELL_EFFECT_TELEPORT_UNITS_FACE_CASTER = 43
&Spell::EffectLearnSkill, //SPELL_EFFECT_SKILL_STEP = 44
&Spell::EffectNULL, //unknown45 = 45
&Spell::EffectNULL, //SPELL_EFFECT_SPAWN = 46
&Spell::EffectTradeSkill, //SPELL_EFFECT_TRADE_SKILL = 47
&Spell::EffectNULL, //SPELL_EFFECT_STEALTH = 48 //Useless
&Spell::EffectNULL, //SPELL_EFFECT_DETECT = 49
&Spell::EffectTransmitted, //SPELL_EFFECT_TRANS_DOOR = 50
&Spell::EffectNULL, //SPELL_EFFECT_FORCE_CRITICAL_HIT = 51 //Useless
&Spell::EffectNULL, //SPELL_EFFECT_GUARANTEE_HIT = 52
&Spell::EffectEnchantItemPerm, //SPELL_EFFECT_ENCHANT_ITEM = 53
&Spell::EffectEnchantItemTmp, //SPELL_EFFECT_ENCHANT_ITEM_TEMPORARY = 54
&Spell::EffectTameCreature, //SPELL_EFFECT_TAMECREATURE = 55
&Spell::EffectSummonPet, //SPELL_EFFECT_SUMMON_PET = 56
&Spell::EffectLearnPetSpell, //SPELL_EFFECT_LEARN_PET_SPELL = 57
&Spell::EffectWeaponDmg, //SPELL_EFFECT_WEAPON_DAMAGE = 58
&Spell::EffectOpenSecretSafe, //SPELL_EFFECT_OPEN_LOCK_ITEM = 59
&Spell::EffectProficiency, //SPELL_EFFECT_PROFICIENCY = 60
&Spell::EffectSendEvent, //SPELL_EFFECT_SEND_EVENT = 61
&Spell::EffectPowerDrain, //SPELL_EFFECT_POWER_BURN = 62
&Spell::EffectThreat, //SPELL_EFFECT_THREAT = 63
&Spell::EffectTriggerSpell, //SPELL_EFFECT_TRIGGER_SPELL = 64
&Spell::EffectNULL, //SPELL_EFFECT_HEALTH_FUNNEL = 65 //Useless
&Spell::EffectNULL, //SPELL_EFFECT_POWER_FUNNEL = 66 //Useless
&Spell::EffectHealMaxHealth, //SPELL_EFFECT_HEAL_MAX_HEALTH = 67
&Spell::EffectInterruptCast, //SPELL_EFFECT_INTERRUPT_CAST = 68
&Spell::EffectNULL, //SPELL_EFFECT_DISTRACT = 69
&Spell::EffectNULL, //SPELL_EFFECT_PULL = 70
&Spell::EffectPickPocket, //SPELL_EFFECT_PICKPOCKET = 71
&Spell::EffectNULL, //SPELL_EFFECT_ADD_FARSIGHT = 72
&Spell::EffectSummonWild, //SPELL_EFFECT_SUMMON_POSSESSED = 73
&Spell::EffectNULL, //SPELL_EFFECT_SUMMON_TOTEM = 74 //Useless
&Spell::EffectNULL, //SPELL_EFFECT_HEAL_MECHANICAL = 75
&Spell::EffectSummonObjectWild, //SPELL_EFFECT_SUMMON_OBJECT_WILD = 76
&Spell::EffectScriptEffect, //SPELL_EFFECT_SCRIPT_EFFECT = 77
&Spell::EffectNULL, //SPELL_EFFECT_ATTACK = 78 //Useless
&Spell::EffectNULL, //SPELL_EFFECT_SANCTUARY = 79
&Spell::EffectAddComboPoints, //SPELL_EFFECT_ADD_COMBO_POINTS = 80
&Spell::EffectNULL, //SPELL_EFFECT_CREATE_HOUSE = 81
&Spell::EffectNULL, //SPELL_EFFECT_BIND_SIGHT = 82
&Spell::EffectDuel, //SPELL_EFFECT_DUEL = 83
&Spell::EffectNULL, //SPELL_EFFECT_STUCK = 84
&Spell::EffectNULL, //SPELL_EFFECT_SUMMON_PLAYER = 85
&Spell::EffectNULL, //SPELL_EFFECT_ACTIVATE_OBJECT = 86
&Spell::EffectSummonTotem, //SPELL_EFFECT_SUMMON_TOTEM_SLOT1 = 87
&Spell::EffectSummonTotem, //SPELL_EFFECT_SUMMON_TOTEM_SLOT2 = 88
&Spell::EffectSummonTotem, //SPELL_EFFECT_SUMMON_TOTEM_SLOT3 = 89
&Spell::EffectSummonTotem, //SPELL_EFFECT_SUMMON_TOTEM_SLOT4 = 90
&Spell::EffectNULL, //SPELL_EFFECT_THREAT_ALL = 91
&Spell::EffectEnchantHeldItem, //SPELL_EFFECT_ENCHANT_HELD_ITEM = 92
&Spell::EffectNULL, //SPELL_EFFECT_SUMMON_PHANTASM = 93
&Spell::EffectSelfResurrect, //SPELL_EFFECT_SELF_RESURRECT = 94
&Spell::EffectSkinning, //SPELL_EFFECT_SKINNING = 95
&Spell::EffectCharge, //SPELL_EFFECT_CHARGE = 96
&Spell::EffectSummonCritter, //SPELL_EFFECT_SUMMON_CRITTER = 97
&Spell::EffectKnockBack, //SPELL_EFFECT_KNOCK_BACK = 98
&Spell::EffectDisEnchant, //SPELL_EFFECT_DISENCHANT = 99
&Spell::EffectInebriate, //SPELL_EFFECT_INEBRIATE = 100
&Spell::EffectFeedPet, //SPELL_EFFECT_FEED_PET = 101
&Spell::EffectDismissPet, //SPELL_EFFECT_DISMISS_PET = 102
&Spell::EffectReputation, //SPELL_EFFECT_REPUTATION = 103
&Spell::EffectSummonObject, //SPELL_EFFECT_SUMMON_OBJECT_SLOT1 = 104
&Spell::EffectSummonObject, //SPELL_EFFECT_SUMMON_OBJECT_SLOT2 = 105
&Spell::EffectSummonObject, //SPELL_EFFECT_SUMMON_OBJECT_SLOT3 = 106
&Spell::EffectSummonObject, //SPELL_EFFECT_SUMMON_OBJECT_SLOT4 = 107
&Spell::EffectNULL, //SPELL_EFFECT_DISPEL_MECHANIC = 108
&Spell::EffectSummonDeadPet, //SPELL_EFFECT_SUMMON_DEAD_PET = 109
&Spell::EffectNULL, //SPELL_EFFECT_DESTROY_ALL_TOTEMS = 110
&Spell::EffectNULL, //SPELL_EFFECT_DURABILITY_DAMAGE = 111
&Spell::EffectNULL, //SPELL_EFFECT_SUMMON_DEMON = 112
&Spell::EffectResurrectNew, //SPELL_EFFECT_RESURRECT_NEW = 113
&Spell::EffectAttackMe, //SPELL_EFFECT_ATTACK_ME = 114
&Spell::EffectNULL, //SPELL_EFFECT_DURABILITY_DAMAGE_PCT = 115
&Spell::EffectNULL, //SPELL_EFFECT_SKIN_PLAYER_CORPSE = 116
&Spell::EffectNULL, //SPELL_EFFECT_SPIRIT_HEAL = 117
&Spell::EffectSkill, //SPELL_EFFECT_SKILL = 118 -- professions and more
&Spell::EffectNULL, //SPELL_EFFECT_APPLY_AURA_NEW = 119
&Spell::EffectNULL, //SPELL_EFFECT_TELEPORT_GRAVEYARD = 120
&Spell::EffectWeaponDmg //SPELL_EFFECT_NORMALIZED_WEAPON_DMG = 121
};


SQL query:

/* * Copyright (C) 2005,2006 MaNGOS * * This program is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 2 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */ #include "Common.h" #include "Database/DatabaseEnv.h" #include "WorldPacket.h" #include "WorldSession.h" #include "Opcodes.h" #include "Log.h" #include "UpdateMask.h" #include "World.h" #include "ObjectMgr.h" #include "Player.h" #include "Unit.h" #include "CreatureAI.h" #include "Spell.h" #include "DynamicObject.h" #include "SpellAuras.h" #include "Group.h" #include "UpdateData.h" #include "MapManager.h" #include "ObjectAccessor.h" #include "RedZoneDistrict.h" #include "CellImpl.h" #include "SharedDefines.h" #include "Pet.h" #include "GameObject.h" #include "GossipDef.h" #include "Creature.h" #include "Totem.h" #include "CreatureAI.h" #include "GridNotifiers.h" #include "GridNotifiersImpl.h" pEffect SpellEffects[TOTAL_SPELL_EFFECTS]= { &Spell::EffectNULL, //nothing &Spell::EffectInstaKill, //SPELL_EFFECT_INSTAKILL = 1 &Spell::EffectSchoolDMG, //SPELL_EFFECT_SCHOOL_DAMAGE = 2 &Spell::EffectDummy, //SPELL_EFFECT_DUMMY = 3 &Spell::EffectNULL, //SPELL_EFFECT_PORTAL_TELEPORT = 4 &Spell::EffectTeleportUnits, //SPELL_EFFECT_TELEPORT_UNITS = 5 &Spell::EffectApplyAura, //SPELL_EFFECT_APPLY_AURA = 6 &Spell::EffectSchoolDMG, //SPELL_EFFECT_ENVIRONMENTAL_DAMAGE =7 &Spell::EffectManaDrain, //SPELL_EFFECT_MANA_DRAIN = 8 &Spell::EffectHealthLeach, //SPELL_EFFECT_HEALTH_LEECH = 9 &Spell::EffectHeal, //SPELL_EFFECT_HEAL = 10 &Spell::EffectNULL, //SPELL_EFFECT_BIND = 11 &Spell::EffectNULL, //SPELL_EFFECT_PORTAL = 12 &Spell::EffectNULL, //SPELL_EFFECT_RITUAL_BASE = 13 &Spell::EffectNULL, //SPELL_EFFECT_RITUAL_SPECIALIZE = 14 &Spell::EffectNULL, //SPELL_EFFECT_RITUAL_ACTIVATE_PORTAL = 15 &Spell::EffectQuestComplete, //SPELL_EFFECT_QUEST_COMPLETE = 16 &Spell::EffectWeaponDmg, //SPELL_EFFECT_WEAPON_DAMAGE_NOSCHOOL = 17 &Spell::EffectResurrect, //SPELL_EFFECT_RESURRECT = 18 &Spell::EffectNULL, //SPELL_EFFECT_ADD_EXTRA_ATTACKS = 19 &Spell::EffectNULL, //SPELL_EFFECT_DODGE = 20 &Spell::EffectNULL, //SPELL_EFFECT_EVADE = 21 &Spell::EffectParry, //SPELL_EFFECT_PARRY = 22 &Spell::EffectNULL, //SPELL_EFFECT_BLOCK = 23 &Spell::EffectCreateItem, //SPELL_EFFECT_CREATE_ITEM = 24 &Spell::EffectNULL, //SPELL_EFFECT_WEAPON = 25 &Spell::EffectNULL, //SPELL_EFFECT_DEFENSE = 26 &Spell::EffectPersistentAA, //SPELL_EFFECT_PERSISTENT_AREA_AURA = 27 &Spell::EffectSummon, //SPELL_EFFECT_SUMMON = 28 &Spell::EffectMomentMove, //SPELL_EFFECT_LEAP = 29 &Spell::EffectEnergize, //SPELL_EFFECT_ENERGIZE = 30 &Spell::EffectWeaponDmg, //SPELL_EFFECT_WEAPON_PERCENT_DAMAGE = 31 &Spell::EffectNULL, //SPELL_EFFECT_TRIGGER_MISSILE = 32 //Useless &Spell::EffectOpenLock, //SPELL_EFFECT_OPEN_LOCK = 33 &Spell::EffectSummonChangeItem, //SPELL_EFFECT_SUMMON_CHANGE_ITEM = 34 &Spell::EffectApplyAA, //SPELL_EFFECT_APPLY_AREA_AURA = 35 &Spell::EffectLearnSpell, //SPELL_EFFECT_LEARN_SPELL = 36 &Spell::EffectNULL, //SPELL_EFFECT_SPELL_DEFENSE = 37 //Useless &Spell::EffectDispel, //SPELL_EFFECT_DISPEL = 38 &Spell::EffectNULL, //SPELL_EFFECT_LANGUAGE = 39 &Spell::EffectDualWield, //SPELL_EFFECT_DUAL_WIELD = 40 &Spell::EffectSummonWild, //SPELL_EFFECT_SUMMON_WILD = 41 &Spell::EffectSummonWild, //SPELL_EFFECT_SUMMON_GUARDIAN = 42 &Spell::EffectTeleUnitsFaceCaster, //SPELL_EFFECT_TELEPORT_UNITS_FACE_CASTER = 43 &Spell::EffectLearnSkill, //SPELL_EFFECT_SKILL_STEP = 44 &Spell::EffectNULL, //unknown45 = 45 &Spell::EffectNULL, //SPELL_EFFECT_SPAWN = 46 &Spell::EffectTradeSkill, //SPELL_EFFECT_TRADE_SKILL = 47 &Spell::EffectNULL, //SPELL_EFFECT_STEALTH = 48 //Useless &Spell::EffectNULL, //SPELL_EFFECT_DETECT = 49 &Spell::EffectTransmitted, //SPELL_EFFECT_TRANS_DOOR = 50 &Spell::EffectNULL, //SPELL_EFFECT_FORCE_CRITICAL_HIT = 51 //Useless &Spell::EffectNULL, //SPELL_EFFECT_GUARANTEE_HIT = 52 &Spell::EffectEnchantItemPerm, //SPELL_EFFECT_ENCHANT_ITEM = 53 &Spell::EffectEnchantItemTmp, //SPELL_EFFECT_ENCHANT_ITEM_TEMPORARY = 54 &Spell::EffectTameCreature, //SPELL_EFFECT_TAMECREATURE = 55 &Spell::EffectSummonPet, //SPELL_EFFECT_SUMMON_PET = 56 &Spell::EffectLearnPetSpell, //SPELL_EFFECT_LEARN_PET_SPELL = 57 &Spell::EffectWeaponDmg, //SPELL_EFFECT_WEAPON_DAMAGE = 58 &Spell::EffectOpenSecretSafe, //SPELL_EFFECT_OPEN_LOCK_ITEM = 59 &Spell::EffectProficiency, //SPELL_EFFECT_PROFICIENCY = 60 &Spell::EffectSendEvent, //SPELL_EFFECT_SEND_EVENT = 61 &Spell::EffectPowerDrain, //SPELL_EFFECT_POWER_BURN = 62 &Spell::EffectThreat, //SPELL_EFFECT_THREAT = 63 &Spell::EffectTriggerSpell, //SPELL_EFFECT_TRIGGER_SPELL = 64 &Spell::EffectNULL, //SPELL_EFFECT_HEALTH_FUNNEL = 65 //Useless &Spell::EffectNULL, //SPELL_EFFECT_POWER_FUNNEL = 66 //Useless &Spell::EffectHealMaxHealth, //SPELL_EFFECT_HEAL_MAX_HEALTH = 67 &Spell::EffectInterruptCast, //SPELL_EFFECT_INTERRUPT_CAST = 68 &Spell::EffectNULL, //SPELL_EFFECT_DISTRACT = 69 &Spell::EffectNULL, //SPELL_EFFECT_PULL = 70 &Spell::EffectPickPocket, //SPELL_EFFECT_PICKPOCKET = 71 &Spell::EffectNULL, //SPELL_EFFECT_ADD_FARSIGHT = 72 &Spell::EffectSummonWild, //SPELL_EFFECT_SUMMON_POSSESSED = 73 &Spell::EffectNULL, //SPELL_EFFECT_SUMMON_TOTEM = 74 //Useless &Spell::EffectNULL, //SPELL_EFFECT_HEAL_MECHANICAL = 75 &Spell::EffectSummonObjectWild, //SPELL_EFFECT_SUMMON_OBJECT_WILD = 76 &Spell::EffectScriptEffect, //SPELL_EFFECT_SCRIPT_EFFECT = 77 &Spell::EffectNULL, //SPELL_EFFECT_ATTACK = 78 //Useless &Spell::EffectNULL, //SPELL_EFFECT_SANCTUARY = 79 &Spell::EffectAddComboPoints, //SPELL_EFFECT_ADD_COMBO_POINTS = 80 &Spell::EffectNULL, //SPELL_EFFECT_CREATE_HOUSE = 81 &Spell::EffectNULL, //SPELL_EFFECT_BIND_SIGHT = 82 &Spell::EffectDuel, //SPELL_EFFECT_DUEL = 83 &Spell::EffectNULL, //SPELL_EFFECT_STUCK = 84 &Spell::EffectNULL, //SPELL_EFFECT_SUMMON_PLAYER = 85 &Spell::EffectNULL, //SPELL_EFFECT_ACTIVATE_OBJECT = 86 &Spell::EffectSummonTotem, //SPELL_EFFECT_SUMMON_TOTEM_SLOT1 = 87 &Spell::EffectSummonTotem, //SPELL_EFFECT_SUMMON_TOTEM_SLOT2 = 88 &Spell::EffectSummonTotem, //SPELL_EFFECT_SUMMON_TOTEM_SLOT3 = 89 &Spell::EffectSummonTotem, //SPELL_EFFECT_SUMMON_TOTEM_SLOT4 = 90 &Spell::EffectNULL, //SPELL_EFFECT_THREAT_ALL = 91 &Spell::EffectEnchantHeldItem, //SPELL_EFFECT_ENCHANT_HELD_ITEM = 92 &Spell::EffectNULL, //SPELL_EFFECT_SUMMON_PHANTASM = 93 &Spell::EffectSelfResurrect, //SPELL_EFFECT_SELF_RESURRECT = 94 &Spell::EffectSkinning, //SPELL_EFFECT_SKINNING = 95 &Spell::EffectCharge, //SPELL_EFFECT_CHARGE = 96 &Spell::EffectSummonCritter, //SPELL_EFFECT_SUMMON_CRITTER = 97 &Spell::EffectKnockBack, //SPELL_EFFECT_KNOCK_BACK = 98 &Spell::EffectDisEnchant, //SPELL_EFFECT_DISENCHANT = 99 &Spell::EffectInebriate, //SPELL_EFFECT_INEBRIATE = 100 &Spell::EffectFeedPet, //SPELL_EFFECT_FEED_PET = 101 &Spell::EffectDismissPet, //SPELL_EFFECT_DISMISS_PET = 102 &Spell::EffectReputation, //SPELL_EFFECT_REPUTATION = 103 &Spell::EffectSummonObject, //SPELL_EFFECT_SUMMON_OBJECT_SLOT1 = 104 &Spell::EffectSummonObject, //SPELL_EFFECT_SUMMON_OBJECT_SLOT2 = 105 &Spell::EffectSummonObject, //SPELL_EFFECT_SUMMON_OBJECT_SLOT3 = 106 &Spell::EffectSummonObject, //SPELL_EFFECT_SUMMON_OBJECT_SLOT4 = 107 &Spell::EffectNULL, //SPELL_EFFECT_DISPEL_MECHANIC = 108 &Spell::EffectSummonDeadPet, //SPELL_EFFECT_SUMMON_DEAD_PET = 109 &Spell::EffectNULL, //SPELL_EFFECT_DESTROY_ALL_TOTEMS = 110 &Spell::EffectNULL, //SPELL_EFFECT_DURABILITY_DAMAGE = 111 &Spell::EffectNULL, //SPELL_EFFECT_SUMMON_DEMON = 112 &Spell::EffectResurrectNew, //SPELL_EFFECT_RESURRECT_NEW = 113 &Spell::EffectAttackMe, //SPELL_EFFECT_ATTACK_ME = 114 &Spell::EffectNULL, //SPELL_EFFECT_DURABILITY_DAMAGE_PCT = 115 &Spell::EffectNULL, //SPELL_EFFECT_SKIN_PLAYER_CORPSE = 116 &Spell::EffectNULL, //SPELL_EFFECT_SPIRIT_HEAL = 117 &Spell::EffectSkill, //SPELL_EFFECT_SKILL = 118 -- professions and more &Spell::EffectNULL, //SPELL_EFFECT_APPLY_AURA_NEW = 119 &Spell::EffectNULL, //SPELL_EFFECT_TELEPORT_GRAVEYARD = 120 &Spell::EffectWeaponDmg //SPELL_EFFECT_NORMALIZED_WEAPON_DMG = 121 };

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'pEffect SpellEffects[TOTAL_SPELL_EFFECTS]=
{
&Spell::EffectNULL, ' at line 1


UpdateFields:

Error

SQL query:

/* * Copyright (C) 2005,2006 MaNGOS <http://www.mangosproject.org/> * * This program is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 2 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */#include "Common.h"
#ifndef _UPDATEFIELDS_AUTO_H
#define _UPDATEFIELDS_AUTO_H
enumEObjectFields{OBJECT_FIELD_GUID = 0x0000, OBJECT_FIELD_TYPE = 0x0002, OBJECT_FIELD_ENTRY = 0x0003, OBJECT_FIELD_SCALE_X = 0x0004, OBJECT_FIELD_PADDING = 0x0005, OBJECT_END = OBJECT_FIELD_PADDING +1, };

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'enum EObjectFields
{
OBJECT_FIELD_GUID = 0x0000,' at line 1




sry 4 the error spam,but i dont understand y i have errors when i import the right updates...
so,plz! if some 1 know how to import some updates and don't get errors,plz post here! I'm really getting sick of these errors...
 
come on! i think i'v waited enough n still there arent answers... is there some 1 who can tell me why i get these fuxin errors when i import an update 4 the right mangos version????????????????????
 
Back