Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers
Reload this Page Mercenary Crash

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 05-02-2013, 12:54 PM
Randymarsh9
Dragon
  
Join Date: Dec 2007
Posts: 658
Default Mercenary Crash
I found a problem with mercenaries, and I was wondering if this is a fault with them or with my configuration. I hired a Tier V Apprentice froglok healer mercenary, and it buffed me up, and nothing bad happened. I then dismissed it and I hired a a Tier II Froglok Journeyman healer, and upon casting Balikor's Mark (a spell that the first mercenary cast with no problems) the zone crashed. I tried it again, and the zone crashed again.

Code:
>	ntdll.dll!775115de() 	
 	[Frames below may be incorrect and/or missing, no symbols loaded for ntdll.dll]	
 	ntdll.dll!775115de() 	
 	ntdll.dll!7750014e() 	
 	KernelBase.dll!761f778a() 	
 	Zone.exe!01469cdd() 	
 	Zone.exe!01469cf1() 	
 	Zone.exe!01491e4d() 	
 	Zone.exe!0146d591() 	
 	kernel32.dll!762333aa() 	
 	ntdll.dll!77529ef2() 	
 	ntdll.dll!77529ec5()
That is what I got in the call stack when I debugged it, but I guess I do not know enough to find any meaning in that.
Reply With Quote
  #2  
Old 05-02-2013, 02:05 PM
Derision
Developer
  
Join Date: Feb 2004
Location: UK
Posts: 1,540
Default
I just tested the scenario you described without any problems. If you are using the latest source, selected a Debug build in CMake, and the .pdb files generated in your build directory during compilation are copied over to the same folder you are running zone.exe from, you should have a crash.log in your logs directory which should tells us exactly which line of source code the crash is occurring at.
Reply With Quote
  #3  
Old 05-02-2013, 02:25 PM
Randymarsh9
Dragon
  
