Error : Loading Items FAILED

[ultimatex]

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.

[ultimatex]

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"

[ultimatex]

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

[govtcheeze]

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.

[ultimatex]

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

[ultimatex]

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?

[ultimatex]

I guess i should post the walkthrough. thought i did

http://www.eqemulator.net/forums/viewtopic.php?t=13403&sid=ebdc55e4033d5231390802e1320f57d6

[ultimatex]

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

[ultimatex]

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