World.EXE and DB problems

[darkdonno]

World Server Problems.

EQEMU = 0.6.0-DR1
Operating System: Windows
Database: 5.8 Classic (5.8-classic-1095550545.zip)
Perl - Installed = C:\perl\
Mysql - Installed = C:\mysql
Using MINILOGIN
Database Name = eq

Help would be much appreciated, thanks.

Below is the quote of what it said in my World.exe

[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.0-DR1
[Status] Loading variables..
[Status] Loading zones..
[Status] Clearing groups..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=34229, max id=77505
[Error] DBLoadItems query 'SELECT charges,unknown002,unknown003,merchantprice,un
known005,unknown006,unknown007,unknown008,itemclas s,name,lore,idfile,id,weight,n
orent,nodrop,attuneable,size,slots,cost,icon,unkno wn018,unknown019,unknown020,tr
adeskills,cr,dr,pr,mr,fr,astr,asta,aagi,adex,acha, aint,awis,hp,mana,ac,deity,ski
llmodvalue,skillmodtype,banedmgrace,banedmgamt,ban edmgbody,magic,casttime2,haste
proclvl,reqlevel,bardtype,bardvalue,light,delay,re clevel,recskill,elemdmgtype,el
emdmgamt,effecttype,range,damage,color,classes,rac es,unknown061,spellid,maxcharg
es,itemtype,material,sellrate,unknown067,casttime, unknown069,proc_rate_mod,focus
id,combateffects,shielding,stunresist,strikethroug h,combatskill,combatskilldmg,s
pellshield,avoidance,accuracy,unknown081,factionmo d1,factionmod2,factionmod3,fac
tionmod4,factionamt1,factionamt2,factionamt3,facti onamt4,charmfile,augtype,augsl
ot1type,augslot2type,augslot3type,augslot4type,aug slot5type,ldonpointtheme,ldonp
ointcost,ldonsold,bagtype,bagslots,bagsize,bagwr,u nknown105,booktype,filename,ba
nedmgamt2,augmentrestriction,loreflag,pendingloref lag,artifactflag,summonedflag,
tribute,gmflag,endur,dotshielding,attackbonus,hpre gen,manaregen,hastepercent,dam
ageshield,minstatus FROM items ORDER BY id', #1054: Unknown column 'attuneable'
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..
[Status] Loading EQ time of day..
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Warning: Pants may change during online play.
TCP listening on: 10.10.1.4:9000
World server listening on: 10.10.1.4:9000
Connected to LoginServer: 10.10.1.4:5999
390251 New TCP connection: 127.0.0.1:1388
New zoneserver: #1 127.0.0.1:1388
Zoneserver SetConnectInfo: 127.0.0.1:1388: 10.10.1.4:8780

[Laviathon]

ok this had worked for me but i am using 6.0 DR 2

open comand prompt and

do this

CD C:\mysql\bin

this

mysql -u root mysql

this

Use eq;

then these

ALTER TABLE `doors` CHANGE `liftheight` `door_param` INT(4)  DEFAULT "0" NOT NULL;

ALTER TABLE `doors` ADD `size` SMALLINT(5)  UNSIGNED DEFAULT "100" NOT NULL;

not 100% sure if this will work for you cuz of the diff versions but its worth a try ..

[darkdonno]

It did not work

I might have to try reloading the whole datebase.

[mrea]

the problem is your 'attuneable' column, it doesn't want to recognize it. I think there was a post about this before that may help you

[Cisyouc]

Originally Posted by mrea

the problem is your 'attuneable' column, it doesn't want to recognize it. I think there was a post about this before that may help you

Not quite.

 Unknown column 'attuneable' 
in 'field list'

It's looking for it and cannot find it.

ALTER TABLE items ADD COLUMN `attuneable` tinyint(3) unsigned NOT NULL default '0';

[mrea]

Oh, that always confused me. Whether it found it and didn't know what it was, or it wasn't there.

[darkdonno]

I have no error on my World.exe anymore

It look like taht fixed it


Thanks Cisyouc

[1Boppoom1]

still have an error and tried all the querys suggested....but im using kunark not classic any suggestions?

[Sarepean]

What error?

-Sarepean

[1Boppoom1]

#::EDITED::#
Ok i got this resolved not sure how but i did.

[Status] Loading items from database: count=36965, max id=77768
[Error] DBLoadItems query 'SELECT charges,unknown002,unknown003,merchantprice,un
known005,unknown006,unknown007,unknown008,itemclass,name,lore,idfile,id,weight,n
orent,nodrop,attuneable,size,slots,cost,icon,unknown018,unknown019,unknown020,tr
adeskills,cr,dr,pr,mr,fr,astr,asta,aagi,adex,acha,aint,awis,hp,mana,ac,deity,ski
llmodvalue,skillmodtype,banedmgrace,banedmgamt,banedmgbody,magic,casttime2,haste
proclvl,reqlevel,bardtype,bardvalue,light,delay,reclevel,recskill,elemdmgtype,el
emdmgamt,effecttype,range,damage,color,classes,races,unknown061,spellid,maxcharg
es,itemtype,material,sellrate,unknown067,casttime,unknown069,proc_rate_mod,focus
id,combateffects,shielding,stunresist,strikethrough,combatskill,combatskilldmg,s
pellshield,avoidance,accuracy,unknown081,factionmod1,factionmod2,factionmod3,fac
tionmod4,factionamt1,factionamt2,factionamt3,factionamt4,charmfile,augtype,augsl
ot1type,augslot2type,augslot3type,augslot4type,augslot5type,ldonpointtheme,ldonp
ointcost,ldonsold,bagtype,bagslots,bagsize,bagwr,unknown105,booktype,filename,ba
nedmgamt2,augmentrestriction,loreflag,pendingloreflag,artifactflag,summonedflag,
tribute,gmflag,endur,dotshielding,attackbonus,hpregen,manaregen,hastepercent,dam
ageshield,minstatus FROM items ORDER BY id', #1054: Unknown column 'unknown008'
in 'field list'
Error: EMuShareMem: DLLLoadItems: !cbDBLoadItems
[Error] Error: Could not load item data.  But ignoring

[Denethor72]

Having more or less the same problem; this is what mine is saying now..

[Error] DBLoadItems query 'SELECT gmflag,minstatus,unknown002,unknown005,unknown
107,unknown108,id,weight,norent,nodrop,size,itemcl ass,idfile,lore,slots,cost,nam
e,icon,unknown105,booktype,filename,bagtype,bagslo ts,bagsize,bagwr,augslot1type,
augslot2type,augslot3type,augslot4type,augslot5typ e,unknown018,unknown019,unknow
n020,casttime2,unknown061,unknown067,unknown069,un known070,unknown076,unknown077
,augtype,ldonpointtheme,ldonpointcost,unknown099,a str,asta,aagi,adex,awis,aint,a
cha,pr,mr,dr,fr,cr,skillmodvalue,skillmodtype,bane dmgamt,banedmgbody,banedmgrace
,magic,hasteproclvl,light,delay,effecttype,range,d amage,material,maxcharges,recl
evel,recskill,charmfile,factionmod1,factionmod2,fa ctionmod3,factionmod4,factiona
mt1,factionamt2,factionamt3,factionamt4,reqlevel,h p,mana,ac,color,classes,races,
spellid,casttime,focusid,itemtype,accuracy,avoidan ce,bardtype,bardvalue,combatef
fects,deity,elemdmgamt,elemdmgtype,sellrate,shield ing,spellshield,strikethrough,
stunresist,tradeskills FROM items ORDER BY id', #1054: Unknown column 'unknown10
7' in 'field list'

I tried using the tip from Cisyouc;
ALTER TABLE items ADD COLUMN `attuneable` tinyint(3) unsigned NOT NULL default '0';
changing the column name to unknown107, but it keeps giving me a syntax error. What am I missing here; I'm using the 5.8 classic db and trying to use the 5.5 EQEmu.

[HurtinuDaily]

Any chance you could use Mysq Front to check and see what fields you have in your items table, appears as tho you are missing a whole pile of fields(all of them). Does the database you loaded even include items? If it doesnt you may want to load the 13thfloor items.