Join Date: Dec 2007
Posts: 658
Default
Here's the crash log
Code:
[05.02. - 00:40:14] Starting Log: logs/crash_zone_1528.log
[05.02. - 00:40:14] EXCEPTION_ACCESS_VIOLATION
[05.02. - 00:40:14] SymInit: Symbol-SearchPath: '.;C:\...\Emulator Server\Build;C:\...\Build;C:\Windows;C:\Windows\system32;SRV*C:\websymbols*http://msdl.microsoft.com/download/symbols;', symOptions: 530, UserName: '...' 
[05.02. - 00:40:14] OS-Version: 6.1.7601 (Service Pack 1) 0x100-0x1 
[05.02. - 00:40:14] C:\...\Emulator Server\Build\zone.exe:zone.exe (012A0000), size: 15814656 (result: 0), SymType: 'PDB', PDB: 'C:\...\Emulator Server\Build\zone.exe' 
[05.02. - 00:40:14] C:\Windows\SysWOW64\ntdll.dll:ntdll.dll (774F0000), size: 1572864 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\SysWOW64\ntdll.dll', fileVersion: 6.1.7601.17725 
[05.02. - 00:40:14] C:\Windows\syswow64\kernel32.dll:kernel32.dll (76220000), size: 1114112 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\kernel32.dll', fileVersion: 6.1.7601.18015 
[05.02. - 00:40:14] C:\Windows\syswow64\KERNELBASE.dll:KERNELBASE.dll (761C0000), size: 290816 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\KERNELBASE.dll', fileVersion: 6.1.7601.18015 
[05.02. - 00:40:14] C:\Windows\syswow64\SHELL32.dll:SHELL32.dll (751B0000), size: 12886016 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\SHELL32.dll', fileVersion: 6.1.7601.17859 
[05.02. - 00:40:14] C:\Windows\syswow64\msvcrt.dll:msvcrt.dll (74CC0000), size: 704512 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\msvcrt.dll', fileVersion: 7.0.7601.17744 
[05.02. - 00:40:14] C:\Windows\syswow64\SHLWAPI.dll:SHLWAPI.dll (76390000), size: 356352 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\SHLWAPI.dll', fileVersion: 6.1.7601.17514 
[05.02. - 00:40:14] C:\Windows\syswow64\GDI32.dll:GDI32.dll (74E40000), size: 589824 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\GDI32.dll', fileVersion: 6.1.7601.17514 
[05.02. - 00:40:14] C:\Windows\syswow64\USER32.dll:USER32.dll (75F60000), size: 1048576 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\USER32.dll', fileVersion: 6.1.7601.17514 
[05.02. - 00:40:14] C:\Windows\syswow64\ADVAPI32.dll:ADVAPI32.dll (76A70000), size: 655360 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\ADVAPI32.dll', fileVersion: 6.1.7601.17514 
[05.02. - 00:40:14] C:\Windows\SysWOW64\sechost.dll:sechost.dll (76490000), size: 102400 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\SysWOW64\sechost.dll', fileVersion: 6.1.7600.16385 
[05.02. - 00:40:14] C:\Windows\syswow64\RPCRT4.dll:RPCRT4.dll (75E00000), size: 983040 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\RPCRT4.dll', fileVersion: 6.1.7601.17514 
[05.02. - 00:40:14] C:\Windows\syswow64\SspiCli.dll:SspiCli.dll (74BD0000), size: 393216 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\SspiCli.dll', fileVersion: 6.1.7601.17856 
[05.02. - 00:40:14] C:\Windows\syswow64\CRYPTBASE.dll:CRYPTBASE.dll (74BC0000), size: 49152 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\CRYPTBASE.dll', fileVersion: 6.1.7600.16385 
[05.02. - 00:40:14] C:\Windows\syswow64\LPK.dll:LPK.dll (750E0000), size: 40960 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\LPK.dll', fileVersion: 6.1.7600.16385 
[05.02. - 00:40:14] C:\Windows\syswow64\USP10.dll:USP10.dll (763F0000), size: 643072 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\USP10.dll', fileVersion: 1.626.7601.18009 
[05.02. - 00:40:14] C:\Perl\bin\perl512.dll:perl512.dll (28000000), size: 1273856 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\bin\perl512.dll', fileVersion: 5.12.4.1205 
[05.02. - 00:40:14] C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.7601.17514_none_ec83dffa859149af\COMCTL32.dll:COMCTL32.dll (71140000), size: 540672 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.7601.17514_none_ec83dffa859149af\COMCTL32.dll', fileVersion: 5.82.7601.17514 
[05.02. - 00:40:14] C:\Windows\syswow64\WS2_32.dll:WS2_32.dll (76330000), size: 217088 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\WS2_32.dll', fileVersion: 6.1.7601.17514 
[05.02. - 00:40:14] C:\Windows\syswow64\NSI.dll:NSI.dll (75EF0000), size: 24576 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\NSI.dll', fileVersion: 6.1.7600.16385 
[05.02. - 00:40:14] C:\Windows\system32\VERSION.dll:VERSION.dll (74AF0000), size: 36864 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\VERSION.dll', fileVersion: 6.1.7600.16385 
[05.02. - 00:40:14] C:\Windows\system32\apphelp.dll:apphelp.dll (73C00000), size: 311296 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\apphelp.dll', fileVersion: 6.1.7601.17514 
[05.02. - 00:40:14] C:\Windows\AppPatch\AcLayers.DLL:AcLayers.DLL (73990000), size: 577536 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\AppPatch\AcLayers.DLL', fileVersion: 6.1.7601.17974 
[05.02. - 00:40:14] C:\Windows\syswow64\ole32.dll:ole32.dll (76060000), size: 1425408 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\ole32.dll', fileVersion: 6.1.7601.17514 
[05.02. - 00:40:14] C:\Windows\syswow64\OLEAUT32.dll:OLEAUT32.dll (76540000), size: 585728 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\OLEAUT32.dll', fileVersion: 6.1.7601.17676 
[05.02. - 00:40:14] C:\Windows\system32\USERENV.dll:USERENV.dll (73B50000), size: 94208 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\USERENV.dll', fileVersion: 6.1.7601.17514 
[05.02. - 00:40:14] C:\Windows\system32\profapi.dll:profapi.dll (73B40000), size: 45056 (result: 0), SymType: '-nosymbols-', PDB: 'C:\Windows\system32\profapi.dll', fileVersion: 6.1.7600.16385 
[05.02. - 00:40:14] C:\Windows\system32\WINSPOOL.DRV:WINSPOOL.DRV (74A90000), size: 331776 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\WINSPOOL.DRV', fileVersion: 6.1.7601.17514 
[05.02. - 00:40:14] C:\Windows\system32\MPR.dll:MPR.dll (747B0000), size: 73728 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\MPR.dll', fileVersion: 6.1.7600.16385 
[05.02. - 00:40:14] C:\Windows\system32\IMM32.DLL:IMM32.DLL (75F00000), size: 393216 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\IMM32.DLL', fileVersion: 6.1.7601.17514 
[05.02. - 00:40:14] C:\Windows\syswow64\MSCTF.dll:MSCTF.dll (74D70000), size: 835584 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\MSCTF.dll', fileVersion: 6.1.7600.16385 
[05.02. - 00:40:14] C:\Windows\system32\NLAapi.dll:NLAapi.dll (70690000), size: 65536 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\NLAapi.dll', fileVersion: 6.1.7601.17761 
[05.02. - 00:40:14] C:\Windows\system32\napinsp.dll:napinsp.dll (70670000), size: 65536 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\napinsp.dll', fileVersion: 6.1.7600.16385 
[05.02. - 00:40:14] C:\Windows\system32\pnrpnsp.dll:pnrpnsp.dll (70630000), size: 73728 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\pnrpnsp.dll', fileVersion: 6.1.7600.16385 
[05.02. - 00:40:14] C:\Windows\System32\mswsock.dll:mswsock.dll (70FA0000), size: 245760 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\mswsock.dll', fileVersion: 6.1.7601.17514 
[05.02. - 00:40:14] C:\Windows\system32\DNSAPI.dll:DNSAPI.dll (70380000), size: 278528 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\DNSAPI.dll', fileVersion: 6.1.7601.17570 
[05.02. - 00:40:14] C:\Windows\System32\winrnr.dll:winrnr.dll (70370000), size: 32768 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\winrnr.dll', fileVersion: 6.1.7600.16385 
[05.02. - 00:40:14] C:\Program Files (x86)\Bonjour\mdnsNSP.dll:mdnsNSP.dll (702D0000), size: 135168 (result: 0), SymType: '-exported-', PDB: 'C:\Program Files (x86)\Bonjour\mdnsNSP.dll', fileVersion: 3.0.0.10 
[05.02. - 00:40:14] C:\Windows\system32\Iphlpapi.DLL:Iphlpapi.DLL (71930000), size: 114688 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\Iphlpapi.DLL', fileVersion: 6.1.7601.17514 
[05.02. - 00:40:14] C:\Windows\system32\WINNSI.DLL:WINNSI.DLL (71920000), size: 28672 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\WINNSI.DLL', fileVersion: 6.1.7600.16385 
[05.02. - 00:40:14] C:\Windows\system32\rasadhlp.dll:rasadhlp.dll (6E590000), size: 24576 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\rasadhlp.dll', fileVersion: 6.1.7600.16385 
[05.02. - 00:40:14] C:\Program Files (x86)\Avira\AntiVir Desktop\avsda.dll:avsda.dll (71010000), size: 274432 (result: 0), SymType: '-exported-', PDB: 'C:\Program Files (x86)\Avira\AntiVir Desktop\avsda.dll', fileVersion: 13.6.2.666 
[05.02. - 00:40:14] C:\Windows\System32\wshtcpip.dll:wshtcpip.dll (70F80000), size: 20480 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\wshtcpip.dll', fileVersion: 6.1.7600.16385 
[05.02. - 00:40:14] C:\Perl\lib\auto\Cwd\Cwd.dll:Cwd.dll (10000000), size: 20480 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\lib\auto\Cwd\Cwd.dll' 
[05.02. - 00:40:14] C:\Perl\lib\auto\DBI\DBI.dll:DBI.dll (002F0000), size: 98304 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\lib\auto\DBI\DBI.dll' 
[05.02. - 00:40:14] C:\Perl\lib\auto\List\Util\Util.dll:Util.dll (001B0000), size: 28672 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\lib\auto\List\Util\Util.dll' 
[05.02. - 00:40:14] C:\Perl\lib\auto\Filter\Util\Call\Call.dll:Call.dll (00290000), size: 20480 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\lib\auto\Filter\Util\Call\Call.dll' 
[05.02. - 00:40:14] C:\Perl\lib\auto\IO\IO.dll:IO.dll (00310000), size: 24576 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\lib\auto\IO\IO.dll' 
[05.02. - 00:40:14] C:\Windows\System32\fwpuclnt.dll:fwpuclnt.dll (6C2A0000), size: 229376 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\fwpuclnt.dll', fileVersion: 6.1.7601.17514 
[05.02. - 00:40:14] C:\Windows\system32\dbghelp.dll:dbghelp.dll (669A0000), size: 962560 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\dbghelp.dll', fileVersion: 6.1.7601.17514 
[05.02. - 00:40:14] ERROR: SymGetSymFromAddr64, GetLastError: 487 (Address: 0138D084) 
[05.02. - 00:40:14] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 0138D084) 
[05.02. - 00:40:14] 0138D084 (zone): (filename not available): (function-name not available) 
[05.02. - 00:40:14] ERROR: SymGetSymFromAddr64, GetLastError: 487 (Address: 0139046A) 
[05.02. - 00:40:14] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 0139046A) 
[05.02. - 00:40:14] 0139046A (zone): (filename not available): (function-name not available) 
[05.02. - 00:40:14] ERROR: SymGetSymFromAddr64, GetLastError: 487 (Address: 01391045) 
[05.02. - 00:40:14] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 01391045) 
[05.02. - 00:40:14] 01391045 (zone): (filename not available): (function-name not available) 
[05.02. - 00:40:14] ERROR: SymGetSymFromAddr64, GetLastError: 487 (Address: 0147CC9E) 
[05.02. - 00:40:14] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 0147CC9E) 
[05.02. - 00:40:14] 0147CC9E (zone): (filename not available): (function-name not available) 
[05.02. - 00:40:14] ERROR: SymGetSymFromAddr64, GetLastError: 487 (Address: 0148B79B) 
[05.02. - 00:40:14] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 0148B79B) 
[05.02. - 00:40:14] 0148B79B (zone): (filename not available): (function-name not available) 
[05.02. - 00:40:14] ERROR: SymGetSymFromAddr64, GetLastError: 487 (Address: 01377633) 
[05.02. - 00:40:14] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 01377633) 
[05.02. - 00:40:14] 01377633 (zone): (filename not available): (function-name not available) 
[05.02. - 00:40:14] ERROR: SymGetSymFromAddr64, GetLastError: 487 (Address: 014882E3) 
[05.02. - 00:40:14] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 014882E3) 
[05.02. - 00:40:14] 014882E3 (zone): (filename not available): (function-name not available) 
[05.02. - 00:40:14] ERROR: SymGetSymFromAddr64, GetLastError: 487 (Address: 0148A214) 
[05.02. - 00:40:14] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 0148A214) 
[05.02. - 00:40:14] 0148A214 (zone): (filename not available): (function-name not available) 
[05.02. - 00:40:14] ERROR: SymGetSymFromAddr64, GetLastError: 487 (Address: 0148C0C6) 
[05.02. - 00:40:14] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 0148C0C6) 
[05.02. - 00:40:14] 0148C0C6 (zone): (filename not available): (function-name not available) 
[05.02. - 00:40:14] ERROR: SymGetSymFromAddr64, GetLastError: 487 (Address: 013AC619) 
[05.02. - 00:40:14] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 013AC619) 
[05.02. - 00:40:14] 013AC619 (zone): (filename not available): (function-name not available) 
[05.02. - 00:40:14] ERROR: SymGetSymFromAddr64, GetLastError: 487 (Address: 0156D591) 
[05.02. - 00:40:14] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 0156D591) 
[05.02. - 00:40:14] 0156D591 (zone): (filename not available): (function-name not available) 
[05.02. - 00:40:14] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 762333AA) 
[05.02. - 00:40:14] 762333AA (kernel32): (filename not available): BaseThreadInitThunk 
[05.02. - 00:40:14] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77529EF2) 
[05.02. - 00:40:14] 77529EF2 (ntdll): (filename not available): RtlInitializeExceptionChain 
[05.02. - 00:40:14] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77529EC5) 
[05.02. - 00:40:14] 77529EC5 (ntdll): (filename not available): RtlInitializeExceptionChain
Reply With Quote
  #4  
