Log in

View Full Version : ERROR: Unable to assign grid - multiple spawn2 rows match

zerjz3
09-05-2014, 06:19 PM
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?
zerjz3
09-05-2014, 07:57 PM
This is my zone crash log:

---------------------------------------------
[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_ec8 3dffa859149af\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_ec8 3dffa859149af\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.dl l (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
NatedogEZ
09-05-2014, 09:01 PM
waypoints.cpp .. line 1293

should look like this...

http://i.imgur.com/mrSunQ7.png

It was missing the line...


results = QueryDatabase(query);
demonstar55
09-05-2014, 09:48 PM
waypoints.cpp .. line 1293

should look like this...

http://i.imgur.com/mrSunQ7.png

It was missing the line...


results = QueryDatabase(query);


Commited, thanks for catching that.
zerjz3
09-05-2014, 09:50 PM
How do I fix this on my end? Do I need to download something and recompile something?
zerjz3
09-05-2014, 10:11 PM
I added that line to my waypoints.cpp and recompiled, but it did not solve my problem
Coenxai
09-05-2014, 10:21 PM
void ZoneDatabase::AssignGrid(Client *client, float x, float y, uint32 grid)

if(matches == 1)

should be:

if(matches > 1)

Change first query to:

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.
NatedogEZ
09-05-2014, 10:24 PM
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.
Coenxai
09-05-2014, 10:27 PM
The crash log he mentioned is fixed with the code above.

Okay buddy, good job fixing his problem then.
zerjz3
09-05-2014, 10:42 PM
Okay buddy, good job fixing his problem then.

Can you tell me exactly how to do what you described in your most recent post?
NatedogEZ
09-06-2014, 12:33 AM
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...

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


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



command.cpp -- replace the whole function..


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!");
}
Coenxai
09-06-2014, 12:50 AM
Many years and many developers has that effect :(
zerjz3
09-06-2014, 09:36 PM
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.