Error creating character
 

After a long time of being away and finally getting VS2010 to compile the x64 version I tried to fire up the client (SoD)

I did a clean db install rev 2092 (then player, then bots)

A clean pull of the source rev 2097.

Using login server from GoogleCode

Copied over the new .conf files from utils
Fired up the client and went to create a character. After submitting the character I immediately get a "You have been disconnected" message and back to the login screen.

This is from the log

Doing a litle digging in the zone tables

start_zone for the above combo is 75, which (if i'm reading the db correctly and looking at 'zoneidnumber') is paineel, which should be correct.

zoneidnumber 10 = freporte

The same thing happens when creating any character.

Start Zone is always '10' per the logs.

any suggestions?

Same problem in Underfoot as well.

I found a backup of a junk character that i had a while back and source the 'character_' table only and was able to log in, and everything seems to work (zoning, combat, quests/task)

Can you post your world start up log real quick?

Here's the rest of the debug world (ends where my OP begins)


login

Here's a fresh log from world and login, trying to create a character. i trimmed out the opcode dump. everything else is there.

World

login

your eqhost.txt should be using 5999 not 5998 for Sod might need to go over your server ports and double check them, your zone ports should be 9000 req by server under mysql peq database goto zone_server change port to 9000
make sure your login opcodes read
patch_sod.conf,patch_underfoot.conf,patch_hot.conf ,opcodes.conf,login_opcodes_sod.conf read
#Login opcodes
OP_SessionReady=0x0001
OP_Login=0x0002
OP_ServerListRequest=0x0004
OP_PlayEverquestRequest=0x000d
OP_PlayEverquestResponse=0x0022
OP_ChatMessage=0x0017
OP_LoginAccepted=0x0018
OP_ServerListResponse=0x0019
OP_Poll=0x0029
OP_EnterChat=0x000f
OP_PollResponse=0x0011
make sure your Login opcodes read
for all others patch_Titanium.conf,patch_6.2.conf,patch_SoF.conf, login_opcodes.conf
#Login opcodes
OP_SessionReady=0x0001
OP_Login=0x0002
OP_ServerListRequest=0x0004
OP_PlayEverquestRequest=0x000d
OP_PlayEverquestResponse=0x0021
OP_ChatMessage=0x0016
OP_LoginAccepted=0x0017
OP_ServerListResponse=0x0018
OP_Poll=0x0029
OP_EnterChat=0x000f
OP_PollResponse=0x0011
note: opcodes.conf depends on the client you want to run so it may very for your client setup use settings login ports listed above for Sod Client.

EqHosts is set correctly, 5999 for both SoD and UF clients.

From what I can see the login server listens by default on BOTH 5998 and 5999, and detects what client is connecting and pulls the opcodes from the corresponding file set in login.ini, so i doubt it's that, especially because I CAN login with multiple clients if there's a character already in the db.

No trouble zoning once logged in either, my zone_server table is empty - never had to fill that in before, will take a look.

All .conf files are present and accounted for.


Only problem is character creation.

my login.ini

I"m sorry i have the same problem using EQEmuLoginServer but if you use your eqemulator Ls account goto the website and can login to your server it'll create an acount for you first then go back to EQEmuLoginServer minilogin and you'll have an account to login with .I use minilogin.exe goto mysql peq goto accouout type in user name and password ip address done.

I don't know why you would be getting set to zone 10 for an Erudite character. Have you tried any other class/race combos? Maybe try one that actually can start in FP East (maybe Human Warror?).

Also, you may want to check some of your rule and variable settings such as:

rule_values table:
World:EnableTutorialButton
World:TutorialZoneID
World:SoFStartZoneID

variables table:
startzone

You should also probably check to make sure you have the following SQL on your server:

http://code.google.com/p/projecteqem...svn2024&r=2024

Yep - the last world log i posted here was an Iksar SK, same result - start zone 10. Also Barb / War is 10.

I'll try the hum / necro - and yep, that worked. sent me to E Freeport too.

I wonder if it has to do with World:SoFStartZoneID = -1. i'll try setting it to 189 and see what happens, nope same thing disconnects, sets to SZ = 10.

the thing that's driving me crazy is that this is all a clean and unmodified / unpatched install / build.


I sourced PEQ 2092 and made no modifications to it, so that sql should be there.

I didn't check if the data matched, but the fields are the same and there are 641 entries in my table and 641 entries in the sql for 'char_create_combination'

'char_create_point_allocations' fields match as well, and same # of entries (108)

'character_buffs' fields match, table is presently empty.

'inventory' and 'sharedbank' were modifed as well per the sql.

So as far as i can tell, that sql is all there.

Download from http://projecteqdb.googlecode.com/svn/trunk/peqdatabase

Here is how i loaded my server files

copy peqdb_2092.sql
copy player_tables directory
copy updates directory
copy load_player.sql
copy load_updates.sql The file you just made
copy load_updatesbots.sql The file you just made

Copy all Files and Folders too C:\MySQL\bin Directory

All updates without Bots

Make a File Called load_updates.sql
copy and paste into a file rename it too load_updates.sql save file.

source updates/Rev59.sql;
source updates/Rev82.sql;
source updates/Rev109.sql;
source updates/Rev125.sql;
source updates/Rev127.sql;
source updates/Rev129.sql;
source updates/Rev131.sql;
source updates/Rev166.sql;
source updates/Rev198.sql;
source updates/Rev200.sql;
source updates/Rev222.sql;
source updates/Rev227.sql;
source updates/Rev247.sql;
source updates/Rev249.sql;
source updates/Rev271.sql;
source updates/Rev274.sql;
source updates/Rev278.sql;
source updates/Rev288.sql;
source updates/Rev294.sql;
source updates/Rev326.sql;
source updates/Rev340.sql;
source updates/Rev360.sql;
source updates/Rev284.sql;
source updates/Rev438.sql;
source updates/Rev461.sql;
source updates/Rev507.sql;
source updates/Rev512.sql;
source updates/Rev535.sql;
source updates/Rev590.sql;
source updates/Rev610.sql;
source updates/Rev669.sql;
source updates/Rev703.sql;
source updates/Rev752.sql;
source updates/Rev781.sql;
source updates/Rev859.sql;
source updates/Rev922.sql;
source updates/Rev946.sql;
source updates/Rev974.sql;
source updates/Rev1008.sql;
source updates/Rev1038.sql;
source updates/Rev1052.sql;
source updates/Rev1265.sql;
source updates/Rev1395.sql;
source updates/Rev1496.sql;
source updates/Rev1535.sql;
source updates/Rev1589.sql;
source updates/Rev2021.sql;
source updates/Rev2083.sql;
source updates/Rev2092.sql;

All updates with Bots

Make a File Called load_updatesbots.sql
copy and paste into a file rename it too load_updatesbots.sql save file.

source updates/Rev59.sql;
source updates/Rev82.sql;
source updates/Rev109.sql;
source updates/Rev125.sql;
source updates/Rev127.sql;
source updates/Rev129.sql;
source updates/Rev131.sql;
source updates/Rev166.sql;
source updates/Rev198.sql;
source updates/Rev200.sql;
source updates/Rev222.sql;
source updates/Rev227.sql;
source updates/Rev247.sql;
source updates/Rev249.sql;
source updates/Rev266-Bots.sql;
source updates/Rev271.sql;
source updates/Rev274.sql;
source updates/Rev278.sql;
source updates/Rev288.sql;
source updates/Rev294.sql;
source updates/Rev326.sql;
source updates/Rev328-Bots.sql;
source updates/Rev340.sql;
source updates/Rev360.sql;
source updates/Rev284.sql;
source updates/Rev386-Bots.sql;
source updates/Rev438.sql;
source updates/Rev461.sql;
source updates/Rev507.sql;
source updates/Rev512.sql;
source updates/Rev535.sql;
source updates/Rev590.sql;
source updates/Rev610.sql;
source updates/Rev669.sql;
source updates/Rev703.sql;
source updates/Rev752.sql;
source updates/Rev781.sql;
source updates/Rev859.sql;
source updates/Rev922.sql;
source updates/Rev946.sql;
source updates/Rev946-Bots.sql;
source updates/Rev974.sql;
source updates/Rev974-Bots.sql;
source updates/Rev1008.sql;
source updates/Rev1038.sql;
source updates/Rev1038-Bots.sql;
source updates/Rev1052.sql;
source updates/Rev1054-Bots.sql;
source updates/Rev1265.sql;
source updates/Rev1265-Bots.sql;
source updates/Rev1395.sql;
source updates/Rev1496.sql;
source updates/Rev1535.sql;
source updates/Rev1589.sql;
source updates/Rev2021.sql;
source updates/Rev2022-Bots.sql;
source updates/Rev2083.sql;
source updates/Rev2087-Bots.sql;
source updates/Rev2092.sql;

15. NOW, you need to go in to a command prompt and navigate to the peqdb folder.
Simply type cd \peqdb and you should be there. You will see: C:\peqdb>_

REMEMBER THE PASSWORD YOU GAVE when you set up MySQL ? (You need it NOW)

***WARNING*** - at this point, make sure you are in the peqdb folder.
C:\MySQL\bin

Then type mysql -uroot -p
Hit enter and enter your password. (Hit enter again)
You should now see a prompt that looks like this: (along with "Welcome" text before it)
mysql>_

Type the following (in order):

use peq (Hit enter and you will see a short note saying "Database changed")

Then type the following:

source peqdb_rev2092.sql (when this is done, you will be back at the mysql>_ prompt)

Then type in the following:

source load_player.sql (this will load fast)

source only one of them below without bots or with bots.
source load_updates.sql (This will load fast)
source load_updatesbots.sql (This will load fast)
Done.

If you're sourcing a database from scratch, you do not need to source the updates, they are already in the player tables.

Also, you only need to source updates if you're upgrading an existing database. The db_version table of your database will tell you which revision you are currently at. You simply source all the updates from after that point. Unless your database is ancient and needs to be upgraded, there is no reason to source all the updates, and in fact I don't recommend doing so.

I'll give that a shot - not to be a tool and sound ungrateful for any help on this, but this isn't my first rodeo. I've been running/compiling the emu since 2004 ish.

The update sql's are already contained in the peqdb_2092.sql, so they aren't needed when doing a fresh install.

I'll try it anyhow and see what happens...


Didn't change anything - still get the disconnect attempting to set the start zone to 10 for any character, but CAN create a human necro that starts in E Freeport (or any char that starts in EFP)

One thing that I'm not sure if it means anything, after reading post #8 by Noport

I'm using the EQEmuLoginServer as well,

is that a possible problem? I haven't been able to compile the login server - i used to be able to. Still using a VS2008 for that, compiling Win32.

MySQL is 5.5.20 x64
Perl 5.14 x64
I'm getting 'pthread.h' errors - which i'm trying to track down. (From what I understand 'pthread.h' is for linux compiles - so what I'm deducing is that the _Windows is not getting defined somewhere...

Maybe your start_zones table is set to zone id 10 for all entries for some reason?

I am not sure why you would be having an issue that no one else is unless you did something different from everyone else.

You might try disabling the tutorial button in your rules and see if that makes any difference.