Problem with loading server

[maya6man24]

Hi all I have compiled and sourced everything and when i click on start.bat I get this.

---------------------------------------------
[09.30. - 18:26:52] Starting Log: logs/eqemu_debug_world_92632.log
[09.30. - 18:26:52] [WORLD__INIT] Loading server configuration..
[09.30. - 18:26:52] [WORLD__INIT] Log settings loaded from log.ini
[09.30. - 18:26:52] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEmulator 0.8.0
[09.30. - 18:26:52] [WORLD__INIT] Added loginserver eqemulator.net:5998
[09.30. - 18:26:52] [WORLD__INIT] Connecting to MySQL...
[09.30. - 18:26:52] [WORLD__INIT] HTTP world service disabled.
[09.30. - 18:26:52] [WORLD__INIT] Loading variables..
[09.30. - 18:26:52] [WORLD__INIT] Loading zones..
[09.30. - 18:26:52] [WORLD__INIT] Clearing groups..
[09.30. - 18:26:52] [WORLD__INIT] Clearing raids..
[09.30. - 18:26:52] [WORLD__INIT] Loading items..
[09.30. - 18:26:52] [WORLD__INIT_ERR] Error: Could not load item data. But ignoring
[09.30. - 18:26:52] [WORLD__INIT] Loading guilds..
[09.30. - 18:26:52] [WORLD__INIT] Loaded default rule set 'default'
[09.30. - 18:26:52] [WORLD__INIT] Clearing temporary merchant lists..
[09.30. - 18:26:52] [WORLD__INIT] Loading EQ time of day..
[09.30. - 18:26:52] [WORLD__INIT] Loading launcher list..
[09.30. - 18:26:52] [WORLD__INIT] Reboot zone modes ON
[09.30. - 18:26:52] [WORLD__INIT] Deleted 0 stale player corpses from database
[09.30. - 18:26:52] [WORLD__INIT] Deleted 0 stale player backups from database
[09.30. - 18:26:52] [WORLD__INIT] Loading adventures...
[09.30. - 18:26:52] [WORLD__INIT_ERR] Unable to load adventure templates.
[09.30. - 18:26:52] [WORLD__INIT_ERR] Unable to load adventure templates.
[09.30. - 18:26:52] [WORLD__INIT] Purging expired instances
[09.30. - 18:26:52] [WORLD__INIT] Loading char create info...
[09.30. - 18:26:52] [WORLD__INIT] Zone (TCP) listener started.
[09.30. - 18:26:52] [WORLD__INIT] Client (UDP) listener started.
[09.30. - 18:26:52] [NET__IDENTIFY] Registered patch 6.2
[09.30. - 18:26:52] [NET__IDENTIFY] Registered patch Titanium
[09.30. - 18:26:52] [NET__IDENTIFY] Registered patch SoF
[09.30. - 18:26:52] [NET__IDENTIFY] Registered patch SoD
[09.30. - 18:26:52] [NET__IDENTIFY] Registered patch Underfoot
[09.30. - 18:26:52] [WORLD__LS] Connecting to login server: eqemulator.net:5998
[09.30. - 18:26:52] [WORLD__LS] Connected to Loginserver: eqemulator.net:5998
[09.30. - 18:26:52] [WORLD__LS] Loginserver provided 98.16.213.96 as world address
[09.30. - 18:27:01] [WORLD__ZONE] New TCP connection from 127.0.0.1:58637
[09.30. - 18:27:01] [WORLD__CONSOLE] New launcher from 127.0.0.1:58637
[09.30. - 18:27:01] [WORLD__LAUNCH] Adding pending launcher 1
[09.30. - 18:27:01] [WORLD__LAUNCH] Launcher Identified itself as 'zone'. Loading zone list.
[09.30. - 18:27:01] [WORLD__LAUNCH] Removing pending launcher 1. Adding zone to active list.
[09.30. - 18:27:06] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (1 starts)
[09.30. - 18:27:08] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (1 starts)
[09.30. - 18:27:26] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (2 starts)
[09.30. - 18:27:28] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (2 starts)
[09.30. - 18:27:46] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (3 starts)
[09.30. - 18:27:48] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (3 starts)
[09.30. - 18:28:06] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (4 starts)
[09.30. - 18:28:08] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (4 starts)
[09.30. - 18:28:26] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (5 starts)
[09.30. - 18:28:28] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (5 starts)

