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