Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::General Support
Reload this Page Issue with Waypoints.

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
Page 1 of 2 1 2
 
Thread Tools Display Modes
  #1  
Old 06-22-2015, 11:09 PM
Nerdgasm
Discordant
  
Join Date: Apr 2013
Posts: 419
Default Issue with Waypoints.
So we were setting up mobs to patrol and every time we used #wp add or #wp circular, zone crashed. This is the error.

Code:
---------------------------------------------
[06.19. - 20:34:37] Starting Log: logs/crash_shared_memory_8764.log
[06.19. - 20:34:37] EXCEPTION_BREAKPOINT
[06.19. - 20:34:37] 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: 'Steven' 
[06.19. - 20:34:37] OS-Version: 6.2.9200 () 0x300-0x1 
[06.19. - 20:34:37] C:\EQ\EQEmuServer\shared_memory.exe:shared_memory.exe (00810000), size: 5087232 (result: 0), SymType: 'PDB', PDB: 'C:\EQ\EQEmuServer\shared_memory.exe' 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\ntdll.dll:ntdll.dll (77B20000), size: 1409024 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\ntdll.dll', fileVersion: 6.2.9200.17313 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\KERNEL32.DLL:KERNEL32.DLL (77000000), size: 1245184 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\KERNEL32.DLL', fileVersion: 6.2.9200.16815 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\KERNELBASE.dll:KERNELBASE.dll (75730000), size: 684032 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\KERNELBASE.dll', fileVersion: 6.2.9200.17366 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\WS2_32.dll:WS2_32.dll (77960000), size: 327680 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\WS2_32.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\VERSION.dll:VERSION.dll (75090000), size: 32768 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\VERSION.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\USER32.dll:USER32.dll (774D0000), size: 1138688 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\USER32.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\ADVAPI32.dll:ADVAPI32.dll (779B0000), size: 712704 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\ADVAPI32.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\RPCRT4.dll:RPCRT4.dll (77410000), size: 704512 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\RPCRT4.dll', fileVersion: 6.2.9200.17037 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\NSI.dll:NSI.dll (755B0000), size: 32768 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\NSI.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\msvcrt.dll:msvcrt.dll (76DF0000), size: 724992 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\msvcrt.dll', fileVersion: 7.0.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\GDI32.dll:GDI32.dll (76B40000), size: 1036288 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\GDI32.dll', fileVersion: 6.2.9200.17053 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\sechost.dll:sechost.dll (778A0000), size: 212992 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\sechost.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\SspiCli.dll:SspiCli.dll (75110000), size: 118784 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\SspiCli.dll', fileVersion: 6.2.9200.16864 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\CRYPTBASE.dll:CRYPTBASE.dll (75100000), size: 36864 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\CRYPTBASE.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\bcryptPrimitives.dll:bcryptPrimitives.dll (750A0000), size: 331776 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\bcryptPrimitives.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\system32\IMM32.DLL:IMM32.DLL (77860000), size: 131072 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\IMM32.DLL', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\MSCTF.dll:MSCTF.dll (768B0000), size: 905216 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\MSCTF.dll', fileVersion: 6.2.9200.17310 
[06.19. - 20:34:37] C:\WINDOWS\system32\napinsp.dll:napinsp.dll (74DB0000), size: 65536 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\napinsp.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\system32\pnrpnsp.dll:pnrpnsp.dll (74C70000), size: 81920 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\pnrpnsp.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\system32\NLAapi.dll:NLAapi.dll (74C60000), size: 65536 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\NLAapi.dll', fileVersion: 6.2.9200.17199 
[06.19. - 20:34:37] C:\WINDOWS\System32\mswsock.dll:mswsock.dll (74DC0000), size: 303104 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\mswsock.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\DNSAPI.dll:DNSAPI.dll (74D30000), size: 475136 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\DNSAPI.dll', fileVersion: 6.2.9200.17137 
[06.19. - 20:34:37] C:\WINDOWS\System32\winrnr.dll:winrnr.dll (74C50000), size: 36864 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\winrnr.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\Windows\System32\rasadhlp.dll:rasadhlp.dll (74D20000), size: 28672 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\rasadhlp.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\system32\uxtheme.dll:uxtheme.dll (735D0000), size: 557056 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\uxtheme.dll', fileVersion: 6.2.9200.17377 
[06.19. - 20:34:37] C:\Users\Steven\Desktop\Mq2\MQ2Main.dll:MQ2Main.dll (13220000), size: 925696 (result: 0), SymType: '-exported-', PDB: 'C:\Users\Steven\Desktop\Mq2\MQ2Main.dll' 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\WSOCK32.dll:WSOCK32.dll (73660000), size: 32768 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\WSOCK32.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\WINMM.dll:WINMM.dll (73400000), size: 135168 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\WINMM.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\SHELL32.dll:SHELL32.dll (757E0000), size: 17588224 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\SHELL32.dll', fileVersion: 6.2.9200.17279 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\WINMMBASE.dll:WINMMBASE.dll (733D0000), size: 172032 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\WINMMBASE.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\combase.dll:combase.dll (77720000), size: 1269760 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\combase.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\SHLWAPI.dll:SHLWAPI.dll (753C0000), size: 262144 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\SHLWAPI.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\PROGRA~2\Raptr\ltc_help32-96675.dll:ltc_help32-96675.dll (60370000), size: 135168 (result: 0), SymType: '-exported-', PDB: 'C:\PROGRA~2\Raptr\ltc_help32-96675.dll', fileVersion: 1.0.0.1 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\WINTRUST.dll:WINTRUST.dll (773B0000), size: 270336 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\WINTRUST.dll', fileVersion: 6.2.9200.16666 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\CRYPT32.dll:CRYPT32.dll (76C60000), size: 1581056 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\CRYPT32.dll', fileVersion: 6.2.9200.17164 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\MSASN1.dll:MSASN1.dll (76EB0000), size: 73728 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\MSASN1.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\dwmapi.dll:dwmapi.dll (73090000), size: 106496 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\dwmapi.dll', fileVersion: 6.2.9200.17044 
[06.19. - 20:34:37] C:\WINDOWS\system32\ole32.dll:ole32.dll (75490000), size: 1150976 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\ole32.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\dbghelp.dll:dbghelp.dll (73430000), size: 1216512 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\dbghelp.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] g:\bs\connector-c-vs2008-32bit\src\mysql-connector-c-6.0.2\mysys\my_thr_init.c (510): my_sigabrt_handler 
[06.19. - 20:34:37] f:\dd\vctools\crt\crtw32\misc\winsig.c (587): raise 
[06.19. - 20:34:37] f:\dd\vctools\crt\crtw32\misc\dbgrpt.c (401): __crtMessageWindowW 
[06.19. - 20:34:37] f:\dd\vctools\crt\crtw32\misc\dbgrptt.c (672): _VCrtDbgReportW 
[06.19. - 20:34:37] f:\dd\vctools\crt\crtw32\misc\dbgrpt.c (262): _CrtDbgReportWV 
[06.19. - 20:34:37] f:\dd\vctools\crt\crtw32\misc\dbgrpt.c (279): _CrtDbgReportW 
[06.19. - 20:34:37] f:\dd\vctools\crt\crtw32\convert\strtol.c (94): strtoxl 
[06.19. - 20:34:37] f:\dd\vctools\crt\crtw32\convert\strtol.c (232): strtol 
[06.19. - 20:34:37] f:\dd\vctools\crt\crtw32\convert\atox.c (56): atol 
[06.19. - 20:34:37] f:\dd\vctools\crt\crtw32\convert\atox.c (100): atoi 
[06.19. - 20:34:37] c:\eq\source\common\shareddb.cpp (894): SharedDatabase::LoadItems 
[06.19. - 20:34:37] c:\eq\source\shared_memory\items.cpp (44): LoadItems 
[06.19. - 20:34:37] c:\eq\source\shared_memory\main.cpp (114): main 
[06.19. - 20:34:37] f:\dd\vctools\crt\crtw32\startup\crt0.c (255): __tmainCRTStartup 
[06.19. - 20:34:37] f:\dd\vctools\crt\crtw32\startup\crt0.c (165): mainCRTStartup 
[06.19. - 20:34:37] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77028624) 
[06.19. - 20:34:37] 77028624 (KERNEL32): (filename not available): BaseThreadInitThunk 
[06.19. - 20:34:37] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77B7BCE9) 
[06.19. - 20:34:37] 77B7BCE9 (ntdll): (filename not available): RtlInitializeExceptionChain 
[06.19. - 20:34:37] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77B7BCBC) 
[06.19. - 20:34:37] 77B7BCBC (ntdll): (filename not available): RtlInitializeExceptionChain
__________________
I am the All Mighty Mittens!
Reply With Quote
  #2  
