Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers
Reload this Page ERROR: Unable to assign grid - multiple spawn2 rows match

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

Reply
 
Thread Tools Display Modes
  #1  
Old 09-05-2014, 06:19 PM
zerjz3
Banned
  
Join Date: Aug 2010
Location: Sanctuary
Posts: 269
Default ERROR: Unable to assign grid - multiple spawn2 rows match
I am unable to get pathing to work on this new server I've set up. When I try to assign a grid, I get the error Unable to assign grid - multiple spawn2 rows match


When I try doing #wpadd , the server crashes entirely

Any suggestions?
Reply With Quote
  #2  
Old 09-05-2014, 07:57 PM
zerjz3
Banned
  
Join Date: Aug 2010
Location: Sanctuary
Posts: 269
Default
This is my zone crash log:

Code:
---------------------------------------------
[09.05. - 20:05:22] Starting Log: logs/crash_zone_5264.log
[09.05. - 20:05:22] EXCEPTION_ACCESS_VIOLATION
[09.05. - 20:05:22] 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: 'JAK3' 
[09.05. - 20:05:22] OS-Version: 6.1.7601 (Service Pack 1) 0x100-0x1 
[09.05. - 20:05:22] C:\EQ\EQEmuServer\zone.exe:zone.exe (013C0000), size: 30470144 (result: 0), SymType: 'PDB', PDB: 'C:\EQ\EQEmuServer\zone.exe' 
[09.05. - 20:05:22] C:\Windows\SysWOW64\ntdll.dll:ntdll.dll (77920000), size: 1572864 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\SysWOW64\ntdll.dll', fileVersion: 6.1.7601.17514 
[09.05. - 20:05:22] C:\Windows\syswow64\kernel32.dll:kernel32.dll (76C30000), size: 1114112 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\kernel32.dll', fileVersion: 6.1.7601.17651 
[09.05. - 20:05:22] C:\Windows\syswow64\KERNELBASE.dll:KERNELBASE.dll (76FC0000), size: 286720 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\KERNELBASE.dll', fileVersion: 6.1.7601.17651 
[09.05. - 20:05:22] C:\Windows\syswow64\SHELL32.dll:SHELL32.dll (75790000), size: 12886016 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\SHELL32.dll', fileVersion: 6.1.7601.17514 
[09.05. - 20:05:22] C:\Windows\syswow64\msvcrt.dll:msvcrt.dll (768C0000), size: 704512 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\msvcrt.dll', fileVersion: 7.0.7600.16385 
[09.05. - 20:05:22] C:\Windows\syswow64\SHLWAPI.dll:SHLWAPI.dll (76AC0000), size: 356352 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\SHLWAPI.dll', fileVersion: 6.1.7601.17514 
[09.05. - 20:05:22] C:\Windows\syswow64\GDI32.dll:GDI32.dll (76470000), size: 589824 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\GDI32.dll', fileVersion: 6.1.7601.17514 
[09.05. - 20:05:22] C:\Windows\syswow64\USER32.dll:USER32.dll (76EC0000), size: 1048576 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\USER32.dll', fileVersion: 6.1.7601.17514 
[09.05. - 20:05:22] C:\Windows\syswow64\ADVAPI32.dll:ADVAPI32.dll (77150000), size: 655360 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\ADVAPI32.dll', fileVersion: 6.1.7601.17514 
[09.05. - 20:05:22] C:\Windows\SysWOW64\sechost.dll:sechost.dll (77130000), size: 102400 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\SysWOW64\sechost.dll', fileVersion: 6.1.7600.16385 
[09.05. - 20:05:22] C:\Windows\syswow64\RPCRT4.dll:RPCRT4.dll (756A0000), size: 983040 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\RPCRT4.dll', fileVersion: 6.1.7601.17514 
[09.05. - 20:05:22] C:\Windows\syswow64\SspiCli.dll:SspiCli.dll (75480000), size: 393216 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\SspiCli.dll', fileVersion: 6.1.7601.17514 
[09.05. - 20:05:22] C:\Windows\syswow64\CRYPTBASE.dll:CRYPTBASE.dll (75470000), size: 49152 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\CRYPTBASE.dll', fileVersion: 6.1.7600.16385 
[09.05. - 20:05:22] C:\Windows\syswow64\LPK.dll:LPK.dll (76BA0000), size: 40960 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\LPK.dll', fileVersion: 6.1.7600.16385 
[09.05. - 20:05:22] C:\Windows\syswow64\USP10.dll:USP10.dll (76820000), size: 643072 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\USP10.dll', fileVersion: 1.626.7601.17514 
[09.05. - 20:05:22] 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 
[09.05. - 20:05:22] C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.7601.17514_none_ec83dffa859149af\COMCTL32.dll:COMCTL32.dll (74D80000), 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 
[09.05. - 20:05:22] C:\EQ\EQEmuServer\lua51.dll:lua51.dll (72FE0000), size: 356352 (result: 0), SymType: '-exported-', PDB: 'C:\EQ\EQEmuServer\lua51.dll' 
[09.05. - 20:05:22] C:\Windows\system32\MSVCR110.dll:MSVCR110.dll (6CCA0000), size: 876544 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\MSVCR110.dll', fileVersion: 11.0.51106.1 
[09.05. - 20:05:22] C:\Windows\syswow64\WS2_32.dll:WS2_32.dll (76E80000), size: 217088 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\WS2_32.dll', fileVersion: 6.1.7601.17514 
[09.05. - 20:05:22] C:\Windows\syswow64\NSI.dll:NSI.dll (778F0000), size: 24576 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\NSI.dll', fileVersion: 6.1.7600.16385 
[09.05. - 20:05:22] C:\Windows\system32\VERSION.dll:VERSION.dll (74160000), size: 36864 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\VERSION.dll', fileVersion: 6.1.7600.16385 
[09.05. - 20:05:22] C:\Windows\system32\apphelp.dll:apphelp.dll (74FD0000), size: 311296 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\apphelp.dll', fileVersion: 6.1.7601.17514 
[09.05. - 20:05:22] C:\Windows\AppPatch\AcLayers.DLL:AcLayers.DLL (73040000), size: 577536 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\AppPatch\AcLayers.DLL', fileVersion: 6.1.7601.17514 
[09.05. - 20:05:22] C:\Windows\syswow64\ole32.dll:ole32.dll (76500000), size: 1425408 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\ole32.dll', fileVersion: 6.1.7601.17514 
[09.05. - 20:05:22] C:\Windows\syswow64\OLEAUT32.dll:OLEAUT32.dll (755B0000), size: 585728 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\OLEAUT32.dll', fileVersion: 6.1.7601.17567 
[09.05. - 20:05:22] C:\Windows\system32\USERENV.dll:USERENV.dll (74ED0000), size: 94208 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\USERENV.dll', fileVersion: 6.1.7601.17514 
[09.05. - 20:05:23] C:\Windows\system32\profapi.dll:profapi.dll (73DC0000), size: 45056 (result: 0), SymType: '-nosymbols-', PDB: 'C:\Windows\system32\profapi.dll', fileVersion: 6.1.7600.16385 
[09.05. - 20:05:23] C:\Windows\system32\WINSPOOL.DRV:WINSPOOL.DRV (73350000), size: 331776 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\WINSPOOL.DRV', fileVersion: 6.1.7601.17514 
[09.05. - 20:05:23] C:\Windows\system32\MPR.dll:MPR.dll (73170000), size: 73728 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\MPR.dll', fileVersion: 6.1.7600.16385 
[09.05. - 20:05:23] C:\Windows\system32\IMM32.DLL:IMM32.DLL (75640000), size: 393216 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\IMM32.DLL', fileVersion: 6.1.7601.17514 
[09.05. - 20:05:23] C:\Windows\syswow64\MSCTF.dll:MSCTF.dll (754E0000), size: 835584 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\MSCTF.dll', fileVersion: 6.1.7600.16385 
[09.05. - 20:05:23] C:\Windows\system32\NLAapi.dll:NLAapi.dll (73D20000), size: 65536 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\NLAapi.dll', fileVersion: 6.1.7601.17514 
[09.05. - 20:05:23] C:\Windows\system32\napinsp.dll:napinsp.dll (73B80000), size: 65536 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\napinsp.dll', fileVersion: 6.1.7600.16385 
[09.05. - 20:05:23] C:\Windows\system32\pnrpnsp.dll:pnrpnsp.dll (73790000), size: 73728 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\pnrpnsp.dll', fileVersion: 6.1.7600.16385 
[09.05. - 20:05:23] C:\Windows\system32\wshbth.dll:wshbth.dll (73B70000), size: 53248 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\wshbth.dll', fileVersion: 6.1.7601.17514 
[09.05. - 20:05:23] C:\Windows\System32\mswsock.dll:mswsock.dll (73D80000), size: 245760 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\mswsock.dll', fileVersion: 6.1.7601.17514 
[09.05. - 20:05:23] C:\Windows\system32\DNSAPI.dll:DNSAPI.dll (736E0000), size: 278528 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\DNSAPI.dll', fileVersion: 6.1.7601.17514 
[09.05. - 20:05:23] C:\Windows\System32\winrnr.dll:winrnr.dll (735A0000), size: 32768 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\winrnr.dll', fileVersion: 6.1.7600.16385 
[09.05. - 20:05:23] C:\Windows\system32\rasadhlp.dll:rasadhlp.dll (731B0000), size: 24576 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\rasadhlp.dll', fileVersion: 6.1.7600.16385 
[09.05. - 20:05:23] C:\Windows\System32\wshtcpip.dll:wshtcpip.dll (73770000), size: 20480 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\wshtcpip.dll', fileVersion: 6.1.7600.16385 
[09.05. - 20:05:23] C:\Perl\lib\auto\Cwd\Cwd.dll:Cwd.dll (10000000), size: 20480 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\lib\auto\Cwd\Cwd.dll' 
[09.05. - 20:05:23] C:\Perl\lib\auto\Filter\Util\Call\Call.dll:Call.dll (000A0000), size: 20480 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\lib\auto\Filter\Util\Call\Call.dll' 
[09.05. - 20:05:23] C:\Perl\lib\auto\IO\IO.dll:IO.dll (001F0000), size: 24576 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\lib\auto\IO\IO.dll' 
[09.05. - 20:05:23] C:\Perl\lib\auto\List\Util\Util.dll:Util.dll (00370000), size: 28672 (result: 0), SymType: '-exported-', PDB: 'C:\Perl\lib\auto\List\Util\Util.dll' 
[09.05. - 20:05:23] C:\Windows\System32\fwpuclnt.dll:fwpuclnt.dll (6DFE0000), size: 229376 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\fwpuclnt.dll', fileVersion: 6.1.7601.17514 
[09.05. - 20:05:23] C:\Windows\system32\dbghelp.dll:dbghelp.dll (737B0000), size: 962560 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\dbghelp.dll', fileVersion: 6.1.7601.17514 
[09.05. - 20:05:23] c:\eq\source\common\mysql_request_row.cpp (67): MySQLRequestRow::operator[] 
[09.05. - 20:05:23] c:\eq\source\zone\waypoints.cpp (1300): ZoneDatabase::AddWPForSpawn 
[09.05. - 20:05:23] c:\eq\source\zone\command.cpp (6034): command_wpadd 
[09.05. - 20:05:23] c:\eq\source\zone\command.cpp (610): command_realdispatch 
[09.05. - 20:05:23] c:\eq\source\zone\client.cpp (1029): Client::ChannelMessageReceived 
[09.05. - 20:05:23] c:\eq\source\zone\client_packet.cpp (3521): Client::Handle_OP_ChannelMessage 
[09.05. - 20:05:23] c:\eq\source\zone\client_packet.cpp (486): Client::HandlePacket 
[09.05. - 20:05:23] c:\eq\source\zone\client_process.cpp (704): Client::Process 
[09.05. - 20:05:23] c:\eq\source\zone\entity.cpp (500): EntityList::MobProcess 
[09.05. - 20:05:23] c:\eq\source\zone\net.cpp (434): main 
[09.05. - 20:05:23] f:\dd\vctools\crt\crtw32\startup\crt0.c (255): __tmainCRTStartup 
[09.05. - 20:05:23] f:\dd\vctools\crt\crtw32\startup\crt0.c (165): mainCRTStartup 
[09.05. - 20:05:23] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 76C4339A) 
[09.05. - 20:05:23] 76C4339A (kernel32): (filename not available): BaseThreadInitThunk 
[09.05. - 20:05:23] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77959ED2) 
[09.05. - 20:05:23] 77959ED2 (ntdll): (filename not available): RtlInitializeExceptionChain 
[09.05. - 20:05:23] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77959EA5) 
[09.05. - 20:05:23] 77959EA5 (ntdll): (filename not available): RtlInitializeExceptionChain
Reply With Quote
  #3  
