Page 1 of 1
EQ2World just opens and closes
Posted: Sun Sep 27, 2009 10:47 am
by Astal
It doesnt populate the database, what did i do wrong guys? I followed the guide and edited everything it said to, it was a little fuzzy on some areas.
Code: Select all
### --- This file tells world.exe what loginserver to connect to.
### --- Change the account and password fields to the information you used when you created your SERVER account.
### --- NOTE: the word "Server" is added to each server automaticly.
# READ README.TXT
[LoginServer]
loginserver=eq2emulator.net
loginport=9100
worldname=Arda - The Undying Lands
worldaddress=207.255.55.187
#internalworldaddress=localhost (If used, otherwise blank)
worldport=9000
locked=false
account=myaccount
password=mypassword
#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=updates.eq2emulator.net
updateserverport=9103
[LoginConfig]
ServerMode=StandAlone
ServerPort=9100
Code: Select all
# READ README.TXT!
[Database]
host=localhost
user=root
password=root
database=eq2
### --- This file tells world.exe what computer mySQL is on. Host should
### --- be left "localhost" unless mysql is on a differant computer than world.exe.
Re: EQ2World just opens and closes
Posted: Sun Sep 27, 2009 10:57 am
by John Adams
Open a "cmd" window (Start / Run / cmd), change to your eq2world directory and run it by hand "EQ2World.exe [enter]" so the command box does not close. You might see the error there, or check the Logs folder for any possible error logs.
Re: EQ2World just opens and closes
Posted: Sun Sep 27, 2009 11:31 am
by Astal
John Adams wrote:Open a "cmd" window (Start / Run / cmd), change to your eq2world directory and run it by hand "EQ2World.exe [enter]" so the command box does not close. You might see the error there, or check the Logs folder for any possible error logs.
thanks bro, it seems i had to move the exe to the config files folder, I couldnt run it from where tortoise places all the files originally
Re: EQ2World just opens and closes
Posted: Sun Sep 27, 2009 11:33 am
by John Adams
That is correct. SVN is not the proper folder structure
There is a release package on Sourceforge that should have everything where it belongs, and all you need to do is replace files from SVN after that.
And beware the bad Updates URL in loginserver.ini in the package. that's never been fixed.
Re: EQ2World just opens and closes
Posted: Sun Sep 27, 2009 11:39 am
by Astal
John Adams wrote:That is correct. SVN is not the proper folder structure
There is a release package on Sourceforge that should have everything where it belongs, and all you need to do is replace files from SVN after that.
And beware the bad Updates URL in loginserver.ini in the package. that's never been fixed.
Yeah i saw that in the guide. Hmm all is working just cant connect lol or isnt everything set up for you to connect right off the bat yet?
Re: EQ2World just opens and closes
Posted: Sun Sep 27, 2009 12:08 pm
by John Adams
Soon as you set your LoginServer.ini and world_db.ini properly, start the server, and it has NO errors starting, you should be gtg.
Don't forget opening the proper port (9000 by default, from LoginServer.ini) on your router. And point your client cl_ls_address to eq2emulator.net
Those are the most obvious points of failure.
Re: EQ2World just opens and closes
Posted: Sun Sep 27, 2009 2:37 pm
by Astal
John Adams wrote:Soon as you set your LoginServer.ini and world_db.ini properly, start the server, and it has NO errors starting, you should be gtg.
Don't forget opening the proper port (9000 by default, from LoginServer.ini) on your router. And point your client cl_ls_address to eq2emulator.net
Those are the most obvious points of failure.
Hey if its not to much trouble what all files do i need to source from the server pack to get the database items in my server? Just the 2 sql files or other things and if i do that will i need to re-updated from the svn?
Edit: Never mind i just exported it all from the 1.1 database deleted mine and im sourcing it in now. Thanks man
Edit: ok that didnt work, I couldnt create a character on my server when i did that. Anyone know how to source the files from the release pack in to your own server?
This is the error im getting
Code: Select all
[20090927 18:52:09] Error in SaveCharacter query 'Insert into characters (account_id, server_id, name, race, class, gender, deity, body_size, body_age, soga_wing_type, soga_chest_type, soga_legs_type, soga_hair_type, soga_model_type, legs_type, chest_type, wing_type, hair_type, model_type, facial_hair_type, soga_facial_hair_type, created_date, last_saved) values(3846, 1756, 'Astal', 15, 39, 1, 1, 0.300000, 0.000000, 0, 0, 0, 0, 5081, 5578, 5577, 0, 1140, 1451, 0, 0, now(), unix_timestamp())': #1452: Cannot add or update a child row: a foreign key constraint fails (`eq2/characters`, CONSTRAINT `FK_char_zone` FOREIGN KEY (`current_zone_id`) REFERENCES `zones` (`id`) ON UPDATE CASCADE)
[20090927 18:52:56] Error in GetCharacterName query 'SELECT name from characters where id=0':