EQEmulator Forums - Database Error

If you are getting the following error please see below:

Quote:

[Error] DBLoadItems query 'SELECT charges,unknown002,unknown003,merchantprice,unknow n005,unknown006,unknown007,SpellCharges,itemclass, name,lore,idfile,id,weight,norent,nodrop,attuneabl e,size,slots,cost,icon,unknown018,unknown019,unkno wn020,tradeskills,cr,dr,pr,mr,fr,astr,asta,aagi,ad ex,acha,aint,awis,hp,mana,ac,deity,skillmodvalue,s killmodtype,banedmgrace,banedmgamt,banedmgbody,mag ic,casttime2,hasteproclvl,reqlevel,bardtype,bardva lue,light,delay,reclevel,recskill,elemdmgtype,elem dmgamt,effecttype,range,damage,color,classes,races ,unknown061,spellid,maxcharges,itemtype,material,s ellrate,unknown067,casttime,unknown069,proc_rate_m od,focusid,combateffects,shielding,stunresist,stri kethrough,combatskill,combatskilldmg,spellshield,a voidance,accuracy,unknown081,factionmod1,factionmo d2,factionmod3,factionmod4,factionamt1,factionamt2 ,factionamt3,factionamt4,charmfile,augtype,augslot 1type,augslot2type,augslot3type,augslot4type,augsl ot5type,ldonpointtheme,ldonpointcost,ldonsold,bagt ype,bagslots,bagsize,bagwr,unknown105,booktype,fil ename,banedmgamt2,augmentrestriction,loreflag,pend ingloreflag,artifactflag,summonedflag,tribute,gmfl ag,endur,dotshielding,attackbonus,hpregen,manarege n,hastepercent,damageshield,minstatus FROM items ORDER BY id', #1054: Unknown column 'unknown002' in 'field list'[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;
Error: EMuShareMem: DLLLoadItems: !cbDBLoadItems
[Error] Error: Could not load item data. But ignoring

Start -> Run -> cmd

Code:

cd\mysql\bin

mysql -u root

use dbname;

Then use these commands to correct the error:

Code:

ALTER TABLE `items` ADD `unknown002` INT NOT NULL;

Code:

ALTER TABLE `items` ADD `unknown003` INT NOT NULL;

Code:

ALTER TABLE `items` ADD `unknown005` INT NOT NULL;

Code:

ALTER TABLE `items` ADD `unknown007` INT NOT NULL;

Code:

ALTER TABLE `items` ADD `unknown018` INT NOT NULL;

Code:

ALTER TABLE `items` ADD `unknown019` INT NOT NULL;

Code:

ALTER TABLE `items` ADD `unknown020` INT NOT NULL;

Code:

ALTER TABLE `items` ADD `unknown061` INT NOT NULL;

Code:

ALTER TABLE `items` ADD `unknown067` INT NOT NULL;

Code:

ALTER TABLE `items` ADD `unknown069` INT NOT NULL;

Code:

ALTER TABLE `items` ADD `unknown081` INT NOT NULL;

Code:

ALTER TABLE `items` ADD `unknown105` INT NOT NULL;

I stumbled accross this error myself and with the help of RangerDown figured out a quick and painless solution. To anybody who is recieving this error, here is your fix.