Old 09-05-2014, 09:01 PM
NatedogEZ's Avatar
NatedogEZ
Developer
  
Join Date: Dec 2012
Posts: 515
Default
waypoints.cpp .. line 1293

should look like this...



It was missing the line...

Code:
results = QueryDatabase(query);
Reply With Quote
  #4  
Old 09-05-2014, 09:48 PM
demonstar55
Demi-God
  
Join Date: Apr 2008
Location: MA
Posts: 1,164
Default
Quote:
Originally Posted by NatedogEZ View Post
waypoints.cpp .. line 1293

should look like this...



It was missing the line...

Code:
results = QueryDatabase(query);
Commited, thanks for catching that.
Reply With Quote
  #5  
Old 09-05-2014, 09:50 PM
zerjz3
Banned
  
Join Date: Aug 2010
Location: Sanctuary
Posts: 269
Default
How do I fix this on my end? Do I need to download something and recompile something?
Reply With Quote
  #6  
Old 09-05-2014, 10:11 PM
zerjz3
Banned
  
Join Date: Aug 2010
Location: Sanctuary
Posts: 269
Default
I added that line to my waypoints.cpp and recompiled, but it did not solve my problem
Reply With Quote
  #7  
Old 09-05-2014, 10:21 PM
Coenxai's Avatar
Coenxai
Hill Giant
  
