PDA

View Full Version : World.EXE and DB problems


darkdonno
11-06-2004, 06:09 PM
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
11-06-2004, 06:44 PM
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
11-06-2004, 08:58 PM
It did not work

I might have to try reloading the whole datebase.

mrea
11-07-2004, 01:22 AM
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
11-07-2004, 04:49 AM
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 youNot 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
11-07-2004, 04:57 AM
Oh, that always confused me. Whether it found it and didn't know what it was, or it wasn't there.

darkdonno
11-08-2004, 09:38 PM
I have no error on my World.exe anymore

It look like taht fixed it


Thanks Cisyouc

1Boppoom1
11-15-2004, 06:37 PM
still have an error and tried all the querys suggested....but im using kunark not classic any suggestions?

Sarepean
11-16-2004, 12:22 AM
What error?

-Sarepean

1Boppoom1
11-16-2004, 02:53 AM
#::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,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 'unknown008'
in 'field list'
Error: EMuShareMem: DLLLoadItems: !cbDBLoadItems
[Error] Error: Could not load item data. But ignoring

Denethor72
02-08-2006, 08:01 AM
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
02-10-2006, 03:41 AM
Any chance you could use Mysq Front (http://www.mysqlfront.de/download.html) 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.