Old 06-23-2015, 12:22 AM
Kingly_Krab
Administrator
  
Join Date: May 2013
Location: United States
Posts: 1,603
Default
Has nothing to do with waypoints, you have a NULL column in your items table causing a crash in your shared_memory:
Code:
[06.19. - 20:34:37] c:\eq\source\common\shareddb.cpp (894): SharedDatabase::LoadItems
[06.19. - 20:34:37] c:\eq\source\shared_memory\items.cpp (44): LoadItems
Reply With Quote
  #3  
Old 06-23-2015, 04:23 AM
Nerdgasm
Discordant
  
Join Date: Apr 2013
Posts: 419
Default
I figured it was an item issue based on that when I saw the crash logs, it's just weird that literally the ONLY time it crashes is when we do anything with waypoints.

I'll figure out where the issue is in the item table and go from there.

Thanks.
__________________
I am the All Mighty Mittens!
Reply With Quote
  #4  
Old 06-23-2015, 11:05 PM
Nerdgasm
Discordant
  
Join Date: Apr 2013
Posts: 419
Default
So I rebuilt my items table, and redid the entire data tables, did #wpadd circular 40 and boom. Server crashed, same log.

Code:
---------------------------------------------
[06.19. - 20:34:37] Starting Log: logs/crash_shared_memory_8764.log
[06.19. - 20:34:37] EXCEPTION_BREAKPOINT
[06.19. - 20:34:37] 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: 'Steven' 
[06.19. - 20:34:37] OS-Version: 6.2.9200 () 0x300-0x1 
[06.19. - 20:34:37] C:\EQ\EQEmuServer\shared_memory.exe:shared_memory.exe (00810000), size: 5087232 (result: 0), SymType: 'PDB', PDB: 'C:\EQ\EQEmuServer\shared_memory.exe' 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\ntdll.dll:ntdll.dll (77B20000), size: 1409024 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\ntdll.dll', fileVersion: 6.2.9200.17313 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\KERNEL32.DLL:KERNEL32.DLL (77000000), size: 1245184 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\KERNEL32.DLL', fileVersion: 6.2.9200.16815 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\KERNELBASE.dll:KERNELBASE.dll (75730000), size: 684032 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\KERNELBASE.dll', fileVersion: 6.2.9200.17366 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\WS2_32.dll:WS2_32.dll (77960000), size: 327680 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\WS2_32.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\VERSION.dll:VERSION.dll (75090000), size: 32768 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\VERSION.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\USER32.dll:USER32.dll (774D0000), size: 1138688 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\USER32.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\ADVAPI32.dll:ADVAPI32.dll (779B0000), size: 712704 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\ADVAPI32.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\RPCRT4.dll:RPCRT4.dll (77410000), size: 704512 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\RPCRT4.dll', fileVersion: 6.2.9200.17037 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\NSI.dll:NSI.dll (755B0000), size: 32768 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\NSI.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\msvcrt.dll:msvcrt.dll (76DF0000), size: 724992 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\msvcrt.dll', fileVersion: 7.0.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\GDI32.dll:GDI32.dll (76B40000), size: 1036288 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\GDI32.dll', fileVersion: 6.2.9200.17053 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\sechost.dll:sechost.dll (778A0000), size: 212992 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\sechost.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\SspiCli.dll:SspiCli.dll (75110000), size: 118784 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\SspiCli.dll', fileVersion: 6.2.9200.16864 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\CRYPTBASE.dll:CRYPTBASE.dll (75100000), size: 36864 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\CRYPTBASE.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\bcryptPrimitives.dll:bcryptPrimitives.dll (750A0000), size: 331776 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\bcryptPrimitives.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\system32\IMM32.DLL:IMM32.DLL (77860000), size: 131072 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\IMM32.DLL', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\MSCTF.dll:MSCTF.dll (768B0000), size: 905216 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\MSCTF.dll', fileVersion: 6.2.9200.17310 
[06.19. - 20:34:37] C:\WINDOWS\system32\napinsp.dll:napinsp.dll (74DB0000), size: 65536 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\napinsp.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\system32\pnrpnsp.dll:pnrpnsp.dll (74C70000), size: 81920 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\pnrpnsp.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\system32\NLAapi.dll:NLAapi.dll (74C60000), size: 65536 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\NLAapi.dll', fileVersion: 6.2.9200.17199 
[06.19. - 20:34:37] C:\WINDOWS\System32\mswsock.dll:mswsock.dll (74DC0000), size: 303104 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\mswsock.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\DNSAPI.dll:DNSAPI.dll (74D30000), size: 475136 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\DNSAPI.dll', fileVersion: 6.2.9200.17137 
[06.19. - 20:34:37] C:\WINDOWS\System32\winrnr.dll:winrnr.dll (74C50000), size: 36864 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\winrnr.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\Windows\System32\rasadhlp.dll:rasadhlp.dll (74D20000), size: 28672 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\rasadhlp.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\system32\uxtheme.dll:uxtheme.dll (735D0000), size: 557056 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\uxtheme.dll', fileVersion: 6.2.9200.17377 
[06.19. - 20:34:37] C:\Users\Steven\Desktop\Mq2\MQ2Main.dll:MQ2Main.dll (13220000), size: 925696 (result: 0), SymType: '-exported-', PDB: 'C:\Users\Steven\Desktop\Mq2\MQ2Main.dll' 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\WSOCK32.dll:WSOCK32.dll (73660000), size: 32768 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\WSOCK32.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\WINMM.dll:WINMM.dll (73400000), size: 135168 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\WINMM.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\SHELL32.dll:SHELL32.dll (757E0000), size: 17588224 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\SHELL32.dll', fileVersion: 6.2.9200.17279 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\WINMMBASE.dll:WINMMBASE.dll (733D0000), size: 172032 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\WINMMBASE.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\combase.dll:combase.dll (77720000), size: 1269760 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\combase.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\SHLWAPI.dll:SHLWAPI.dll (753C0000), size: 262144 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\SHLWAPI.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\PROGRA~2\Raptr\ltc_help32-96675.dll:ltc_help32-96675.dll (60370000), size: 135168 (result: 0), SymType: '-exported-', PDB: 'C:\PROGRA~2\Raptr\ltc_help32-96675.dll', fileVersion: 1.0.0.1 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\WINTRUST.dll:WINTRUST.dll (773B0000), size: 270336 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\WINTRUST.dll', fileVersion: 6.2.9200.16666 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\CRYPT32.dll:CRYPT32.dll (76C60000), size: 1581056 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\CRYPT32.dll', fileVersion: 6.2.9200.17164 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\MSASN1.dll:MSASN1.dll (76EB0000), size: 73728 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\MSASN1.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\dwmapi.dll:dwmapi.dll (73090000), size: 106496 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\dwmapi.dll', fileVersion: 6.2.9200.17044 
[06.19. - 20:34:37] C:\WINDOWS\system32\ole32.dll:ole32.dll (75490000), size: 1150976 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\ole32.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] C:\WINDOWS\SYSTEM32\dbghelp.dll:dbghelp.dll (73430000), size: 1216512 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\dbghelp.dll', fileVersion: 6.2.9200.16384 
[06.19. - 20:34:37] g:\bs\connector-c-vs2008-32bit\src\mysql-connector-c-6.0.2\mysys\my_thr_init.c (510): my_sigabrt_handler 
[06.19. - 20:34:37] f:\dd\vctools\crt\crtw32\misc\winsig.c (587): raise 
[06.19. - 20:34:37] f:\dd\vctools\crt\crtw32\misc\dbgrpt.c (401): __crtMessageWindowW 
[06.19. - 20:34:37] f:\dd\vctools\crt\crtw32\misc\dbgrptt.c (672): _VCrtDbgReportW 
[06.19. - 20:34:37] f:\dd\vctools\crt\crtw32\misc\dbgrpt.c (262): _CrtDbgReportWV 
[06.19. - 20:34:37] f:\dd\vctools\crt\crtw32\misc\dbgrpt.c (279): _CrtDbgReportW 
[06.19. - 20:34:37] f:\dd\vctools\crt\crtw32\convert\strtol.c (94): strtoxl 
[06.19. - 20:34:37] f:\dd\vctools\crt\crtw32\convert\strtol.c (232): strtol 
[06.19. - 20:34:37] f:\dd\vctools\crt\crtw32\convert\atox.c (56): atol 
[06.19. - 20:34:37] f:\dd\vctools\crt\crtw32\convert\atox.c (100): atoi 
[06.19. - 20:34:37] c:\eq\source\common\shareddb.cpp (894): SharedDatabase::LoadItems 
[06.19. - 20:34:37] c:\eq\source\shared_memory\items.cpp (44): LoadItems 
[06.19. - 20:34:37] c:\eq\source\shared_memory\main.cpp (114): main 
[06.19. - 20:34:37] f:\dd\vctools\crt\crtw32\startup\crt0.c (255): __tmainCRTStartup 
[06.19. - 20:34:37] f:\dd\vctools\crt\crtw32\startup\crt0.c (165): mainCRTStartup 
[06.19. - 20:34:37] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77028624) 
[06.19. - 20:34:37] 77028624 (KERNEL32): (filename not available): BaseThreadInitThunk 
[06.19. - 20:34:37] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77B7BCE9) 
[06.19. - 20:34:37] 77B7BCE9 (ntdll): (filename not available): RtlInitializeExceptionChain 
[06.19. - 20:34:37] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77B7BCBC) 
[06.19. - 20:34:37] 77B7BCBC (ntdll): (filename not available): RtlInitializeExceptionChain
__________________
I am the All Mighty Mittens!
Reply With Quote
  #5  
