No mobs, npc, or items?

[the2ndone]

I set my server up as it said in the how to setup a server with eqemu 5.x and for some reason I get no items, mobs, or npc? I see a few errors but I dont know where to start to fix them (outside of the guide)? I look for a while in the forums to find an answer but i dint see any thing of use.
Thank you in advance.


this is my world.exe

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.1
[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: ***********:9000
World server listening on: ***********:9000
Connected to LoginServer: eqlogin1.eqemulator.net:5997

[kai_shadowbane]

the general option would be to source in tcsmyworld's database if you want the mobs and such, since either you have an empty database there or there's an error with it.

[the2ndone]

In my c:\mysql\data\eq is 159 files and 1.77MB of data. I used the db.sql file that came ziped up in the 5.1 win zip.

2 more odd things are happeing too my server. It is locked till my zones fall a sleep and when its unlocked I can log into the server with in my lan but I cant log in outside of my lan?

[a_Guest03]

Your LAN problem is covered in the tutorials section. It is called NAT setup guide. You have a routing problem, and it can be corrected.

[omper]

Your problem with your MOBS not showing up is cuz you dont have any correctly placed..

You cant just go get any of Tcmysworld's DB filese and source them in.. There are different versions..
For instance if you try to use the 5.2 DB with the 5.0 server you would encounter similar problem to the one in your post. You need the correct coloum count in your db that the Server is looking for.

Now .. If i might suggest.. Search for Tcmysworld posts and look for some that match your Server environment. Then do the following..

Start-Run-Cmd
c:\????\> cd \mysql\bin

c:\mysql\bin> mysql -u root mysql

welcome to the MySQL monitor. Commands end with ; or \g
Your MySQL connection id is 13 to server version: 4.0.12-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer

mysql> drop database eq;
Query OK, 0 rows affected <0.13 sec>


mysql> create database eq;
Query OK, 1 row affected <0.00 sec)

mysql> use eq;
Database changed

mysql> source tcmysqorld5.0db.sql;

blah blah blah

ok .. done


ok that should give you his database for that server .. then go to the tutorial to change yourself to be a server op..

Omper

[the2ndone]

Ok thank you i'll give it a try

[the2ndone]

Ok I got no errors in the world.exe now and zones load up fast now.
But when I try to create a new char I get this error:

\0\0\0\0\0\0\0\0\0\0\0' WHERE account_id=1 AND name='Notcreated'' #1054: Unknown
column 'timelaston' in 'field list'
database.CreateCharacter failed
Got a bogus character (Notcreated), deleting it.
PP length =0
What I did was sourced a item dump sql file and my db.sql file. After that my old chars I had on the server were still there and able to log on but I cant make any new chars?
this is what my world exe looks like now

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.1
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=26489, max id=68199
[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
Please don't make me a levelme server. :(
TCP listening on: *********:9000
World server listening on: **********:9000
Connected to LoginServer: eqlogin1.eqemulator.net:5997
EDIT: 12\06\03
I fixed the char problem no I can create a char with the items they should come with. but I still have no mobs or npc? I'm going to keep trying till I get it.
I fixed it by sourceing the db.sql first (that came with the eqemu zip 5.1) then I sourced the update server.sql(also in the eqemu zip 5.1) and the last thing I did was sourced dumpeditems.sql I hope this info helps some one with the same problem.

[the2ndone]

I'm still having no npc or mobs can some one who was 5.1 runing with npc and mobs can you tell me what sql files you sourced?
Or maybe i skipped a step or something dumb I over looked?
Thanks

[Smarto]

Hello there!
As recently stated by someone else, no mobs are on your server because you don't have any in your database :).

See, when you loaded the itemsdump.sql or whatever its name is, that put all those items into the database.

So you need a database, for example, named monsters.sql so you have monsters on your server.

Now, tcsmyworld created an excellent database for 0.5.1.
Search around in the world building forums for his database. Then drop your current database and source his.

Hope this helps

[the2ndone]

Omper's post did help a lot but I still was not sure what db file I was looking for. I try a few before db files I reposted but I still had no luck but now I got a better idea what im looking for.
Thank you :D