EQEmulator Forums - Problem with DB, and server not showing

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=617)

- - Problem with DB, and server not showing (https://www.eqemulator.org/forums/showthread.php?t=13909)

Problem with DB, and server not showing

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.

Quote:

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

Quote:

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

Quote:

[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

Code:

[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

Code:

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

add this to the bottom of your loginserver.ini file

Code:

[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.

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

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

Quote:

[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

Quote:

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.

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.