Old 06-23-2015, 11:10 PM
Nerdgasm
Discordant
  
Join Date: Apr 2013
Posts: 419
Default
I know it says items, but what in items is crashing, there is no custom items in my db at the moment.
__________________
I am the All Mighty Mittens!
Reply With Quote
  #6  
Old 06-23-2015, 11:42 PM
Shendare
Dragon
  
Join Date: Apr 2009
Location: California
Posts: 814
Default
The line number it's stating as the problem - common/shareddb.cpp line 894 - loads an item's Fire Resist from the database, so it sounds like some item's FR field is null, or otherwise not a number.

https://github.com/EQEmu/Server/blob...reddb.cpp#L894
Reply With Quote
  #7  
Old 06-23-2015, 11:46 PM
Shendare
Dragon
  
Join Date: Apr 2009
Location: California
Posts: 814
Default
Looking at my copy of the database, it looks like it's an int column that doesn't allow nulls, and I can't find any records that don't have a valid value of -128 to +127 for the field. Very weird...
Reply With Quote
  #8  
Old 06-24-2015, 12:09 AM
Nerdgasm
Discordant
  
Join Date: Apr 2013
Posts: 419
Default
Yeah I have no idea...
__________________
I am the All Mighty Mittens!
Reply With Quote
  #9  
