Need DB help.

[Tarnien]

I am using MW_051DR2_alpha1 database atm..

I keep getting this in World.exe whenever I open it.

**********************************

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.2
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=1, max id=1
[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 'casttime2
' 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
Breaking bards...done
TCP listening on: 192.168.1.108:9000
World server listening on: 192.168.1.108:9000
Connected to LoginServer: eqlogin1.eqemulator.net:5997

**********************************

Everything on my server works besides the items :/
If anyone knows how to fix this problem please help!
I have used like 5 other DB's and I get the same message everytime in World.exe.

[Kroeg]

try sourcing in the newest item dump, and this may help your problem.

[Joshjje]

Download: http://npcmovdb.eqemulator.net/MW_051_052_alpha1.zip

Either open mysql.exe or if that doesnt work (like if you get an access denied error) open up a cmd prompt and type:

mysql -u root mysql

After you get to the mysql prompt type:

drop database eq;
create database eq;
use eq;

Now copy the MW_051_052_alpha1.sql file to the c:\mysql\bin folder

Now type:

source MW_051_052_alpha1.sql
quit

that should fix it.

[Tarnien]

I'll try that, thanks.

[El_Labero]

@joshjje
got the same error and get it after your instruction finally to word, but there is still a eqtime file error, is this another DB Problem?

[Tarnien]

It worked... everything is fine now ;) but i think people cant log on my server still... ill have to fool aroundw ith some stuff

[Tattered]

This actually solved my problem as well, thank you for answering this post. :oops:

[eristole]

you rock!
thanks man,
board trolling like a mo fo helps because of people like you!