#wp #grid problems..I have log file of it.

[Gonkers]

Here is my log file.

[Mon May 03 12:01:25 2004] Logging to 'eqlog.txt' is now *ON*.
[Mon May 03 12:03:47 2004] You say, '#grid'
[Mon May 03 12:03:47 2004] Usage: #grid add/delete grid_num wandertype pausetype
[Mon May 03 12:03:56 2004] You say, '#grid add 13001 2 2'
[Mon May 03 12:04:05 2004] Your Location is 441.41, 101.72, -9.28
[Mon May 03 12:04:07 2004] You say, '#wp'
[Mon May 03 12:04:07 2004] Usage: #wp add/delete grid_num pause wp_num
[Mon May 03 12:04:16 2004] You say, '#wp add 13001 5 1'
[Mon May 03 12:04:22 2004] Your Location is 400.79, 71.74, -9.56
[Mon May 03 12:04:25 2004] You say, '#wp add 13001 5 2'
[Mon May 03 12:04:29 2004] You say, '#wp add 13001 5 3'
[Mon May 03 12:04:32 2004] You say, '#wp add 13001 5 4'
[Mon May 03 12:04:34 2004] You say, '#wp add 13001 5 5'
[Mon May 03 12:04:42 2004] You say, '#gassign 13001'
[Mon May 03 12:04:42 2004] ERROR: Unable to assign grid - multiple spawn2 rows match

Why is it giving me that Error?, I know it's obviously spawn2, but where do i find this and how do i correct it?

[Gonkers]

bah, still having this problem. Been messing with the mysql database but it keeps telling me this error. No one knows solution? :(

[Derision]

That error is produced by this code:

#define _GASSIGN_TOLERANCE	1.0
	if(!(matches = mysql_num_rows(result)))	// try a fuzzy match if that didn't find it
	{
		mysql_free_result(result);
		RunQuery(
			query,
			MakeAnyLenString(
				&query,
				"SELECT id,x,y FROM spawn2 WHERE zone='%s' AND "
				"ABS( ABS(x) - ABS(%f) ) < %f AND "
				"ABS( ABS(y) - ABS(%f) ) < %f",
				zone->GetShortName(), x, _GASSIGN_TOLERANCE, y, _GASSIGN_TOLERANCE
			),
			errbuf,
			&result
		);
		safe_delete_array(query);
		fuzzy = 1;
		if(!(matches = mysql_num_rows(result)))
			mysql_free_result(result);
	}
	if(matches)
	{
		if(matches > 1)
		{
			client->Message(0, "ERROR: Unable to assign grid - multiple spawn2 rows match");

So it would seem you have two or more spawn2 entries for that zone that spawn in the same place, +/- 1 unit in the x and y direction. Try altering the spawn2 entry for the mob you are assigning the grid to so that it is at least 2 units away from the other entries in both the x and y direction.