Old 06-24-2015, 01:28 AM
Nerdgasm
Discordant
  
Join Date: Apr 2013
Posts: 419
Default
The only thing I'm finding with FR is -100 up to 127. Everything else is inbetween with no null value, only 0.

When searching filter FR = Null it populates all the FR fields with 0. I mean, I know null means 0, or nothing. But in the scheme of things, I thought null was a blank field? O.o could that be the issue?
__________________
I am the All Mighty Mittens!
Reply With Quote
  #10  
Old 06-24-2015, 01:39 AM
Kingly_Krab
Administrator
  
Join Date: May 2013
Location: United States
Posts: 1,603
Default
Try using this query.
Code:
SELECT * FROM `items` WHERE `fr` IS NULL;
Reply With Quote
  #11  
Old 06-24-2015, 01:40 AM
Shendare
Dragon
  
Join Date: Apr 2009
Location: California
Posts: 814
Default
A null is a blank field. However, the default spells_new table definition in the peq database specifies that that field does not allow nulls, so any saves to the record that don't specify a value for FR get the default value, which is set to 0.

The error really is a headscratcher. I'm assuming you've tried rebooting the server and re-running everything, including shared_memory.
Reply With Quote
  #12  
Old 06-24-2015, 02:19 AM
Nerdgasm
Discordant
  
