EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::General Support (https://www.eqemulator.org/forums/forumdisplay.php?f=616)
-   -   Missing Info (https://www.eqemulator.org/forums/showthread.php?t=8954)

08-03-2003 05:07 AM

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... :x

[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. :shock:

Bigpull 08-03-2003 05:27 AM

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;

08-03-2003 05:34 AM

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.


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

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