Join Date: Dec 2013
Posts: 151
Default
void ZoneDatabase::AssignGrid(Client *client, float x, float y, uint32 grid)
Code:
if(matches == 1)
should be:
Code:
if(matches > 1)
Change first query to:
Code:
	std::string query = StringFormat("SELECT id, x, y FROM spawn2 WHERE zone = '%s' AND x = %i AND y = %i",
                                    zone->GetShortName(), x, y);
This will help you temporarily until that section of the code is cleaned up.
Reply With Quote
  #8  
Old 09-05-2014, 10:24 PM
NatedogEZ's Avatar
NatedogEZ
Developer
  
Join Date: Dec 2012
Posts: 515
Default
Quote:
Originally Posted by Coenxai View Post
I just got home, I'll help you momentarily. Their fix is for something else entirely.
The crash log he mentioned is fixed with the code above.
Reply With Quote
  #9  
Old 09-05-2014, 10:27 PM
Coenxai's Avatar
Coenxai
Hill Giant
  
Join Date: Dec 2013
Posts: 151
Default
Quote:
Originally Posted by NatedogEZ View Post
The crash log he mentioned is fixed with the code above.
Okay buddy, good job fixing his problem then.
Reply With Quote
  #10  
Old 09-05-2014, 10:42 PM
zerjz3
Banned
  
