Zone.exe Crash... help!

[rameho2433]

Alright. So I'm asking you to bear with me. I'm a complete amateur.

i set up my first server today. it went up without a hitch, everything running ok....

until I log in and load up a character.

I create a character, and he zones into South Qeynos.


and i get a little popup saying "Zone.exe has encountered an error and needs to terminate"

The zone crashes, and my character gets kicked out. tried multiple times. not a fluke

So here's the feedback I got from the server. any help would be greatly appreciated. I'm trying to learn as I go along here.

[Debug] [WORLD__CLIENT] New connection from 192.168.0.7:1634
[Debug] [NET__IDENT_TRACE] 192.168.0.7:1634: First opcode 0x4dd0 did not match e
xpected 0x2792
[Debug] [NET__IDENT_TRACE] 192.168.0.7:1634: Tried patch 6.2_world, and it did n
ot match.
[Debug] [NET__IDENT_TRACE] 192.168.0.7:1634: First opcode 0x4dd0 did not match e
xpected 0x2ec9
[Debug] [NET__IDENT_TRACE] 192.168.0.7:1634: Tried patch 6.2_zone, and it did no
t match.
[Debug] [NET__IDENT_TRACE] 192.168.0.7:1634: First opcode matched 0x4dd0 and len
gth matched 464
[Debug] [NET__IDENTIFY] Identified stream 192.168.0.7:1634 with signature Titani
um_world
[Debug] [WORLD__CLIENT] New client from 192.168.0.7:1634
[Debug] [WORLD__CLIENT] rameho2433: Logged in. Mode=(CharSel)
[Debug] [WORLD__CLIENT] rameho2433: LS Account #71347
[Debug] [WORLD__CLIENT] rameho2433: Name approval request.  Name=Avvmo, race=Fro
glok, class=Wizard
[Debug] [WORLD__CLIENT] rameho2433: Character creation request from rameho2433 L
S#71347 (192.168.0.7:1634) :
[Debug] [WORLD__CLIENT] rameho2433: Name: Avvmo
[Debug] [WORLD__CLIENT] rameho2433: Race: 330  Class: 12  Gender: 0  Deity: 208
 Start zone: 14
[Debug] [WORLD__CLIENT] rameho2433: STR  STA  AGI  DEX  WIS  INT  CHA    Total
[Debug] [WORLD__CLIENT] rameho2433:  70   95  100  100   75  110   50     600
[Debug] [WORLD__CLIENT] rameho2433: Face: 1  Eye colors: 5 5
[Debug] [WORLD__CLIENT] rameho2433: Hairstyle: 255  Haircolor: 255
[Debug] [WORLD__CLIENT] rameho2433: Beard: 255  Beardcolor: 255
[Debug] [WORLD__CLIENT] Validating char creation info...
[Debug] [WORLD__CLIENT] Found 0 errors in character creation request
[Status] Start zone query: SELECT x,y,z,zone_id,bind_id FROM start_zones WHERE p
layer_choice=14 AND player_class=12 AND player_deity=208 AND player_race=330

No start_zones entry in database, using defaults
[Debug] [WORLD__CLIENT] rameho2433: Current location: qeynos  -1.00, -1.00, -1.0
0
[Debug] [WORLD__CLIENT] rameho2433: Bind location: qeynos  -1.00, -1.00, -1.00
[Debug] [WORLD__CLIENT] rameho2433: Character creation successful: Avvmo
[Debug] [WORLD__CLIENT] rameho2433: Attempting autobootup of qeynos (1)
[Debug] [WORLD__ZONE] [8] Setting to 'qeynos' (1)
[Debug] [WORLD__CLIENT] rameho2433: Entering zone qeynos (1)
[Debug] [WORLD__ZONE] [8] [qeynos] Broadcasting a world time update
[Debug] [WORLD__ZONE] [8] [qeynos] Setting to 'qeynos' (1)
[Debug] [WORLD__CLIENT] rameho2433: Sending client to zone qeynos (1) at 192.168
.0.7:7007
[Debug] [WORLD__CLIENT] rameho2433: Client disconnected (not active in process)
[Debug] [WORLD__ZONELIST] Removing zoneserver #8 at :7007
[Debug] [WORLD__ZONELIST] Hold Zones mode is ON - rebooting lost zone
[Debug] [WORLD__CLIENT] New connection from 192.168.0.7:1638
[Debug] [NET__IDENT_TRACE] 192.168.0.7:1638: First opcode 0x4dd0 did not match e
xpected 0x2792
[Debug] [NET__IDENT_TRACE] 192.168.0.7:1638: Tried patch 6.2_world, and it did n
ot match.
[Debug] [NET__IDENT_TRACE] 192.168.0.7:1638: First opcode 0x4dd0 did not match e
xpected 0x2ec9
[Debug] [NET__IDENT_TRACE] 192.168.0.7:1638: Tried patch 6.2_zone, and it did no
t match.
[Debug] [NET__IDENT_TRACE] 192.168.0.7:1638: First opcode matched 0x4dd0 and len
gth matched 464
[Debug] [NET__IDENTIFY] Identified stream 192.168.0.7:1638 with signature Titani
um_world
[Debug] [WORLD__CLIENT] New client from 192.168.0.7:1638
[Debug] [WORLD__CLIENT] rameho2433: Logged in. Mode=(CharSel)
[Debug] [WORLD__CLIENT] rameho2433: LS Account #71347

