Dynamic starts then stops...Help?!

sheir96 · #1 01-26-2012, 06:19 AM

---------------------------------------------
[01.26. - 01:57:40] Starting Log: logs/eqemu_debug_world_3756.log
[01.26. - 01:57:40] [WORLD__INIT] Loading server configuration..
[01.26. - 01:57:40] [WORLD__INIT] Warning: Unable to read log.ini
[01.26. - 01:57:40] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEmulator 0.8.0
[01.26. - 01:57:40] [WORLD__INIT] Added loginserver 127.0.0.1:5999
[01.26. - 01:57:40] [WORLD__INIT] Connecting to MySQL...
[01.26. - 01:57:40] [WORLD__INIT] HTTP world service disabled.
[01.26. - 01:57:40] [WORLD__INIT] Loading variables..
[01.26. - 01:57:40] [WORLD__INIT] Loading zones..
[01.26. - 01:57:40] [WORLD__INIT] Clearing groups..
[01.26. - 01:57:40] [WORLD__INIT] Clearing raids..
[01.26. - 01:57:40] [WORLD__INIT] Loading items..
[01.26. - 01:57:40] [WORLD__INIT_ERR] Error: Could not load item data. But ignoring
[01.26. - 01:57:40] [WORLD__INIT] Loading guilds..
[01.26. - 01:57:40] [WORLD__INIT] Loaded default rule set 'default'
[01.26. - 01:57:40] [WORLD__INIT] Clearing temporary merchant lists..
[01.26. - 01:57:40] [WORLD__INIT] Loading EQ time of day..
[01.26. - 01:57:41] [WORLD__INIT_ERR] Unable to load eqtime.cfg
[01.26. - 01:57:41] [WORLD__INIT] Loading launcher list..
[01.26. - 01:57:41] [WORLD__INIT] Reboot zone modes ON
[01.26. - 01:57:41] [WORLD__INIT] Deleted 0 stale player corpses from database
[01.26. - 01:57:41] [WORLD__INIT] Deleted 0 stale player backups from database
[01.26. - 01:57:41] [WORLD__INIT] Loading adventures...
[01.26. - 01:57:41] [WORLD__INIT_ERR] Unable to load adventure templates.
[01.26. - 01:57:41] [WORLD__INIT_ERR] Unable to load adventure templates.
[01.26. - 01:57:41] [WORLD__INIT] Purging expired instances
[01.26. - 01:57:41] [WORLD__INIT] Loading char create info...
[01.26. - 01:57:41] [WORLD__INIT] Zone (TCP) listener started.
[01.26. - 01:57:41] [WORLD__INIT] Client (UDP) listener started.
[01.26. - 01:57:41] [NET__IDENTIFY] Registered patch 6.2
[01.26. - 01:57:41] [NET__IDENTIFY] Registered patch Titanium
[01.26. - 01:57:41] [NET__IDENTIFY] Registered patch SoF
[01.26. - 01:57:41] [NET__IDENTIFY] Registered patch SoD
[01.26. - 01:57:41] [NET__IDENTIFY] Registered patch Underfoot
[01.26. - 01:57:41] [WORLD__LS] Connecting to login server: 127.0.0.1:5999
[01.26. - 01:57:41] [WORLD__LS] Setting World to MiniLogin Server type
[01.26. - 01:57:41] [WORLD__LS] Connected to Loginserver: 127.0.0.1:5999
[01.26. - 01:57:50] [WORLD__ZONE] New TCP connection from 127.0.0.1:50643
[01.26. - 01:57:50] [WORLD__CONSOLE] New launcher from 127.0.0.1:50643
[01.26. - 01:57:50] [WORLD__LAUNCH] Adding pending launcher 1
[01.26. - 01:57:50] [WORLD__LAUNCH] Launcher Identified itself as 'zone'. Loading zone list.
[01.26. - 01:57:50] [WORLD__LAUNCH] Removing pending launcher 1. Adding zone to active list.
[01.26. - 01:57:55] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (1 starts)
[01.26. - 01:57:57] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (1 starts)
[01.26. - 01:58:15] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (2 starts)
[01.26. - 01:58:17] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (2 starts)
[01.26. - 01:58:35] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (3 starts)
[01.26. - 01:58:37] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (3 starts)
[01.26. - 01:58:55] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (4 starts)
[01.26. - 01:58:57] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (4 starts)
[01.26. - 01:59:15] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (5 starts)
[01.26. - 01:59:17] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (5 starts)
[01.26. - 01:59:35] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (6 starts)
[01.26. - 01:59:36] [WORLD__LAUNCH] Removing launcher zone (1)

Anyone Help?

**trevius** · #2 01-26-2012, 07:06 AM

Quote:

Originally Posted by sheir96

