EQEmulator Forums - loading items problem

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - loading items problem (https://www.eqemulator.org/forums/showthread.php?t=20364)

loading items problem

Hello, I setup a 6.6 server with no problem using the 3.0 server pack. Then I tried to update it to 7.0 with the 3.1 upgrade and now I get the error below with I run my server. How can I fix it?

From World.exe
[Status] Using database 'emusp3' at localhost:3306
[Status] EMuShareMem loaded
[Status] Loading items from database: count=46073
[Error] DBLoadItems query 'select source,itemclass,name,lore,idfile,id,weight,no
rent,nodrop,size,slots,price,icon,UNK012,UNK013,be nefitflag,tradeskills,cr,dr,pr
,mr,fr,astr,asta,aagi,adex,acha,aint,awis,hp,mana, ac,deity,skillmodvalue,UNK033,
skillmodtype,banedmgrace,banedmgamt,banedmgbody,ma gic,casttime_,reqlevel,bardtyp
e,bardvalue,light,delay,reclevel,recskill,elemdmgt ype,elemdmgamt,range,damage,co
lor,classes,races,UNK054,maxcharges,itemtype,mater ial,sellrate,UNK059,casttime,U
NK061,procrate,combateffects,shielding,stunresist, strikethrough,extradmgskill,ex
tradmgamt,spellshield,avoidance,accuracy,charmfile id,factionmod1,factionmod2,fac
tionmod3,factionmod4,factionamt1,factionamt2,facti onamt3,factionamt4,charmfile,a
ugtype,augslot1type,augslot1unk,augslot2type,augsl ot2unk,augslot3type,augslot3un
k,augslot4type,augslot4unk,augslot5type,augslot5un k,ldontheme,ldonprice,ldonsold
,bagtype,bagslots,bagsize,bagwr,book,booktype,file name,banedmgraceamt,augrestric
t,loregroup,pendingloreflag,artifactflag,summonedf lag,favor,fvnodrop,endur,dotsh
ielding,attack,regen,manaregen,enduranceregen,hast e,damageshield,recastdelay,rec
asttype,guildfavor,augdistiller,UNK123,UNK124,attu neable,nopet,UNK127,pointtype,
potionbelt,potionbeltslots,stacksize,notransfer,st ackable,UNK134,clickeffect,cli
cktype,clicklevel,clicklevel2,proceffect,proctype, proclevel,proclevel2,worneffec
t,worntype,wornlevel,wornlevel2,focuseffect,focust ype,focuslevel,focuslevel2,scr
olleffect,scrolltype,scrolllevel,scrolllevel2,upda ted from items order by id', #
1054: Unknown column 'augslot1unk' in 'field list'
[Error] If you got boat loads of errors, make sure you sourced: utils/items-0.6.
0-DR2-0.6.1-DR1-convert.sql

Error: EMuShareMem: DLLLoadItems: !cbDBLoadItems

Code:

ALTER TABLE items CHANGE loreflag loregroup int NOT NULL;

ALTER TABLE items CHANGE UNK117 UNK123 int NOT NULL;

ALTER TABLE items CHANGE UNK150 UNK157 int NOT NULL;

ALTER TABLE items CHANGE UNK145 UNK152 int NOT NULL;

ALTER TABLE items CHANGE UNK140 UNK147 int NOT NULL;

ALTER TABLE items CHANGE UNK135 UNK142 int NOT NULL;

ALTER TABLE items CHANGE UNK130 UNK137 int NOT NULL;

ALTER TABLE items CHANGE UNK124 UNK130 int NOT NULL;

ALTER TABLE items CHANGE UNK121 UNK127 int NOT NULL;

ALTER TABLE items CHANGE UNK118 UNK124 int NOT NULL;

ALTER TABLE items ADD augslot1unk int NOT NULL AFTER augslot1type;

ALTER TABLE items ADD augslot2unk int NOT NULL AFTER augslot2type;

ALTER TABLE items ADD augslot3unk int NOT NULL AFTER augslot3type;

ALTER TABLE items ADD augslot4unk int NOT NULL AFTER augslot4type;

ALTER TABLE items ADD augslot5unk int NOT NULL AFTER augslot5type;

ALTER TABLE items ADD enduranceregen int NOT NULL AFTER manaregen;

ALTER TABLE items ADD notransfer int NOT NULL AFTER stacksize;

ALTER TABLE items ADD UNK133 int NOT NULL AFTER notransfer;

ALTER TABLE items ADD UNK134 varchar(255) NOT NULL AFTER UNK133;

ALTER TABLE items CHANGE UNK130 potionbeltslots int NOT NULL;

ALTER TABLE items CHANGE UNK133 stackable int NOT NULL;

thank you, loads fine now with no errors.

Hmmm that is a bug with the installer upgrade... It should have removed the old items table and replaced it with the new. Thanks I'll look into the problem.

Edit: Fixed was a small error on my part. I'll re-upload tonight. You may want to re-run the installer upgrade once it's up there. It sources in the newest 13th floor items adding about 10k items or so.