Bot Zoning / Grouping issue

[ionhsmith]

Found two issues with the bots when grouping.

1. When there are bots in a group and anyone zones or dies the group is disbanded.

2. When in group the group leader cannot invite other bots only his own. The group leader has to pass the lead to get other players bots in.

[N0ctrnl]

#2 isn't a an issue. That's how it works.

#1 is likely due to you missing a table update. Check your table names and structure against the bot SQL file https://github.com/EQEmu/Server/blob/master/utils/sql/git/bots/required/2015_09_30_bots.sql

[Uleat]

(#1)
I had him manually install the updates since he was having issues with eqemu_update.pl.

He probably needs a few more schema changes applied..though, it could be a missed table addition or change.


(#2)
This could be looked at in the future..just make the check include a case for the owner being in the group, or such.

Wouldn't know its feasibility until it was actually looked at, though.

[ionhsmith]

yea looks like I have that because I manually loaded in that bot sql ... I'm not sure which one is out of date but if there is a fix I would love it lol because that zoning things is annoying

[Uleat]

Check your server log files to see if there are any database query errors.

[Cursian]

Hi Uleat,

I am having the same issue with bots disappearing and disbanding on zone.

I have dropped bots and reloaded several times. I also manually confirmed each table and field / value with the above SQL.

There are no query errors in the logs. I have another server / DB version from 2013 that has the same issue. I actually thought this was normal until I saw posts regarding this problem.

Do you have any ideas? This issue persists on all client versions. I sourced, compiled and created a new DB just a few days ago.

[Uleat]

Are you manually dropping/loading bots? Or are you using the eqemu_update.pl script to do it?

[ionhsmith]

ok I manually looked at my tables and they are all there and look the same as the update. the only thing I see different is where this says integer unsigned... mine has INT(10) unigned

CREATE TABLE `bot_groups` (
186 `groups_index` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
187 `group_leader_id` INTEGER UNSIGNED NOT NULL DEFAULT '0',
188 `group_name` VARCHAR(64) NOT NULL,
189 PRIMARY KEY (`groups_index`),
190 KEY `FK_bot_groups_1` (`group_leader_id`),
191 CONSTRAINT `FK_bot_groups_1` FOREIGN KEY (`group_leader_id`) REFERENCES `bot_data` (`bot_id`)

[Uleat]

That should be fine..INT(10) is large enough to an unsigned 32-bit integer.


Make sure that you have these four tables (views):

vw_bot_character_mobs
vw_bot_groups
vw_groups
vw_guild_members


and these two functions:

GetMobType
GetMobTypeById

[ionhsmith]

Yes I have all of those

[Uleat]

What do these queries return:

SELECT `id`, `enabled` FROM `spawn2` WHERE `id` IN (59297,59298);
SHOW KEYS FROM `guild_members` WHERE `Key_name` LIKE 'PRIMARY';
SHOW KEYS FROM `group_id` WHERE `Key_name` LIKE 'PRIMARY';




id,enabled
59297,1
59298,1






Table,Non_unique,Key_name,Seq_in_index,Column_name ,Collation,Cardinality,Sub_part,Packed,Null,Index_ type,Comment,Index_comment
group_id,0,PRIMARY,1,groupid,A,1,\N,\N,,BTREE,,
group_id,0,PRIMARY,2,charid,A,1,\N,\N,,BTREE,,
group_id,0,PRIMARY,3,name,A,1,\N,\N,,BTREE,,
group_id,0,PRIMARY,4,ismerc,A,1,\N,\N,,BTREE,,

[ionhsmith]

/* Delimiter changed to ; */
/* Connecting to 127.0.0.1 via MySQL (TCP/IP), username root, using password: Yes ... */
SELECT CONNECTION_ID();
/* Connected. Thread-ID: 622 */
/* Characterset: utf8mb4 */
SHOW STATUS;
SHOW VARIABLES;
SHOW DATABASES;
USE `peq`;
/* Entering session "EQ" */
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='peq';
SHOW TABLE STATUS FROM `peq`;
SHOW FUNCTION STATUS WHERE `Db`='peq';
SHOW PROCEDURE STATUS WHERE `Db`='peq';
SHOW TRIGGERS FROM `peq`;
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='information_schema';
SHOW TABLE STATUS FROM `information_schema`;
SHOW FUNCTION STATUS WHERE `Db`='information_schema';
SHOW PROCEDURE STATUS WHERE `Db`='information_schema';
SHOW TRIGGERS FROM `information_schema`;
SHOW EVENTS FROM `information_schema`;
SELECT *, EVENT_SCHEMA AS `Db`, EVENT_NAME AS `Name` FROM information_schema.`EVENTS` WHERE `EVENT_SCHEMA`='peq';
SELECT `id`, `enabled` FROM `spawn2` WHERE `id` IN (59297,59298);
SHOW KEYS FROM `guild_members` WHERE `Key_name` LIKE 'PRIMARY';
SHOW KEYS FROM `group_id` WHERE `Key_name` LIKE 'PRIMARY';

[ionhsmith]

ID Enabled

59,297 1
59,298 1

and the group id is 0

[ionhsmith]

Is this what its suppose to show ?

[Uleat]

The `spawn2` query is fine.

Just need clarification on the `guild_members` and `group_id` queries.

[ionhsmith]

SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='information_schema';
SHOW TABLE STATUS FROM `information_schema`;
SHOW FUNCTION STATUS WHERE `Db`='information_schema';
SHOW PROCEDURE STATUS WHERE `Db`='information_schema';
SHOW TRIGGERS FROM `information_schema`;
SHOW EVENTS FROM `information_schema`;
SELECT *, EVENT_SCHEMA AS `Db`, EVENT_NAME AS `Name` FROM information_schema.`EVENTS` WHERE `EVENT_SCHEMA`='peq';
SHOW KEYS FROM `guild_members` WHERE `Key_name` LIKE 'PRIMARY';
/* Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 1 query: 0.000 sec. */

/* Delimiter changed to ; */
/* Connecting to 127.0.0.1 via MySQL (TCP/IP), username root, using password: Yes ... */
SELECT CONNECTION_ID();
/* Connected. Thread-ID: 979 */
/* Characterset: utf8mb4 */
SHOW STATUS;
SHOW VARIABLES;
SHOW DATABASES;
USE `peq`;
/* Entering session "EQ" */
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='peq';
SHOW TABLE STATUS FROM `peq`;
SHOW FUNCTION STATUS WHERE `Db`='peq';
SHOW PROCEDURE STATUS WHERE `Db`='peq';
SHOW TRIGGERS FROM `peq`;
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='information_schema';
SHOW TABLE STATUS FROM `information_schema`;
SHOW FUNCTION STATUS WHERE `Db`='information_schema';
SHOW PROCEDURE STATUS WHERE `Db`='information_schema';
SHOW TRIGGERS FROM `information_schema`;
SHOW EVENTS FROM `information_schema`;
SELECT *, EVENT_SCHEMA AS `Db`, EVENT_NAME AS `Name` FROM information_schema.`EVENTS` WHERE `EVENT_SCHEMA`='peq';
SHOW KEYS FROM `guild_members` WHERE `Key_name` LIKE 'PRIMARY';
/* Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 1 query: 0.000 sec. */
SHOW KEYS FROM `group_id` WHERE `Key_name` LIKE 'PRIMARY';
/* Affected rows: 0 Found rows: 4 Warnings: 0 Duration for 1 query: 0.000 sec. */


This everything you needed?

[Uleat]

`guild_members` has 1 key for standard, 0 keys for bots..

`group_id` has 3 keys for standard, 4 keys for bots..


Based on that, and the previous checks, it 'looks' like you have the correct db schema for bots.


At this point, we really need log errors to see what may be going on - in particular, database query failures.

[ionhsmith]

where do I find these because in my logs folder I don't see any thing except world.exe logs and in the zone folder ... everything else is blank

[Uleat]

Check your zone folder logs.

Look for entries in the zone log for the zone where the failed action occurred.

[ionhsmith]

[07-07-2015 :: 22:47:03] [Crash] EXCEPTION_ACCESS_VIOLATION
[07-07-2015 :: 22:47:03] [Crash] SymInit: Symbol-SearchPath: '.;C:\EQ\EQEMUServer;C:\EQ\EQEMUServer;C:\Windows; C:\Windows\system32;SRV*C:\websymbols*http://msdl.microsoft.com/download/symbols;', symOptions: 530, UserName: 'Gamble'
[07-07-2015 :: 22:47:03] [Crash] OS-Version: 6.1.7601 (Service Pack 1) 0x300-0x1
[07-07-2015 :: 22:47:04] [Crash] C:\EQ\EQEMUServer\world.exe:world.exe (00D60000), size: 7806976 (result: 0), SymType: 'PDB', PDB: 'C:\EQ\EQEMUServer\world.exe'
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\SysWOW64\ntdll.dll:ntdll.dll (77B00000), size: 1572864 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\SysWOW64\ntdll.dll', fileVersion: 6.1.7601.18869
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\syswow64\kernel32.dll:kernel32.dll (759B0000), size: 1114112 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\kernel32.dll', fileVersion: 6.1.7601.18869
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\syswow64\KERNELBASE.dll:KERNELBASE.dll (76050000), size: 290816 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\KERNELBASE.dll', fileVersion: 6.1.7601.18869
[07-07-2015 :: 22:47:04] [Crash] C:\Perl\bin\perl512.dll:perl512.dll (28000000), size: 1273856 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\bin\perl512.dll', fileVersion: 5.12.3.1204
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\syswow64\USER32.dll:USER32.dll (77130000), size: 1048576 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\USER32.dll', fileVersion: 6.1.7601.17514
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\syswow64\GDI32.dll:GDI32.dll (76110000), size: 589824 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\GDI32.dll', fileVersion: 6.1.7601.18778
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\syswow64\LPK.dll:LPK.dll (760E0000), size: 40960 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\LPK.dll', fileVersion: 6.1.7601.18768
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\syswow64\USP10.dll:USP10.dll (77030000), size: 643072 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\USP10.dll', fileVersion: 1.626.7601.18454
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\syswow64\msvcrt.dll:msvcrt.dll (75F90000), size: 704512 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\msvcrt.dll', fileVersion: 7.0.7601.17744
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\syswow64\ADVAPI32.dll:ADVAPI32.dll (77650000), size: 659456 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\ADVAPI32.dll', fileVersion: 6.1.7601.18869
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\SysWOW64\sechost.dll:sechost.dll (75570000), size: 102400 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\SysWOW64\sechost.dll', fileVersion: 6.1.7601.18869
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\syswow64\RPCRT4.dll:RPCRT4.dll (75EA0000), size: 983040 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\RPCRT4.dll', fileVersion: 6.1.7601.18532
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\syswow64\SspiCli.dll:SspiCli.dll (75470000), size: 393216 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\SspiCli.dll', fileVersion: 6.1.7601.18869
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\syswow64\CRYPTBASE.dll:CRYPTBASE.dll (75460000), size: 49152 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\CRYPTBASE.dll', fileVersion: 6.1.7600.16385
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.7601.18837_none_ec8 6b8d6858ec0bc\COMCTL32.dll:COMCTL32.dll (6EBD0000), size: 540672 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.7601.18837_none_ec8 6b8d6858ec0bc\COMCTL32.dll', fileVersion: 5.82.7601.18837
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\syswow64\WS2_32.dll:WS2_32.dll (760A0000), size: 217088 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\WS2_32.dll', fileVersion: 6.1.7601.17514
[07-07-2015 :: 22:47:04] [Crash] C:\Windows\syswow64\NSI.dll:NSI.dll (76ED0000), size: 24576 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\NSI.dll', fileVersion: 6.1.7600.16385
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\system32\VERSION.dll:VERSION.dll (736A0000), size: 36864 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\VERSION.dll', fileVersion: 6.1.7600.16385
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\system32\IMM32.DLL:IMM32.DLL (775F0000), size: 393216 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\IMM32.DLL', fileVersion: 6.1.7601.17514
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\syswow64\MSCTF.dll:MSCTF.dll (76E00000), size: 835584 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\MSCTF.dll', fileVersion: 6.1.7601.18731
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\system32\NLAapi.dll:NLAapi.dll (68CA0000), size: 65536 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\NLAapi.dll', fileVersion: 6.1.7601.18685
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\system32\napinsp.dll:napinsp.dll (68C90000), size: 65536 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\napinsp.dll', fileVersion: 6.1.7600.16385
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\system32\pnrpnsp.dll:pnrpnsp.dll (67F40000), size: 73728 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\pnrpnsp.dll', fileVersion: 6.1.7600.16385
[07-07-2015 :: 22:47:05] [Crash] C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live\WLIDNSP.DLL:WLIDNSP.DLL (6E950000), size: 159744 (result: 0), SymType: '-exported-', PDB: 'C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live\WLIDNSP.DLL', fileVersion: 7.250.4225.0
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\syswow64\PSAPI.DLL:PSAPI.DLL (761A0000), size: 20480 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\PSAPI.DLL', fileVersion: 6.1.7600.16385
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\syswow64\SHLWAPI.dll:SHLWAPI.dll (75950000), size: 356352 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\SHLWAPI.dll', fileVersion: 6.1.7601.17514
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\System32\mswsock.dll:mswsock.dll (71D60000), size: 245760 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\mswsock.dll', fileVersion: 6.1.7601.18254
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\system32\DNSAPI.dll:DNSAPI.dll (71BF0000), size: 278528 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\DNSAPI.dll', fileVersion: 6.1.7601.17570
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\System32\winrnr.dll:winrnr.dll (68C80000), size: 32768 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\winrnr.dll', fileVersion: 6.1.7600.16385
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\system32\rasadhlp.dll:rasadhlp.dll (6E940000), size: 24576 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\rasadhlp.dll', fileVersion: 6.1.7600.16385
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\System32\wshtcpip.dll:wshtcpip.dll (71D50000), size: 20480 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\wshtcpip.dll', fileVersion: 6.1.7600.16385
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\System32\wship6.dll:wship6.dll (6E9B0000), size: 24576 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\wship6.dll', fileVersion: 6.1.7600.16385
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\system32\IPHLPAPI.DLL:IPHLPAPI.DLL (71C50000), size: 114688 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\IPHLPAPI.DLL', fileVersion: 6.1.7601.17514
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\system32\WINNSI.DLL:WINNSI.DLL (71C40000), size: 28672 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\WINNSI.DLL', fileVersion: 6.1.7600.16385
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\System32\fwpuclnt.dll:fwpuclnt.dll (6E900000), size: 229376 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\fwpuclnt.dll', fileVersion: 6.1.7601.18283
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\system32\apphelp.dll:apphelp.dll (6CB20000), size: 311296 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\apphelp.dll', fileVersion: 6.1.7601.18777
[07-07-2015 :: 22:47:05] [Crash] C:\Windows\system32\dbghelp.dll:dbghelp.dll (75100000), size: 962560 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\dbghelp.dll', fileVersion: 6.1.7601.17514
[07-07-2015 :: 22:47:06] [Crash] c:\eq\source\common\queue.h (116): MyQueue<ServerPacket>::count
[07-07-2015 :: 22:47:06] [Crash] c:\eq\source\common\emu_tcp_connection.cpp (803): EmuTCPConnection::RecvData
[07-07-2015 :: 22:47:06] [Crash] c:\eq\source\common\tcp_connection.cpp (541): TCPConnection::Process
[07-07-2015 :: 22:47:07] [Crash] c:\eq\source\common\tcp_server.h (99): TCPServer<EmuTCPConnection>::Process
[07-07-2015 :: 22:47:07] [Crash] c:\eq\source\common\emu_tcp_server.cpp (23): EmuTCPServer::Process
[07-07-2015 :: 22:47:07] [Crash] c:\eq\source\common\tcp_server.cpp (77): BaseTCPServer::TCPServerLoop
[07-07-2015 :: 22:47:07] [Crash] f:\dd\vctools\crt\crtw32\startup\thread.c (255): _callthreadstart
[07-07-2015 :: 22:47:07] [Crash] f:\dd\vctools\crt\crtw32\startup\thread.c (239): _threadstart
[07-07-2015 :: 22:47:07] [Crash] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 759C337A)
[07-07-2015 :: 22:47:07] [Crash] 759C337A (kernel32): (filename not available): BaseThreadInitThunk
[07-07-2015 :: 22:47:07] [Crash] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77B392E2)
[07-07-2015 :: 22:47:07] [Crash] 77B392E2 (ntdll): (filename not available): RtlInitializeExceptionChain
[07-07-2015 :: 22:47:07] [Crash] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77B392B5)
[07-07-2015 :: 22:47:07] [Crash] 77B392B5 (ntdll): (filename not available): RtlInitializeExceptionChain


