Page 1 of 1

DB updating error

Posted: Tue Jan 08, 2008 10:14 am
by algon
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

Posted: Tue Jan 08, 2008 3:38 pm
by LethalEncounter
Grab the latest from the link below and try again:
http://eq2emulator.svn.sourceforge.net/ ... /World.exe