Join Date: Aug 2010
Location: Sanctuary
Posts: 269
Default
Quote:
Originally Posted by Coenxai View Post
Okay buddy, good job fixing his problem then.
Can you tell me exactly how to do what you described in your most recent post?
Reply With Quote
  #11  
Old 09-06-2014, 12:33 AM
NatedogEZ's Avatar
NatedogEZ
Developer
  
Join Date: Dec 2012
Posts: 515
Default
Assign Grid code is completely weird to me.. using X and Y to find an NPC when the NPC already has a Spawn2 ID ... (much easier to find an npc this way)


waypoint.cpp - replace the whole function with this...
Code:
void ZoneDatabase::AssignGrid(Client *client, int grid, int spawn2id) {
	std::string query = StringFormat("UPDATE spawn2 SET pathgrid = %d WHERE id = %d", grid, spawn2id);
	auto results = QueryDatabase(query);
	if (!results.Success())
	{
		LogFile->write(EQEMuLog::Error, "Error updating spawn2 '%s': '%s'", query.c_str(), results.ErrorMessage().c_str());
		return;
    }
    if (results.RowsAffected() != 1) {
        client->Message(0, "ERROR: found spawn2 id %d but the update query failed", spawn2id);
        return;
    }
    if(client)
        client->LogSQL(query.c_str());

    client->Message(0, "Grid assign: spawn2 id = %d updated", spawn2id);
}
zonedb.h - fix the header...

Code:
void	AssignGrid(Client *client, int grid, int spawn2id);

command.cpp -- replace the whole function..

Code:
void command_gassign(Client *c, const Seperator *sep) {
	if (sep->IsNumber(1) && c->GetTarget() && c->GetTarget()->IsNPC() && c->GetTarget()->CastToNPC()->GetSpawnPointID() > 0) {
		int spawn2id =  c->GetTarget()->CastToNPC()->GetSpawnPointID();
		database.AssignGrid(c, atoi(sep->arg[1]), spawn2id);
	}
	else
		c->Message(0,"Usage: #gassign [num] - must have an npc target!");
}
Reply With Quote
  #12  
Old 09-06-2014, 12:50 AM
Coenxai's Avatar
Coenxai
Hill Giant
  
Join Date: Dec 2013
Posts: 151
Default
Many years and many developers has that effect :(
Reply With Quote
  #13  
Old 09-06-2014, 09:36 PM
zerjz3
Banned
  
Join Date: Aug 2010
Location: Sanctuary
Posts: 269
Default
Just to let everyone know, the advice Coenxai gave me solved this problem. Just update those lines and recompile and you're good to go.
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 07:34 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