[01.26. - 01:57:40] [WORLD__INIT] Loading items..
[01.26. - 01:57:40] [WORLD__INIT_ERR] Error: Could not load item data. But ignoring

Since items are failing to load, you are most likely missing some required SQL updates. Which DB version and source code version are you running?

Here is the list of SQL updates, but you would only need to apply ones between the database revision you run and the source code revision you run:
http://code.google.com/p/projecteqem...ls%2Fsql%2Fsvn

sheir96 · #3 01-26-2012, 07:19 AM

Yeah,i was missing the "zone" table and a few other things.Its fixed now...Everything seems to be fine,i tried logging in and it doesnt go to server select. It says loading please wait forever lol

Noport · #4 01-26-2012, 11:17 AM

For minilogin client make sure your opcodes for sod.conf,underfoot.conf,hot.conf,voa.conf,opcodes. conf,login_opcodes_sod.conf read
#Login opcodes
OP_SessionReady=0x0001
OP_Login=0x0002
OP_ServerListRequest=0x0004
OP_PlayEverquestRequest=0x000d
OP_PlayEverquestResponse=0x0022
OP_ChatMessage=0x0017
OP_LoginAccepted=0x0018
OP_ServerListResponse=0x0019
OP_Poll=0x0029
OP_EnterChat=0x000f
OP_PollResponse=0x0011
I known what your going throw i fought that for hours trying to recall the settings.
here is the main settings you need to look for
OP_PlayEverquestResponse=0x0022
OP_ChatMessage=0x0017
OP_LoginAccepted=0x0018
OP_ServerListResponse=0x0019
for all others should read patch_Titanium.conf,patch_6.2.conf,patch_SoF.conf, login_opcodes.conf
#Login opcodes
OP_SessionReady=0x0001 #
OP_Login=0x0002 #
OP_ServerListRequest=0x0004 #
OP_PlayEverquestRequest=0x000d #
OP_PlayEverquestResponse=0x0021 #
OP_ChatMessage=0x0016 #
OP_LoginAccepted=0x0017 #
OP_ServerListResponse=0x0018 #
OP_Poll=0x0029 #
OP_EnterChat=0x000f #
OP_PollResponse=0x0011 #
here is the main settings you need to look for
OP_PlayEverquestResponse=0x0021 #
OP_ChatMessage=0x0016 #
OP_LoginAccepted=0x0017 #
OP_ServerListResponse=0x0018 #

under mysql server peq make sure variables is set to minilogin and not public
note: make a blank log.ini file then save it, and for eqtime.cfg should look like this
1000
1
9
0
1
3100
1141490814
then save file put in server directory.

i noticed ERR] Error: Could not load item data. and ERR] Unable to load adventure templates the server patch files are missing doh don't worry it's not your problem the programer forgot to add them.
so what i did to fix this installed an older server patch copy them out then copy them back to server what a pain that was.

sheir96 · #5 01-27-2012, 03:03 AM

Quote:

Originally Posted by Noport

i noticed ERR] Error: Could not load item data. and ERR] Unable to load adventure templates the server patch files are missing doh don't worry it's not your problem the programer forgot to add them.
so what i did to fix this installed an older server patch copy them out then copy them back to server what a pain that was.

Yeah i need to get these,so how could i do that? Do you have a link to where i can get these or? I got everything else good to go and running just need items

sheir96 · #6 01-27-2012, 04:56 AM

Quote:

Originally Posted by trevius

Since items are failing to load, you are most likely missing some required SQL updates. Which DB version and source code version are you running?

Here is the list of SQL updates, but you would only need to apply ones between the database revision you run and the source code revision you run:
http://code.google.com/p/projecteqem...ls%2Fsql%2Fsvn

Im running it off of r2092 atm

**trevius** · #7 01-27-2012, 05:46 AM

Maybe you forgot to source all of the SQL that comes from PEQ. Check and make sure you have an items table, and you may be missing other tables like the adventure related ones. Which server setup guide are you using?

sheir96 · #8 01-27-2012, 06:05 AM

I tried putting in all the SQL files the required ones that comes with the database and whatnot,double checked to make sure there was an items table,got 6 adventure tables...Used this one here http://www.eqemulator.net/wiki/wikka.php?wakka=Windows

Noport · #9 01-27-2012, 08:38 AM

Sorry for the long post it would be nice if they included both load_updates.sql & load_updatesbots.sql file.

Download from http://projecteqdb.googlecode.com/svn/trunk/peqdatabase

Here is how i loaded my server files

copy peqdb_2092.sql
copy player_tables directory
copy updates directory
copy load_player.sql
copy load_updates.sql The file you just made
copy load_updatesbots.sql The file you just made

Copy all Files and Folders too C:\MySQL\bin Directory

All updates without Bots

Make a File Called load_updates.sql
copy and paste into a file rename it too load_updates.sql save file.

