Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::General Support
Reload this Page How to update to the latest build

Support::General Support Post all topics here having to do with errors while trying to connect to an EQEMu server but not about the setup/running of the Server itself.

Reply
 
Thread Tools Display Modes
  #1  
Old 06-14-2006, 12:31 AM
elation
Sarnak
  
Join Date: Sep 2005
Posts: 33
Default
Thanks guys! I pasted the new files into my eqemu folder and ran the sql lines. It worked!

Many thanks!
Reply With Quote
  #2  
Old 06-17-2006, 01:10 AM
EliteSting
Sarnak
  
Join Date: May 2005
Posts: 58
Default
I've been working on trying to get the emu up and working , and am making headway , but im running into the same problem ( zone unavilable when I hit enter at character select ) . I've got the latest win32 binaries (EQEmu-0.7.0-801.zip ) , and Ive done :

ALTER TABLE spawnentry DROP spawn_limit;
ALTER TABLE spawngroup ADD spawn_limit tinyint(4) NOT NULL default '0';
ALTER TABLE altadv_vars ADD class_type int unsigned NOT NULL DEFAULT 0;

to the eq database , and even confirmed the changes were made. Zones boot fine with no errors , using minilogin and it all seems to look/work ok , the 5 dynamic zones go into sleep mode ( well , at the top of the window it says 0: sleeping ) When they start up it says they're active , and then go into sleep mode a short while after. I'm using a fresh Titanium install , and haven't patched anything.
I've got both the peq and cavedudes databases sourced . Everything connects fine until I get to character select , I can create characters just fine , the problem begins when I try to enter the world.