Old 05-02-2013, 02:33 PM
Derision
Developer
  
Join Date: Feb 2004
Location: UK
Posts: 1,540
Default
Code:
 013AC619 (zone): (filename not available): (function-name not available)
Looks like either you compiled a release rather than debug version, or the .pdb files are not present, since it is saying the filename/function-name are not available.
Reply With Quote
  #5  
Old 05-02-2013, 06:16 PM
Randymarsh9
Dragon
  
Join Date: Dec 2007
Posts: 658
Default
Ok, this time I recompiled and used the Debug builds, and I copied over all of the pdb files.

Code:
[05.02. - 18:13:11] c:\...\projecteqemu\server\zone\merc.cpp (279): Merc::CalcItemBonuses 
[05.02. - 18:13:11] c:\...\projecteqemu\server\zone\merc.cpp (88): Merc::CalcBonuses 
[05.02. - 18:13:11] c:\...\projecteqemu\server\zone\merc.cpp (5179): Merc::UpdateMercStats 
[05.02. - 18:13:11] c:\...\projecteqemu\server\zone\merc.cpp (5088): Merc::LoadMerc 
[05.02. - 18:13:11] c:\...\projecteqemu\server\zone\merc.cpp (5528): Client::SpawnMercOnZone 
[05.02. - 18:13:11] c:...\projecteqemu\server\zone\client_packet.cpp (833): Client::Handle_Connect_OP_WorldObjectsSent 
[05.02. - 18:13:11] c:\...\projecteqemu\server\zone\client_packet.cpp (442): Client::HandlePacket 
[05.02. - 18:13:11] c:\...\projecteqemu\server\zone\client_process.cpp (705): Client::Process 
[05.02. - 18:13:11] c:\...\projecteqemu\server\zone\entity.cpp (505): EntityList::MobProcess 
[05.02. - 18:13:11] c:\...\projecteqemu\server\zone\net.cpp (417): main 
[05.02. - 18:13:11] f:\dd\vctools\crt_bld\self_x86\crt\src\crt0.c (278): __tmainCRTStartup 
[05.02. - 18:13:11] f:\dd\vctools\crt_bld\self_x86\crt\src\crt0.c (189): mainCRTStartup 
[05.02. - 18:13:11] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 762333AA) 
[05.02. - 18:13:11] 762333AA (kernel32): (filename not available): BaseThreadInitThunk 
[05.02. - 18:13:11] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77529EF2) 
[05.02. - 18:13:11] 77529EF2 (ntdll): (filename not available): RtlInitializeExceptionChain 
[05.02. - 18:13:11] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77529EC5) 
[05.02. - 18:13:11] 77529EC5 (ntdll): (filename not available): RtlInitializeExceptionChain
Reply With Quote
  #6  
