Problems Starting a Server
 

My world.exe appears to be working, but I can't find my server in the server list when I login. I'm running Windows XP, using EQemu 0.5.6


heres what my world.exe window displays :

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.6
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=0, max id=0
[Error] DBLoadItems query 'SELECT gmflag,minstatus,unknown002,unknown005,unknown
107,unknown108,id,weight,norent,nodrop,size,itemcl ass,idfile,lore,slots,cost,nam
e,icon,unknown105,booktype,filename,bagtype,bagslo ts,bagsize,bagwr,augslot1type,
augslot2type,augslot3type,augslot4type,augslot5typ e,unknown018,unknown019,unknow
n020,casttime2,unknown061,unknown067,unknown069,un known070,unknown076,unknown077
,augtype,ldonpointtheme,ldonpointcost,unknown099,a str,asta,aagi,adex,awis,aint,a
cha,pr,mr,dr,fr,cr,skillmodvalue,skillmodtype,bane dmgamt,banedmgbody,banedmgrace
,magic,hasteproclvl,light,delay,effecttype,range,d amage,material,maxcharges,recl
evel,recskill,charmfile,factionmod1,factionmod2,fa ctionmod3,factionmod4,factiona
mt1,factionamt2,factionamt3,factionamt4,reqlevel,h p,mana,ac,color,classes,races,
spellid,casttime,focusid,itemtype,accuracy,avoidan ce,bardtype,bardvalue,combatef
fects,deity,elemdmgamt,elemdmgtype,sellrate,shield ing,spellshield,strikethrough,
stunresist,tradeskills FROM items ORDER BY id', #1054: Unknown column 'casttime2
' in 'field list'
Error: EMuShareMem: DLLLoadItems: !cbDBLoadItems
[Error] Error: Could not load item data. But ignoring
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Breaking bards...done
TCP listening on: ***.***.***.***:9000
World server listening on: ***.***.***.***:9000
Connected to LoginServer: eqlogin1.eqemulator.net:5997


my db.ini file :

[Database]
host=localhost
user=test
password=test
database=eq
compression=off


my loginserver.ini :

[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginport=5997
worldname=Anachronism [testing]
worldaddress=***.***.***.***
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=


(any place where "***.***.***.***" is found is my external ip address)

Your item database most likely is not up to date. Looks like you are missing the "casttime2" field.

Update
 

ok i resourced the database and it fixed a lot of those problems, now my world.exe displays this, but i still cant find my server on the servers list


[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.6
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=26619, max id=68199
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Liberating a country that despises us...
TCP listening on: 67.9.63.90:9000
World server listening on: 67.9.63.90:9000
Connected to LoginServer: eqlogin1.eqemulator.net:5997

Make sure there are no spaces after [LoginServer] or any other command in your loginserver file

Checked
 

checked that, no spaces

Boot5zones
 

when I run the Boot5zones.bat I get this message in one of the windows :


[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.6
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading NPCTypes from database...
NPCs loaded - using old database format
[Status] Loading npc faction lists
[Status] Loading NPC Faction Lists from database...
[Status] Loading loot tables
[Status] Loading Loot tables from database...
[Status] Loading doors
[Status] Loading Doors from database...
Error in DBLoadDoors query 'SELECT id,doorid,zone,name,pos_x,pos_y,pos_z,heading
,opentype,guild,lockpick,keyitem,triggerdoor,trigg ertype,dest_zone,dest_x,dest_y
,dest_z,dest_heading,liftheight,invert_state,incli ne from doors' #1054: Unknown
column 'invert_state' in 'field list'
Error: EMuShareMem: DLLLoadDoors: !cbDBLoadDoors
[Status] FileLoadSPDat() Loading spells from ./spells_us.txt
[Status] FileLoadSPDat() spells loaded: 5442
[Status] Loading guilds
[Status] Loading factions
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] command_init(): Warning: Command 'help' defaulting to access level 0!
[Status] command_init(): Warning: Command 'version' defaulting to access level 0
!
[Status] command_init(): Warning: Command 'serversidename' defaulting to access
level 0!
[Status] command_init(): Warning: Command 'loc' defaulting to access level 0!
[Status] command_init(): Warning: Command 'flag' defaulting to access level 0!
[Status] command_init(): Warning: Command 'si' defaulting to access level 0!
[Status] 160 commands loaded
WorldServer connect: Connecting to the server failed: TCPConnection::Connect():
connect() failed. Error: 10060
[Error] worldserver.Connect() FAILED!
[Status] Entering sleep mode

Items Database
 

I finally got my server working but now I'm not able to save any changes that I make to my items database.

Isn't that supposed to be 5995?

nah, 5995 is the new one for 5.7 stuff.
eqemulator.net
port 5995..