EQEmulator Forums - Problem with loading server

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

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Problem with loading server (https://www.eqemulator.org/forums/showthread.php?t=35814)

Problem with loading server

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)

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!

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.

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.

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. */

Im using mysql 5.5 maybe I should try another version?

I installed Wamp which comes with MySQL 5.5, PHP, and Apache (The apache and PHP I'm using for PEQ Editor) and so far it works great with 5.5.

Are you using Windows 7?
Make sure you have the most current PEQDB files. Mine was Rev2214 I think.

I placed mine in a folder on my desktop.
If your using windows 7 you can "hold shift" then right click on the folder then click on Command prompt. That will open you command prompt on that folder. In the command prompt type this:

Code:

mysql -uroot -p

you will see MqSQL start up and ask for a "password:"
Enter your password then you will see this:

Code:

mysql>

Then type your peq database name like this:

Code:

mysql> use peq

Then it should say changed to peq or using peq or something like that.

then:

Code:

source peqdb_rev2214.sql



then



source load_player.sql



and/if



load_bots.sql

the rest are the update files in your "EQEmu\util\sql" folder
any of the numbers higher then your rev are updates and you can use you 3rd party program to source them in real fast. Also check out Navicat. I tend to use it more then Heidi though I use both of them I like Navicat much better.

I didn't use the Bot release so never sourced it in. and also make sure the peqdb_rev sql file is in the same folder as the other sql files you just downloaded.

as long as you have the most resent things you shouldn't have a problem.

thanks will try that again. Just found this people have had the same problem.
http://www.eqemulator.org/forums/showthread.php?t=29784

Before you sourced the load_player.sql did you open the file and set the correct file paths?

By default it will look something like this:

source player_tables/aa_timers.sql;
source player_tables/account.sql;
source player_tables/account_ip.sql;
source player_tables/account_rewards.sql;

But in order for it to work it should look similar to this:

source C:/Temp/player_tables/aa_timers.sql;
source C:/Temp/player_tables/account.sql;
source C:/Temp/player_tables/account_ip.sql;
source C:/Temp/player_tables/account_rewards.sql;

and i did this but still will not work for me.

I changed load_player back to source/player_tables and did the shift right click thing and it worked, thanks, but gave an error on loading the bots but thats ok, more worried about getting the server up and running first. Now to try to run it and see what happens.

Nope with the most resent rev of the peqdb I didn't have to change anything. I don't know about the bots sql, didn't use it.

But the players sql and the actual rev I never had a prob on at all. I have tweeked my db so many time in the last week getting the way I want it or tring different things that I have had to source / back it up several times. never with any problems.

very important to be in the same directory as your sql files when you open your command prompt and start mysql.

getting zone: dynamic_01 reported state start then stopped over and over again. wont go past that first zone, I used 2214 db.

Don't know what to tell you then. I did tweek my stuff once and had to redo parts of it. I forgot to do something but I can't remember and I kept getting the stop / start state over and over....
It had to do witht he DB to.. sorry, just can't remember what it was but I did figure it out.. and it was a DOH moment. Palm to forehead. I just wish I knoew what to tell ya.

Thank you for your help you have been very helpful, going to fiddle with it some more maybe start over and try that. Thank you.

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.

C:\EQEmu>zone.exe
[Debug] Starting Log: logs/eqemu_debug_zone_101788.log
[Debug] [ZONE__INIT] Loading server configuration..
[Debug] [ZONE__INIT] Log settings loaded from log.ini
[Debug] [ZONE__INIT] Connecting to MySQL...
[Status] Starting Log: logs/eqemu_zone_101788.log
[Status] Using database 'peq' at localhost:3306
[Debug] [ZONE__INIT] CURRENT_ZONE_VERSION: EQEmulator 0.8.0
[Debug] [ZONE__INIT] Log settings loaded from ./log.ini
[Debug] [ZONE__INIT] Mapping Incoming Opcodes
[Debug] [ZONE__INIT] Loading Variables
[Debug] [ZONE__INIT] Loading zone names
Error in LoadZoneNames query 'SELECT MAX(zoneidnumber) FROM zone' #1146: Table '
peq.zone' doesn't exist
[Debug] [ZONE__INIT] Loading items
[Status] EMuShareMem loaded
Error in GetItemsCount query 'SELECT MAX(id),count(*) FROM items' #1146: Table '
peq.items' doesn't exist
Error: SharedDatabase::LoadItems() (sharemem): GetItemsCount() returned -1
[Debug] [ZONE__INIT_ERR] Loading items FAILED!
Got this after opening command prompt in my server folder and typing zone.exe. Anybody have any ideas I have no idea what it means.

[Debug] [ZONE__INIT] Failed. But ignoring error and going on...
Error in LoadItemStatus query: 'Select id, minstatus from items where minstatus
> 0'
[Debug] [ZONE__INIT] Loading npc faction lists
Error in GetNPCFactionListsCount query 'SELECT MAX(id), count(*) FROM npc_factio
n' #1146: Table 'peq.npc_faction' doesn't exist
Error: SharedDatabase::LoadNPCFactionLists-ShareMem: GetNPCFactionListsCount() r
eturned < 0
[Debug] [ZONE__INIT_ERR] Loading npcs faction lists FAILED!

C:\EQEmu>