http://oldforums.eq2classic.com/

SQL and char creation issues/problems

http://oldforums.eq2classic.com/viewtopic.php?t=1263

Page 2 of 3

Re: SQL and char creation issues/problems

Posted: Tue Jan 20, 2009 3:46 pm
by Zcoretri
World server listening on: 98.166.58.168:9000
Starting static zones...
Connected to LoginServer: eq2emulator.net:9100
Delete char request: 3877 88
Name check on: Caal
Resp: 1
AddAuth: 3877 Key: 1232490578
Got signal 2
You trying to connect to your EQ2 server with a client on the same machine or internal network?
I think the problem is you need to add your internal network IP to loginserver.ini like so...

Code: Select all

### --- This file tells world.exe what loginserver to connect to.
### --- Leave the account and password field BLANK.

### --- NOTE: the word "Server" is added to each server automaticly.

# READ README.TXT

[LoginServer]
loginserver=eq2emulator.net
loginport=9100
worldname=
worldaddress= <external IP address here>
internalworldaddress= i.e. 192.168.0.114
worldport=9000
locked=false ...

Re: SQL and char creation issues/problems

Posted: Tue Jan 20, 2009 3:58 pm
by aeco
Wow, had a feeling it would be something simple and low and behold. the internal address resolved the entering world issue. thank you very much for the help with that.

thank you to who ever reset my patch downloads as well. im still getting the error from the SQL though

Code: Select all

[Error] Error in updating tables query 'replace into spell_tiers (id,spell_id,tier,hp_req,hp_req_percent,hp_upkeep,power_req,power_req_percent,power_upkeep,req_concentration,cast_time,recovery,recast,radius,max_aoe_targets,min_range,range,duration1,duration2,resistibility,hit_bonus,call_frequency)  values(2,1,1,0,0,0,0,10,0,0,0,50,5,0,0,0,2,600,600,0,0,30)': #1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'range,duration1,duration2,resistibility,hit_bonus,call_frequency)  values(2,1,1,' at line 1
[Error] 	Attempting to update database table 'spell_tiers' data ... FAILED!
oh and

Code: Select all

[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, radius, max_aoe_targets, req_concentration, range, duration1, duration2, resistibility, hp_upkeep, power_upkeep, duration_until_cancel, target_type, recovery, level, 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 syntax to use near 'range, duration1, duration2, resistibility, hp_upkeep, power_upkeep, duration_un' at line 1

Re: SQL and char creation issues/problems

Posted: Tue Jan 20, 2009 4:00 pm
by John Adams
Now that you have things working, and LE likely reset your downloads, empty your database one last time and restart EQ2World.exe twice, and you should not get anymore errors (as long as you are using the SVN exe, xml, and port 9102 for DB updates).

Re: SQL and char creation issues/problems

Posted: Tue Jan 20, 2009 4:28 pm
by aeco
So i dumped my Data base, started the server noticed it had failed on something was going to wait for it to fish to note everything that had gone wrong if there was anything else. but it quit out before i had a chance to note it. started it a second time it went threw looked like it had an issue with something but it quit out again on me. the third time i started in from the command prompt so if it quit i could maybee see the reason why. however it looks like it does not have an issue now. but i am still having the SQL issues at the same points.

Re: SQL and char creation issues/problems

Posted: Tue Jan 20, 2009 4:30 pm
by John Adams
Well from what I read in your postings, you still have not changed your update port to 9102. It is still showing 9101, so that is probably your entire problem.

My LoginServer.ini example:

Code: Select all

[LoginServer]
loginserver=eq2emulator.net
loginport=9100
worldname=myworldname
worldaddress=mypublicIP
internalworldaddress=mylocalIP
worldport=9200
locked=false
account=
password=
autotableupdates=always
autotableverbose=true
autotabledata=true

[WorldServer]
Defaultstatus=
Unavailzone=

[UpdateServer]
updateserveraddress=updates.eq2emulator.net
updateserverport=9102

[LoginConfig]
ServerMode=StandAlone
ServerPort=9100
Make sure your information is in the following values:

worldname=
worldaddress=
internalworldaddress=

account=
password=

And

[UpdateServer]
updateserveraddress=updates.eq2emulator.net
updateserverport=9102 ;)

Re: SQL and char creation issues/problems

Posted: Tue Jan 20, 2009 4:35 pm
by John Adams
edited the above with an example

Re: SQL and char creation issues/problems

Posted: Tue Jan 20, 2009 4:40 pm
by aeco
sorry thought i had mentioned that when someone made mention of that earlier.

-so far this is what my Loginserver.ini looks like

Code: Select all

[LoginServer]
loginserver=eq2emulator.net
loginport=9100
worldname=Kamikaze
worldaddress=98.166.58.168
#internalworldaddress=192.168.1.103
worldport=9000
locked=false
account=*******
password=********
#autotableupdates retrieves the latest table updates and applies them to your database
#autotableupdates valid options=always, ask, and never
autotableupdates=always
#autotableverbose displays detailed information about the updates; options=true or false
autotableverbose=false
#autotabledata retrieves the latest data for tables like the opcodes table; options=true or false
autotabledata=true

[WorldServer]
Defaultstatus=
Unavailzone=

[UpdateServer]
updateserveraddress=eq2emulator.net
updateserverport=9102

[LoginConfig]
ServerMode=StandAlone
ServerPort=9100
- my world_db.ini

Code: Select all

