I am receiving an error message when trying to update my Spells table, error below. Any ideas?
Code: Select all
[Error] Error in updating tables query 'replace into spells (id,version,sub_vers
ion,type,cast_type,name,description,icon,icon2,icontype,class_skill,mastery_skil
l,tier,hp_req,hp_upkeep,power_req,power_upkeep,cast_time,recast,radius,max_aoe_t
argets,req_concentration,range,duration1,duration2,duration_until_cancel,call_fr
equency,resistibility,target_type,recovery,level,power_req_percent,hp_req_percen
t,success_message,fade_message,interruptable,lua_script,spell_visual,effect_mess
age,spell_book_type) values(2,23,10,0,0,'Lightning Burst','Deals instant heat d
amage to the targeted enemy.',161,25,315,0,0,1,0,0,3,0,200,3,0,0,0,35,0,0,0,0,0.
748,1,50,1,0,0,'You utter a fiery arcane spell.','',1,'Damage',18,'%t is blasted
by a fiery burst!',256)': #1064: You have an error in your SQL syntax; check th
e manual that corresponds to your MySQL server version for the right syntax to u
se near 'range,duration1,duration2,duration_until_cancel,call_frequency,resistib
ility,tar' at line 1
[Error] Attempting to update database table 'spells' data ... FAILED!
[Status] Update complete.
Code: Select all
[Status] Using database 'eq2' at localhost
[Status] CURRENT_WORLD_VERSION:EQ2EMu 0.6.0 Developer Alpha
[Status] ./LoginServer.ini read.
[Status] Connecting to Update Server..
[Status] Connected to Update Server: eq2emulator.net:9101
[Status] Checking for updates.
[Status] Found Updates.
[Status] Processing Updates.
[Error] The following queries will be inserted into your database to bring it up
to date:
replace into spells (id,version,sub_version,type,cast_type,name,description,icon
,icon2,icontype,class_skill,mastery_skill,tier,hp_req,hp_upkeep,power_req,power_
upkeep,cast_time,recast,radius,max_aoe_targets,req_concentration,range,duration1
,duration2,duration_until_cancel,call_frequency,resistibility,target_type,recove
ry,level,power_req_percent,hp_req_percent,success_message,fade_message,interrupt
able,lua_script,spell_visual,effect_message,spell_book_type) values(2,23,10,0,0
,'Lightning Burst','Deals instant heat damage to the targeted enemy.',161,25,315
,0,0,1,0,0,3,0,200,3,0,0,0,35,0,0,0,0,0.748,1,50,1,0,0,'You utter a fiery arcane
spell.','',1,'Damage',18,'%t is blasted by a fiery burst!',256)
replace into spells (id,version,sub_version,type,cast_type,name,description,icon
,icon2,icontype,class_skill,mastery_skill,tier,hp_req,hp_upkeep,power_req,power_
upkeep,cast_time,recast,radius,max_aoe_targets,req_concentration,range,duration1
,duration2,duration_until_cancel,call_frequency,resistibility,target_type,recove
ry,level,power_req_percent,hp_req_percent,success_message,fade_message,interrupt
able,lua_script,spell_visual,effect_message,spell_book_type) values(1,23,10,2,1
,'Sprint','This ability allows your character to run at an increased rate for a
short period of time at the cost of Power. (Can be used while in combat)',303,65
535,317,0,0,1,0,0,0,0,0,5,0,0,0,2,600,600,0,30,0,0,50,0,10,0,'You begin to sprin
t.','You are no longer sprinting.',0,'Sprint.lua',0,'%t begins to sprint.',256)