World.exe crashing when somebody joins...

psalm · #1 10-23-2010, 02:10 AM

When somebody connect to my server, world.exe promptly crashes (world.exe has stopped working, close the program etc.)

The last line world.exe shows before it crashes is:

[Debug] [WORLD_CLIENT] New connection from xxx.x.x.x

xxxx
[Debug] [WORLD_LAUNCH] zone: dynamic_01 reported state STARTED <2 starts>

The login screen ingame just stays at 'Logging in to the server. Please wait....'

Any ideas?

psalm · #2 10-23-2010, 09:11 AM

---------------------------------------------
[10.23. - 13:57:31] Starting Log: logs/eqemu_debug_world_4804.log
[10.23. - 13:57:31] [WORLD__INIT] Loading server configuration..
[10.23. - 13:57:31] [WORLD__INIT] Log settings loaded from log.ini
[10.23. - 13:57:31] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
[10.23. - 13:57:31] [WORLD__INIT] Connecting to MySQL...
[10.23. - 13:57:31] [WORLD__INIT] Starting HTTP world service...
[10.23. - 13:57:31] [WORLD__HTTP] Loaded mime types from mime.types
[10.23. - 13:57:31] [WORLD__INIT] Loading variables..
[10.23. - 13:57:31] [WORLD__INIT] Loading zones..
[10.23. - 13:57:31] [WORLD__INIT] Clearing groups..
[10.23. - 13:57:31] [WORLD__INIT] Clearing temporary merchant lists..
[10.23. - 13:57:31] [WORLD__INIT] Loading items..
[10.23. - 13:57:31] [WORLD__INIT_ERR] Error: Could not load item data. But ignoring
[10.23. - 13:57:31] [WORLD__INIT] Loading guilds..
[10.23. - 13:57:31] [RULES__CHANGE] Loading rule set 'default' (1)
[10.23. - 13:57:31] [RULES__CHANGE] Set rule GM:MinStatusToZoneAnywhere to value 250
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Character:MaxLevel to value 65
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Character:LeaveCorpses to value true
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Character:LeaveNakedCorpses to value true
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Character:ExpMultiplier to value 0.7500000000000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Character

eathExpLossLevel to value 10
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Character:CorpseDecayTimeMS to value 86400000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Character:AutosaveIntervalS to value 300
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Character:HPRegenMultiplier to value 100
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Character:ManaRegenMultiplier to value 100
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Character:EnduranceRegenMultiplier to value 100
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Guild:MaxMembers to value 2048
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Skills:MaxTrainTradeskills to value 21
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Pets:AttackCommandRange to value 150.0000000000000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule World:ZoneAutobootTimeoutMS to value 120000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule World:ClientKeepaliveTimeoutMS to value 95000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule World:UseBannedIPsTable to value true
[10.23. - 13:57:31] [RULES__CHANGE] Set rule World:MaxClientsPerIP to value -1
[10.23. - 13:57:31] [RULES__CHANGE] Set rule World:ExemptMaxClientsStatus to value -1
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Aggro:PetSpellAggroMod to value 10
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Aggro:SongAggroMod to value 33
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Aggro:SpellAggroMod to value 100
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Combat:BaseCritChance to value 0.0000000000000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Combat:WarBerBaseCritChance to value 0.0299999993294
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Combat:BerserkBaseCritChance to value 0.0599999986589
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Combat:NPCBashKickLevel to value 6
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Character:ConsumptionMultiplier to value 200
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Spells:AutoResistDiff to value 15
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Spells:ResistChance to value 2.0000000000000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Spells:ResistMod to value 0.4000000059605
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Spells:PartialHitChance to value 0.6999999880791
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Combat:ClientBaseCritChance to value 0.0000000000000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Zone:NPCGlobalPositionUpdateInterval to value 60000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule NPC:MinorNPCCorpseDecayTimeMS to value 600000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule NPC:MajorNPCCorpseDecayTimeMS to value 1200000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Zone:GraveyardTimeMS to value 1200000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Zone:EnableShadowrest to value true
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Map:FixPathingZWhenLoading to value true
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Map:FixPathingZAtWaypoints to value true
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Map:FixPathingZWhenMoving to value true
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Map:FixPathingZOnSendTo to value false
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Zone:ClientLinkdeadMS to value 180000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule NPC:UseItemBonusesForNonPets to value true
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Map:FixPathingZMaxDeltaSendTo to value 20.0000000000000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Map:FixPathingZMaxDeltaLoading to value 20.0000000000000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Map:FixPathingZMaxDeltaMoving to value 20.0000000000000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Map:FixPathingZMaxDeltaWaypoint to value 20.0000000000000
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Character:HealOnLevel to value false
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Character:FeignKillsPet to value false
[10.23. - 13:57:31] [RULES__CHANGE] Set rule Character:ItemManaRegenCap to value 15
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Character:ItemHealthRegenCap to value 15
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Combat:UseIntervalAC to value true
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Combat:PetAttackMagicLevel to value 30
[10.23. - 13:57:32] [RULES__CHANGE] Set rule NPC:SayPauseTimeInSec to value 10
[10.23. - 13:57:32] [RULES__CHANGE] Set rule NPC:OOCRegen to value 0
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Aggro:SmartAggroList to value true
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Aggro:SittingAggroMod to value 35
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Aggro:MeleeRangeAggroMod to value 20
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Aggro:CurrentTargetAggroMod to value 0
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Aggro:CriticallyWoundedAggroMod to value 100
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Aggro:SlowAggroMod to value 450
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Aggro:IncapacitateAggroMod to value 500
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Aggro:MovementImpairAggroMod to value 175
[10.23. - 13:57:32] [RULES__CHANGE] Set rule NPC:BuffFriends to value true
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Character