source updates/Rev59.sql;
source updates/Rev82.sql;
source updates/Rev109.sql;
source updates/Rev125.sql;
source updates/Rev127.sql;
source updates/Rev129.sql;
source updates/Rev131.sql;
source updates/Rev166.sql;
source updates/Rev198.sql;
source updates/Rev200.sql;
source updates/Rev222.sql;
source updates/Rev227.sql;
source updates/Rev247.sql;
source updates/Rev249.sql;
source updates/Rev271.sql;
source updates/Rev274.sql;
source updates/Rev278.sql;
source updates/Rev288.sql;
source updates/Rev294.sql;
source updates/Rev326.sql;
source updates/Rev340.sql;
source updates/Rev360.sql;
source updates/Rev284.sql;
source updates/Rev438.sql;
source updates/Rev461.sql;
source updates/Rev507.sql;
source updates/Rev512.sql;
source updates/Rev535.sql;
source updates/Rev590.sql;
source updates/Rev610.sql;
source updates/Rev669.sql;
source updates/Rev703.sql;
source updates/Rev752.sql;
source updates/Rev781.sql;
source updates/Rev859.sql;
source updates/Rev922.sql;
source updates/Rev946.sql;
source updates/Rev974.sql;
source updates/Rev1008.sql;
source updates/Rev1038.sql;
source updates/Rev1052.sql;
source updates/Rev1265.sql;
source updates/Rev1395.sql;
source updates/Rev1496.sql;
source updates/Rev1535.sql;
source updates/Rev1589.sql;
source updates/Rev2021.sql;
source updates/Rev2083.sql;
source updates/Rev2092.sql;

All updates with Bots

Make a File Called load_updatesbots.sql
copy and paste into a file rename it too load_updatesbots.sql save file.

source updates/Rev59.sql;
source updates/Rev82.sql;
source updates/Rev109.sql;
source updates/Rev125.sql;
source updates/Rev127.sql;
source updates/Rev129.sql;
source updates/Rev131.sql;
source updates/Rev166.sql;
source updates/Rev198.sql;
source updates/Rev200.sql;
source updates/Rev222.sql;
source updates/Rev227.sql;
source updates/Rev247.sql;
source updates/Rev249.sql;
source updates/Rev266-Bots.sql;
source updates/Rev271.sql;
source updates/Rev274.sql;
source updates/Rev278.sql;
source updates/Rev288.sql;
source updates/Rev294.sql;
source updates/Rev326.sql;
source updates/Rev328-Bots.sql;
source updates/Rev340.sql;
source updates/Rev360.sql;
source updates/Rev284.sql;
source updates/Rev386-Bots.sql;
source updates/Rev438.sql;
source updates/Rev461.sql;
source updates/Rev507.sql;
source updates/Rev512.sql;
source updates/Rev535.sql;
source updates/Rev590.sql;
source updates/Rev610.sql;
source updates/Rev669.sql;
source updates/Rev703.sql;
source updates/Rev752.sql;
source updates/Rev781.sql;
source updates/Rev859.sql;
source updates/Rev922.sql;
source updates/Rev946.sql;
source updates/Rev946-Bots.sql;
source updates/Rev974.sql;
source updates/Rev974-Bots.sql;
source updates/Rev1008.sql;
source updates/Rev1038.sql;
source updates/Rev1038-Bots.sql;
source updates/Rev1052.sql;
source updates/Rev1054-Bots.sql;
source updates/Rev1265.sql;
source updates/Rev1265-Bots.sql;
source updates/Rev1395.sql;
source updates/Rev1496.sql;
source updates/Rev1535.sql;
source updates/Rev1589.sql;
source updates/Rev2021.sql;
source updates/Rev2022-Bots.sql;
source updates/Rev2083.sql;
source updates/Rev2087-Bots.sql;
source updates/Rev2092.sql;

15. NOW, you need to go in to a command prompt and navigate to the peqdb folder.
Simply type cd \peqdb and you should be there. You will see: C:\peqdb>_

REMEMBER THE PASSWORD YOU GAVE when you set up MySQL ? (You need it NOW)

***WARNING*** - at this point, make sure you are in the peqdb folder.
C:\MySQL\bin

Then type mysql -uroot -p
Hit enter and enter your password. (Hit enter again)
You should now see a prompt that looks like this: (along with "Welcome" text before it)
mysql>_

Type the following (in order):

use peq (Hit enter and you will see a short note saying "Database changed")

Then type the following:

source peqdb_rev2092.sql (when this is done, you will be back at the mysql>_ prompt)

Then type in the following:

source load_player.sql (this will load fast)

source only one of them below without bots or with bots.
source load_updates.sql (This will load fast)
source load_updatesbots.sql (This will load fast)
Done.