The new connection at the end is me getting kicked to character select and reconnecting.


Like I said, as soon as I zone in, zone.exe crashes. I don't have time to do anything except walk around while I wait for the client to catch up with the server.


thanks in advance.

[rameho2433]

Also, I noticed when I'm logging in and creating a character, it isn't showing up on the _character table.

but when i log back in, the characters are there. odd?

[kouhei]

[Status] Start zone query: SELECT x,y,z,zone_id,bind_id FROM start_zones WHERE p
layer_choice=14 AND player_class=12 AND player_deity=208 AND player_race=330

No start_zones entry in database, using defaults

I think it has to do with your start_zones in the DB. Try and re source the new start_zones.sql and zones.sql into the db and then restart the db that probaly should fix it.

[rameho2433]

sorry i'm a noob. what exactly do you me by re sourcing the files?

[Dr Zauis]

Look at this tutorial:
http://www.eqemulator.net/wiki/wikka...indowsServer64

Now look how as they are logged in to mysql as user eq they are sourcing empty_users from the .sql files (usually people put them in the /bin folder of mysql.

Now..I dont know where you got your database but it might be missing the tables mentioned so check the /bin folder in mysql to see if they are there.

If so then you need to log back in to mysql and source them.

[rameho2433]

There are no sql files in my bin folder.

i used the most recent tutorial, with CVS to download the PEQ database.


I don't know if that helps. I have no file called "empty_zones"

[Lamec]

Originally Posted by rameho2433

Alright. So I'm asking you to bear with me. I'm a complete amateur.

i set up my first server today. it went up without a hitch, everything running ok....

until I log in and load up a character.

I create a character, and he zones into South Qeynos.


and i get a little popup saying "Zone.exe has encountered an error and needs to terminate"

The zone crashes, and my character gets kicked out. tried multiple times. not a fluke

So here's the feedback I got from the server. any help would be greatly appreciated. I'm trying to learn as I go along here.


...snip...

The new connection at the end is me getting kicked to character select and reconnecting.


Like I said, as soon as I zone in, zone.exe crashes. I don't have time to do anything except walk around while I wait for the client to catch up with the server.


thanks in advance.

I've seen so many people fall into this trap, and get really frustrated I think I know what the problem is, cause we had it a couple of times (talk about making you sweat when your sever crashes when anyone tries to zone in...)

Anyways, the merchantlist table allows you to put "bad rows" in. Meaning you can enter a row with the merchantid of zero. Well, guess what, everyone's merchantid is zero. This causes zone to crash when trying to load merchant lists (not exactly sure why...)

So, when anyone tries to log in, poof, zone crash...

Simple fix, find the bad row(s) in merchantlist, and delete it(them) Long term fix, change merchantlist table to not accept 0 (we put an autoincrement on it, at least it avoids the crashes... your new merchant probably won't work right, but your zone will load.. LOL) The function that loads the merchants might handle this a bit more gracefully too, maybe some > 0 in the sql or something

[AndMetal]

For the record, this fixed my issue. It was the same as the original poster's, except I wasn't getting a crash message.

I'm running 0.7.0.988 on Debian Linux with MySQL version 4.1.11 and PEQ for the server, and the client on another machine.

When I would go into a zone, I would go linkdead immediately upon entering into the zone, so I was able to walk around until I timed out. The zone logs weren't showing a crash, but when I went into the web page (http://172.0.0.1:9080), it would go from saying 7 zones loaded to 0 zones loaded when I zoned in (6 dynamic, 1 static), so it seemed like a crash.

Looked all over the forums and couldn't find much else that was helpful, other than this thread.

I copied Spells_en & Spells_us into my eqemu directory, restarted the zone servers, and was able to log in successfully.

[Joetuul]

Originally Posted by Lamec

I've seen so many people fall into this trap, and get really frustrated I think I know what the problem is, cause we had it a couple of times (talk about making you sweat when your sever crashes when anyone tries to zone in...)

Anyways, the merchantlist table allows you to put "bad rows" in. Meaning you can enter a row with the merchantid of zero. Well, guess what, everyone's merchantid is zero. This causes zone to crash when trying to load merchant lists (not exactly sure why...)

So, when anyone tries to log in, poof, zone crash...

Simple fix, find the bad row(s) in merchantlist, and delete it(them) Long term fix, change merchantlist table to not accept 0 (we put an autoincrement on it, at least it avoids the crashes... your new merchant probably won't work right, but your zone will load.. LOL) The function that loads the merchants might handle this a bit more gracefully too, maybe some > 0 in the sql or something

The merchant with a 0 merchID was my problem. I created a merchant in the nexus. when I tried editing the merchant, it was assigned 0 as the merchID. I had no idea this was going to crash everything. I've been scouring the forums for hours over the last few days tyring to figure out why everytime I would select "enter world" on the char select screen it would crash ALL my zones.... but I opened up the database merchantlist table, deleted all the 0 merchid items. and whamo! I was able to log back into the server and I am having no problems..... kidna funny the original post was over a year ago. just thought others might like to find this post if they are having this problem.