Infernal Den Server - DB 80% Complete, need 1 more thing...

[Kroeg]

I have a server up and running off and on, on the master eqlogin server list. I've noticed people getting db items to show up and npcs are starting to work too.

------------

Ok, I've got npcs, doors, weather sequences, and many other things working right. the ONLY thing I don't have working is the item list. Is there a new table convention used in 0.5.0? How come eqemu runs perfectly with all worlds populated, and all doors in place - nearly 80% efficiently, and yet when world.exe is first loaded, I get the following output:

------------------------Start of World.exe Output Window-----------------


[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.0
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=23980, max id=67382
[Error] DBLoadItems query 'SELECT gmflag,minstatus,unknown002,unknown005,unknown
107,unknown108,id,weight,norent,nodrop,size,itemcl ass,idfile,lore,slots,cost,nam
e,icon,unknown105,booktype,filename,bagtype,bagslo ts,bagsize,bagwr,augslot1type,
augslot2type,augslot3type,augslot4type,augslot5typ e,unknown018,unknown019,unknow
n020,casttime2,unknown061,unknown067,unknown069,un known070,unknown076,unknown077
,augtype,unknown097,unknown098,unknown099,astr,ast a,aagi,adex,awis,aint,acha,pr,
mr,dr,fr,cr,skillmodvalue,skillmodtype,banedmgamt, banedmgbody,banedmgrace,magic,
hasteproclvl,light,delay,effecttype,range,damage,m aterial,maxcharges,reclevel,re
cskill,charmfile,factionmod1,factionmod2,factionmo d3,factionmod4,factionamt1,fac
tionamt2,factionamt3,factionamt4,reqlevel,hp,mana, ac,color,classes,races,spellid
,casttime,focusid,itemtype,accuracy,avoidance,bard type,bardvalue,combateffects,d
eity,elemdmgamt,elemdmgtype,sellrate,shielding,spe llshield,strikethrough,stunres
ist,tradeskills FROM items ORDER BY id', #1054: Unknown column 'casttime2' in 'f
ield 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
You may already be a winner... of the darwin award.
TCP listening on: xx.xxx.xxx.xxxxxx
World server listening on: xx.xxx.xxx.xxxxxx
Connected to LoginServer: eqlogin1.eqemulator.net:5997

-------------------EOF-----------------------------------------------------


I've gone into my database and tried to rebuild the table for 'items' with no luck. No matter what I do, even dropping the item table from the database, along with the item dump table... I still get that error.

Even though I get these errors, people can login to my server with about 90% stability over 5 hours, and I have somewhat interactable and casting npcs with working doors and weather cycles.

My only question is, how is 0.5.0 DR4 meant to interact with the new database structure for the items table / dump table? Blindly editing the code is teadious and almost makes it impossible to get things exactly stable. There are servers up that have made the item tables work, so it must be a simple fix somewhere.

[tcsmyworld]

Kroeg , sorry I missed you on npcmovDB channel , been working alot lately.
Not sure which DB you are using , but the one in this post- http://www.everquestserver.com/forum...797cc23f6693d1
is probably the better 050 DB for right now.
Not sure how many changes have been made in the last couple weeks tho.
It is a complete DB , only source the sql in the D/L.
The referal to item# 0 is in the starting items , and is only one item bearing the item# 0 , simply remove that one item to get rid of the error when booting the server.
Hope that helps a bit

[Kroeg]

Sorry, I should have responded earlier. I have fixed my db problems with the latest cvs build (duh, why didn't I check that first). Sadie helped me get my database running correclty with npcs items and mobs, so my thanks goes out to both you and Sadie.