just got this one

[ionhsmith]

[02-23-2016 :: 20:36:13] [Crash] EXCEPTION_ACCESS_VIOLATION
[02-23-2016 :: 20:36:13] [Crash] SymInit: Symbol-SearchPath: '.;C:\EQ\EQEMUServer;C:\EQ\EQEMUServer;C:\WINDOWS; C:\WINDOWS\system32;SRV*C:\websymbols*http://msdl.microsoft.com/download/symbols;', symOptions: 530, UserName: 'Gamble'
[02-23-2016 :: 20:36:13] [Crash] OS-Version: 6.2.9200 () 0x300-0x1
[02-23-2016 :: 20:36:14] [Crash] C:\EQ\EQEMUServer\zone.exe:zone.exe (00020000), size: 17686528 (result: 0), SymType: 'PDB', PDB: 'C:\EQ\EQEMUServer\zone.exe'
[02-23-2016 :: 20:36:14] [Crash] C:\WINDOWS\SYSTEM32\ntdll.dll:ntdll.dll (76FE0000), size: 1544192 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\ntdll.dll', fileVersion: 6.2.10240.16683
[02-23-2016 :: 20:36:14] [Crash] C:\WINDOWS\SYSTEM32\KERNEL32.DLL:KERNEL32.DLL (74680000), size: 983040 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\KERNEL32.DLL', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:14] [Crash] C:\WINDOWS\SYSTEM32\KERNELBASE.dll:KERNELBASE.dll (742B0000), size: 1531904 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\KERNELBASE.dll', fileVersion: 6.2.10240.16683
[02-23-2016 :: 20:36:14] [Crash] C:\WINDOWS\system32\apphelp.dll:apphelp.dll (73FC0000), size: 593920 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\apphelp.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:14] [Crash] C:\WINDOWS\AppPatch\AcLayers.DLL:AcLayers.DLL (67C60000), size: 2588672 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\AppPatch\AcLayers.DLL', fileVersion: 6.2.10240.16425
[02-23-2016 :: 20:36:14] [Crash] C:\WINDOWS\SYSTEM32\msvcrt.dll:msvcrt.dll (75320000), size: 778240 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\msvcrt.dll', fileVersion: 7.0.10240.16384
[02-23-2016 :: 20:36:14] [Crash] C:\WINDOWS\SYSTEM32\USER32.dll:USER32.dll (74530000), size: 1310720 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\USER32.dll', fileVersion: 6.2.10240.16603
[02-23-2016 :: 20:36:14] [Crash] C:\WINDOWS\SYSTEM32\GDI32.dll:GDI32.dll (751B0000), size: 1363968 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\GDI32.dll', fileVersion: 6.2.10240.16644
[02-23-2016 :: 20:36:14] [Crash] C:\WINDOWS\SYSTEM32\SHELL32.dll:SHELL32.dll (75620000), size: 20701184 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\SHELL32.dll', fileVersion: 6.2.10240.16542
[02-23-2016 :: 20:36:14] [Crash] C:\WINDOWS\SYSTEM32\windows.storage.dll:windows.st orage.dll (74BE0000), size: 5095424 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\windows.storage.dll', fileVersion: 6.2.10240.16515
[02-23-2016 :: 20:36:14] [Crash] C:\WINDOWS\SYSTEM32\combase.dll:combase.dll (74940000), size: 1810432 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\combase.dll', fileVersion: 6.2.10240.16683
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\RPCRT4.dll:RPCRT4.dll (74430000), size: 704512 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\RPCRT4.dll', fileVersion: 6.2.10240.16412
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\SspiCli.dll:SspiCli.dll (740D0000), size: 122880 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\SspiCli.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\CRYPTBASE.dll:CRYPTBASE.dll (740C0000), size: 40960 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\CRYPTBASE.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\bcryptPrimitives.dll:bcryptPri mitives.dll (74060000), size: 364544 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\bcryptPrimitives.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\sechost.dll:sechost.dll (740F0000), size: 274432 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\sechost.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\advapi32.dll:advapi32.dll (74B20000), size: 503808 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\advapi32.dll', fileVersion: 6.2.10240.16644
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\shlwapi.dll:shlwapi.dll (76DF0000), size: 278528 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\shlwapi.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\kernel.appcore.dll:kernel.appc ore.dll (74B10000), size: 49152 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\kernel.appcore.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\shcore.dll:shcore.dll (750C0000), size: 577536 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\shcore.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\powrprof.dll:powrprof.dll (76F90000), size: 278528 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\powrprof.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\profapi.dll:profapi.dll (74670000), size: 61440 (result: 0), SymType: '-nosymbols-', PDB: 'C:\WINDOWS\SYSTEM32\profapi.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\OLEAUT32.dll:OLEAUT32.dll (74830000), size: 598016 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\OLEAUT32.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\SETUPAPI.dll:SETUPAPI.dll (76C40000), size: 1724416 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\SETUPAPI.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\CFGMGR32.dll:CFGMGR32.dll (74BA0000), size: 221184 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\CFGMGR32.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\MPR.dll:MPR.dll (737A0000), size: 94208 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\MPR.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\sfc.dll:sfc.dll (012C0000), size: 12288 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\sfc.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\WINSPOOL.DRV:WINSPOOL.DRV (6FD50000), size: 421888 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\WINSPOOL.DRV', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\bcrypt.dll:bcrypt.dll (72F30000), size: 110592 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\bcrypt.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\sfc_os.DLL:sfc_os.DLL (67C50000), size: 61440 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\sfc_os.DLL', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\IMM32.DLL:IMM32.DLL (74280000), size: 176128 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\IMM32.DLL', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\MSCTF.dll:MSCTF.dll (74160000), size: 1179648 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\MSCTF.dll', fileVersion: 6.2.10240.16683
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\WS2_32.dll:WS2_32.dll (76F30000), size: 376832 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\WS2_32.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\NSI.dll:NSI.dll (75480000), size: 28672 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\NSI.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\EQ\EQEMUServer\LIBMYSQL.dll:LIBMYSQL.dll (64A30000), size: 3960832 (result: 0), SymType: 'PDB', PDB: 'C:\EQ\EQEMUServer\LIBMYSQL.dll'
[02-23-2016 :: 20:36:15] [Crash] C:\EQ\EQEMUServer\zlib1.dll:zlib1.dll (67FC0000), size: 81920 (result: 0), SymType: '-exported-', PDB: 'C:\EQ\EQEMUServer\zlib1.dll', fileVersion: 1.2.8.0
[02-23-2016 :: 20:36:15] [Crash] C:\EQ\EQEMUServer\lua51.dll:lua51.dll (67520000), size: 356352 (result: 0), SymType: '-exported-', PDB: 'C:\EQ\EQEMUServer\lua51.dll'
[02-23-2016 :: 20:36:15] [Crash] C:\Perl\bin\perl512.dll:perl512.dll (28000000), size: 1273856 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\bin\perl512.dll', fileVersion: 5.12.3.1204
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\VERSION.dll:VERSION.dll (73660000), size: 32768 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\VERSION.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\SYSTEM32\MSVCR110.dll:MSVCR110.dll (67EE0000), size: 876544 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\MSVCR110.dll', fileVersion: 11.0.51106.1
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.10240.16384_none_49 c02355cf03478c\COMCTL32.dll:COMCTL32.dll (753E0000), size: 598016 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.10240.16384_none_49 c02355cf03478c\COMCTL32.dll', fileVersion: 5.82.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\system32\NLAapi.dll:NLAapi.dll (73100000), size: 77824 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\NLAapi.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\system32\napinsp.dll:napinsp.dll (730B0000), size: 73728 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\napinsp.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\system32\pnrpnsp.dll:pnrpnsp.dll (73090000), size: 90112 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\pnrpnsp.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:15] [Crash] C:\WINDOWS\System32\mswsock.dll:mswsock.dll (72890000), size: 319488 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\mswsock.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:16] [Crash] C:\WINDOWS\SYSTEM32\DNSAPI.dll:DNSAPI.dll (73DC0000), size: 540672 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\DNSAPI.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:16] [Crash] C:\WINDOWS\System32\winrnr.dll:winrnr.dll (737F0000), size: 45056 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\winrnr.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:16] [Crash] C:\Windows\System32\rasadhlp.dll:rasadhlp.dll (6FCD0000), size: 32768 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\rasadhlp.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:16] [Crash] C:\WINDOWS\System32\fwpuclnt.dll:fwpuclnt.dll (6FCE0000), size: 286720 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\fwpuclnt.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:16] [Crash] C:\Perl\lib\auto\Cwd\Cwd.dll:Cwd.dll (10000000), size: 20480 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\lib\auto\Cwd\Cwd.dll'
[02-23-2016 :: 20:36:17] [Crash] C:\Perl\site\lib\auto\DBI\DBI.dll:DBI.dll (0D770000), size: 98304 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\site\lib\auto\DBI\DBI.dll'
[02-23-2016 :: 20:36:17] [Crash] C:\Perl\lib\auto\List\Util\Util.dll:Util.dll (01450000), size: 28672 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\lib\auto\List\Util\Util.dll'
[02-23-2016 :: 20:36:17] [Crash] C:\Perl\lib\auto\Filter\Util\Call\Call.dll:Call.dl l (030F0000), size: 20480 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\lib\auto\Filter\Util\Call\Call.dll'
[02-23-2016 :: 20:36:17] [Crash] C:\Perl\lib\auto\IO\IO.dll:IO.dll (03250000), size: 24576 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\lib\auto\IO\IO.dll'
[02-23-2016 :: 20:36:17] [Crash] C:\Perl\site\lib\auto\DBD\mysql\mysql.dll:mysql.dl l (0D790000), size: 86016 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\site\lib\auto\DBD\mysql\mysql.dll'
[02-23-2016 :: 20:36:17] [Crash] C:\WINDOWS\SYSTEM32\dbghelp.dll:dbghelp.dll (68820000), size: 1306624 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\dbghelp.dll', fileVersion: 6.2.10240.16384
[02-23-2016 :: 20:36:24] [Crash] c:\eq\source\zone\bot.cpp (3880): Bot::LoadAndSpawnAllZonedBots
[02-23-2016 :: 20:36:24] [Crash] c:\eq\source\zone\client_packet.cpp (1556): Client::Handle_Connect_OP_ZoneEntry
[02-23-2016 :: 20:36:24] [Crash] c:\eq\source\zone\client_packet.cpp (452): Client::HandlePacket
[02-23-2016 :: 20:36:24] [Crash] c:\eq\source\zone\client_process.cpp (609): Client::Process
[02-23-2016 :: 20:36:24] [Crash] c:\eq\source\zone\entity.cpp (487): EntityList::MobProcess
[02-23-2016 :: 20:36:24] [Crash] c:\eq\source\zone\net.cpp (472): main
[02-23-2016 :: 20:36:24] [Crash] f:\dd\vctools\crt\crtw32\startup\crt0.c (255): __tmainCRTStartup
[02-23-2016 :: 20:36:24] [Crash] f:\dd\vctools\crt\crtw32\startup\crt0.c (165): mainCRTStartup
[02-23-2016 :: 20:36:24] [Crash] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 74693744)
[02-23-2016 :: 20:36:24] [Crash] 74693744 (KERNEL32): (filename not available): BaseThreadInitThunk
[02-23-2016 :: 20:36:24] [Crash] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77039E54)
[02-23-2016 :: 20:36:24] [Crash] 77039E54 (ntdll): (filename not available): RtlSetCurrentTransaction
[02-23-2016 :: 20:36:24] [Crash] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77039E1F)
[02-23-2016 :: 20:36:24] [Crash] 77039E1F (ntdll): (filename not available): RtlSetCurrentTransaction

