• Error Updating Spells Table

Posted: **Sun Dec 14, 2008 8:17 pm**

Thanks for your patience with my download limit!
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.

This is the query it is trying to execute:

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)

Posted: **Sun Dec 14, 2008 8:29 pm**

What version of mysql are you using? and are you using the svn compile of the emu or the binary?
a copy of both databases can be found here
http://www.eq2emulator.net/forums/viewt ... ight=#8322
use the one i posted if you are compiling your own from source and make sure your world_db.ini port is set to 9102
if you are using the binary use the one JA posted and use port 9101

Posted: **Sun Dec 14, 2008 9:08 pm**

Bion wrote:What version of mysql are you using? and are you using the svn compile of the emu or the binary?
a copy of both databases can be found here
http://www.eq2emulator.net/forums/viewt ... ight=#8322
use the one i posted if you are compiling your own from source and make sure your world_db.ini port is set to 9102
if you are using the binary use the one JA posted and use port 9101

I am using MySQL 5.1 under Vista 32-bit, with the SourceForge EMU.
Thanks for the links, I'll give that a try!

Posted: **Sun Dec 14, 2008 9:14 pm**

Ok sounds good lets us know if that solves it for ya

Posted: **Tue Dec 16, 2008 9:13 am**

Bion wrote:Ok sounds good lets us know if that solves it for ya

I finally got the database copied over, and am receiving a different SQL error:

[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, r
adius, max_aoe_targets, req_concentration, range, duration1, duration2, resistib
ility, hp_upkeep, power_upkeep, duration_until_cancel, target_type, recovery, le
vel, power_req_percent, hp_req_percent, icon, icon2, icontype, success_message,
fade_message, cast_type, lua_script, call_frequency, interruptable, spell_visual
, effect_message from spells, Error: #1064: You have an error in your SQL syntax
; check the manual that corresponds to your MySQL server version for the right s
yntax to use near 'range, duration1, duration2, resistibility, hp_upkeep, power_
upkeep, duration_un' at line 1

Is this something server-side?
I have 2 spells in my spells table.
Here is the SQL dump from my spells table, in case it helps?

CREATE TABLE /*!32312 IF NOT EXISTS*/ "spells" (
"id" int(10) unsigned NOT NULL AUTO_INCREMENT,
"version" mediumint(8) unsigned NOT NULL DEFAULT '0',
"sub_version" mediumint(8) unsigned NOT NULL DEFAULT '0',
"type" mediumint(8) unsigned NOT NULL DEFAULT '0',
"cast_type" tinyint(3) unsigned NOT NULL DEFAULT '0',
"name" varchar(250) NOT NULL DEFAULT 'NoName',
"description" text NOT NULL,
"icon" mediumint(8) unsigned NOT NULL DEFAULT '0',
"icon2" mediumint(8) unsigned NOT NULL DEFAULT '0',
"icontype" mediumint(8) unsigned NOT NULL DEFAULT '0',
"class_skill" int(10) unsigned NOT NULL DEFAULT '0',
"mastery_skill" int(10) unsigned NOT NULL DEFAULT '0',
"tier" tinyint(3) unsigned NOT NULL DEFAULT '1',
"hp_req" mediumint(8) unsigned NOT NULL DEFAULT '0',
"hp_upkeep" mediumint(8) unsigned NOT NULL DEFAULT '0',
"power_req" mediumint(8) unsigned NOT NULL DEFAULT '0',
"power_upkeep" mediumint(8) unsigned NOT NULL DEFAULT '0',
"cast_time" mediumint(8) unsigned NOT NULL DEFAULT '100',
"recast" float unsigned NOT NULL DEFAULT '1',
"radius" float unsigned NOT NULL DEFAULT '0',
"max_aoe_targets" mediumint(8) unsigned NOT NULL DEFAULT '0',
"req_concentration" mediumint(8) unsigned NOT NULL DEFAULT '0',
"range" float unsigned NOT NULL DEFAULT '0',
"duration1" int(10) unsigned NOT NULL DEFAULT '0',
"duration2" int(10) unsigned NOT NULL DEFAULT '0',
"duration_until_cancel" tinyint(3) unsigned NOT NULL DEFAULT '0',
"call_frequency" int(10) unsigned NOT NULL DEFAULT '0',
"resistibility" float unsigned NOT NULL DEFAULT '0',
"target_type" tinyint(3) unsigned NOT NULL DEFAULT '0',
"recovery" smallint(5) unsigned NOT NULL DEFAULT '0',
"level" tinyint(3) unsigned NOT NULL DEFAULT '0',
"power_req_percent" tinyint(3) unsigned NOT NULL DEFAULT '0',
"hp_req_percent" tinyint(3) unsigned NOT NULL DEFAULT '0',
"success_message" varchar(255) DEFAULT NULL,
"fade_message" varchar(255) DEFAULT NULL,
"interruptable" tinyint(3) unsigned NOT NULL DEFAULT '1',
"lua_script" varchar(64) DEFAULT NULL,
"spell_visual" int(10) unsigned NOT NULL DEFAULT '0',
"effect_message" varchar(255) DEFAULT NULL,
"spell_book_type" int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY ("id")
) AUTO_INCREMENT=3 /*!40100 DEFAULT CHARSET=latin1*/;
#
# Dumping data for table 'spells'
#
LOCK TABLES "spells" WRITE;
/*!40000 ALTER TABLE "spells" DISABLE KEYS;*/
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", "recovery", "level", "power_req_percent", "hp_req_percent", "success_message", "fade_message", "interruptable", "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", "recovery", "level", "power_req_percent", "hp_req_percent", "success_message", "fade_message", "interruptable", "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,65535,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 sprint.','You are no longer sprinting.',0,'Sprint.lua','0','%t begins to sprint.','256');
/*!40000 ALTER TABLE "spells" ENABLE KEYS;*/
UNLOCK TABLES;

Posted: **Tue Dec 16, 2008 1:35 pm**

I am sorry i can not recreate this issue you are having here. everything tests out fine
by looking at your database and output you are using the 0.6 server off of the homepage correct?
you will need to use the 0.6 database as posted by JA Here
when you do this drop the database you are using now create a empty database named the same as you called it in your world_db.ini use this command replace with your details

Code: Select all

mysql -u username -ppassword database_name < eq2emulator.sql

that should load ya up a fresh copy of the 0.6 database.

Posted: **Tue Dec 16, 2008 3:46 pm**

Bion wrote:when you do this drop the database you are using now create a empty database named the same as you called it in your world_db.ini use this command replace with your details
Code: Select all
mysql -u username -ppassword database_name < eq2emulator.sql
that should load ya up a fresh copy of the 0.6 database.

Followed your steps, thanks! It still gives the error message, even when using mysql to load in the database (I was using that heidisql program).
I will try and re-download the files from SourceForge to see what's up.
I'm not sure it's related, but I was able to create a character on my server and log in, but when I tried to zone to Qeynos (/zone qey_north), it tried to load something and crashed with a reference to E:\live\(something).