Join Date: Apr 2013
Posts: 419
Default
Just ran Shared_memory (and I do mean just) completed, 0 errors. Restarted server, hell even rebuilt server from ground up. However, I did just happen to notice this in my logs that was not there yesterday, so maybe this is something...

Code:
---------------------------------------------
[06.23. - 02:59:38] Starting Log: logs/crash_zone_2416.log
[06.23. - 02:59:38] EXCEPTION_BREAKPOINT
[06.23. - 02:59:38] 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: 'Steven' 
[06.23. - 02:59:38] OS-Version: 6.2.9200 () 0x300-0x1 
[06.23. - 02:59:39] C:\EQ\EQEmuServer\zone.exe:zone.exe (008E0000), size: 31141888 (result: 0), SymType: 'PDB', PDB: 'C:\EQ\EQEmuServer\zone.exe' 
[06.23. - 02:59:39] C:\WINDOWS\SYSTEM32\ntdll.dll:ntdll.dll (77D50000), size: 1499136 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\ntdll.dll', fileVersion: 6.3.9600.17736 
[06.23. - 02:59:39] C:\WINDOWS\SYSTEM32\KERNEL32.DLL:KERNEL32.DLL (75580000), size: 1310720 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\KERNEL32.DLL', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:39] C:\WINDOWS\SYSTEM32\KERNELBASE.dll:KERNELBASE.dll (75840000), size: 880640 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\KERNELBASE.dll', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:39] C:\WINDOWS\system32\apphelp.dll:apphelp.dll (75440000), size: 655360 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\apphelp.dll', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:39] C:\WINDOWS\AppPatch\AcLayers.DLL:AcLayers.DLL (70950000), size: 2584576 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\AppPatch\AcLayers.DLL', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:39] C:\WINDOWS\SYSTEM32\msvcrt.dll:msvcrt.dll (77300000), size: 798720 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\msvcrt.dll', fileVersion: 7.0.9600.17415 
[06.23. - 02:59:39] C:\WINDOWS\SYSTEM32\USER32.dll:USER32.dll (75920000), size: 1388544 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\USER32.dll', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:39] C:\WINDOWS\SYSTEM32\GDI32.dll:GDI32.dll (77640000), size: 1105920 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\GDI32.dll', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:39] C:\WINDOWS\SYSTEM32\SHELL32.dll:SHELL32.dll (75B20000), size: 19578880 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\SHELL32.dll', fileVersion: 6.3.9600.17680 
[06.23. - 02:59:39] C:\WINDOWS\SYSTEM32\SHLWAPI.dll:SHLWAPI.dll (77110000), size: 282624 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\SHLWAPI.dll', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:39] C:\WINDOWS\SYSTEM32\OLEAUT32.dll:OLEAUT32.dll (75A80000), size: 610304 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\OLEAUT32.dll', fileVersion: 6.3.9600.17560 
[06.23. - 02:59:39] C:\WINDOWS\SYSTEM32\MPR.dll:MPR.dll (71700000), size: 90112 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\MPR.dll', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:39] C:\WINDOWS\SYSTEM32\SETUPAPI.dll:SETUPAPI.dll (77AC0000), size: 1773568 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\SETUPAPI.dll', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:39] C:\WINDOWS\SYSTEM32\sfc.dll:sfc.dll (71440000), size: 12288 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\sfc.dll', fileVersion: 6.3.9600.16384 
[06.23. - 02:59:39] C:\WINDOWS\SYSTEM32\WINSPOOL.DRV:WINSPOOL.DRV (753C0000), size: 413696 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\WINSPOOL.DRV', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:39] C:\WINDOWS\SYSTEM32\RPCRT4.dll:RPCRT4.dll (77000000), size: 761856 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\RPCRT4.dll', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:39] C:\WINDOWS\SYSTEM32\combase.dll:combase.dll (756C0000), size: 1560576 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\combase.dll', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:39] C:\WINDOWS\SYSTEM32\CFGMGR32.dll:CFGMGR32.dll (77550000), size: 245760 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\CFGMGR32.dll', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:39] C:\WINDOWS\SYSTEM32\SspiCli.dll:SspiCli.dll (75550000), size: 122880 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\SspiCli.dll', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:39] C:\WINDOWS\SYSTEM32\sfc_os.DLL:sfc_os.DLL (71430000), size: 61440 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\sfc_os.DLL', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:39] C:\WINDOWS\SYSTEM32\CRYPTBASE.dll:CRYPTBASE.dll (75540000), size: 40960 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\CRYPTBASE.dll', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:39] C:\WINDOWS\SYSTEM32\sechost.dll:sechost.dll (775F0000), size: 266240 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\sechost.dll', fileVersion: 6.3.9600.17734 
[06.23. - 02:59:39] C:\WINDOWS\SYSTEM32\bcryptPrimitives.dll:bcryptPrimitives.dll (754E0000), size: 344064 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\bcryptPrimitives.dll', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:39] C:\WINDOWS\system32\IMM32.DLL:IMM32.DLL (77160000), size: 159744 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\IMM32.DLL', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:40] C:\WINDOWS\SYSTEM32\MSCTF.dll:MSCTF.dll (76EE0000), size: 1122304 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\MSCTF.dll', fileVersion: 6.3.9600.17706 
[06.23. - 02:59:40] 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 
[06.23. - 02:59:40] C:\EQ\EQEmuServer\lua51.dll:lua51.dll (6AB90000), size: 356352 (result: 0), SymType: '-exported-', PDB: 'C:\EQ\EQEmuServer\lua51.dll' 
[06.23. - 02:59:40] C:\WINDOWS\SYSTEM32\WS2_32.dll:WS2_32.dll (770C0000), size: 327680 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\WS2_32.dll', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:40] C:\WINDOWS\SYSTEM32\VERSION.dll:VERSION.dll (75430000), size: 32768 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\VERSION.dll', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:40] C:\WINDOWS\SYSTEM32\ADVAPI32.dll:ADVAPI32.dll (77A20000), size: 507904 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\ADVAPI32.dll', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:40] C:\WINDOWS\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.9600.17810_none_7c5b6194aa0716f1\COMCTL32.dll:COMCTL32.dll (71EA0000), size: 561152 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.9600.17810_none_7c5b6194aa0716f1\COMCTL32.dll', fileVersion: 5.82.9600.17810 
[06.23. - 02:59:40] C:\WINDOWS\SYSTEM32\MSVCR110.dll:MSVCR110.dll (627D0000), size: 860160 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\MSVCR110.dll', fileVersion: 11.0.50727.1 
[06.23. - 02:59:40] C:\WINDOWS\SYSTEM32\NSI.dll:NSI.dll (75570000), size: 28672 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\NSI.dll', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:40] C:\WINDOWS\system32\napinsp.dll:napinsp.dll (75010000), size: 69632 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\napinsp.dll', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:40] C:\WINDOWS\system32\pnrpnsp.dll:pnrpnsp.dll (74FF0000), size: 90112 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\pnrpnsp.dll', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:40] C:\WINDOWS\system32\NLAapi.dll:NLAapi.dll (74FD0000), size: 81920 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\NLAapi.dll', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:40] C:\WINDOWS\System32\mswsock.dll:mswsock.dll (75110000), size: 307200 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\mswsock.dll', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:40] C:\WINDOWS\SYSTEM32\DNSAPI.dll:DNSAPI.dll (75090000), size: 516096 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\DNSAPI.dll', fileVersion: 6.3.9600.17481 
[06.23. - 02:59:40] C:\WINDOWS\System32\winrnr.dll:winrnr.dll (74F60000), size: 40960 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\winrnr.dll', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:40] C:\Windows\System32\rasadhlp.dll:rasadhlp.dll (75080000), size: 32768 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\rasadhlp.dll', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:40] C:\Perl\lib\auto\Cwd\Cwd.dll:Cwd.dll (10000000), size: 20480 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\lib\auto\Cwd\Cwd.dll' 
[06.23. - 02:59:40] C:\Perl\lib\auto\Filter\Util\Call\Call.dll:Call.dll (0D040000), size: 20480 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\lib\auto\Filter\Util\Call\Call.dll' 
[06.23. - 02:59:40] C:\Perl\lib\auto\IO\IO.dll:IO.dll (0D050000), size: 24576 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\lib\auto\IO\IO.dll' 
[06.23. - 02:59:40] C:\Perl\lib\auto\List\Util\Util.dll:Util.dll (0D460000), size: 28672 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\lib\auto\List\Util\Util.dll' 
[06.23. - 02:59:40] C:\WINDOWS\System32\fwpuclnt.dll:fwpuclnt.dll (75030000), size: 286720 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\System32\fwpuclnt.dll', fileVersion: 6.3.9600.17485 
[06.23. - 02:59:40] C:\WINDOWS\system32\uxtheme.dll:uxtheme.dll (72740000), size: 970752 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\uxtheme.dll', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:40] C:\Program Files (x86)\TeamViewer\tv_w32.dll:tv_w32.dll (62190000), size: 262144 (result: 0), SymType: '-exported-', PDB: 'C:\Program Files (x86)\TeamViewer\tv_w32.dll', fileVersion: 10.0.43174.0 
[06.23. - 02:59:40] C:\WINDOWS\SYSTEM32\ole32.dll:ole32.dll (771D0000), size: 1212416 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\ole32.dll', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:40] C:\WINDOWS\system32\dwmapi.dll:dwmapi.dll (71790000), size: 106496 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\system32\dwmapi.dll', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:40] C:\WINDOWS\SYSTEM32\kernel.appcore.dll:kernel.appcore.dll (736B0000), size: 36864 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\kernel.appcore.dll', fileVersion: 6.3.9600.17415 
[06.23. - 02:59:40] C:\WINDOWS\SYSTEM32\dbghelp.dll:dbghelp.dll (72560000), size: 1314816 (result: 0), SymType: '-exported-', PDB: 'C:\WINDOWS\SYSTEM32\dbghelp.dll', fileVersion: 6.3.9600.17787 
[06.23. - 02:59:40] g:\bs\connector-c-vs2008-32bit\src\mysql-connector-c-6.0.2\mysys\my_thr_init.c (510): my_sigabrt_handler 
[06.23. - 02:59:40] f:\dd\vctools\crt\crtw32\misc\winsig.c (587): raise 
[06.23. - 02:59:40] f:\dd\vctools\crt\crtw32\misc\dbgrpt.c (401): __crtMessageWindowW 
[06.23. - 02:59:40] f:\dd\vctools\crt\crtw32\misc\dbgrptt.c (672): _VCrtDbgReportW 
[06.23. - 02:59:40] f:\dd\vctools\crt\crtw32\misc\dbgrpt.c (262): _CrtDbgReportWV 
[06.23. - 02:59:40] f:\dd\vctools\crt\crtw32\misc\dbgrpt.c (279): _CrtDbgReportW 
[06.23. - 02:59:40] f:\dd\vctools\crt\crtw32\convert\strtol.c (94): strtoxl 
[06.23. - 02:59:40] f:\dd\vctools\crt\crtw32\convert\strtol.c (232): strtol 
[06.23. - 02:59:40] f:\dd\vctools\crt\crtw32\convert\atox.c (56): atol 
[06.23. - 02:59:40] f:\dd\vctools\crt\crtw32\convert\atox.c (100): atoi 
[06.23. - 02:59:40] c:\eq\source\zone\waypoints.cpp (1328): ZoneDatabase::GetFreeGrid 
[06.23. - 02:59:41] c:\eq\source\zone\waypoints.cpp (1265): ZoneDatabase::AddWPForSpawn 
[06.23. - 02:59:41] c:\eq\source\zone\command.cpp (5449): command_wpadd 
[06.23. - 02:59:41] c:\eq\source\zone\command.cpp (583): command_realdispatch 
[06.23. - 02:59:41] c:\eq\source\zone\client.cpp (973): Client::ChannelMessageReceived 
[06.23. - 02:59:41] c:\eq\source\zone\client_packet.cpp (4183): Client::Handle_OP_ChannelMessage 
[06.23. - 02:59:41] c:\eq\source\zone\client_packet.cpp (477): Client::HandlePacket 
[06.23. - 02:59:41] c:\eq\source\zone\client_process.cpp (696): Client::Process 
[06.23. - 02:59:41] c:\eq\source\zone\entity.cpp (498): EntityList::MobProcess 
[06.23. - 02:59:41] c:\eq\source\zone\net.cpp (430): main 
[06.23. - 02:59:41] f:\dd\vctools\crt\crtw32\startup\crt0.c (255): __tmainCRTStartup 
[06.23. - 02:59:41] f:\dd\vctools\crt\crtw32\startup\crt0.c (165): mainCRTStartup 
[06.23. - 02:59:41] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 75597C04) 
[06.23. - 02:59:41] 75597C04 (KERNEL32): (filename not available): BaseThreadInitThunk 
[06.23. - 02:59:41] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77DAAD1F) 
[06.23. - 02:59:41] 77DAAD1F (ntdll): (filename not available): RtlInitializeExceptionChain 
[06.23. - 02:59:41] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77DAACEA) 
[06.23. - 02:59:41] 77DAACEA (ntdll): (filename not available): RtlInitializeExceptionChain
I'm still getting the shared_memory error with the items (it's the first thing that populates on the error list).

