PDA

View Full Version : Issue with Waypoints.

Nerdgasm
06-22-2015, 11:09 PM
So we were setting up mobs to patrol and every time we used #wp add or #wp circular, zone crashed. This is the error.

---------------------------------------------
[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:bcryptPri mitives.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.dl l (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
Kingly_Krab
06-23-2015, 12:22 AM
Has nothing to do with waypoints, you have a NULL column in your items table causing a crash in your shared_memory: [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
Nerdgasm
06-23-2015, 04:23 AM
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.
Nerdgasm
06-23-2015, 11:05 PM
So I rebuilt my items table, and redid the entire data tables, did #wpadd circular 40 and boom. Server crashed, same log.

---------------------------------------------
[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:bcryptPri mitives.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.dl l (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
Nerdgasm
06-23-2015, 11:10 PM
I know it says items, but what in items is crashing, there is no custom items in my db at the moment.
Shendare
06-23-2015, 11:42 PM
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/master/common/shareddb.cpp#L894
Shendare
06-23-2015, 11:46 PM
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...
Nerdgasm
06-24-2015, 12:09 AM
Yeah I have no idea...
Nerdgasm
06-24-2015, 01:28 AM
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?
Kingly_Krab
06-24-2015, 01:39 AM
Try using this query. SELECT * FROM `items` WHERE `fr` IS NULL;
Shendare
06-24-2015, 01:40 AM
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.
Nerdgasm
06-24-2015, 02:19 AM
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...

---------------------------------------------
[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:bcryptPri mitives.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_7c5 b6194aa0716f1\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_7c5 b6194aa0716f1\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.dl l (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.appc ore.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)

http://i59.tinypic.com/102ku91.png

So clearly, it's not the items... Plus, why would items crash a WP command? O.o
Shendare
06-24-2015, 02:39 AM
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/master/zone/waypoints.cpp#L1208


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:



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.
Shendare
06-24-2015, 12:23 PM
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:



INSERT INTO `grid` VALUES (0, 123, 0, 0);
Shendare
06-24-2015, 12:32 PM
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:



INSERT INTO `grid`
SELECT DISTINCT 0, `zoneidnumber`, 0, 0 FROM `zone` WHERE `zoneidnumber` NOT IN
(SELECT DISTINCT `zoneid` FROM `grid`);
NatedogEZ
06-24-2015, 04:43 PM
Are you on old code? Those line numbers do not match up for me and this does not crash for me even if there are no waypoints in that zone and the query is NULL
Shendare
06-24-2015, 04:59 PM
Hmm... that would explain why the line number doesn't match up with the current repo.
joligario
06-24-2015, 05:13 PM
I thought KLS added code to stop crashes with zones having 0 entries. I'll look when I get home tonight.

EDIT: Ah, nm. That was factions.
Drajor
06-24-2015, 07:22 PM
Attach a debugger!
Nerdgasm
06-25-2015, 03:21 AM
This is the newest repack that is on git hub, or was when I downloaded it. 2015-02-13-02_01.
Nerdgasm
06-25-2015, 03:29 AM
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:



INSERT INTO `grid`
SELECT DISTINCT 0, `zoneidnumber`, 0, 0 FROM `zone` WHERE `zoneidnumber` NOT IN
(SELECT DISTINCT `zoneid` FROM `grid`);



This fixed the issue.
Huppy
01-15-2016, 03:03 AM
This fixed the issue.

I thank you for this fix. I was having a similiar issue. Its all good now.
provocating
01-18-2016, 03:50 PM
I ran into this exact same problem today. Has anyone fixed this in the source yet?