Issues setting up a Windows server

[AdrianD]

Greetings.

I am having problems getting my server going. I am, by no means, an expert. I have been using this guide, http://www.eqemulator.net/wiki/wikka.php?wakka=WindowsServerSetupGuide, and realize it's outdated and have made some adjustments concerning the database. I also used information from this wiki: https://github.com/EQEmu/Server/wiki/PEQ-Setup-using-XAMPP

I start it up with a batch file..

@echo off
shared_memory.exe
start world.exe
echo waiting for the world to finish before starting zone...
ping -n 10 127.0.0.1 > nul
start queryserv.exe
start ucs.exe
start eqlaunch.exe zone
exit

I get this log...

eqemu_error_world_####

---------------------------------------------
[12.27. - 15:30:43] Starting Log: logs/eqemu_error_world_5824.log
[12.27. - 15:30:43] Error Loading Items: EQEmu Exception (Shared Memory) in ..\..\common\memory_mapped_file.cpp at line (112): Could not open the file to find the existing file size.
[12.27. - 15:30:43] Error in AdventureManager:::LoadAdventures: SELECT id, zone, zone_version, is_hard, min_level, max_level, type, type_data, type_count, assa_x, assa_y, assa_z, assa_h, text, duration, zone_in_time, win_points, lose_points, theme, zone_in_zone_id, zone_in_x, zone_in_y, zone_in_object_id, dest_x, dest_y, dest_z, dest_h, graveyard_zone_id, graveyard_x, graveyard_y, graveyard_z, graveyard_radius FROM adventure_template (#1146: Table 'peq.adventure_template' doesn't exist)
[12.27. - 15:30:43] Error in AdventureManager:::LoadAdventureEntries: SELECT id, template_id FROM adventure_template_entry (#1146: Table 'peq.adventure_template_entry' doesn't exist)

plus many of these logs, all the same...

eqemu_error_zone_####

---------------------------------------------
[12.27. - 15:30:59] Starting Log: logs/eqemu_error_zone_2072.log
[12.27. - 15:30:59] Error Loading Items: EQEmu Exception (Shared Memory) in ..\..\common\memory_mapped_file.cpp at line (112): Could not open the file to find the existing file size.
[12.27. - 15:30:59] Error Loading npc factions: EQEmu Exception (Shared Memory) in ..\..\common\memory_mapped_file.cpp at line (112): Could not open the file to find the existing file size.

Basically, everything is an error. I'm very green when it comes to this stuff although I have searched as much as my sanity would allow to rectify this on my own.

I would like some help.

Thanks

[lerxst2112]

Did you make a shared directory in your server directory for shared_memory to save the files to?

[AdrianD]

I have c:\EQ\EQEmuServer\Shared but, there is nothing in the folder. That folder was there after following the steps. The .bat file and the rest of the apps are in the same EQEmuServer folder.

[lerxst2112]

What happens if you just run shared_memory from a command prompt? Any errors? It also looks like your database isn't setup properly so that may be the root cause.

[AdrianD]

After I clicked to run the app in the folder (shared_memory), this log arrived...

---------------------------------------------
[12.28. - 16:48:14] Starting Log: logs/eqemu_error_shared_memory_0752.log
[12.28. - 16:48:14] Error in GetItemsCount 'SELECT MAX(id), count(*) FROM items': '#1146: Table 'peq.items' doesn't exist'
[12.28. - 16:48:14] EQEmu Exception (Shared Memory) in ..\..\shared_memory\items.cpp at line (35): Unable to get any items from the database.

I don't have a lot of knowledge about this stuff but I can read and follow directions quite well. Please help.

[lerxst2112]

Your database isn't sourced correctly, or it is not named peq and you need to fix the name in your config file.