I still get the shared_memory crash even with the items not being a problem (picture below)



So clearly, it's not the items... Plus, why would items crash a WP command? O.o
__________________
I am the All Mighty Mittens!
Reply With Quote
  #13  
Old 06-24-2015, 02:39 AM
Shendare
Dragon
  
Join Date: Apr 2009
Location: California
Posts: 814
Default
Looks like it's trying to translate a NULL result to an int on the "freeGridID = atoi(row[0]) + 1;" line:

https://github.com/EQEmu/Server/blob...ints.cpp#L1208

Code:
uint32 ZoneDatabase::GetFreeGrid(uint16 zoneid) {

	std::string query = StringFormat("SELECT max(id) FROM grid WHERE zoneid = %i", zoneid);
	auto results = QueryDatabase(query);
	if (!results.Success()) {
		return 0;
	}

	if (results.RowCount() != 1)
		return 0;

	auto row = results.begin();
	uint32 freeGridID = 1;
	freeGridID = atoi(row[0]) + 1;

	return freeGridID;
}
This query would return a NULL only if there are no grid entries for the specified zone in the database at all.

It looks like the code should be updated to check for NULL in row[0], and return 0 if it finds it.

A workaround would be to manually add a dummy grid entry to the table for that zone. Something like:

Code:
INSERT INTO `grid_entries` VALUES (0, <<YourZoneID>>, 0, 0.0, 0.0, 0.0, 0, 0);
Replace <<YourZoneID>> with the id of whatever the zone you're seeing the crash in.

That would at least return a 0 to the function in the meantime, instead of a NULL.
Reply With Quote
  #14  
Old 06-24-2015, 12:23 PM
Shendare
Dragon
  
Join Date: Apr 2009
Location: California
Posts: 814
Default
Oops, I goofed. Bonehead. It's the grid table that it's querying, not grid_entries. Had the wrong table left open after visualizing and investigating the problem.

Here's the correct query to execute for the workaround.

Replace the 123 with the actual zoneid of the zone that doesn't have any grid entry records yet:

Code:
INSERT INTO `grid` VALUES (0, 123, 0, 0);
Reply With Quote
  #15  
Old 06-24-2015, 12:32 PM
Shendare
Dragon
  
Join Date: Apr 2009
Location: California
Posts: 814
Default
Alternatively, this would add all missing zone entries in the `grid` table so the code doesn't crash looking up the max(id) for them:

Code:
INSERT INTO `grid`
SELECT DISTINCT 0, `zoneidnumber`, 0, 0 FROM `zone` WHERE `zoneidnumber` NOT IN
(SELECT DISTINCT `zoneid` FROM `grid`);
Reply With Quote
Reply
Page 1 of 2 1 2

« Previous Thread | Next Thread »

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 10:09 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