Page 1 of 1

Error Loading Spells

Posted: Fri Mar 06, 2009 11:18 am
by KiriX
Server was downloaded from: http://sourceforge.net/project/showfile ... _id=663186
And get this errors on startup
[Status] Using database 'eq2' at 127.0.0.1
[Status] CURRENT_WORLD_VERSION:EQ2EMu 0.6.5 Developer Alpha
[Status] ./LoginServer.ini read.
[Status] Connecting to Update Server..
[Status] Connected to Update Server: updates.eq2emulator.net:9103
[Status] Checking for updates.
[Status] Server is already up-to-date.
[Status] Loading opcodes..
[Status] Loading structs..
[Status] Loading command list..
[Status] Loaded 21 entity command lists.
[Status] Loaded 0 NPC(s).
[Status] Loaded 0 Object(s).
[Status] Loaded 0 GroundSpawn(s).
[Status] Loaded 0 Widget(s).
[Status] Loaded 0 Sign(s).
[Status] Loading ground spawn items..
[Status] Loading loot data..
[Status] Loaded 0 loot tables.
[Status] Loaded 0 loot drops.
[Status] Loaded 0 spawn loot lists.
[Status] Loading Transporter Information..
[Status] Loaded 0 Teleporter(s)
[Status] Loaded global variables list..
[Status] Loaded visual states list..
[Status] Loading World Time..
[Status] Loading items.. (this might take a few minutes)
[Status] Loaded 0 Bag(s)
[Status] Loaded 0 Food(s)
[Status] Loaded 0 Weapon(s)
[Status] Loaded 0 Armor/Shield Piece(s)
[Status] Loaded 0 Skill Item(s)
[Status] Loaded 0 Regular Items
[Status] Loading spells..
Error Loading Spells, Query: select spells.id, name, description, type, class_sk
ill, mastery_skill, tier, hp_req, power_req, cast_time, recast, radius, max_aoe_
targets, req_concentration, range, duration1, duration2, resistibility, hp_upkee
p, power_upkeep, duration_until_cancel, target_type, recovery, power_req_percent
, hp_req_percent, icon, icon2, icontype, success_message, fade_message, cast_typ
e, lua_script, call_frequency, interruptable, spell_visual, effect_message, min_
range, can_effect_raid, affect_only_group_members, hit_bonus, spell_text_color,
display_spell_tier, friendly_spell, group_spell from spells, spell_tiers where s
pells.id = spell_tiers.spell_id order by tier, Error: #1064: You have an error i
n your SQL syntax; check the manual that corresponds to your MySQL server versio
n for the right syntax to use near 'range, duration1, duration2, resistibility,
hp_upkeep, power_upkeep, duration_un' at line 1
[Status] Loading LUA spells..
[Status] Loaded 2 LUA Spell(s)
[Status] Loading factions..
[Status] Loaded 48 Factions
[Status] Loading skills..
[Status] Loaded 129 Skills
[Status] Loading Quests..
[Status] Loaded 0 Quest(s)
[Status] Loading Merchant Information..
[Status] Loaded 0 Merchant List(s)
[Status] Loaded 0 Merchant Multiplier(s)
[Status] Loading Spawn Script Information..
[Status] Loading EQ time of day..
Please refrain from drinking alcoholic beverages while using this program.
Starting factory Reader
Starting factory Writer
World server listening on: 10.1.170.92:9000
Starting static zones...
Connected to LoginServer: eq2emulator.net:9100
Sorry for my English? I'm from Russia :mrgreen:

Re: Error Loading Spells

Posted: Fri Mar 06, 2009 1:05 pm
by LethalEncounter
You are running mysql 5.1 or later. MySQL 5.0 is the recommended version.

Re: Error Loading Spells

Posted: Fri Mar 06, 2009 1:38 pm
by John Adams
We have discussed this many times, please use Search to find some of your error keywords.