stclairguy
05-31-2004, 04:17 AM
I just started trying to set up a server. I have the newest DB and source, but i'm having 2 issues:
Think it was already covered in another post, but i'll put it here because honestly i never saw an answer. I"m getting an item error with my DB. I think one post said i needed to source a file that came with the newest you will need to run the item update.sql that came with emu source But, i downloaded the newest source and didn't find that file. If anyone can give....i guess a more complete or better explained solution i'd be appreciative. The error message is the same as this one:
[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..
[Status] Reboot zone modes ON
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Abort/retry/cancel?
TCP listening on: localhost:9000
World server listening on: localhost:9000
Connected to LoginServer: localhost:5999
Second, my server is locked on the server list every time i try to get into it. How do i unlock the server?
Thanks, i appreciate the help. I did search for the answer, as you can see above, but honestly didn't find anything that fixed it.
Think it was already covered in another post, but i'll put it here because honestly i never saw an answer. I"m getting an item error with my DB. I think one post said i needed to source a file that came with the newest you will need to run the item update.sql that came with emu source But, i downloaded the newest source and didn't find that file. If anyone can give....i guess a more complete or better explained solution i'd be appreciative. The error message is the same as this one:
[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..
[Status] Reboot zone modes ON
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Abort/retry/cancel?
TCP listening on: localhost:9000
World server listening on: localhost:9000
Connected to LoginServer: localhost:5999
Second, my server is locked on the server list every time i try to get into it. How do i unlock the server?
Thanks, i appreciate the help. I did search for the answer, as you can see above, but honestly didn't find anything that fixed it.