Database Error

[Cari_Moon]

I'm using the database MW_057DR2_alpha_1.sql

this is my world.exe output:

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.7-DR6
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=28731, max id=69304
[Error] DBLoadItems query 'SELECT charges,unknown002,unknown003,merchantprice,un
known005,unknown006,unknown007,unknown008,itemclas s,name,lore,idfile,id,weight,n
orent,nodrop,size,slots,cost,icon,unknown018,unkno wn019,unknown020,tradeskills,c
r,dr,pr,mr,fr,astr,asta,aagi,adex,acha,aint,awis,h p,mana,ac,deity,skillmodvalue,
skillmodtype,banedmgrace,banedmgamt,banedmgbody,ma gic,casttime2,hasteproclvl,req
level,bardtype,bardvalue,light,delay,reclevel,recs kill,elemdmgtype,elemdmgamt,ef
fecttype,range,damage,color,classes,races,unknown0 61,spellid,maxcharges,itemtype
,material,sellrate,unknown067,casttime,unknown069, proc_rate_mod,focusid,combatef
fects,shielding,stunresist,strikethrough,combatski ll,combatskilldmg,spellshield,
avoidance,accuracy,unknown081,factionmod1,factionm od2,factionmod3,factionmod4,fa
ctionamt1,factionamt2,factionamt3,factionamt4,char mfile,augtype,augslot1type,aug
slot2type,augslot3type,augslot4type,augslot5type,l donpointtheme,ldonpointcost,ld
onsold,bagtype,bagslots,bagsize,bagwr,unknown105,b ooktype,filename,banedmgamt2,a
ugmentrestriction,loreflag,pendingloreflag,artifac tflag,summonedflag,tribute,gmf
lag,endur,dotshielding,attackbonus,hpregen,manareg en,hastepercent,damageshield,m
instatus FROM items ORDER BY id', #1054: Unknown column 'charges' 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..
[Error] Could not load EQTime file ./eqtime.cfg
[Error] Unable to load ./eqtime.cfg
[Status] Reboot zone modes ON
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Formatting drive C:
TCP listening on: 99.99.999.999:9000
World server listening on: 99.99.999.999:9000
Connected to LoginServer: eqemulator.net:5995

[jimbox114]

I had that problem. I ran the following from mysql and it worked after that:

ALTER TABLE `npc_types` ADD `AC` smallint(5) not null default 0;
ALTER TABLE items ADD unknown008 INT(11) DEFAULT "0" NOT NULL;

[Melwin]

WRONG. FORUM.

Moved to Win32 Support. Ask your goddamn server questions in Win32 server support.

[Cari_Moon]

mysql> ALTER TABLE `npc_typs` ADD `AC` smallint(5) not null default 0;
ERROR 1146: Table 'eq2.npc_typs' doesn't exist

[Cari_Moon]

I did what jimbox114 said to do but i still get this world.exe output:

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.7-DR6
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=28731, max id=69304
[Error] DBLoadItems query 'SELECT charges,unknown002,unknown003,merchantprice,un
known005,unknown006,unknown007,unknown008,itemclas s,name,lore,idfile,id,weight,n
orent,nodrop,size,slots,cost,icon,unknown018,unkno wn019,unknown020,tradeskills,c
r,dr,pr,mr,fr,astr,asta,aagi,adex,acha,aint,awis,h p,mana,ac,deity,skillmodvalue,
skillmodtype,banedmgrace,banedmgamt,banedmgbody,ma gic,casttime2,hasteproclvl,req
level,bardtype,bardvalue,light,delay,reclevel,recs kill,elemdmgtype,elemdmgamt,ef
fecttype,range,damage,color,classes,races,unknown0 61,spellid,maxcharges,itemtype
,material,sellrate,unknown067,casttime,unknown069, proc_rate_mod,focusid,combatef
fects,shielding,stunresist,strikethrough,combatski ll,combatskilldmg,spellshield,
avoidance,accuracy,unknown081,factionmod1,factionm od2,factionmod3,factionmod4,fa
ctionamt1,factionamt2,factionamt3,factionamt4,char mfile,augtype,augslot1type,aug
slot2type,augslot3type,augslot4type,augslot5type,l donpointtheme,ldonpointcost,ld
onsold,bagtype,bagslots,bagsize,bagwr,unknown105,b ooktype,filename,banedmgamt2,a
ugmentrestriction,loreflag,pendingloreflag,artifac tflag,summonedflag,tribute,gmf
lag,endur,dotshielding,attackbonus,hpregen,manareg en,hastepercent,damageshield,m
instatus FROM items ORDER BY id', #1054: Unknown column 'charges' 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..
[Error] Could not load EQTime file ./eqtime.cfg
[Error] Unable to load ./eqtime.cfg
[Status] Reboot zone modes ON
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Abort/retry/cancel?
TCP listening on: 99.99.999.999:9000
World server listening on: 99.99.999.999:9000
Connected to LoginServer: eqemulator.net:5995

[sotonin]

no, you mispelled it. double check your shit, re-read it and copy and paste. refuse to help idiots )

ur using an incompatible items table for whatever source you're using.

[Darkwaters]

Cari which version of CVS are you using and I'm talking about date or site gathered from (ie. is this blastoma's and 7/31/04)?
I'm asking this because obviously from your output you did not use the itemtablechanges.sql from 7/31/04 source code which it adds "charges" a few others and updates a few.

Just a thought but even with your typo's your not going to get the db up and running without the itmetablechanges.sql file found in the 7/31/04 source code.

Darkwaters

[Cari_Moon]

no cvs

[hypershadow66]

Originally Posted by Cari_Moon

no cvs

Didnt i give you the compiles that i made?? if you where using those, then its from 7/31 . if you got compiles from somewhere/someone else also then i dont know.