Error when starting world.exe

[BLOOD_kane]

Ok I followed the setup EXACTLY how it shows in the guides to setup a server and it all goes GREAT until I start world.exe and this shows up:



I blurred out my IP addy (of course) but those errors I get, I can STILL connect to the login server, and when I run Boot5Zones.bat they run good, and go into sleeping mode, but when I logon to EQEMu servers it shows my server as LOCKED and I cannot logon.

I use WinXP so I checked to see if my firewall was on and it WAS NOT. Then after a while the boot5zones will give an error about not finding the items etc. etc.

Any advice?

[koad]

look at the error, theres a field missing fromyour items table. what db did you source?

[BLOOD_kane]

eq and its the one I copied into my /bin folder from the EQEMu folder... the db.dql

[BLOOD_kane]

sorry to bump but I still need help!

use a newer DB

[Scorpious2k]

I think Myra still has the latest db.sql file for download at http://www.bossmob.com/Myra but you will also need a mobs DB (Myra has that DB at her web site too) and items, which you get from a link from the eqemu news page.

[BLOOD_kane]

just downloaded that and it STILL gives me the same problem :(

[Tertiary]

Originally Posted by BLOOD_kane

eq and its the one I copied into my /bin folder from the EQEMu folder... the db.dql

Did you go into mysql and source the db in ? Copying into your '/bin' directory won't achieve anything.

[BLOOD_kane]

yes i followed the instructions by the letter

could also be you are using older binaries.

[BLOOD_kane]

i can get on my server, set myself as a SysOp, I can spawn NPC's, the world itself IS SPAWNED, but the only thing missing is items...It must be somthing with the items db that is screwing up

Also when I try to load Myra's Items from that website (to try and see if those will work) this happens:

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\MARCUS>cd\program files\mysql\bin

C:\Program Files\mysql\bin>mysql -u root mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.16-nt

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

mysql> use eq;
Database changed
mysql> source MyraItems.sql;
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1

the error 1136 just goes on and on and makes my PC shriek a God awful noise...