Problem with DB, and server not showing

[hejhohej1]

OK i have a problem i was wondering if anyone could help me with or try anyway..

I didnt update the EQemu folder ot the latest patch, where they changed the login proccess, so thats not my problem.

But i had a Server up and running with 5.6 could see my server and get to char select, was a problem with the char creating as many posted here how to fix..

Then i decided to upgrade to 5.7-DR3, went and compiled it, copyed files, Updated to Myra DB for the DR versions, and now i get this in my world.exe file(see below for the text). I can skip it and just go to server select but my server doesnt appear on the list, which makes it hard to get in and fool around.

Hoping one here can give me a tip or 2 to what can be wrong or if anyone know it. I searched for it but didnt find any good info about it.

[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.7-DR3
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded

LoginServer.ini read.
MiniLoginAccounts.ini read.
Server mode: Standalone
Login server listening on port:5999

[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=27378, 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
[Error] [ChatChannelServer] block not found in ./LoginServer.ini
[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
You may already be a winner... of the darwin award.
TCP listening on: 10.0.0.2:9000
World server listening on: 10.0.0.2:9000

[Charmy]

[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,unknown020,tradeskills,cr,dr,pr,mr, 
fr,astr,asta,aagi,adex,acha,aint,awis,hp,mana,ac,deity,skillmodvalue,skillmodtyp 
e,banedmgrace,banedmgamt,banedmgbody,magic,casttime2,hasteproclvl,reqlevel,bardt 
ype,bardvalue,light,delay,reclevel,recskill,elemdmgtype,elemdmgamt,effecttype,ra 
nge,damage,color,classes,races,unknown061,spellid,maxcharges,itemtype,material,s 
ellrate,unknown067,casttime,unknown069,proc_rate_mod,focusid,combateffects,shiel 
ding,stunresist,strikethrough,combatskill,combatskilldmg,spellshield,avoidance,a 
ccuracy,unknown081,factionmod1,factionmod2,factionmod3,factionmod4,factionamt1,f 
actionamt2,factionamt3,factionamt4,charmfile,augtype,augslot1type,augslot2type,a 
ugslot3type,augslot4type,augslot5type,ldonpointtheme,ldonpointcost,ldonsold,bagt 
ype,bagslots,bagsize,bagwr,booktype,unknown105,filename,banedmgamt2,augmentrestr 
iction,loreflag,pendingloreflag,artifactflag,summonedflag,tribute,gmflag,endur,d 
otshielding,attackbonus,hpregen,manaregen,hastepercent,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

It looks like your using the latest CVS Code but your database is missing the newest item data field updates. your going to kill me becuase i can't find the link to what chagnes need to be made, but its around here somewhere. you just need to run a few SQL queieres to alter your table and i think that will clear it up

[Error] [ChatChannelServer] block not found in ./LoginServer.ini

add this to the bottom of your loginserver.ini file

[ChatChannelServer]
ChatChannelServer=localhost

hope that clears it up, sorry i can't find the link to the database chagnes, its late and i am falling asleep.
Good luck and hope it works for you.

[KhaN]

Latest 5.7DR3 (20.05.04) use new DB item system, you need to source the SQL file with the RAR.

[hejhohej1]

i source teh itemtablechanges.sql file from the newest .rar file with my DB, but i still get the same error.

On the bright side my server is showing now and i can login. But still the problem with the DB i would like to get fixed hee

Anymore suggestions about what can be wrong with my Item Db. since i get thta error



My Boot5Zones come up like this now after 3min of thinking

[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...
[Status] FileLoadSPDat() Loading spells from ./spells_us.txt
[Status] FileLoadSPDat() spells loaded: 5020
[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: 10.0.0.2:9000

[KhaN]

Error: EMuShareMem: DLLLoadItems: !ItemsMMF.IsLoaded() (timeout)

Or you dont compiled 5.7DR3 (20.05.04) eqsharemem.dll, or you dont have source correctly sql file.

[cofruben]

compile ALL cvs files.Then execute the sql,probably you get an error with endur column,I got it,but delete all syntax to endur(included) and try again.