Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Support > Archive::General Support

Archive::General Support Archive area for General Support's posts that were moved here after an inactivity period of 90 days.

 
 
Thread Tools Display Modes
  #1  
Old 05-24-2004, 11:52 PM
rizzen04
Hill Giant
 
Join Date: Apr 2004
Location: The Overthere
Posts: 123
Default 5-20-04cvs code, MW057DR2_alpha1.sql

[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.
__________________
Rizzen
[ServerOp]Shattered Lands(active...kinda)
MUD? whats that? telnet://shattered-lands.net:6666
*****
If it doesn
  #2  
Old 05-25-2004, 12:18 AM
Derision
Developer
 
Join Date: Feb 2004
Location: UK
Posts: 1,540
Default

There is a file called itemtablechanges.sql that come with the 05-20 CVS code. Try sourcing that into your database.
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 04:53 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3