DB updating error

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.
Post Reply
algon
Posts: 1
Joined: Tue Jan 08, 2008 1:41 am

DB updating error

Post by algon » Tue Jan 08, 2008 10:14 am

Hello,I'm using EQ2Emulator0.4.0 to update
MySql(Ver 5.1.22),after it updated some tables,
I got the error message as below,am I done something wrong ?
[Status] Loaded 0 Armor Pieces
[Status] Loaded 5590 Regular Items
[Status] Loading spells..
Error Loading Spells, Query: select id, name, description, version, sub_version
type, class_skill, mastery_skill, tier, hp_req, power_req, cast_time, recast,
adius, max_aoe_targets, req_concentration, range, duration1, duration2, resisti
ility, hp_upkeep, power_upkeep, duration_until_cancel, target_type, recovery, l
vel, power_req_percent, hp_req_percent, icon, icon2, icontype, success_message,
fade_message, cast_type from spells, Error: #1064: You have an error in your SQ
syntax; check the manual that corresponds to your MySQL server version for the
right syntax to use near 'range, duration1, duration2, resistibility, hp_upkeep
power_upkeep, duration_un' at line 1
[Status] Loading factions..
[Status] Loaded 36 Factions
[Status] ./LoginServer.ini read.
[Status] Loading EQ time of day..
Please stand behind the yellow line before I start chopping off heads.
Starting factory Reader
Starting factory Writer
World server listening on: localhost:9000
Connected to LoginServer: eq2emulator.net:9100
[Error] Error in updating tables query '': Got signal 11

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

Post by LethalEncounter » Tue Jan 08, 2008 3:38 pm

Grab the latest from the link below and try again:
http://eq2emulator.svn.sourceforge.net/ ... /World.exe

Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests