Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Support > Archive::Windows Servers

Archive::Windows Servers Archive area for Windows Servers's posts that were moved here after an inactivity period of 90 days.

Reply
 
Thread Tools Display Modes
  #16  
Old 06-22-2003, 12:15 PM
tcsmyworld's Avatar
tcsmyworld
Discordant
 
Join Date: Feb 2002
Posts: 452
Default

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.
Reply With Quote
  #17  
Old 06-22-2003, 12:20 PM
tcsmyworld's Avatar
tcsmyworld
Discordant
 
Join Date: Feb 2002
Posts: 452
Default

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;
Reply With Quote
  #18  
Old 06-23-2003, 10:46 AM
booa
Fire Beetle
 
Join Date: Jun 2003
Posts: 9
Default

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 !
Reply With Quote
  #19  
Old 06-23-2003, 05:01 PM
Velosity
Sarnak
 
Join Date: May 2003
Location: Rancho Cucamonga, Ca
Posts: 77
Default

thanks alot tcs, im gonna try that after i am done posting,
Reply With Quote
  #20  
Old 06-24-2003, 08:29 AM
leviathan7
Fire Beetle
 
Join Date: Jun 2003
Posts: 3
Default

The thing is I haven't done any editing to the db though. It is all the original data.
Reply With Quote
  #21  
Old 06-24-2003, 08:47 AM
Trumpcard
Demi-God
 
Join Date: Jan 2002
Location: Charlotte, NC
Posts: 2,614
Default

Yes, but the binaries he posted require changes to the database to work.
__________________
Quitters never win, and winners never quit, but those who never win and never quit are idiots.
Reply With Quote
  #22  
Old 06-24-2003, 01:41 PM
leviathan7
Fire Beetle
 
Join Date: Jun 2003
Posts: 3
Default

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?
Reply With Quote
  #23  
Old 07-20-2003, 11:38 PM
mollymillions's Avatar
mollymillions
Hill Giant
 
Join Date: May 2003
Posts: 176
Default

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


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 11:56 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3