Bot Zoning / Grouping issue - Page 2

ionhsmith · #16 02-22-2016, 11:04 PM

Code:

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. */

Code:

/* 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** · #17 02-22-2016, 11:13 PM

`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 · #18 02-23-2016, 06:58 PM

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** · #19 02-23-2016, 07:25 PM

Check your zone folder logs.

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

ionhsmith · #20 02-23-2016, 09:38 PM

Code:

[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_ec86b8d6858ec0bc\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_ec86b8d6858ec0bc\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 · #21 02-23-2016, 09:40 PM

Code:

[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.storage.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:bcryptPrimitives.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.appcore.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_49c02355cf03478c\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_49c02355cf03478c\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.dll (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.dll (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 · #22 02-29-2016, 03:56 PM

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** · #23 02-29-2016, 06:55 PM

https://github.com/EQEmu/Server/blob.../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 · #24 05-14-2016, 11:39 AM

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.../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** · #25 07-12-2016, 10:22 PM

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 · #26 07-14-2016, 04:27 PM

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 · #27 07-15-2016, 05:11 PM

Quote:

Originally Posted by 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.

That would be an interest in my world (chuckle)

c0ncrete · #28 07-16-2016, 01:44 AM

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 · #29 02-13-2017, 02:11 AM

I added logging to the Bot:

epop() 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:

epop() 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.