EQEmulator Forums - Ok I need some help with my DB..

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Server Discussion (https://www.eqemulator.org/forums/forumdisplay.php?f=614)

- - Ok I need some help with my DB.. (https://www.eqemulator.org/forums/showthread.php?t=12020)

Ok I need some help with my DB..

K I got everything setup ok, I can log into the server selection and my server is there finally. WOOHOO!

But it says it is locked .. and in the loginserver.ini file it says

Quote:

Locked=false

This really isnt my problem it is just one thing I think the problem is causing if that is linked to the db I have.

Quote:

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.3-DR3
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=0, max id=0
[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: 127.0.0.1:9000
World server listening on: 127.0.0.1:9000
Connected to LoginServer: 127.0.0.1:5999

I think its because of the version of the DB.sql but I am not sure I am a bit new to all of this.

I would greatly apreciate any help I can get and here are a few things that may help.

Running windows xp pro
and the db I am using inside says

Quote:

EQEmu 0.5.0 Database

that imho is the problem but I cant find a updated one that may be all I need though thanks :D

download the items and source it in

I did download items and source them in

Just not sure if I got the right version and where to download the right version :roll:

Quote:

and the db I am using inside says
Quote:
EQEmu 0.5.0 Database

Actually that is your problem. Go to the world building forum there are stickys that link to newer DB's for you to use. You are trying to use a DB that is NOT compatible with the version of server you are using.

[edit] Oh, and if you use MW DB it is more of a complete db (read, you dont have to source the dumpeditems.sql in)

Thanks for the help I am going to check that out right now

Going to check out that world building forum...and the link you gave me badil I think that is for linux... or maybe a compression I dont have software that will support it :?

I will edit in my results shortly :)

[edit] I take back what I said about the linux format found a prog that supports it :)

try getting winace or winrar..they will open it.

Alright thanks a million

K got it all to work up to my login so thanks for that :D

Now all I have to deal with is the.... dreaded Error #1017 NOOOO!

Looking for the fix to that now any suggestions would be great.

wait for 5.5 to be released..current eqlive and emu not compatible

Thanks for the help everybody hopefully I will be playing on my server when the 5.5 comes out.

Oh yea do I have to redo the database or can I just source the new db or do I have to drop my eq database?

Same one no DB changes with 5.5

there was a small patch on shawns site. nothing too big..like 4 lines altered

Thanks and I had another idea come to me my ex-girlfriend who I am still friends with hasnt played eq in a few weeks because she hasnt put her account back up and I think it was before the doomsday that she last updated so does the DB I am using support everything predoomsday?