[ionhsmith]

Hey Uleat ... have you had a chance to look at this anymore? Anything else I can contribute to helping figure this issues out for people?

[Uleat]

https://github.com/EQEmu/Server/blob/master/zone/bot.cpp#L3880


It's still too vague to determine what the actual cause is.

Group is taken from the bot owner - who should be leader in that case.

And the code that follows can only be accessed if the conditions that appear to lead to the crash are true. (The access of 'g->GetLeader()->GetID()' would crash if 'g' or
'GetLeader()' were nullptr..but, they're not. They could have been recently deleted..but, that type of diagnosis requires a hands-on testing.)

[ponyboy_nd32]

I was running into this same issue, however I did not receive a crash or anything when I zoned or died. The bots would simply despawn and I would have to respawn them.

After some investigation, I was able to fix the zoning issue by commenting out the the Depop(); line in:

https://github.com/EQEmu/Server/blob/master/zone/bot.cpp#L6960



I was also able to prevent my bots from despawning when I die with a couple other changes. Now when I die, my bots do not despawn but instead my group gets disbanded and my bots zone to my bind spot with me.

What I would like to happen is that when I die my bots stay where they are and continue to fight until they die also or better yet win. That way when I die they could Rez me to where we they are (assuming they didn't die also) and I wouldn't have to run back. I'm not sure if this is possible since looking at the code it seems that anytime the client zones the bots zone along with them.

[Uleat]

Not sure if this is relevant to this thread..

..but, I pushed a fix for a database-related issue that may solve client crashing when zoning with bots, for some people.


For some reason, the view in the database was causing serious hang and delaying zone boot-up - causing the client to disconnect after a few minutes.

This fix is not very elegant..but, is much faster than using the view for affected systems.

[c0ncrete]

I made some modifications to the source a long time ago that allowed a group leader to invite any group member's bots. If there is interest, I'll see if I can find it, test it with the current source, and post a patch here.

[DanCanDo]

I made some modifications to the source a long time ago that allowed a group leader to invite any group member's bots. If there is interest, I'll see if I can find it, test it with the current source, and post a patch here.

That would be an interest in my world (chuckle)

[c0ncrete]

affirmative. i'll fetch the old laptop out of storage and see what i can find. even if i'm unable, i think the alteration wasn't too difficult. it's been a long time since i've poked around in there, but i should be able to duplicate it without too much effort.

[Random Gamer]

I added logging to the Bot::Depop() It doesn't trigger when the bots are vanishing.

Bots basically only fudge up, when a party member zones into the zone, (Does not call Bot::Depop() yet bots vanish) or if the main toon zones in after other players. Bots go non-responsive, basically drop group, but not visually updated on client side.

So, what ever re-groups the players, when zoning, with bots is what is broken.