Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

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 duck up ? i use MANGOS Server v3083,the mangos platinum project based.
 
Lord of the Legion
Joined
Jul 28, 2005
Messages
426
Reaction score
35
Are you using the proper updates?

If you use the wrong updates with the wrong revision, you will get many errors.
 
Junior Spellweaver
Joined
Sep 29, 2006
Messages
135
Reaction score
0
can you maybe give us the error's your getting copy paste or screenshot
 
Newbie Spellweaver
Joined
Jan 30, 2007
Messages
30
Reaction score
0
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.
 
Banned
Banned
Joined
Oct 20, 2006
Messages
3,245
Reaction score
1,652
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.
 
Newbie Spellweaver
Joined
Jan 30, 2007
Messages
30
Reaction score
0
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...
 
Newbie Spellweaver
Joined
Jan 30, 2007
Messages
30
Reaction score
0
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
Top