Log in

View Full Version : Missing Info


08-03-2003, 05:07 AM
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
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.