eathItemLossLevel to value 10
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Watermap:CheckWaypointsInWaterWhenLoading to value true
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Watermap:CheckForWaterAtWaypoints to value true
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Watermap:CheckForWaterWhenMoving to value true
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Watermap:CheckForWaterOnSendTo to value false
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Watermap:CheckForWaterWhenFishing to value true
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Watermap:FishingRodLength to value 30.0000000000000
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Watermap:FishingLineLength to value 40.0000000000000
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Character:ItemDamageShieldCap to value 30
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Character:ItemAccuracyCap to value 150
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Character:ItemAvoidanceCap to value 100
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Character:ItemCombatEffectsCap to value 100
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Character:ItemShieldingCap to value 35
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Character:ItemSpellShieldingCap to value 35
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Character:ItemDoTShieldingCap to value 35
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Character:ItemStunResistCap to value 35
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Character:ItemStrikethroughCap to value 35
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Spells:PartialHitChanceFear to value 0.2500000000000
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Zone:MQWarpExemptStatus to value -1
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Zone:MQZoneExemptStatus to value -1
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Zone:MQGateExemptStatus to value -1
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Zone:MQGhostExemptStatus to value -1
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Zone:EnableMQWarpDetector to value true
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Zone:EnableMQZoneDetector to value true
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Zone:EnableMQGateDetector to value true
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Zone:EnableMQGhostDetector to value true
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Zone:MQWarpDetectorDistance to value 4900.0000000000000
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Zone:MQWarpLagThreshold to value 140.0000000000000
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Zone:MQWarpThresholdTimer to value 90000.0000000000000
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Combat:EnableFearPathing to value true
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Combat:FleeHPRatio to value 22
[10.23. - 13:57:32] [RULES__CHANGE] Set rule Combat:FleeIfNotAlone to value false
[10.23. - 13:57:32] [WORLD__INIT] Loaded default rule set 'default'
[10.23. - 13:57:32] [WORLD__INIT] Loading EQ time of day..
[10.23. - 13:57:32] [WORLD__INIT] Loading launcher list..
[10.23. - 13:57:32] [WORLD__INIT] Reboot zone modes ON
[10.23. - 13:57:32] [WORLD__INIT] Deleted 0 stale player corpses from database
[10.23. - 13:57:32] [WORLD__INIT] Deleted 0 stale player backups from database
[10.23. - 13:57:32] [WORLD__INIT] Zone (TCP) listener started.
[10.23. - 13:57:32] [WORLD__INIT] Client (UDP) listener started.
[10.23. - 13:57:32] [NET__IDENTIFY] Registered patch 6.2
[10.23. - 13:57:32] [NET__IDENTIFY] Registered patch Titanium
[10.23. - 13:57:32] [NET__IDENTIFY] Registered patch Anniversary
[10.23. - 13:57:32] [NET__IDENTIFY] Registered patch Live
[10.23. - 13:57:32] [WORLD__LS] Connecting to login server...
[10.23. - 13:57:32] [WORLD__LS] Connected to Loginserver: eqemulator.net:5998
[10.23. - 13:57:32] [WORLD__LS] Loginserver provided 87.194.34.223 as world address
[10.23. - 13:57:51] [WORLD__ZONE] New TCP connection from 127.0.0.1:52629
[10.23. - 13:57:51] [WORLD__CONSOLE] New launcher from 127.0.0.1:52629
[10.23. - 13:57:51] [WORLD__LAUNCH] Adding pending launcher 1
[10.23. - 13:57:51] [WORLD__LAUNCH] Launcher Identified itself as 'zone'. Loading zone list.
[10.23. - 13:57:51] [WORLD__LAUNCH] Removing pending launcher 1. Adding zone to active list.
[10.23. - 13:57:56] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (1 starts)
[10.23. - 13:57:58] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (1 starts)
[10.23. - 13:58:16] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (2 starts)
[10.23. - 13:58:18] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (2 starts)
[10.23. - 13:58:36] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (3 starts)
[10.23. - 13:58:38] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (3 starts)
[10.23. - 13:58:56] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (4 starts)
[10.23. - 13:58:58] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (4 starts)
[10.23. - 13:59:16] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (5 starts)
[10.23. - 13:59:18] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (5 starts)
[10.23. - 13:59:36] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (6 starts)
[10.23. - 13:59:38] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (6 starts)
[10.23. - 13:59:56] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (7 starts)
[10.23. - 13:59:58] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (7 starts)
[10.23. - 14:00:16] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (8 starts)
[10.23. - 14:00:18] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (8 starts)
[10.23. - 14:00:36] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (9 starts)
[10.23. - 14:00:38] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (9 starts)
[10.23. - 14:00:56] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (10 starts)
[10.23. - 14:00:58] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (10 starts)
[10.23. - 14:01:01] [WORLD__CLIENT] New connection from 127.0.0.1:55441

