It's EoF. I've gotten 1 from ebay and 2 from Amazon so far. I've been purchasing them because when we played, all of our expansions were purchased online.

I got a TSO box set before and it was too new. I got some error "bad version" 994 and the build was 5848. There really seems like there should be an easier way to do this other than purchasing my 3rd box set now... o.O lol

Well you seemed to have had some bad luck, because you are the first one I know of that got a TSO boxed set and could not connect

Oh man... I imagine you facepalm'd yourself reading that the box you just bought is still not right

But I will point out it should be very clear what packages we support here, and TSO+ is really the only one now. ROK still works, but there are some issues that would need to be fixed, and since that box set is 2+ years old now, it really doesn't make sense to focus dev efforts to keep that one compatible.

I'm sorry for your troubles, and frustrations. I assure you, with the supported client, this thing does work

Here's a thought, load up your TSO set and use the 3rd party client patcher to go back 1 version. I haven't used the tool in a while myself, so I am not sure what versions are listed - but whatever version you have, usually 1 back might make it compatible again.

Technically, the TSO box set I was talking about says The Complete Collection but includes TSO. So, I'll try what you suggested John, but if that doesn't work, if I get the TSO box set dated November 2008, that should work, right?

Also, just so that I can make sure I'm doing this correctly. I start MySQL+Apache, LoginServer and WorldServer. Then I'm good to connect with the EverQuest2.exe app, right? I'm not missing any steps? I'm following the guide that John put together.

Thanks again.

Yep, that should do the trick. I do hope the TSO package you have will work though. If not, I might need to send you a tool to determine your data version. Maybe all we need to do is expand one of our old opcode ranges to allow your client access.

nlmiller1975 wrote:Technically, the TSO box set I was talking about says The Complete Collection but includes TSO.

Yeah, that is not the 'TSO Boxed Set' we were talking about, so that's why it doesn't work

So, I'll try what you suggested John, but if that doesn't work, if I get the TSO box set dated November 2008, that should work, right?

That should work straight away out the box

I tried the third party patcher and I didn't make any progress with getting The Complete Collection to work. I have ordered RoK as well as TSO and hopefully one will work. I really hope to get this fixed so that I can send it to my hubby before his deployment is over.

I'll post again once I get one or the other of those, so please heads up for more posts!

Alrighty, so I got RoK and TSO, installed them and semi-created a character. It said "Zone rejected entry request because it failed to fetch character from DB."

Any ideas?

Thank you!

Hmm.. interesting sidenote. I was able to log in with the premade char, Admin, but the character I made -- an Arasai starting in Neriak -- I couldn't get to log in. A woodelf didn't work either. Also, in case it's needed, the build is 5040.

That is very positive progress! Considering your nightmare thusfar anyway. 5040 should be good to go. You might try deleting the ServerPack and re-installing it fresh. Sounds like there might have been some confusion created in the tables between all your other attempts.

What the error means is that LoginServer knows about your character by char_id (in the eq2ls database), but when it went to your server characters table (eq2world.characters), it could not find a match.

Re-install the ServerPack, see if that clears things up. I for one am overjoyed to hear you got into EQ2Emu >at all< after all this time

