EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=617)
-   -   That Zone Is Currently Unavailable. (https://www.eqemulator.org/forums/showthread.php?t=1700)

tcsmyworld 06-22-2003 12:15 PM

the timeleft error is caused from a field missing in the spawn2 table.
Open mysql and add this to your DB.

ALTER TABLE spawn2 ADD COLUMN timeleft int(5) NOT NULL default '0';

that fixed the error for me.

tcsmyworld 06-22-2003 12:20 PM

The minstaus error is in the items table, to fix it open mysql and add this-

ALTER TABLE items ADD COLUMN minstatus tinyint(3) unsigned default '0' after raw_data;

booa 06-23-2003 10:46 AM

Quote:

Originally Posted by tcsmyworld
the timeleft error is caused from a field missing in the spawn2 table.
Open mysql and add this to your DB.

ALTER TABLE spawn2 ADD COLUMN timeleft int(5) NOT NULL default '0';

that fixed the error for me.

I was having a population error in zone.exe .
This did the trick .

Thank you tcsmyworld !

Velosity 06-23-2003 05:01 PM

thanks alot tcs, im gonna try that after i am done posting,

leviathan7 06-24-2003 08:29 AM

The thing is I haven't done any editing to the db though. It is all the original data.

Trumpcard 06-24-2003 08:47 AM

Yes, but the binaries he posted require changes to the database to work.

leviathan7 06-24-2003 01:41 PM

Instead of launching zone.exe with the typical boot5zones.bat file:

start zone . 192.168.0.1 7995 192.168.0.1 etc etc

I created a new batch file that had it load a specific zone instead of the autozone thatit normally does.

start zone qeynos 192.168.0.1 7995 192.168.0.1

When I then launched bootazone.bat lol the zone file came up briefly and had an error but closed so i ran it again and took a screen shot when i looked atthe error it talked about something with object.

I then:
ran mysql.exe
use eq
delete from object; which deletes all entries within this table

after doing that bootazone.bat worked fine and i ran boot5zones.bat and was able to log in and play and everything.
so my question is two-fold i believe object is simply like ovens and what not is this right? and second has anyone else had any problems with this?

mollymillions 07-20-2003 11:38 PM

Thanks once again TCS, you are fast becoming my hero (who was that masked man - or girrr!!)


All times are GMT -4. The time now is 01:07 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.