Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 03-14-2005, 02:55 PM
Minlail
Sarnak
 
Join Date: Mar 2005
Posts: 38
Default db error when loading world help

hrm help? what stupid thing did i do wrong?

Quote:
[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.0-DR2
[Status] Loading variables..
[Status] Loading zones..
[Status] Clearing groups..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=34229
[Error] DBLoadItems query 'SELECT charges,unknown002,unknown003,merchantprice,un
known005,unknown006,unknown007,SpellCharges,itemcl ass,name,lore,idfile,id,weight
,norent,nodrop,attuneable,size,slots,cost,icon,unk nown018,unknown019,unknown020,
tradeskills,cr,dr,pr,mr,fr,astr,asta,aagi,adex,ach a,aint,awis,hp,mana,ac,deity,s
killmodvalue,skillmodtype,banedmgrace,banedmgamt,b anedmgbody,magic,casttime2,has
teproclvl,reqlevel,bardtype,bardvalue,light,delay, reclevel,recskill,elemdmgtype,
elemdmgamt,effecttype,range,damage,color,classes,r aces,unknown061,spellid,maxcha
rges,itemtype,material,sellrate,unknown067,casttim e,unknown069,proc_rate_mod,foc
usid,combateffects,shielding,stunresist,strikethro ugh,combatskill,combatskilldmg
,spellshield,avoidance,accuracy,unknown081,faction mod1,factionmod2,factionmod3,f
actionmod4,factionamt1,factionamt2,factionamt3,fac tionamt4,charmfile,augtype,aug
slot1type,augslot2type,augslot3type,augslot4type,a ugslot5type,ldonpointtheme,ldo
npointcost,ldonsold,bagtype,bagslots,bagsize,bagwr ,unknown105,booktype,filename,
banedmgamt2,augmentrestriction,loreflag,pendinglor eflag,artifactflag,summonedfla
g,tribute,gmflag,endur,dotshielding,attackbonus,hp regen,manaregen,hastepercent,d
amageshield,minstatus FROM items ORDER BY id', #1054: Unknown column 'SpellCharg
es' in 'field list'
[Error] If you got an error related to the 'SpellCharges' field, run the followi
ng SQL Query: ALTER TABLE `items` CHANGE `unknown008` `SpellCharges` INT(11) DE
FAULT "0" NOT NULL;
Error: EMuShareMem: DLLLoadItems: !cbDBLoadItems
[Error] Error: Could not load item data. But ignoring
Invalid worldname, please edit LoginServer.ini. Server name must be at least 10
characters.
[Error] [ChatChannelServer] block not found in ./LoginServer.ini
[Status] Loading guild ranks..
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Breaking bards...done
TCP listening on: ceberus.eqserver.servegame.com:9000
World server listening on: ceberus.eqserver.servegame.com:9000
Reply With Quote
  #2  
Old 03-15-2005, 01:42 AM
absolom75
Fire Beetle
 
Join Date: Mar 2005
Posts: 5
Default

The fix for your problem is listed in the error message:

Quote:
[Error] If you got an error related to the 'SpellCharges' field, run the following SQL Query: ALTER TABLE `items` CHANGE `unknown008` `SpellCharges` INT(11) DEFAULT "0" NOT NULL;
It also says your server name needs to be at least 10 characters long.

Lastly, make sure the following is in your LoginServer.ini file (presuming you're using MiniLogin):

Code:
[ChatChannelServer]
worldshortname=
chataddress=
chatport=

Last edited by absolom75; 03-15-2005 at 09:49 AM..
Reply With Quote
Reply


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 10:13 PM.


 

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 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3