Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Support > Archive::General Support

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

 
 
Thread Tools Display Modes
  #1  
Old 08-03-2003, 05:07 AM
Guest
 
Posts: n/a
Default Missing Info

i think im missing an entry from a table in my DB. when entering the world i get this from the zone server...

[Status] Entering sleep mode
Connected to worldserver: 127.0.0.1:9000
Init: Loading zone lists, zone state or spawn listError in PopulateZoneLists que
ry 'SELECT id, spawngroupID, x, y, z, heading, respawntime, variance, pathgrid,
timeleft FROM spawn2 WHERE zone='felwithea'' #1054: Unknown column 'timeleft' in
'field list'
ERROR: Couldn't populate zone spawn list.
Zone->Init failed


and from the world server i get this...

Logged in: Local: eqemu
[Error] Invalid inventory account:1 character:0
Attempting autobootup of felwithea (61) for Dantheman
Zoneserver SetZone: 127.0.0.1:7995 (0)
Zoneserver SetZone: 127.0.0.1:7995 (0)
Error in UpdateTimeLeftWorldUpdate spawn2 set timeleft=(timeleft-300000) where t
imeleft>=300000' 
Client disconnected
Removing client from ip:192.168.108.100 port:1397
Error in UpdateTimeLeftWorldUpdate spawn2 set timeleft=(timeleft-300000) where t
imeleft>=300000' 


any help would be appreciated.
  #2  
Old 08-03-2003, 05:27 AM
Bigpull
Discordant
 
Join Date: Feb 2003
Posts: 305
Default

You're using a < 0.4.5 database, on a 0.4.5 server, or was that 0.4.3 on a 0.4.4 server =)

alter table spawn2 add timeleft bigint(16) default 0;
  #3  
Old 08-03-2003, 05:34 AM
Guest
 
Posts: n/a
Default 050

useing the cvsdev release 050. with the cvs db with some extra bd entries from varius db's, none of them were dropping fields just inserting. i think i just add the items_ tables

i didnt notice your edit, that was it too.
 


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 12:39 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 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3