EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   ERROR: Unable to assign grid - multiple spawn2 rows match (https://www.eqemulator.org/forums/showthread.php?t=38727)

zerjz3 09-05-2014 06:19 PM
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?

zerjz3 09-05-2014 07:57 PM
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

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

Code:
results = QueryDatabase(query);

demonstar55 09-05-2014 09:48 PM
Quote:
Originally Posted by NatedogEZ (Post 233628)
waypoints.cpp .. line 1293

should look like this...

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

It was missing the line...

Code:
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)
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.

NatedogEZ 09-05-2014 10:24 PM
Quote:
Originally Posted by Coenxai (Post 233633)
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
Quote:
Originally Posted by NatedogEZ (Post 233634)
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
Quote:
Originally Posted by Coenxai (Post 233635)
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...
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!");
}

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.


All times are GMT -4. The time now is 10:16 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.