zone/world crash's

[fireclav]

horray finally got everything working on my lan. the only thing i see that really gets semi anoying is that if i leave the server running for awhile inactive when someone tries to log on the zone.exe will crash or world.exe will crash. its only after a period of inactivity ex. if i go to work and come back i have to reset server or when i logon it will crash the zone. is there any way to resolve this. i was thinking maybe its just my setup but not sure.

looked in forums but couldnt find anything with this type of situation so before i go trying all kindsa stuff figured id ask

[Angelox]

horray finally got everything working on my lan. the only thing i see that really gets semi anoying is that if i leave the server running for awhile inactive when someone tries to log on the zone.exe will crash or world.exe will crash. its only after a period of inactivity ex. if i go to work and come back i have to reset server or when i logon it will crash the zone. is there any way to resolve this. i was thinking maybe its just my setup but not sure.

looked in forums but couldnt find anything with this type of situation so before i go trying all kindsa stuff figured id ask

Are you logging in from another machine in the LAN or on the same machine? Maybe your machine is too slow, or short on mem? I use a P3 900MhZ with 1.3 gigs of mem (probably too slow), It works fine while I play alone on the server, or with others and I am on a LAN machine. If I play on the server with other people, it crashes the worlds.

[vales]

Another possiblity:
If you haven't updated to the latest binary release, you should. The one that comes with the DRP installer has a plain vanilla 7.0 server in it. There's been at least eight server updates since then, and the bug you're having was fixed two releases after your current one.

[fireclav]

ok found it i take it just copy things like maps and such into this folder? and my emu and such

[fireclav]

ok well i copied the exe's into my orig folder and now it just says ZONE NOT FOUND when i try and login. any ideas

[Angelox]

Do you get "Zone not found" error after character select? what dtatabase are you using; PEQ or EQ?

[fireclav]

neither, cavedudes

and yep when i click a char at char select is when i get the error.

[Angelox]

neither, cavedudes

and yep when i click a char at char select is when i get the error.

cavedudes is the EQ one,
as per changelog ==05/31/2006==, did you source these lines into the database?
(don't forget to "USE eq" first)

ALTER TABLE spawnentry DROP spawn_limit;
ALTER TABLE spawngroup ADD spawn_limit tinyint(4) NOT NULL default '0';
ALTER TABLE altadv_vars ADD class_type int unsigned NOT NULL DEFAULT 0;

This is probably why your .EXE's are crashing too.

[fireclav]

how do i go about sourcing them

[Angelox]

how do i go about sourcing them

You need to left click on desktop "start" button, then select "run" and type in "C:\mysql\bin\mysql -u root eq" (no quotes), hit "enter"; given you have made an account under "eq", it will bring up a command window for sql.
then type "use eq" and hit "enter"

you can just copy-paste these three lines into the box,

ALTER TABLE spawnentry DROP spawn_limit;
ALTER TABLE spawngroup ADD spawn_limit tinyint(4) NOT NULL default '0';
ALTER TABLE altadv_vars ADD class_type int unsigned NOT NULL DEFAULT 0;

might have to hit enter on the last one.

[fireclav]

ok then ijust copy and paste the exe's from that new patch into my directory and it will work ?