[Database]
host=127.0.0.1
user=root
password=*******
database=eq2b
I have dropped all previous Databases and started Fresh after LE reset the downloads for me (Again thank you).
prior to that i downloaded the information from the SVN the XML structs and the game server. that seems to working just fine.

so to answer the previous post my port has been set to 9102 for a little time now. should i try the 9101 port instead? or is the 9102 the preferred port? thank you to all that have help so far it is much appreciated.

Re: SQL and char creation issues/problems

Posted: Tue Jan 20, 2009 4:53 pm
by aeco
i saw a diffrence between yours and mine loginserver.ini files the ports where the same. but the address was diffrent instead of using updates.eq2emulator.net i was using eq2emulator.net but that had no effect. same results, should i dump the table and start fresh using that address or is the address the same in either direction?

Re: SQL and char creation issues/problems

Posted: Tue Jan 20, 2009 5:13 pm
by Zcoretri
aeco wrote:i saw a diffrence between yours and mine loginserver.ini files the ports where the same. but the address was diffrent instead of using updates.eq2emulator.net i was using eq2emulator.net but that had no effect. same results, should i dump the table and start fresh using that address or is the address the same in either direction?
You need to use updates.eq2emulator.net

Not sure why you were getting stuff at the other URL, but that's probably why you may be having trouble.

Re: SQL and char creation issues/problems

Posted: Tue Jan 20, 2009 5:15 pm
by aeco
Well i changed it. dropped the old DB and ran using updates.eq2emulator.net on port 9102 .. still having the same issues with the SQL i can however login and look around though.

Re: SQL and char creation issues/problems

Posted: Tue Jan 20, 2009 5:20 pm
by Zcoretri
Try this...drop and start a new DB.
Change the update port to 9101.
Start your EQ2World.exe and let it update...you probably will see some errors, let it finish then exit out.
Change the update port to 9102.
Start your EQ2World.exe and let it update, let it finish then exit.
Start your EQ2World.exe once again, and it should have all the updates.

Good luck

Re: SQL and char creation issues/problems

Posted: Tue Jan 20, 2009 5:38 pm
by aeco
ok tried what Zcoretri just suggested, ended up with the same results though. maybe its me at this point? again i really appreciate all the help and suggestions from every one. if there is any information that i have not revealed or have not made mention of to this point please feel free to ask for it.

Re: SQL and char creation issues/problems

Posted: Tue Jan 20, 2009 5:55 pm
by John Adams
I will drop my test server DB and try a fresh update, just in case there is something wrong with the updater. I just did this last week tho, so I doubt it.

Re: SQL and char creation issues/problems

Posted: Tue Jan 20, 2009 5:59 pm
by aeco
John Adams wrote:I will drop my test server DB and try a fresh update, just in case there is something wrong with the updater. I just did this last week tho, so I doubt it.
i dont think that its something on the update servers end i think its something on my end. i cant see why there would be several servers up and running with no issues if the update server had a problem. maybe my SQL server is too new? let me try another version of it and see what happens. thank you very much John for doing that though its really appreciated.

Re: SQL and char creation issues/problems

Posted: Tue Jan 20, 2009 6:00 pm
by Bion
The spell_tiers table

Code: Select all

CREATE TABLE `spell_tiers` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `spell_id` int(10) unsigned NOT NULL default '0',
  `tier` tinyint(3) unsigned NOT NULL default '0',
  `hp_req` mediumint(8) unsigned NOT NULL default '0',
  `hp_req_percent` tinyint(3) unsigned NOT NULL default '0',
  `hp_upkeep` mediumint(8) unsigned NOT NULL default '0',
  `power_req` mediumint(8) unsigned NOT NULL default '0',
  `power_req_percent` tinyint(3) unsigned NOT NULL default '0',
  `power_upkeep` mediumint(8) unsigned NOT NULL default '0',
  `req_concentration` mediumint(8) unsigned NOT NULL default '0',
  `cast_time` mediumint(8) unsigned NOT NULL default '100',
  `recovery` float NOT NULL default '0',
  `recast` float unsigned NOT NULL default '1',
  `radius` float unsigned NOT NULL default '0',
  `max_aoe_targets` mediumint(8) unsigned NOT NULL default '0',
  `min_range` float 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',
  `resistibility` float unsigned NOT NULL default '0',
  `hit_bonus` float NOT NULL default '0',
  `call_frequency` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `SpellTierIDX` (`spell_id`,`tier`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8
The 2 spells data

Code: Select all

REPLACE INTO `spell_tiers` (`id`, `spell_id`, `tier`, `hp_req`, `hp_req_percent`, `hp_upkeep`, `power_req`, `power_req_percent`, `power_upkeep`, `req_concentration`, `cast_time`, `recovery`, `recast`, `radius`, `max_aoe_targets`, `min_range`, `range`, `duration1`, `duration2`, `resistibility`, `hit_bonus`, `call_frequency`) VALUES
	('1','2',1,0,0,0,3,0,0,0,200,'50','3','0',0,'0','35','0','0','0.748','0','0'),
	('2','1',1,0,0,0,0,10,0,0,0,'50','5','0',0,'0','2','600','600','0','0','30');
if you use something like hedisql click your eq2database drop just the spell_tiers table then click query

copy and paste the create table first then run it after that
clear it and run the replace into.
All times are UTC-07:00
Page 2 of 3

Powered by phpBB® Forum Software © phpBB Limited