Hey there. Oh I was ecstatic when I got farther than I had before. But when I got the error, my heart sank. =(

I reinstalled the serverpack and got the same error. Please don't give up on helping me. I really want to get this thing to work for hubby...

The errors in the World Version file thing are:

Error in SaveCharacter query 'Insert [... yada yada yada]'
Error in GetCharacterName query 'SELECT name from characters where id=0':

Not sure if that would help or not

Actually, if you could copy/paste the entire console window, it might be more helpful. Sounds like maybe there is an insert error on the World side - which makes no sense, since many others (including our devs) use that ServerPack.

You said the pre-installed Admin/Admin works fine tho?

Yes, I can log in with Admin. Here's what it says when I log in with him:

[20100312 10:57:33] [Status] AddAuth: 1 Key: 1268420253
[20100312 10:57:34] [Status] New client from ip: 127.0.0.1 port: 55898
[20100312 10:57:34] [Status] Adding new client...
[20100312 10:57:34] [Debug] Creating OP_AppCombined Packet!
[20100312 10:57:34] [Debug] Combined App Packet!
[20100312 10:57:34] [Debug] Combined Packet: 2, 0!
[20100312 10:57:34] [Status] ZoneAuth: Access Key: 1268420253, Character Name: A
dmin, Account ID: 1
[20100312 10:57:34] [Status] Loading new Zone 'QueensColony'
[20100312 10:57:35] [Status] Loaded for zone 'QueensColony':
10 NPC(s), 1 Object(s), 0 Widget(s)
1 Sign(s), 1 Ground Spawn(s), 3 Spawn Group(s)
1 Spawn Group Association(s), 3 Spawn Group Chance(s)
[20100312 10:57:35] [Debug] Combined Packet: 2, 0!
[20100312 10:57:35] [Status] OP_Unknown Received 0x0038
0: 01 00 00 00 C8 43 | .....C
[20100312 10:57:58] [Debug] Combined Packet: 2, 0!
[20100312 10:58:03] [Status] OP_Unknown Received 0x0178
0: 00 00 | ..
0: B2 01 00 00 | ....
[20100312 10:58:03] [Status] Unhandled command: clearallqueuedabilities
0: 25 00 01 00 30 | %...0
0: 23 00 01 00 31 | #...1

Here's what it says when I attempt to log in with a created character:

***** EQ2Emulator Server Pack *****
***** by John Adams *****
***** WorldServer Starting *****
Starting EQ2 World Server . . .
[Status] Using database 'eq2world' at localhost
[20100312 11:05:49] [Status] CURRENT_WORLD_VERSION:EQ2EMu 0.6.5 Developer Alpha
[20100312 11:05:49] [Status] ./LoginServer.ini read.
[20100312 11:05:49] [Status] Loading opcodes..
[20100312 11:05:49] [Status] Loading structs..
[20100312 11:05:51] [Status] Loading command list..
[20100312 11:05:51] [Status] Clearing player online flags..
[20100312 11:05:51] [Status] Loaded 5 entity command lists.
[20100312 11:05:51] [Status] Loaded 11 NPC(s).
[20100312 11:05:51] [Status] Loaded 1 Object(s).
[20100312 11:05:51] [Status] Loaded 1 GroundSpawn(s).
[20100312 11:05:51] [Status] Loaded 1 Widget(s).
[20100312 11:05:51] [Status] Loaded 1 Sign(s).
[20100312 11:05:51] [Status] Loading ground spawn items..
[20100312 11:05:51] [Status] Loading loot data..
[20100312 11:05:51] [Status] Loaded 1 loot tables.
[20100312 11:05:51] [Status] Loaded 1 loot drops.
[20100312 11:05:51] [Status] Loaded 1 spawn loot lists.
[20100312 11:05:51] [Status] Loading Transporter Information..
[20100312 11:05:51] [Status] Loaded 0 Teleporter(s)
[20100312 11:05:51] [Status] Loaded global variables list..
[20100312 11:05:51] [Status] Loaded visual states list..
[20100312 11:05:51] [Status] Loading World Time..
[20100312 11:05:51] [Status] Loading items.. (this might take a few minutes)
[20100312 11:05:51] [Status] Loaded 1 Bag(s)
[20100312 11:05:51] [Status] Loaded 0 Food(s)
[20100312 11:05:51] [Status] Loaded 0 Weapon(s)
[20100312 11:05:51] [Status] Loaded 0 Armor/Shield Piece(s)
[20100312 11:05:51] [Status] Loaded 0 Skill Item(s)
[20100312 11:05:51] [Status] Loaded 1 Regular Items
[20100312 11:05:51] [Status] Loading spells..
[20100312 11:05:51] [Status] Loaded 4 Spell(s)
[20100312 11:05:51] [Status] Loading LUA spells..
[20100312 11:05:51] [Status] Loaded 4 LUA Spell(s)
[20100312 11:05:51] [Status] Loading factions..
[20100312 11:05:51] [Status] Loaded 202 Factions
[20100312 11:05:51] [Status] Loading skills..
[20100312 11:05:51] [Status] Loaded 129 Skills
[20100312 11:05:51] [Status] Loading Quests..
[20100312 11:05:51] [Status] Loaded 1 Quest(s)
[20100312 11:05:51] [Status] Loading Merchant Information..
[20100312 11:05:51] [Status] Loaded 2 Merchant Inventory Item(s)
[20100312 11:05:51] [Status] Loaded 1 Merchant List(s)
[20100312 11:05:51] [Status] Loading Spawn Script Information..
[20100312 11:05:51] [Status] Loading Zone Script Information..
[20100312 11:05:51] [Status] Loading EQ time of day..
Starting factory Reader
Starting factory Writer
[20100312 11:05:51] [Status] World server listening on: 127.0.0.1:9000
[20100312 11:05:51] [Status] Starting static zones...
[20100312 11:05:51] [Status] Connected to LoginServer: 127.0.0.1: 9100
[20100312 11:08:01] [Error] 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, sog
a_facial_hair_type, created_date) values(1, 1, 'Milltest', 5, 23, 1, 1, -0.12000
0, 0.540000, 0, 0, 0, 0, 4972, 5502, 5501, 0, 1125, 121, 1187, 0, now())': #1452
: Cannot add or update a child row: a foreign key constraint fails (`eq2world/ch
aracters`, CONSTRAINT `FK_char_zone` FOREIGN KEY (`current_zone_id`) REFERENCES
`zones` (`id`) ON UPDATE CASCADE)
[20100312 11:08:01] [Error] Error in GetCharacterName query 'SELECT name from ch
aracters where id=0':

