Ranger65
06-12-2004, 01:35 AM
Hello all. I have been playing with this for a couple of days now, and still haven't been able to resolve this issue. I suspect that it is because of
the error that my server is not showing up on the server selection screen. I have deleted the eq database from mysql twice, and sourced
it twice with no errors. I tried the item editor to delete the line that it drops at, with no luck.
Any help you can provide me would be greatly appreciated.
Thanks in advance,
Mike
World.exe output:
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.7-DR3
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=28731, max id=69304
[Error] DBLoadItems query 'SELECT charges,unknown002,unknown003,merchantprice,un
known005,unknown006,unknown007,itemclass,name,lore ,idfile,id,weight,norent,nodrop,size,slots,cost,ic on,unknown018,unknown019,unknown020,tradeskills,cr ,dr,pr,mr,fr,astr,asta,aagi,adex,acha,aint,awis,hp ,mana,ac,deity,skillmodvalue,skillmodtype,banedmgr ace,banedmgamt,banedmgbody,magic,casttime2,hastepr oclvl,reqlevel,bardt
ype,bardvalue,light,delay,reclevel,recskill,elemdm gtype,elemdmgamt,effecttype,range,damage,color,cla sses,races,unknown061,spellid,maxcharges,itemtype, material,sellrate,unknown067,casttime,unknown069,p roc_rate_mod,focusid,combateffects,shielding,stunr esist,strikethrough,combatskill,combatskilldmg,spe llshield,avoidance,a
ccuracy,unknown081,factionmod1,factionmod2,faction mod3,factionmod4,factionamt1,factionamt2,factionam t3,factionamt4,charmfile,augtype,augslot1type,augs lot2type,augslot3type,augslot4type,augslot5type,ld onpointtheme,ldonpointcost,ldonsold,bagtype,bagslo ts,bagsize,bagwr,booktype,unknown105,filename,bane dmgamt2,augmentrestriction,loreflag,pendinglorefla g,artifactflag,summonedflag,tribute,gmflag,endur,d otshielding,attackbonus,hpregen,manaregen,hasteper cent,damageshield,minstatus FROM items ORDER BY id', #1054: Unknown column 'charges' 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] Reboot zone modes ON
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Assassinating people that whine about horses...done
TCP listening on: 217.84.XXX.XXX:9000
World server listening on: 217.84.XXX.XXX:9000
Connected to LoginServer: eqlogin2.eqemulator.net:5997
356563 New TCP connection: 192.168.1.102:2662
356563 New TCP connection: 192.168.1.102:2663
356563 New TCP connection: 192.168.1.102:2664
356563 New TCP connection: 192.168.1.102:2665
356563 New TCP connection: 192.168.1.102:2666
New zoneserver: #1 192.168.1.102:2666
New zoneserver: #2 192.168.1.102:2665
New zoneserver: #3 192.168.1.102:2664
New zoneserver: #4 192.168.1.102:2663
New zoneserver: #5 192.168.1.102:2662
Zoneserver SetConnectInfo: 192.168.1.102:2662: 217.84.XXX.XXX:7999
Zoneserver SetConnectInfo: 192.168.1.102:2663: 217.84.XXX.XXX:7995
Zoneserver SetConnectInfo: 192.168.1.102:2664: 217.84.XXX.XXX:7998
Zoneserver SetConnectInfo: 192.168.1.102:2665: 217.84.XXX.XXX:7996
Zoneserver SetConnectInfo: 192.168.1.102:2666: 217.84.XXX.XXX:7997
Boot5zones.bat output:
[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.7-DR3
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
Error: EMuShareMem: DLLLoadItems: !ItemsMMF.IsLoaded() (timeout)
[Error] Loading items FAILED!
Failed. But ignoring error and going on...
[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 doors
[Status] FileLoadSPDat() Loading spells from ./spells_us.txt
[Status] FileLoadSPDat() spells loaded: 5426
[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] 161 commands loaded
[Status] Entering sleep mode
Connected to worldserver: 192.168.1.102:9000
Boot5zones.bat:
REM: ****Read this first!!!****
REM: This file requires your real IP in the place of "YourIP" when you are connecting
REM: To the EQEmu Loginserver.
REM: When you are using minilogin, Replace all IP Addresses to say 127.0.0.1
REM: If you still get errors try using localhost instead of 127.0.0.1
REM:--------------Start-----------------------
@echo off
if NOT exist spells_us.txt goto NOSPELL
start zone . 217.84.XXX.XXX 7995 192.168.1.102
start zone . 217.84.XXX.XXX 7996 192.168.1.102
start zone . 217.84.XXX.XXX 7997 192.168.1.102
start zone . 217.84.XXX.XXX 7998 192.168.1.102
start zone . 217.84.XXX.XXX 7999 192.168.1.102
exit
cls
:NOSPELL
echo You did not copy the spells_en.txt from your everquest directory to this one. Please do so or zones will crash on startup.
PAUSE
REM:---------------END------------------------
the error that my server is not showing up on the server selection screen. I have deleted the eq database from mysql twice, and sourced
it twice with no errors. I tried the item editor to delete the line that it drops at, with no luck.
Any help you can provide me would be greatly appreciated.
Thanks in advance,
Mike
World.exe output:
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.7-DR3
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=28731, max id=69304
[Error] DBLoadItems query 'SELECT charges,unknown002,unknown003,merchantprice,un
known005,unknown006,unknown007,itemclass,name,lore ,idfile,id,weight,norent,nodrop,size,slots,cost,ic on,unknown018,unknown019,unknown020,tradeskills,cr ,dr,pr,mr,fr,astr,asta,aagi,adex,acha,aint,awis,hp ,mana,ac,deity,skillmodvalue,skillmodtype,banedmgr ace,banedmgamt,banedmgbody,magic,casttime2,hastepr oclvl,reqlevel,bardt
ype,bardvalue,light,delay,reclevel,recskill,elemdm gtype,elemdmgamt,effecttype,range,damage,color,cla sses,races,unknown061,spellid,maxcharges,itemtype, material,sellrate,unknown067,casttime,unknown069,p roc_rate_mod,focusid,combateffects,shielding,stunr esist,strikethrough,combatskill,combatskilldmg,spe llshield,avoidance,a
ccuracy,unknown081,factionmod1,factionmod2,faction mod3,factionmod4,factionamt1,factionamt2,factionam t3,factionamt4,charmfile,augtype,augslot1type,augs lot2type,augslot3type,augslot4type,augslot5type,ld onpointtheme,ldonpointcost,ldonsold,bagtype,bagslo ts,bagsize,bagwr,booktype,unknown105,filename,bane dmgamt2,augmentrestriction,loreflag,pendinglorefla g,artifactflag,summonedflag,tribute,gmflag,endur,d otshielding,attackbonus,hpregen,manaregen,hasteper cent,damageshield,minstatus FROM items ORDER BY id', #1054: Unknown column 'charges' 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] Reboot zone modes ON
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Assassinating people that whine about horses...done
TCP listening on: 217.84.XXX.XXX:9000
World server listening on: 217.84.XXX.XXX:9000
Connected to LoginServer: eqlogin2.eqemulator.net:5997
356563 New TCP connection: 192.168.1.102:2662
356563 New TCP connection: 192.168.1.102:2663
356563 New TCP connection: 192.168.1.102:2664
356563 New TCP connection: 192.168.1.102:2665
356563 New TCP connection: 192.168.1.102:2666
New zoneserver: #1 192.168.1.102:2666
New zoneserver: #2 192.168.1.102:2665
New zoneserver: #3 192.168.1.102:2664
New zoneserver: #4 192.168.1.102:2663
New zoneserver: #5 192.168.1.102:2662
Zoneserver SetConnectInfo: 192.168.1.102:2662: 217.84.XXX.XXX:7999
Zoneserver SetConnectInfo: 192.168.1.102:2663: 217.84.XXX.XXX:7995
Zoneserver SetConnectInfo: 192.168.1.102:2664: 217.84.XXX.XXX:7998
Zoneserver SetConnectInfo: 192.168.1.102:2665: 217.84.XXX.XXX:7996
Zoneserver SetConnectInfo: 192.168.1.102:2666: 217.84.XXX.XXX:7997
Boot5zones.bat output:
[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.7-DR3
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
Error: EMuShareMem: DLLLoadItems: !ItemsMMF.IsLoaded() (timeout)
[Error] Loading items FAILED!
Failed. But ignoring error and going on...
[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 doors
[Status] FileLoadSPDat() Loading spells from ./spells_us.txt
[Status] FileLoadSPDat() spells loaded: 5426
[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] 161 commands loaded
[Status] Entering sleep mode
Connected to worldserver: 192.168.1.102:9000
Boot5zones.bat:
REM: ****Read this first!!!****
REM: This file requires your real IP in the place of "YourIP" when you are connecting
REM: To the EQEmu Loginserver.
REM: When you are using minilogin, Replace all IP Addresses to say 127.0.0.1
REM: If you still get errors try using localhost instead of 127.0.0.1
REM:--------------Start-----------------------
@echo off
if NOT exist spells_us.txt goto NOSPELL
start zone . 217.84.XXX.XXX 7995 192.168.1.102
start zone . 217.84.XXX.XXX 7996 192.168.1.102
start zone . 217.84.XXX.XXX 7997 192.168.1.102
start zone . 217.84.XXX.XXX 7998 192.168.1.102
start zone . 217.84.XXX.XXX 7999 192.168.1.102
exit
cls
:NOSPELL
echo You did not copy the spells_en.txt from your everquest directory to this one. Please do so or zones will crash on startup.
PAUSE
REM:---------------END------------------------