Error : Loading Items FAILED
 

Hey I've been workin on this server thing. And I got almost everything to work right.

Except When i load world.exe I get this interesting error that Says Error : Loading items failed. And it ignores it and moves on. Then i load the boot5zones.bat and the same error comes up, and it moves on. then the 5 zones enters a sleep mode.

I can see my server inside the selection screen, and it doesnt appear locked, But when i try to connect i get 1017, and i wouldnt doubt that this is because it cannot load the items.

I have tried different Databases and such, still the same error. Maybe i have something set wrong is SQL. But I double and triple checked everything in my EQEmu folder and all that is in order.

If this is not the problem, Then yes i have all firewalls turned off, and I have my server in the DMZ.

Sorry for the long post, I am trying to be informative.

more info
 

This is What World.exe says

Now I don't need anyone to hold my hand. I am a very quick learner. I just need to know if this can cause a problem. And a simple suggestion of how to fix it

"[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=26679, max id=68199
[Error] DBLoadItems query 'SELECT charges,unknown002,unknown003,merchantprice,un
known005,unknown006,unknown007,itemclass,name,lore ,idfile,id,weight,norent,nodro
p,size,slots,cost,icon,unknown018,unknown019,unkno wn020,tradeskills,cr,dr,pr,mr,
fr,astr,asta,aagi,adex,acha,aint,awis,hp,mana,ac,d eity,skillmodvalue,skillmodtyp
e,banedmgrace,banedmgamt,banedmgbody,magic,casttim e2,hasteproclvl,reqlevel,bardt
ype,bardvalue,light,delay,reclevel,recskill,elemdm gtype,elemdmgamt,effecttype,ra
nge,damage,color,classes,races,unknown061,spellid, maxcharges,itemtype,material,s
ellrate,unknown067,casttime,unknown069,proc_rate_m od,focusid,combateffects,shiel
ding,stunresist,strikethrough,combatskill,combatsk illdmg,spellshield,avoidance,a
ccuracy,unknown081,factionmod1,factionmod2,faction mod3,factionmod4,factionamt1,f
actionamt2,factionamt3,factionamt4,charmfile,augty pe,augslot1type,augslot2type,a
ugslot3type,augslot4type,augslot5type,ldonpointthe me,ldonpointcost,ldonsold,bagt
ype,bagslots,bagsize,bagwr,booktype,unknown105,fil ename,banedmgamt2,augmentrestr
iction,loreflag,pendingloreflag,artifactflag,summo nedflag,tribute,gmflag,endur,d
otshielding,attackbonus,hpregen,manaregen,hasteper cent,damageshield,minstatus FR
OM 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..
[Error] Could not load EQTime file ./eqtime.cfg
[Error] Unable to load ./eqtime.cfg
[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: 67.8.170.112:9000
World server listening on: 67.8.170.112:9000
Connected to LoginServer: eqlogin2.eqemulator.net:5997"

This is What the boot5zones.bat says..

[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 npc faction lists
[Status] Loading loot tables
[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: 5415
[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: localhost:9000

It looks like you have the wrong items table sourced. When you set this up, which DB did you use?

The TCS DR2 DB should work with DR3 code, but I know the devs released a new items table a little while back (called items_new). If the TCS DB does not work, you may want to drop the items table and then source in the items_new, and rename it to items and see if the error goes away.

ok
 

Also Found this

[Error] Could not load EQTime file ./eqtime.cfg
[Error] Unable to load ./eqtime.cfg

When i run world.exe. Um this file wasnt included in the downloads. Where do i find it :)


I know whats gonna happen. Im gonna post this, 5mins later i will find my own answer. If i do, I will post again.

Its like lighting your cigarette on a red light, and just as you light it the light turns green. /shrug

I had followed that Walkthrough to the letter. Whatever DB it told me to use, I used it. I dont know much about SQL. But from the way it looked I mixed up a few?

I guess i should post the walkthrough. thought i did

http://www.eqemulator.net/forums/vie...0802e1320f57d6

alright govtcheeze I got all that. I just dont know where to get that items table.

UPDATE
 

Ok so i got it working. Follow That Tutorial on the link above. Then go to this web page

http://cvs.biosprite.net/

And download the one dating the 20th. source in the sql file. and let it rip.. worked great for me