[IMG]

[/IMG]

**bad_captain** · #3 10-23-2010, 09:40 AM

[10.23. - 13:57:31] [WORLD__INIT_ERR] Error: Could not load item data. But ignoring
[10.23. - 13:57:58] [WORLD__LAUNCH] zone: dynamic_01 reported state STOPPED (1 starts)

I would assume there are DB updates that need to be run (items aren't loaded), as well as your Zones are crashing every 18 seconds (most likely a DB error as well). Check all sql updates, then try again. Until the zone stops crashing, I don't think anyone will be able to join.

psalm · #4 10-23-2010, 10:18 AM

Bad_Captain,

Could you elaborate on how I go about updating?

Sorry for the inconvenience.

psalm · #5 10-23-2010, 10:23 AM

Also, I get these errors also, are these also due to requring updates?

[10.23. - 14:57:25] [LAUNCHER__WORLD] World told us to start zone dynamic_01.
[10.23. - 14:57:25] [LAUNCHER__WORLD] World told us to start zone dynamic_02.
[10.23. - 14:57:25] [LAUNCHER__WORLD] World told us to start zone dynamic_03.
[10.23. - 14:57:25] [LAUNCHER__WORLD] World told us to start zone dynamic_04.
[10.23. - 14:57:25] [LAUNCHER__WORLD] World told us to start zone dynamic_05.
[10.23. - 14:57:25] [LAUNCHER__ERROR] World told us to start zone dynamic_01, but it is already running.
[10.23. - 14:57:25] [LAUNCHER__ERROR] World told us to start zone dynamic_02, but it is already running.
[10.23. - 14:57:25] [LAUNCHER__ERROR] World told us to start zone dynamic_03, but it is already running.
[10.23. - 14:57:25] [LAUNCHER__ERROR] World told us to start zone dynamic_04, but it is already running.
[10.23. - 14:57:25] [LAUNCHER__ERROR] World told us to start zone dynamic_05, but it is already running.

**joligario** · #6 10-23-2010, 10:51 AM

Those are normal. Ignore them.

**bad_captain** · #7 10-23-2010, 12:34 PM

What version of the server are you running?
What version of the database are you running?

If you don't know, when/where did you get the binaries, or did you compile yourself? What database file did you run? Did you try to update and now you're getting these errors, or are you setting up for the first time?

In the log you provided, I see: [10.23. - 13:57:31] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0 - If I'm correct, the newest versions say 0.8.0? If so, these binaries are old.

Assuming you want to update your server to the newest build- Back everything up. You don't want to wipe anything out and lose all of your characters! Get the latest build from the svn (Andrew80k uploaded the rev1708 binaries a couple days ago) Then download the latest database (PEQ I assume?) rev-1667 I think. Update the database, then check the server binaries in Utils/sql/svn for any revs later than 1667. You may also want to check the changelog.txt in the server folder for any sql changes not put in it's own script file. Also, if you have accounts and characters already created, you would need to check for any updates for those tables (character_, account, etc.) Some of the guides floating around may help as well.

psalm · #8 10-23-2010, 12:57 PM

Bad Captain,

i used the PEQ LoY server pack (http://www.peqtgc.com/downloads.php) which, now looking, is very out of date.

I presume theres no way to run an out of date pack? (the server is only for a few friends).

I'm a little lost with it all, but was following some database update guide on the peq forum, for which I downloaded the peqdb_rev1667 and the quest files. I had replaced the quest files, and am trying to update my mysql database with the new peqdb file, but navicat is bugging out.

The readme for the peqdb states:
Update Setup:

1. Unpack peqdb_Revxxx.sql.gz using winrar, gzip, whatever you use.
2. Source drop_system.sql.
3. Source the new peqdb_Revxxx.sql into your database.
4. Enter the updates folder, read the readme.txt there and be sure to source in any updates since the last time you updated.

But when i get to executing the peqdv.sql in navi, it just seems to time out, it processes 59/59, but stays at 0% and keeps timing (it was at 300seconds typing this)

I'm not sure where to go from here.

**bad_captain** · #9 10-23-2010, 01:11 PM

I assume you could if everything matched up (also depending on the client used to connect), but it's probably best to update. More features, etc. You will also be able to get better help if you're working with the most recent files.

Also, it takes 10-15 minutes on my server to load the PEQ full DB script (granted it's a really old PC) via MySQL Query Browser. I have more luck running the scripts via the command line. The full file is like 150 MB. I'm not sure if navicat can do that, but I assume it does.

psalm · #10 10-23-2010, 01:24 PM

Bad Captain,

I'm likely growing annoying now,

but how exactly do I source through the CMD? The only reason I'm using navicat, is because it's GUI and, thus easier for me to grasp

**bad_captain** · #11 10-23-2010, 04:20 PM

I assume you're using windows.. Open command prompt. Navigate to mysql bin folder. Mine is C:/Program Files/MySql/MYSQL Server 5.0/bin. Once in that folder type:
mysql -u USERNAME -p peq

substituting your username, and database name if it's not peq. It should prompt for your password. Enter it, then you should be in, with the peq database selected. You can then type source load_system.sql in or the peq_xxx.sql file.

I'm definitely no mysql guru, but that should work. Again, make sure you backup, unless there's no data worth keeping, then it would be best to just wipe everything and start fresh.

Check out http://www.eqemulator.net/wiki/wikka...ka=ws992mysql5 or http://www.eqemulator.net/wiki/wikka.php?wakka=Windows. The sourcing should be much faster that with the GUI. Just switch back after for any other changes if you're more familiar with Navi.

psalm · #12 10-23-2010, 04:55 PM

I presume I'm supposed to move the peqdb files (player_tables/updates/drop_player.sql etc. etc. etc.) to where my actual database is?

How do I actually find where my database is located? Because the PEQ server pack created it for me, and I cannot find it anywhere within the mysql folders, or anywhere obvious on c:

is there a command to throw in mysql-cmd to tell me where it is, so i can transfer the files across + source them.

psalm · #13 10-23-2010, 05:49 PM

ok, I misunderstood what you said,

sourced now.

**bad_captain** · #14 10-23-2010, 05:57 PM

Good to hear. Now, just update your binaries, and hopefully everything will run fine. If there are more errors, post them, and we may be able to figure out which updates to run. Good luck!

psalm · #15 10-23-2010, 06:09 PM

I tried to run it after i sourced all the peqdb files (I'm not sure if I was supposed to source the update folder contents, but did anyway)

The server start failed to find pretty much everything, so I assume I broke it by doing so.

Any ideas?

I'm actually just reinstalling peq server pack, and will start it a fresh.

How do I update the binaris? By binaries, is that the eqmu itself?