Error Loading Spells

General support forum. If you require assistance and your problem doesnt fall in any of the other categories, this is the forum for you!

Moderator: Team Members

Forum rules
READ THE FORUM STICKY THREADS BEFORE ASKING FOR HELP!
Most information can be found there, and if not, the posts will help you determine the information required to get assistance from the development team.
Incomplete Help Requests will be locked or deleted.
Locked
KiriX
Posts: 1
Joined: Fri Mar 06, 2009 10:55 am

Error Loading Spells

Post by KiriX » Fri Mar 06, 2009 11:18 am

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:

LethalEncounter
Team: Zombie
Posts: 2717
Joined: Wed Jul 25, 2007 10:10 pm

Re: Error Loading Spells

Post by LethalEncounter » Fri Mar 06, 2009 1:05 pm

You are running mysql 5.1 or later. MySQL 5.0 is the recommended version.

User avatar
John Adams
Retired
Posts: 9684
Joined: Thu Jul 26, 2007 6:27 am
EQ2Emu Server: EQ2Emulator Test Center
Characters: John
Location: Arizona
Contact:

Re: Error Loading Spells

Post by John Adams » Fri Mar 06, 2009 1:38 pm

We have discussed this many times, please use Search to find some of your error keywords.

Locked

Who is online

Users browsing this forum: No registered users and 0 guests