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

Support::General Support Post all topics here having to do with errors while trying to connect to an EQEMu server but not about the setup/running of the Server itself.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 09-23-2006, 08:57 AM
vales
Discordant
 
Join Date: May 2006
Posts: 458
Default

The thing is that if I add one, another error pops up. If I source it using the loaditems.pl I get no errors, however, when I start up thge EMU, I get the items errors all over again in the server window. It's quite baffling.

You might be right on that one. I think there was a communication breakdown somewhere. :p Was working fine before the September 20th update. I still don't have any answer or clue on which one I should be using to source with though. This is from the 13th floor forum:
Quote:
ALTER TABLE items CHANGE UNK061 UNK060 int not null;
ALTER TABLE items CHANGE UNK123 UNK122 int not null;
ALTER TABLE items CHANGE UNK124 UNK123 int not null;
ALTER TABLE items CHANGE UNK127 UNK126 int not null;
ALTER TABLE items CHANGE UNK134 UNK138 varchar(255) not null default "";

ALTER TABLE items ADD UNK132 int not null AFTER notransfer;
ALTER TABLE items ADD UNK133 int not null AFTER UNK132;
ALTER TABLE items ADD UNK134 int not null AFTER UNK133;
ALTER TABLE items ADD UNK135 int not null AFTER UNK134;
ALTER TABLE items ADD UNK136 int not null AFTER UNK135;
ALTER TABLE items ADD UNK137 varchar(255) not null default "" AFTER UNK136;

ALTER TABLE items ADD svcorruption int not null AFTER scrolllevel;
ALTER TABLE items ADD UNK160 int not null AFTER svcorruption;
ALTER TABLE items ADD UNK161 int not null AFTER UNK160;
So you might want to check it if you're updating items.

Starting all over again, I sourced in the items table, then added the above code. Then I used loaditems.pl and got no errors of course, but got this when I started up the EMU.
Quote:
[09.23. - 14:19:00] DBLoadItems query 'select source,itemclass,name,lore,idfile,id,weight,norent ,nodrop,size,slots,price,icon,UNK012,UNK013,benefi tflag,tradeskills,cr,dr,pr,mr,fr,astr,asta,aagi,ad ex,acha,aint,awis,hp,mana,ac,deity,skillmodvalue,U NK033,skillmodtype,banedmgrace,banedmgamt,banedmgb ody,magic,casttime_,reqlevel,bardtype,bardvalue,li ght,delay,reclevel,recskill,elemdmgtype,elemdmgamt ,range,damage,color,classes,races,UNK054,maxcharge s,itemtype,material,sellrate,UNK059,casttime,UNK06 1,procrate,combateffects,shielding,stunresist,stri kethrough,extradmgskill,extradmgamt,spellshield,av oidance,accuracy,charmfileid,factionmod1,factionmo d2,factionmod3,factionmod4,factionamt1,factionamt2 ,factionamt3,factionamt4,charmfile,augtype,augslot 1type,augslot1unk,augslot2type,augslot2unk,augslot 3type,augslot3unk,augslot4type,augslot4unk,augslot 5type,augslot5unk,ldontheme,ldonprice,ldonsold,bag type,bagslots,bagsize,bagwr,book,booktype,filename ,banedmgraceamt,augrestrict,loregroup,pendingloref lag,artifactflag,summonedflag,favor,fvnodrop,endur ,dotshielding,attack,regen,manaregen,endurancerege n,haste,damageshield,recastdelay,recasttype,guildf avor,augdistiller,UNK123,UNK124,attuneable,nopet,U NK127,pointtype,potionbelt,potionbeltslots,stacksi ze,notransfer,stackable,UNK134,clickeffect,clickty pe,clicklevel,clicklevel2,proceffect,proctype,proc level,proclevel2,worneffect,worntype,wornlevel,wor nlevel2,focuseffect,focustype,focuslevel,focusleve l2,scrolleffect,scrolltype,scrolllevel,scrolllevel 2,updated from items order by id', #1054: Unknown column 'UNK061' in 'field list'
[09.23. - 14:19:00] If you got boat loads of errors, make sure you sourced: utils/items-0.6.0-DR2-0.6.1-DR1-convert.sql

Last edited by vales; 09-23-2006 at 05:29 PM..
Reply With Quote
 

Thread Tools
Display Modes

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:40 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