[maya6man24]

and this

---------------------------------------------
[09.30. - 18:28:06] Starting Log: logs/eqemu_debug_zone_86216.log
[09.30. - 18:28:06] [ZONE__INIT] Loading server configuration..
[09.30. - 18:28:06] [ZONE__INIT] Log settings loaded from log.ini
[09.30. - 18:28:06] [ZONE__INIT] Connecting to MySQL...
[09.30. - 18:28:06] [ZONE__INIT] CURRENT_ZONE_VERSION: EQEmulator 0.8.0
[09.30. - 18:28:06] [ZONE__INIT] Log settings loaded from ./log.ini
[09.30. - 18:28:06] [ZONE__INIT] Mapping Incoming Opcodes
[09.30. - 18:28:06] [ZONE__INIT] Loading Variables
[09.30. - 18:28:06] [ZONE__INIT] Loading zone names
[09.30. - 18:28:06] [ZONE__INIT] Loading items
[09.30. - 18:28:06] [ZONE__INIT_ERR] Loading items FAILED!
[09.30. - 18:28:06] [ZONE__INIT] Failed. But ignoring error and going on...
[09.30. - 18:28:06] [ZONE__INIT] Loading npc faction lists
[09.30. - 18:28:06] [ZONE__INIT_ERR] Loading npcs faction lists FAILED!

[chrismed0]

what are you compiling with VS 2010? 08? 12?
I see you got EQEmu 0.8.0
Did you get follow this guide carefully?
http://www.eqemulator.org/forums/showthread.php?t=32980

Copy all the right files?

When you compiled (the new SVN for the server files) did you get 6 success 0 fails?

Did you make sure it was set to 32 bit or 64 bit?

Just walk through your steps one at a time starting at the begining. I'm sure you might have just missed something. I find when I miss something or forget I usualy have a "DOH!" moment.

I would suggest to using VS2010 it seems to work the best.
also not sure about the perl think I used Perl 5.12 for the 32 bit.
And it doesn't seem to matter on the MySQL, I'm using 5.5 that comes with Wamp.

The only other major thing is making sure you have all the right files copies from the right folders and make sure you have your server config file configured correctly. If you do everthing right shouldn't have any problems. I found it much easier to do now then a few years ago. There was A LOT more steps.

[maya6man24]

Thank you for your reply, yes i am using vs 2010 and tried perl 514 but recieved 512.dll error so I installed perl 512 and no problems. I followed that guide religously, I have used it before. Everything compiled fine 6 successful and no errors. I did have to source load_player and bots from Hiedsql because I could not get it to work in command prompt.

[maya6man24]

just figured it out, turns out i did not hit execute when i loaded load_player.sql and bots. This is what i got inside Hiedsql

/* Loading file "C:\peqdb\load_player.sql" (2.7 KB) into query tab #1 ... */
source player_tables/aa_timers.sql;
/* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'source player_tables/aa_timers.sql' at line 1 */
/* 0 rows affected, 0 rows found. Duration for 0 of 68 queries: 0.000 sec. */

[maya6man24]

Im using mysql 5.5 maybe I should try another version?

[lerxst2112]

You never need to change those filepaths, you just need to execute the source command while in the proper directory so the relative paths are correct.

[lerxst2112]

Your database is all sorts of broken. Not sure if you didn't end up sourcing anything or if your database just isn't named peq.

[maya6man24]

I fixed it so far, I re downloaded the database, I also tried waamp but i could not shift right click and login to mysql I wound up downloading mysql5.1 and placing the files and database in c:\mysql worked perfectly.

[maya6man24]

It worked I have it up and running now! Thanks for the help everyone.