Don't know if you needed this or not, but here's what the login server file thing says:

***** EQ2Emulator Server Pack *****
***** by John Adams *****
***** LoginServer Starting *****
Starting MInilogin Server . . .
[Status] Using database 'eq2ls' at localhost
SUCCESS!
LoginServer.ini read.
[Status] Loading opcodes..
Loading Structs... SUCCESS!
Loading world list...
Login server listening on port:9100
Starting factory Reader
Starting factory Writer
7396 New Server connection: 127.0.0.1 port: 37056
24035 New client from ip: 127.0.0.1 port: 55898
32083 Removing client from ip: 127.0.0.1 port: 55898 Name:
40865 New client from ip: 127.0.0.1 port: 55898
Loading acct for admin...
Finished Loading...SUCCESS!
Current Login List:
OP_KeymapLoadMsg Packet: OPCode: 0x17, size: 2 from admin
Current Login List:
1 : admin
59092 Removing client from ip: 127.0.0.1 port: 55898 Name: admin
Removing connection
251552 New client from ip: 127.0.0.1 port: 55898
Loading acct for admin...
Finished Loading...SUCCESS!
Current Login List:
1 : admin
Char Create Request From: admin....Loaded Successfully
Current Login List:
1 : admin
Current Login List:
1 : admin
Char Create Request From: admin....Loaded Successfully
Current Login List:
1 : admin
Char Create Request From: admin....Loaded Successfully
Current Login List:
1 : admin
admin sent invalid Play Request:
0: 00 00 00 00 01 00 00 00 - 00 00 00 | ...........
admin sent invalid Play Request:
0: 00 00 00 00 01 00 00 00 - 00 00 00 | ...........
Char Create Request From: admin....Loaded Successfully
Current Login List:
1 : admin
Current Login List:
1 : admin
127.0.0.1:49296: TCPConnection::RecvData(): Error: 10054
555769 New Server connection: 127.0.0.1 port: 40384
579258 Removing client from ip: 127.0.0.1 port: 55898 Name: admin
Removing connection
596156 New client from ip: 127.0.0.1 port: 55899
604524 Removing client from ip: 127.0.0.1 port: 55899 Name:
Removing connection
616109 New client from ip: 127.0.0.1 port: 55899
Loading acct for admin...
Finished Loading...SUCCESS!
Current Login List:
1 : admin
OP_KeymapLoadMsg Packet: OPCode: 0x17, size: 2 from admin
Char Create Request From: admin....Loaded Successfully
Current Login List:
1 : admin
Current Login List:
1 : admin

Finally, I just want to recap what I'm doing:
Opening MySQL+Apache, opening LoginServer, opening WorldServer, then opening EverQuest2.
I'm not missing any steps, am I?

Thank you again!

You are starting everything perfectly. It appears you are unable to insert a custom created character, for some reason:

[Error] 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, sog
a_facial_hair_type, created_date) values(1, 1, 'Milltest', 5, 23, 1, 1, -0.12000
0, 0.540000, 0, 0, 0, 0, 4972, 5502, 5501, 0, 1125, 121, 1187, 0, now())'

This error means it cannot find the zone_id of whatever starting location you picked when you created your character. So the next step is me trying to create the same character you just did to see if I get the same error.

Just for fun, you might try creating a human male guardian, or whatever that Admin character is. See if you get in. Maybe there's a bug in starting locations.

I have to say now, I am a little amazed this problem exists, and not one person has ever come forward until you, nlmiller... that is pretty discouraging, but thankful for you. There is a pretty old bug in that version of the code when mixed with my Foreign Key work in the database. When a new character is inserted, it appears it's zone is set to 0, which is invalid, and is blocked by the FK constraint. Not sure why that's just now come up, since I had to create the Admin char, afterall... but anyway...

If you have a SQL editor like SQLYog or HeidiSQL, run this query:
That should get you in-game and allow you to create new characters til I get the new ServerPack finished.