Log in

View Full Version : 5-20-04cvs code, MW057DR2_alpha1.sql


rizzen04
05-24-2004, 11:52 PM
[errtu@shattered-lands eqemu]$ ./world&
[1] 3862
[errtu@shattered-lands eqemu]$ [Status] Using database 'emu' at localhost
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.7-DR3
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] libEMuShareMem.so loaded
[Status] Loading items from database: count=28731, max id=69304
[Error] DBLoadItems query 'SELECT charges,unknown002,unknown003,merchantprice,unknow n005,unknown006,unknown007,itemclass,name,lore,idf ile,id,weight,norent,nodrop,size,slots,cost,icon,u nknown018,unknown019,unknown020,tradeskills,cr,dr, pr,mr,fr,astr,asta,aagi,adex,acha,aint,awis,hp,man a,ac,deity,skillmodvalue,skillmodtype,banedmgrace, banedmgamt,banedmgbody,magic,casttime2,hasteproclv l,reqlevel,bardtype,bardvalue,light,delay,reclevel ,recskill,elemdmgtype,elemdmgamt,effecttype,range, damage,color,classes,races,unknown061,spellid,maxc harges,itemtype,material,sellrate,unknown067,castt ime,unknown069,proc_rate_mod,focusid,combateffects ,shielding,stunresist,strikethrough,combatskill,co mbatskilldmg,spellshield,avoidance,accuracy,unknow n081,factionmod1,factionmod2,factionmod3,factionmo d4,factionamt1,factionamt2,factionamt3,factionamt4 ,charmfile,augtype,augslot1type,augslot2type,augsl ot3type,augslot4type,augslot5type,ldonpointtheme,l donpointcost,ldonsold,bagtype,bagslots,bagsize,bag wr,booktype,unknown105,filename,banedmgamt2,augmen trestriction,loreflag,pendingloreflag,artifactflag ,summonedflag,tribute,gmflag,endur,dotshielding,at tackbonus,hpregen,manaregen,hastepercent,damageshi eld,minstatus FROM 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..
[CommandLevels] block not found in 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
Breaking linux compiles....
TCP listening on: 207.179.69.21:9000
World server listening on: 207.179.69.21:9000
Connected to LoginServer: eqlogin2.eqemulator.net:5997

anyone have any clues as to why the dbitems wont load? I have no problems with the older version of the database with the new source however I cannot get the new db to work at all.

db.ini

# READ README.TXT!

[Database]
host=localhost
user=
password=
database=emu
compression=off


### --- This file tells world.exe what computer mySQL is on. Host should
### --- be left "localhost" unless mysql is on a differant computer than world.exe.

removed the un/pw when making the post, obviously it finds the database as everything else loads cept the items.

Derision
05-25-2004, 12:18 AM
There is a file called itemtablechanges.sql that come with the 05-20 CVS code. Try sourcing that into your database.