Zone.exe Crash... help!

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