EQ2World just opens and closes

[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.

[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.

[Astal]

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

[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.

[Astal]

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?

[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.

[Astal]

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':