Old 05-03-2013, 04:29 AM
Derision
Developer
  
Join Date: Feb 2004
Location: UK
Posts: 1,540
Default
Have you sourced in:
Code:
utils/sql/git/required/2013_03_1_Merc_Rules_and_Equipment.sql:
I can get zone to crash at that point if I delete one of the items in the items table that are referenced in the merc_inventory table.
Reply With Quote
  #7  
Old 05-03-2013, 07:52 AM
Randymarsh9
Dragon
  
Join Date: Dec 2007
Posts: 658
Default
That could be it. I get an error "ERROR 1054 (42S22): Unknown column 'UNK219' in 'field list'" when I try sourcing that sql.
Reply With Quote
  #8  
Old 05-04-2013, 12:53 AM
Randymarsh9
Dragon
  
Join Date: Dec 2007
Posts: 658
Default
I had to alter my items table and add in fields for UNK219-UNK242. After that, the sql sourced perfectly and the merc stopped crashing upon casting. Thanks, Derision.
Reply With Quote
  #9  
Old 08-08-2013, 05:44 AM
thepoetwarrior
Discordant
  
Join Date: Aug 2007
Posts: 307
Default
Quote:
Originally Posted by Randymarsh9 View Post
That could be it. I get an error "ERROR 1054 (42S22): Unknown column 'UNK219' in 'field list'" when I try sourcing that sql.
I had the same error when sourcing that update sql, and now my zones crash.

Will see if I can manually alter the table if that will fix it. Not sure what the table should be, maybe will have to download a current version of PEQ DB?
Reply With Quote
  #10  
Old 08-08-2013, 06:01 AM
thepoetwarrior
Discordant
  
Join Date: Aug 2007
Posts: 307
Default
Some where over the years I seem to have missed the sql update to insert these fields at the end of the records in the items table. Anyone know which sql query update file name did it?


`UNK219`,
`UNK220`,
`UNK221`,
`UNK222`,
`UNK223`,
`UNK224`,
`UNK225`,
`UNK226`,
`UNK227`,
`UNK228`,
`UNK229`,
`UNK230`,
`UNK231`,
`UNK232`,
`UNK233`,
`UNK234`,
`UNK235`,
`UNK236`,
`UNK237`,
`UNK238`,
`UNK239`,
`UNK240`,
`UNK241`,
`UNK242`
Reply With Quote
  #11  
Old 08-08-2013, 06:37 AM
thepoetwarrior
Discordant
  
Join Date: Aug 2007
Posts: 307
Default
Never mind last 2 post, I figured out how to add column those missing fields manually. Not sure which sql I missed over the years for those fields :(
Reply With Quote
Reply

« 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 03:10 AM.

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 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3