World Log :
Quote:
---------------------------------------------
[06.17. - 08:48:20] Starting Log: logs/eqemu_debug_world_3708.log
[06.17. - 08:48:20] [WORLD__INIT] Loading server configuration..
[06.17. - 08:48:20] [WORLD__INIT] Log settings loaded from log.ini
[06.17. - 08:48:20] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
[06.17. - 08:48:20] [WORLD__INIT] Connecting to MySQL...
[06.17. - 08:48:20] [WORLD__INIT] Starting HTTP world service...
[06.17. - 08:48:20] [WORLD__HTTP] Loaded mime types from mime.types
[06.17. - 08:48:20] [WORLD__INIT] Loading variables..
[06.17. - 08:48:20] [WORLD__INIT] Loading zones..
[06.17. - 08:48:20] [WORLD__INIT] Clearing groups..
[06.17. - 08:48:20] [WORLD__INIT] Clearing temporary merchant lists..
[06.17. - 08:48:20] [WORLD__INIT] Loading items..
[06.17. - 08:48:25] [WORLD__INIT] Loading guilds..
[06.17. - 08:48:25] [WORLD__INIT] Loading EQ time of day..
[06.17. - 08:48:25] [WORLD__INIT] Loading launcher list..
[06.17. - 08:48:25] [WORLD__INIT] Reboot zone modes ON
[06.17. - 08:48:25] [WORLD__INIT] Deleted 0 stale player corpses from database
[06.17. - 08:48:25] [WORLD__INIT] Deleted 0 stale player backups from database
[06.17. - 08:48:25] [WORLD__INIT] Zone (TCP) listener started.
[06.17. - 08:48:25] [WORLD__INIT] Client (UDP) listener started.
[06.17. - 08:48:25] [NET__IDENTIFY] Registered patch 6.2
[06.17. - 08:48:25] [NET__IDENTIFY] Registered patch Titanium
[06.17. - 08:48:25] [NET__IDENTIFY] Registered patch Live
[06.17. - 08:48:25] [WORLD__LS] Connecting to login server...
[06.17. - 08:48:25] [WORLD__LS] Setting World to MiniLogin Server type
[06.17. - 08:48:25] [WORLD__LS] Connected to Loginserver: 127.0.0.1:5999
[06.17. - 08:48:40] [WORLD__ZONE] New TCP connection from 127.0.0.1:3896
[06.17. - 08:48:40] [WORLD__CONSOLE] New launcher from 127.0.0.1:3896
[06.17. - 08:48:40] [WORLD__LAUNCH] Adding pending launcher 1
[06.17. - 08:48:40] [WORLD__LAUNCH] Launcher Identified itself as 'zones'. Loading zone list.
[06.17. - 08:48:40] [WORLD__LAUNCH] Removing pending launcher 1. Adding zones to active list.
[06.17. - 08:48:45] [WORLD__LAUNCH] zones: dynamic_01 reported state STARTED (1 starts)
[06.17. - 08:49:11] [WORLD__LAUNCH] zones: dynamic_02 reported state STARTED (1 starts)
[06.17. - 08:49:17] [WORLD__LAUNCH] zones: dynamic_03 reported state STARTED (1 starts)
[06.17. - 08:49:22] [WORLD__LAUNCH] zones: dynamic_04 reported state STARTED (1 starts)
[06.17. - 08:49:26] [WORLD__LAUNCH] zones: dynamic_05 reported state STARTED (1 starts)
[06.17. - 08:49:46] [WORLD__ZONE] New TCP connection from 127.0.0.1:3902
[06.17. - 08:49:46] [WORLD__CONSOLE] New zoneserver #1 from 127.0.0.1:3902
[06.17. - 08:49:46] [WORLD__ZONE] [1] Zone started with name dynamic_01 by launcher zones
[06.17. - 08:49:46] [WORLD__ZONE] [1] Auto zone port configuration. Telling zone to use port 7000
[06.17. - 08:49:46] [WORLD__ZONE] New TCP connection from 127.0.0.1:3903
[06.17. - 08:49:46] [WORLD__CONSOLE] New zoneserver #2 from 127.0.0.1:3903
[06.17. - 08:49:46] [WORLD__ZONE] [2] Zone started with name dynamic_02 by launcher zones
[06.17. - 08:49:46] [WORLD__ZONE] [2] Auto zone port configuration. Telling zone to use port 7001
[06.17. - 08:49:46] [WORLD__ZONE] New TCP connection from 127.0.0.1:3904
[06.17. - 08:49:46] [WORLD__ZONE] New TCP connection from 127.0.0.1:3905
[06.17. - 08:49:46] [WORLD__CONSOLE] New zoneserver #3 from 127.0.0.1:3904
[06.17. - 08:49:46] [WORLD__ZONE] New TCP connection from 127.0.0.1:3906
[06.17. - 08:49:46] [WORLD__CONSOLE] New zoneserver #4 from 127.0.0.1:3906
[06.17. - 08:49:46] [WORLD__CONSOLE] New zoneserver #5 from 127.0.0.1:3905
[06.17. - 08:49:46] [WORLD__ZONE] [5] Zone started with name dynamic_04 by launcher zones
[06.17. - 08:49:46] [WORLD__ZONE] [5] Auto zone port configuration. Telling zone to use port 7002
[06.17. - 08:49:46] [WORLD__ZONE] [4] Zone started with name dynamic_05 by launcher zones
[06.17. - 08:49:46] [WORLD__ZONE] [4] Auto zone port configuration. Telling zone to use port 7003
[06.17. - 08:49:46] [WORLD__ZONE] [3] Zone started with name dynamic_03 by launcher zones
[06.17. - 08:49:46] [WORLD__ZONE] [3] Auto zone port configuration. Telling zone to use port 7004
[06.17. - 08:50:52] [WORLD__CLIENT] New connection from 127.0.0.1:3908
[06.17. - 08:50:52] [NET__IDENT_TRACE] 127.0.0.1:3908: First opcode 0x4dd0 did not match expected 0x2792
[06.17. - 08:50:52] [NET__IDENT_TRACE] 127.0.0.1:3908: Tried patch 6.2_world, and it did not match.
[06.17. - 08:50:52] [NET__IDENT_TRACE] 127.0.0.1:3908: First opcode 0x4dd0 did not match expected 0x2ec9
[06.17. - 08:50:52] [NET__IDENT_TRACE] 127.0.0.1:3908: Tried patch 6.2_zone, and it did not match.
[06.17. - 08:50:52] [NET__IDENT_TRACE] 127.0.0.1:3908: First opcode matched 0x4dd0 and length matched 464
[06.17. - 08:50:52] [NET__IDENTIFY] Identified stream 127.0.0.1:3908 with signature Titanium_world
[06.17. - 08:50:52] [WORLD__CLIENT] New client from 127.0.0.1:3908
[06.17. - 08:50:52] [WORLD__CLIENT_TRACE] NOCLE: Recevied EQApplicationPacket
[06.17. - 08:50:52] [WORLD__CLIENT] mini: Logged in. Mode=(CharSel)
[06.17. - 08:50:52] [WORLD__CLIENT] mini: MiniLogin Account #1
[06.17. - 08:50:52] [GUILDS__OUT_PACKETS] mini: Sending OP_GuildsList of length 96064
[06.17. - 08:50:52] [WORLD__CLIENT_TRACE] mini: Sending EQApplicationPacket OpCode 0x00fb
[06.17. - 08:50:52] [WORLD__CLIENT_TRACE] mini: Sending EQApplicationPacket OpCode 0x00fa
[06.17. - 08:50:52] [WORLD__CLIENT_TRACE] mini: Sending EQApplicationPacket OpCode 0x0105
[06.17. - 08:50:52] [WORLD__CLIENT_TRACE] mini: Sending EQApplicationPacket OpCode 0x0106
[06.17. - 08:50:52] [WORLD__CLIENT_TRACE] mini: Sending EQApplicationPacket OpCode 0x0100
[06.17. - 08:50:52] [WORLD__CLIENT_TRACE] mini: Sending EQApplicationPacket OpCode 0x00ff
[06.17. - 08:51:02] [WORLD__CLIENT_TRACE] mini: Recevied EQApplicationPacket
[06.17. - 08:51:25] [WORLD__CLIENT_TRACE] mini: Recevied EQApplicationPacket
[06.17. - 08:51:25] [WORLD__CLIENT_TRACE] mini: Recevied EQApplicationPacket
[06.17. - 08:51:50] [WORLD__CLIENT_TRACE] mini: Recevied EQApplicationPacket
[06.17. - 08:51:51] [WORLD__CLIENT_TRACE] mini: Recevied EQApplicationPacket
[06.17. - 08:52:13] [WORLD__CLIENT_TRACE] mini: Recevied EQApplicationPacket
[06.17. - 08:52:13] [WORLD__CLIENT_TRACE] mini: Sending EQApplicationPacket OpCode 0x00fc
[06.17. - 08:52:13] [WORLD__CLIENT_TRACE] mini: Sending EQApplicationPacket OpCode 0x010a
[06.17. - 08:52:13] [WORLD__CLIENT_TRACE] mini: Sending EQApplicationPacket OpCode 0x010b
[06.17. - 08:52:13] [WORLD__CLIENT] mini: Attempting autobootup of neriakb (41)
[06.17. - 08:52:13] [WORLD__CLIENT_TRACE] mini: Sending EQApplicationPacket OpCode 0x00c7
[06.17. - 08:52:13] [WORLD__CLIENT_TRACE] mini: Recevied EQApplicationPacket
[06.17. - 08:52:31] [WORLD__CLIENT_TRACE] mini: Recevied EQApplicationPacket
[06.17. - 08:52:31] [WORLD__CLIENT_ERR] mini: Received unknown EQApplicationPacket
[06.17. - 08:52:31] [WORLD__CLIENT_ERR] [OpCode OP_WorldLogout (0x771 Size=0]
[06.17. - 08:52:31] [WORLD__CLIENT_TRACE] mini: Recevied EQApplicationPacket
[06.17. - 08:52:31] [WORLD__CLIENT] mini: Client disconnected (not active in process)
When Minilogin starts up it goes through the usual. Then when the client connects it gets :

137875 New Client from ip: 127.0.0.1 port: 3907
Unknown packet: .4233692 [92.153.64.0:15->0.0.0.0:0]
[OpCode 0x0003 (OP_Unknown) Size=11]
00000: 00 06 00 00 00 00 00 00 - 00 00 00 | ...........

The sleeping zone window doesn't show anything.

I've also noticed this error log entry :
Quote:
---------------------------------------------
[06.17. - 08:52:13] Starting Log: logs/eqemu_error_zone_1352.log
[06.17. - 08:52:13] Error in PopulateZoneLists query 'SELECT id, spawngroupID, x, y, z, heading, respawntime, variance, pathgrid, timeleft, _condition, cond_value FROM spawn2 WHERE zone='neriakb'': #1054: Unknown column '_condition' in 'field list'
[06.17. - 08:52:13] Loading spawn2 points failed.
I'm guessing the database is missing an entry. I've seen references to the " x, y, z " problem some people are having. Is this the same thing? Thanks to all for your awsome work on this project. I wish I knew more to help out , but I guess I'll play catch up for now. If I missed this in the forums or wikki , I'm terribly sorry.
Reply With Quote
  #3  
Old 06-17-2006, 01:37 AM
sesmar
I built it I will Support it!
  
Join Date: Jun 2005
Location: Michigan
Posts: 214
Default
You need to run this SQL statement on your DB

Code:
ALTER TABLE spawn2 CHANGE `condition` `_condition` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0';
__________________
Reply With Quote
  #4  
Old 06-17-2006, 02:10 AM
EliteSting
Sarnak
  
Join Date: May 2005
Posts: 58
Default
Many many thanks !!! =D
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Hybrid Mode Hybrid Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

   

All times are GMT -4. The time now is 08:36 PM.

EQEmulator - Archive - Top

 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3