<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Hi again, after reading your answers, I tried to change dxf_text to gid, as Brent says but the error is exactly the same. The dxf_text column are unique identifiers of our project.<br><br>And to test the idea of Tanya, I have corrected the projection of drawing, referencing it with ArcMap to EPSG 23030:<br><br>Projected Coordinate System: ED_1950_UTM_Zone_30N<br>Projection: Transverse_Mercator<br>Linear Unit: Meter<br><br>And placing on the extend of southern Spain following: 358836 4186265 359163 4186624<br><br>MAP<br> NAME EDIFICIO_C2_MAP<br> STATUS ON<br> EXTENT 358836 4186265 359163 4186624<br> UNITS METERS <br>.....<br> PROJECTION<br> "init=epsg:23030"<br> END<br>......<br>LAYER<br> CONNECTIONTYPE postgis<br> CONNECTION "user=postgres password=************** dbname=edificio_c2 host=localhost port=5432"<br> DATA "the_geom FROM c2_shape USING UNIQUE gid USING SRID=23030"<br>.....<br><br>And the error is as follows:<br><br>Warning: layerObj::queryByRect(): [MapServer Error]: msPostGISLayerWhichShapes(): Error executing query: ERROR: error de sintaxis en o cerca de «C2BO010»<br>LINE 1: ...6624,359163 4186265,358836 4186265))',23030) and (16C2BO010)<br> ^<br>in C:\ms4w\apps\geomoose2\htdocs\php\feature_report.php on line 72<br><br>Warning: mapObj::setExtent(): [MapServer Error]: setExtent(): Given map extent is invalid. Check that it is in the form: minx, miny, maxx, maxy<br> in C:\ms4w\apps\geomoose2\htdocs\php\feature_report.php on line 100<br><br>Warning: mapObj::setExtent(): [MapServer Error]: msPostGISLayerWhichShapes(): Error executing query: ERROR: error de sintaxis en o cerca de «C2BO010»<br>LINE 1: ...6624,359163 4186265,358836 4186265))',23030) and (16C2BO010)<br> ^<br> in C:\ms4w\apps\geomoose2\htdocs\php\feature_report.php on line 100<br><br>Fatal error: Uncaught exception 'MapScriptException' in C:\ms4w\apps\geomoose2\htdocs\php\feature_report.php:100<br>Stack trace:<br>#0 C:\ms4w\apps\geomoose2\htdocs\php\feature_report.php(100): mapObj->setExtent(0, 0, 0, 0)<br>#1 {main}<br> thrown in C:\ms4w\apps\geomoose2\htdocs\php\feature_report.php on line 100<br><br><br>It might be a bug GeoMOOSE programming? What else I can do?<br><br><br><div><hr id="stopSpelling">Date: Thu, 28 May 2015 10:22:53 -0600<br>From: bfraser@geoanalytic.com<br>To: nando_gcia@hotmail.com; geomoose-users@lists.osgeo.org<br>Subject: Re: [Geomoose-users] Feature Report error with Identify Tool<br><br>
Fernanado,<br>
<br>
When Mapserver does the attribute query as requested by the
GeoMOOSE feature_report.php, it applies a spatial filter based on
the EXTENT stated in the map file and a filter on a unique key:<br>
<br>
<tt><span id="ecxresult_box" lang="en"><span title="Warning: layerObj::queryByRect(): [MapServer Error]: msPostGISLayerWhichShapes(): Error executing query: ERROR: error de sintaxis en o cerca de «C2BN001» ">Warning: layerObj
:: queryByRect (): [MapServer Error]:
msPostGISLayerWhichShapes (): Error executing query: ERROR:
syntax error at or near "C2BN001"<br>
</span><span title="LINE 1: ... -1,-136 362,227 362,227 -1,-136 -1))',3857) and (16C2BN001) ">LINE 1: ... -1 362.227 362.227
-136 -1 -136 -1)) ', 3857) and (16C2BN001)<br>
</span><span title="^ ">^</span></span></tt><br>
<br>
It looks like it's having a problem with the unique key. You
specified<br>
<br>
<span id="ecxresult_box" lang="en"><tt><span title="<td>[dxf_text] <a href="javascript:GeoMOOSE.startService('feature_report', {'dxf_text' : '[dxf_text]', 'src' : 'edificio_c2_espacios/C2-ALBERT_EINSTEIN'})">Report</"><Td>
[dxf_text] <a href=<a class="ecxmoz-txt-link-rfc2396E" target="_blank">"javascript:GeoMOOSE.startService('feature_report',
{'dxf_text':'[dxf_text]','src':'edificio_c2_espacios/C2-ALBERT_EINSTEIN'})"</a>>
Report </ </span></tt><span title="a></td> "><tt>a>
</ td></tt><tt><br>
</tt><br>
but you may want to try:<br>
<br>
</span></span><tt><span id="ecxresult_box" lang="en"><span title="<td>[dxf_text] <a href="javascript:GeoMOOSE.startService('feature_report', {'dxf_text' : '[dxf_text]', 'src' : 'edificio_c2_espacios/C2-ALBERT_EINSTEIN'})">Report</"><Td>
[dxf_text] <a href=<a class="ecxmoz-txt-link-rfc2396E" target="_blank">"javascript:GeoMOOSE.startService('feature_report',
{'gid':'[gid]','src':'edificio_c2_espacios/C2-ALBERT_EINSTEIN'})"</a>>
Report </ </span><span title="a></td> ">a>
</ td></span></span></tt><tt><br>
</tt><br>
<br>
<pre class="ecxmoz-signature">Best Regards,
Brent Fraser</pre><br>
<blockquote cite="mid:DUB120-W3442CFEC1F584CAEFF04E4F6CA0@phx.gbl"><div dir="ltr"><div><blockquote cite="mid:DUB120-W24A0B6BDC6AE17EBF05A94F6CB0@phx.gbl"><br><fieldset class="ecxmimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
Geomoose-users mailing list
<a class="ecxmoz-txt-link-abbreviated" href="mailto:Geomoose-users@lists.osgeo.org">Geomoose-users@lists.osgeo.org</a>
<a class="ecxmoz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/geomoose-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/geomoose-users</a></pre>
</blockquote>
<br>
</div>
</div>
</blockquote>
<br></div> </div></body>
</html>