<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Steve,<br>
<br>
the query returns rows, here the code:<br>
<br>
if ($x0 == $x1 || $y0 == $y1){<br>
$my_point = ms_newPointObj();<br>
$my_point->SetXY($x0,$y0);<br>
$bQquery = @$map->queryByPoint($my_point,MS_MULTIPLE,0);<br>
}<br>
else{<br>
$my_rect = ms_newRectObj();<br>
$my_rect->setextent($x0,$y0,$x1,$y1);<br>
$bQuery = @$map->queryByRect($my_rect);<br>
}<br>
<br>
if ($bQuery == MS_SUCCESS){<br>
$sQueryLayers = "layers=";<br>
$sQueryId = "id=";<br>
for ($i=0;$i<sizeof($iLayers);$i++){<br>
$oLayer = $map->getLayer($iLayers[$i]);<br>
if ($oLayer->status == MS_ON)<br>
if ($oLayer->getNumResults() > 0){<br>
$oLayer->open();<br>
$bResults = true;<br>
for ($j=0;$j<$oLayer->getNumResults();$j++){<br>
$oResult = $oLayer->getResult($j);<br>
$sQueryId = $sQueryId . $oResult->shapeindex .
";";<br>
}<br>
$oLayer->close();<br>
$sQueryLayers = $sQueryLayers . $oLayer->name .
"|"; <br>
$sQueryId = substr($sQueryId,0,strlen($sQueryId) - 1) .
"|";<br>
}<br>
}<br>
$sQueryLayers = substr($sQueryLayers,0,strlen($sQueryLayers) -
1);<br>
$sQueryId = substr($sQueryId,0,strlen($sQueryId) - 1);<br>
<br>
The results is viewed in $sQueryId, a string with codes inside,
printed via echo.<br>
<br>
When the draw method is called, or when drawQuery method is called
without a query, the results is a valid map with no error messages
in the debug file. When a query is performed, the debug file
contents the next:<br>
<br>
[[Fri Apr 1 15:41:24 2011].623504 getSymbol(): Symbol definition
error. Parsing error near (I):(line 181)<br>
[Fri Apr 1 15:41:24 2011].623825 getSymbol(): Symbol definition
error. Parsing error near (II):(line 181)<br>
[Fri Apr 1 15:41:24 2011].624023 getSymbol(): Symbol definition
error. Parsing error near (III):(line 181)<br>
[Fri Apr 1 15:41:24 2011].624231 getSymbol(): Symbol definition
error. Parsing error near (IV):(line 181)<br>
[Fri Apr 1 15:41:24 2011].624407 getSymbol(): Symbol definition
error. Parsing error near (V):(line 181)<br>
[Fri Apr 1 15:41:24 2011].624593 getSymbol(): Symbol definition
error. Parsing error near (VI):(line 181)<br>
[Fri Apr 1 15:41:24 2011].624753 getSymbol(): Symbol definition
error. Parsing error near (VII):(line 181)<br>
[Fri Apr 1 15:41:24 2011].625063 getSymbol(): Symbol definition
error. Parsing error near (I):(line 181)<br>
[Fri Apr 1 15:41:24 2011].625235 getSymbol(): Symbol definition
error. Parsing error near (II):(line 181)<br>
[Fri Apr 1 15:41:24 2011].625398 getSymbol(): Symbol definition
error. Parsing error near (III):(line 181)<br>
[Fri Apr 1 15:41:24 2011].625559 getSymbol(): Symbol definition
error. Parsing error near (IV):(line 181)<br>
[Fri Apr 1 15:41:24 2011].625755 getSymbol(): Symbol definition
error. Parsing error near (V):(line 181)<br>
[Fri Apr 1 15:41:24 2011].625916 getSymbol(): Symbol definition
error. Parsing error near (VI):(line 181)<br>
[Fri Apr 1 15:41:24 2011].626109 getSymbol(): Symbol definition
error. Parsing error near (VII):(line 181)<br>
[Fri Apr 1 15:41:24 2011].626523 msPostGISLayerOpen called:
the_geom from (select distinct ua.oid as oid, ua.the_geom as
the_geom, ua.id_region from unidades_academicas as ua, instituciones
as i WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 )
AS foo using SRID=4326 using UNIQUE oid<br>
[Fri Apr 1 15:41:24 2011].626554 msPostGISLayerOpen: No connection
in pool, creating a fresh one.<br>
[Fri Apr 1 15:41:24 2011].644796
msConnPoolRegister(UNIVERSIDADES,user=postgres
dbname=cpres_normalizada_ona password=postgres host=localhost
port=5433,0x7f0dd44ec890)<br>
[Fri Apr 1 15:41:24 2011].644912 msPostGISLayerFreeItemInfo called.<br>
[Fri Apr 1 15:41:24 2011].644928 msPostGISLayerFreeItemInfo called.<br>
[Fri Apr 1 15:41:24 2011].644938 msPostGISLayerGetItems called.<br>
[Fri Apr 1 15:41:24 2011].644948 msPostGISParseData called.<br>
[Fri Apr 1 15:41:24 2011].645035 msPostGISParseData:
unique_column=oid, srid=4326, geom_column_name=the_geom,
table_name=(select distinct ua.oid as oid, ua.the_geom as the_geom,
ua.id_region from unidades_academicas as ua, instituciones as i
WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 ) AS foo<br>
[Fri Apr 1 15:41:24 2011].645054 msPostGISLayerGetItems executing
SQL: select * from (select distinct ua.oid as oid, ua.the_geom as
the_geom, ua.id_region from unidades_academicas as ua, instituciones
as i WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 )
AS foo where false limit 0<br>
[Fri Apr 1 15:41:24 2011].695722 msPostGISLayerInitItemInfo called.<br>
[Fri Apr 1 15:41:24 2011].695894 msPostGISLayerInitItemInfo called.<br>
[Fri Apr 1 15:41:24 2011].695982 msPostGISLayerWhichShapes called.<br>
[Fri Apr 1 15:41:24 2011].696012 msPostGISParseData called.<br>
[Fri Apr 1 15:41:24 2011].696131 msPostGISParseData:
unique_column=oid, srid=4326, geom_column_name=the_geom,
table_name=(select distinct ua.oid as oid, ua.the_geom as the_geom,
ua.id_region from unidades_academicas as ua, instituciones as i
WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 ) AS foo<br>
[Fri Apr 1 15:41:24 2011].696164 msPostGISBuildSQL called.<br>
[Fri Apr 1 15:41:24 2011].696190 msPostGISBuildSQLItems called.<br>
[Fri Apr 1 15:41:24 2011].696337 msPostGISBuildSQLFrom called.<br>
[Fri Apr 1 15:41:24 2011].696400 msPostGISBuildSQLWhere called.<br>
[Fri Apr 1 15:41:24 2011].696430 msPostGISBuildSQLSRID called.<br>
[Fri Apr 1 15:41:24 2011].696458 msPostGISBuildSQLBox called.<br>
[Fri Apr 1 15:41:24 2011].696661 msPostGISLayerWhichShapes query:
select
"oid","id_region",encode(AsBinary(force_collection(force_2d("the_geom")),'NDR'),'hex')
as geom,"oid" from (select distinct ua.oid as oid, ua.the_geom as
the_geom, ua.id_region from unidades_academicas as ua, instituciones
as i WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 )
AS foo where the_geom &&
GeomFromText('POLYGON((-65.3706547152291
-31.5276277454608,-65.3706547152291
-29.281802102631,-61.3038893619969
-29.281802102631,-61.3038893619969
-31.5276277454608,-65.3706547152291 -31.5276277454608))',4326)<br>
[Fri Apr 1 15:41:24 2011].741205 msPostGISLayerWhichShapes got 65
records in result.<br>
[Fri Apr 1 15:41:24 2011].744577 msPostGISLayerNextShape called.<br>
[Fri Apr 1 15:41:24 2011].744584 msPostGISReadShape called.<br>
[Fri Apr 1 15:41:24 2011].744594 msPostGISLayerNextShape called.<br>
[Fri Apr 1 15:41:24 2011].744602 msPostGISReadShape called.<br>
[Fri Apr 1 15:41:24 2011].744611 msPostGISLayerNextShape called.<br>
[Fri Apr 1 15:41:24 2[Fri Apr 1 15:41:32 2011].665529 getSymbol():
Symbol definition error. Parsing error near (I):(line 181)<br>
[Fri Apr 1 15:41:32 2011].665865 getSymbol(): Symbol definition
error. Parsing error near (II):(line 181)<br>
[Fri Apr 1 15:41:32 2011].666045 getSymbol(): Symbol definition
error. Parsing error near (III):(line 181)<br>
[Fri Apr 1 15:41:32 2011].666246 getSymbol(): Symbol definition
error. Parsing error near (IV):(line 181)<br>
[Fri Apr 1 15:41:32 2011].666419 getSymbol(): Symbol definition
error. Parsing error near (V):(line 181)<br>
[Fri Apr 1 15:41:32 2011].666618 getSymbol(): Symbol definition
error. Parsing error near (VI):(line 181)<br>
[Fri Apr 1 15:41:32 2011].666817 getSymbol(): Symbol definition
error. Parsing error near (VII):(line 181)<br>
[Fri Apr 1 15:41:32 2011].667102 getSymbol(): Symbol definition
error. Parsing error near (I):(line 181)<br>
[Fri Apr 1 15:41:32 2011].667313 getSymbol(): Symbol definition
error. Parsing error near (II):(line 181)<br>
[Fri Apr 1 15:41:32 2011].667479 getSymbol(): Symbol definition
error. Parsing error near (III):(line 181)<br>
[Fri Apr 1 15:41:32 2011].667677 getSymbol(): Symbol definition
error. Parsing error near (IV):(line 181)<br>
[Fri Apr 1 15:41:32 2011].667875 getSymbol(): Symbol definition
error. Parsing error near (V):(line 181)<br>
[Fri Apr 1 15:41:32 2011].668041 getSymbol(): Symbol definition
error. Parsing error near (VI):(line 181)<br>
[Fri Apr 1 15:41:32 2011].668206 getSymbol(): Symbol definition
error. Parsing error near (VII):(line 181)<br>
[Fri Apr 1 15:41:32 2011].668659 msPostGISLayerOpen called:
the_geom from (select distinct ua.oid as oid, ua.the_geom as
the_geom, ua.id_region from unidades_academicas as ua, instituciones
as i WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 )
AS foo using SRID=4326 using UNIQUE oid<br>
[Fri Apr 1 15:41:32 2011].668689 msPostGISLayerOpen: No connection
in pool, creating a fresh one.<br>
[Fri Apr 1 15:41:32 2011].685553
msConnPoolRegister(UNIVERSIDADES,user=postgres
dbname=cpres_normalizada_ona password=postgres host=localhost
port=5433,0x7f0dd47a6390)<br>
[Fri Apr 1 15:41:32 2011].685668 msPostGISLayerFreeItemInfo called.<br>
[Fri Apr 1 15:41:32 2011].685685 msPostGISLayerFreeItemInfo called.<br>
[Fri Apr 1 15:41:32 2011].685695 msPostGISLayerGetItems called.<br>
[Fri Apr 1 15:41:32 2011].685705 msPostGISParseData called.<br>
[Fri Apr 1 15:41:32 2011].685804 msPostGISParseData:
unique_column=oid, srid=4326, geom_column_name=the_geom,
table_name=(select distinct ua.oid as oid, ua.the_geom as the_geom,
ua.id_region from unidades_academicas as ua, instituciones as i
WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 ) AS foo<br>
[Fri Apr 1 15:41:32 2011].685826 msPostGISLayerGetItems executing
SQL: select * from (select distinct ua.oid as oid, ua.the_geom as
the_geom, ua.id_region from unidades_academicas as ua, instituciones
as i WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 )
AS foo where false limit 0<br>
[Fri Apr 1 15:41:32 2011].695216 msPostGISLayerInitItemInfo called.<br>
[Fri Apr 1 15:41:32 2011].695313 msPostGISLayerInitItemInfo called.<br>
[Fri Apr 1 15:41:32 2011].695328 msPostGISLayerWhichShapes called.<br>
[Fri Apr 1 15:41:32 2011].695336 msPostGISParseData called.<br>
[Fri Apr 1 15:41:32 2011].695362 msPostGISParseData:
unique_column=oid, srid=4326, geom_column_name=the_geom,
table_name=(select distinct ua.oid as oid, ua.the_geom as the_geom,
ua.id_region from unidades_academicas as ua, instituciones as i
WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 ) AS foo<br>
[Fri Apr 1 15:41:32 2011].695371 msPostGISBuildSQL called.<br>
[Fri Apr 1 15:41:32 2011].695379 msPostGISBuildSQLItems called.<br>
[Fri Apr 1 15:41:32 2011].695463 msPostGISBuildSQLFrom called.<br>
[Fri Apr 1 15:41:32 2011].695481 msPostGISBuildSQLWhere called.<br>
[Fri Apr 1 15:41:32 2011].695489 msPostGISBuildSQLSRID called.<br>
[Fri Apr 1 15:41:32 2011].695497 msPostGISBuildSQLBox called.<br>
[Fri Apr 1 15:41:32 2011].695582 msPostGISLayerWhichShapes query:
select
"oid","id_region",encode(AsBinary(force_collection(force_2d("the_geom")),'NDR'),'hex')
as geom,"oid" from (select distinct ua.oid as oid, ua.the_geom as
the_geom, ua.id_region from unidades_academicas as ua, instituciones
as i WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 )
AS foo where the_geom &&
GeomFromText('POLYGON((-65.3706547152291
-31.5276277454608,-65.3706547152291
-29.281802102631,-61.3038893619969
-29.281802102631,-61.3038893619969
-31.5276277454608,-65.3706547152291 -31.5276277454608))',4326)<br>
[Fri Apr 1 15:41:32 2011].700647 msPostGISLayerWhichShapes got 65
records in result.<br>
[Fri Apr 1 15:41:32 2011].700738 msPostGISLayerNextShape called.<br>
[Fri Apr 1 15:41:32 2011].700749 msPostGISReadShape called.<br>
[Fri Apr 1 15:41:32 2011].700814 msPostGISLayerNextShape called.<br>
[Fri Apr 1 15:41:32 2011].701966 msPostGISLayerNextShape called.<br>
[Fri Apr 1 15:41:32 2011].701973 msPostGISReadShape called.<br>
[Fri Apr 1 15:41:32 2011].702003 msPostGISLayerNextShape called.<br>
[Fri Apr 1 15:41:32 2011].702013 msPostGISReadShape called.<br>
[Fri Apr 1 15:41:32 2011].702024 msPostGISLayerNextShape called.<br>
[Fri Apr 1 15:41:32 2011].702031 msPostGISReadShape called.<br>
[Fri Apr 1 15:41:32 2011].702041 msPostGISLayerNextShape called.<br>
[Fri Apr 1 15:41:32 2011].702048 msPostGISReadShape called.<br>
[Fri Apr 1 15:41:32 2011].702057 msPostGISLayerNextShape called.<br>
[Fri Apr 1 15:41:32 2011].702065 msPostGISReadShape called.<br>
[Fri Apr 1 15:41:32 2011].702075 msPostGISLayerNextShape called.<br>
[Fri Apr 1 15:41:32 2011].710518 msPostGISLayerOpen called:
the_geom from (select distinct ua.oid as oid, ua.the_geom as
the_geom, ua.id_region from unidades_academicas as ua, instituciones
as i WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 )
AS foo using SRID=4326 using UNIQUE oid<br>
[Fri Apr 1 15:41:32 2011].710602 msPostGISLayerOpen: Layer is
already open!<br>
[Fri Apr 1 15:41:32 2011].710611 msPostGISLayerFreeItemInfo called.<br>
[Fri Apr 1 15:41:32 2011].710622 msPostGISLayerGetItems called.<br>
[Fri Apr 1 15:41:32 2011].710631 msPostGISParseData called.<br>
[Fri Apr 1 15:41:32 2011].710655 msPostGISParseData:
unique_column=oid, srid=4326, geom_column_name=the_geom,
table_name=(select distinct ua.oid as oid, ua.the_geom as the_geom,
ua.id_region from unidades_academicas as ua, instituciones as i
WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 ) AS foo<br>
[Fri Apr 1 15:41:32 2011].710667 msPostGISLayerGetItems executing
SQL: select * from (select distinct ua.oid as oid, ua.the_geom as
the_geom, ua.id_region from unidades_academicas as ua, instituciones
as i WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 )
AS foo where false limit 0<br>
[Fri Apr 1 15:41:32 2011].711450 msPostGISLayerInitItemInfo called.<br>
[Fri Apr 1 15:41:32 2011].711999 msPostGISLayerFreeItemInfo called.<br>
[Fri Apr 1 15:41:32 2011].712015 msPostGISLayerClose called:
the_geom from (select distinct ua.oid as oid, ua.the_geom as
the_geom, ua.id_region from unidades_academicas as ua, instituciones
as i WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 )
AS foo using SRID=4326 using UNIQUE oid<br>
[Fri Apr 1 15:41:32 2011].712029
msConnPoolRelease(UNIVERSIDADES,user=postgres
dbname=cpres_normalizada_ona password=postgres host=localhost
port=5433,0x7f0dd47a6390)<br>
011].744618 msPostGISReadShape called.<br>
[Fri Apr 1 15:41:24 2011].744649 msPostGISLayerNextShape called.<br>
[Fri Apr 1 15:41:24 2011].744659 msPostGISReadShape called.<br>
[Fri Apr 1 15:41:24 2011].744668 msPostGISLayerNextShape called.<br>
[Fri Apr 1 15:41:24 2011].744676 msPostGISReadShape called.<br>
[Fri Apr 1 15:41:24 2011].744686 msPostGISLayerNextShape called.<br>
[Fri Apr 1 15:41:24 2011].744693 msPostGISReadShape called.<br>
[Fri Apr 1 15:41:24 2011].744703 msPostGISLayerNextShape called.<br>
[Fri Apr 1 15:41:24 2011].744710 msPostGISReadShape called.<br>
[Fri Apr 1 15:41:24 2011].744720 msPostGISLayerNextShape called.<br>
[Fri Apr 1 15:41:24 2011].753407 msPostGISLayerOpen called:
the_geom from (select distinct ua.oid as oid, ua.the_geom as
the_geom, ua.id_region from unidades_academicas as ua, instituciones
as i WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 )
AS foo using SRID=4326 using UNIQUE oid<br>
[Fri Apr 1 15:41:24 2011].753491 msPostGISLayerOpen: Layer is
already open!<br>
[Fri Apr 1 15:41:24 2011].753501 msPostGISLayerFreeItemInfo called.<br>
[Fri Apr 1 15:41:24 2011].753510 msPostGISLayerGetItems called.<br>
[Fri Apr 1 15:41:24 2011].753519 msPostGISParseData called.<br>
[Fri Apr 1 15:41:24 2011].753543 msPostGISParseData:
unique_column=oid, srid=4326, geom_column_name=the_geom,
table_name=(select distinct ua.oid as oid, ua.the_geom as the_geom,
ua.id_region from unidades_academicas as ua, instituciones as i
WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 ) AS foo<br>
[Fri Apr 1 15:41:24 2011].753554 msPostGISLayerGetItems executing
SQL: select * from (select distinct ua.oid as oid, ua.the_geom as
the_geom, ua.id_region from unidades_academicas as ua, instituciones
as i WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 )
AS foo where false limit 0<br>
[Fri Apr 1 15:41:24 2011].754514 msPostGISLayerInitItemInfo called.<br>
[Fri Apr 1 15:41:24 2011].754973 msPostGISLayerFreeItemInfo called.<br>
[Fri Apr 1 15:41:24 2011].754989 msPostGISLayerClose called:
the_geom from (select distinct ua.oid as oid, ua.the_geom as
the_geom, ua.id_region from unidades_academicas as ua, instituciones
as i WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 )
AS foo using SRID=4326 using UNIQUE oid<br>
[Fri Apr 1 15:41:24 2011].754999
msConnPoolRelease(UNIVERSIDADES,user=postgres
dbname=cpres_normalizada_ona password=postgres host=localhost
port=5433,0x7f0dd44ec890)<br>
[Fri Apr 1 15:41:27 2011].533502 msPostGISLayerClose called:
the_geom from (select distinct ua.oid as oid, ua.the_geom as
the_geom, ua.id_region from unidades_academicas as ua, instituciones
as i WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 )
AS foo using SRID=4326 using UNIQUE oid<br>
[Fri Apr 1 15:41:27 2011].533651 msPostGISLayerIsOpen called.<br>
[Fri Apr 1 15:41:35 2011].705419 getSymbol(): Symbol definition
error. Parsing error near (I):(line 181)<br>
[Fri Apr 1 15:41:35 2011].705625 getSymbol(): Symbol definition
error. Parsing error near (II):(line 181)<br>
[Fri Apr 1 15:41:35 2011].705784 getSymbol(): Symbol definition
error. Parsing error near (III):(line 181)<br>
[Fri Apr 1 15:41:35 2011].705945 getSymbol(): Symbol definition
error. Parsing error near (IV):(line 181)<br>
[Fri Apr 1 15:41:35 2011].706143 getSymbol(): Symbol definition
error. Parsing error near (V):(line 181)<br>
[Fri Apr 1 15:41:35 2011].706335 getSymbol(): Symbol definition
error. Parsing error near (VI):(line 181)<br>
[Fri Apr 1 15:41:35 2011].706496 getSymbol(): Symbol definition
error. Parsing error near (VII):(line 181)<br>
[Fri Apr 1 15:41:35 2011].706793 getSymbol(): Symbol definition
error. Parsing error near (I):(line 181)<br>
[Fri Apr 1 15:41:35 2011].706998 getSymbol(): Symbol definition
error. Parsing error near (II):(line 181)<br>
[Fri Apr 1 15:41:35 2011].707195 getSymbol(): Symbol definition
error. Parsing error near (III):(line 181)<br>
[Fri Apr 1 15:41:35 2011].707390 getSymbol(): Symbol definition
error. Parsing error near (IV):(line 181)<br>
[Fri Apr 1 15:41:35 2011].707588 getSymbol(): Symbol definition
error. Parsing error near (V):(line 181)<br>
[Fri Apr 1 15:41:35 2011].707786 getSymbol(): Symbol definition
error. Parsing error near (VI):(line 181)<br>
[Fri Apr 1 15:41:35 2011].708079 getSymbol(): Symbol definition
error. Parsing error near (VII):(line 181)<br>
[Fri Apr 1 15:41:35 2011].708383 msPostGISLayerOpen called:
the_geom from (select distinct ua.oid as oid, ua.the_geom as
the_geom, ua.id_region from unidades_academicas as ua, instituciones
as i WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 )
AS foo using SRID=4326 using UNIQUE oid<br>
[Fri Apr 1 15:41:35 2011].708405
msConnPoolRequest(UNIVERSIDADES,user=postgres
dbname=cpres_normalizada_ona password=postgres host=localhost
port=5433) -> got 0x7f0dd44ec890<br>
[Fri Apr 1 15:41:35 2011].708416 msPostGISLayerFreeItemInfo called.<br>
[Fri Apr 1 15:41:35 2011].708428 msPostGISLayerFreeItemInfo called.<br>
[Fri Apr 1 15:41:35 2011].708437 msPostGISLayerGetItems called.<br>
[Fri Apr 1 15:41:35 2011].708445 msPostGISParseData called.<br>
[Fri Apr 1 15:41:35 2011].708470 msPostGISParseData:
unique_column=oid, srid=4326, geom_column_name=the_geom,
table_name=(select distinct ua.oid as oid, ua.the_geom as the_geom,
ua.id_region from unidades_academicas as ua, instituciones as i
WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 ) AS foo<br>
[Fri Apr 1 15:41:35 2011].708480 msPostGISLayerGetItems executing
SQL: select * from (select distinct ua.oid as oid, ua.the_geom as
the_geom, ua.id_region from unidades_academicas as ua, instituciones
as i WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 )
AS foo where false limit 0<br>
[Fri Apr 1 15:41:35 2011].709704 msPostGISLayerInitItemInfo called.<br>
[Fri Apr 1 15:41:35 2011].709800 msPostGISLayerInitItemInfo called.<br>
[Fri Apr 1 15:41:35 2011].709810 msPostGISLayerWhichShapes called.<br>
[Fri Apr 1 15:41:35 2011].709818 msPostGISParseData called.<br>
[Fri Apr 1 15:41:35 2011].709841 msPostGISParseData:
unique_column=oid, srid=4326, geom_column_name=the_geom,
table_name=(select distinct ua.oid as oid, ua.the_geom as the_geom,
ua.id_region from unidades_academicas as ua, instituciones as i
WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 ) AS foo<br>
[Fri Apr 1 15:41:35 2011].709850 msPostGISBuildSQL called.<br>
[Fri Apr 1 15:41:35 2011].709857 msPostGISBuildSQLItems called.<br>
[Fri Apr 1 15:41:35 2011].709869 msPostGISBuildSQLFrom called.<br>
[Fri Apr 1 15:41:35 2011].709877 msPostGISBuildSQLWhere called.<br>
[Fri Apr 1 15:41:35 2011].709885 msPostGISBuildSQLSRID called.<br>
[Fri Apr 1 15:41:35 2011].709893 msPostGISBuildSQLBox called.<br>
[Fri Apr 1 15:41:35 2011].709930 msPostGISLayerWhichShapes query:
select
"oid","id_region",encode(AsBinary(force_collection(force_2d("the_geom")),'NDR'),'hex')
as geom,"oid" from (select distinct ua.oid as oid, ua.the_geom as
the_geom, ua.id_region from unidades_academicas as ua, instituciones
as i WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 )
AS foo where the_geom &&
GeomFromText('POLYGON((-65.3706547152291
-31.5276277454608,-65.3706547152291
-29.281802102631,-61.3038893619969
-29.281802102631,-61.3038893619969
-31.5276277454608,-65.3706547152291 -31.5276277454608))',4326)<br>
[Fri Apr 1 15:41:35 2011].713230 msPostGISLayerWhichShapes got 65
records in result.<br>
[Fri Apr 1 15:41:35 2011].713309 msPostGISLayerNextShape called.<br>
[Fri Apr 1 15:41:35 2011].713318 msPostGISReadShape called.<br>
[Fri Apr 1 15:41:35 2011].713347 msPostGISLayerNextShape called.<br>
[Fri Apr 1 15:41:35 2011].713355 msPostGISReadShape called.<br>
[Fri Apr 1 15:41:35 2011].714555 msPostGISLayerNextShape called.<br>
[Fri Apr 1 15:41:35 2011].714563 msPostGISReadShape called.<br>
[Fri Apr 1 15:41:35 2011].714572 msPostGISLayerNextShape called.<br>
[Fri Apr 1 15:41:35 2011].714579 msPostGISReadShape called.<br>
[Fri Apr 1 15:41:35 2011].714589 msPostGISLayerNextShape called.<br>
[Fri Apr 1 15:41:35 2011].722279 msPostGISLayerOpen called:
the_geom from (select distinct ua.oid as oid, ua.the_geom as
the_geom, ua.id_region from unidades_academicas as ua, instituciones
as i WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 )
AS foo using SRID=4326 using UNIQUE oid<br>
[Fri Apr 1 15:41:35 2011].722329 msPostGISLayerOpen: Layer is
already open!<br>
[Fri Apr 1 15:41:35 2011].722337 msPostGISLayerFreeItemInfo called.<br>
[Fri Apr 1 15:41:35 2011].722687 msPostGISLayerGetItems called.<br>
[Fri Apr 1 15:41:35 2011].722695 msPostGISParseData called.<br>
[Fri Apr 1 15:41:35 2011].722720 msPostGISParseData:
unique_column=oid, srid=4326, geom_column_name=the_geom,
table_name=(select distinct ua.oid as oid, ua.the_geom as the_geom,
ua.id_region from unidades_academicas as ua, instituciones as i
WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 ) AS foo<br>
[Fri Apr 1 15:41:35 2011].722872 msPostGISLayerGetItems executing
SQL: select * from (select distinct ua.oid as oid, ua.the_geom as
the_geom, ua.id_region from unidades_academicas as ua, instituciones
as i WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 )
AS foo where false limit 0<br>
[Fri Apr 1 15:41:35 2011].723841 msPostGISLayerInitItemInfo called.<br>
[Fri Apr 1 15:41:35 2011].724345 msPostGISLayerFreeItemInfo called.<br>
[Fri Apr 1 15:41:35 2011].724362 msPostGISLayerClose called:
the_geom from (select distinct ua.oid as oid, ua.the_geom as
the_geom, ua.id_region from unidades_academicas as ua, instituciones
as i WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 )
AS foo using SRID=4326 using UNIQUE oid<br>
[Fri Apr 1 15:41:35 2011].724373
msConnPoolRelease(UNIVERSIDADES,user=postgres
dbname=cpres_normalizada_ona password=postgres host=localhost
port=5433,0x7f0dd44ec890)<br>
[Fri Apr 1 15:41:38 2011].807683 getSymbol(): Symbol definition
error. Parsing error near (I):(line 181)<br>
[Fri Apr 1 15:41:38 2011].808046 getSymbol(): Symbol definition
error. Parsing error near (II):(line 181)<br>
[Fri Apr 1 15:41:38 2011].808257 getSymbol(): Symbol definition
error. Parsing error near (III):(line 181)<br>
[Fri Apr 1 15:41:38 2011].808455 getSymbol(): Symbol definition
error. Parsing error near (IV):(line 181)<br>
[Fri Apr 1 15:41:38 2011].808660 getSymbol(): Symbol definition
error. Parsing error near (V):(line 181)<br>
[Fri Apr 1 15:41:38 2011].808825 getSymbol(): Symbol definition
error. Parsing error near (VI):(line 181)<br>
[Fri Apr 1 15:41:38 2011].809022 getSymbol(): Symbol definition
error. Parsing error near (VII):(line 181)<br>
[Fri Apr 1 15:41:38 2011].809341 getSymbol(): Symbol definition
error. Parsing error near (I):(line 181)<br>
[Fri Apr 1 15:41:38 2011].809556 getSymbol(): Symbol definition
error. Parsing error near (II):(line 181)<br>
[Fri Apr 1 15:41:38 2011].809722 getSymbol(): Symbol definition
error. Parsing error near (III):(line 181)<br>
[Fri Apr 1 15:41:38 2011].809885 getSymbol(): Symbol definition
error. Parsing error near (IV):(line 181)<br>
[Fri Apr 1 15:41:38 2011].810060 getSymbol(): Symbol definition
error. Parsing error near (V):(line 181)<br>
[Fri Apr 1 15:41:38 2011].810225 getSymbol(): Symbol definition
error. Parsing error near (VI):(line 181)<br>
[Fri Apr 1 15:41:38 2011].810387 getSymbol(): Symbol definition
error. Parsing error near (VII):(line 181)<br>
[Fri Apr 1 15:41:38 2011].810839 msPostGISLayerOpen called:
the_geom from (select distinct ua.oid as oid, ua.the_geom as
the_geom, ua.id_region from unidades_academicas as ua, instituciones
as i WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 )
AS foo using SRID=4326 using UNIQUE oid<br>
[Fri Apr 1 15:41:38 2011].810873 msPostGISLayerOpen: No connection
in pool, creating a fresh one.<br>
[Fri Apr 1 15:41:38 2011].827248
msConnPoolRegister(UNIVERSIDADES,user=postgres
dbname=cpres_normalizada_ona password=postgres host=localhost
port=5433,0x7f0dd47a64d0)<br>
[Fri Apr 1 15:41:38 2011].827359 msPostGISLayerFreeItemInfo called.<br>
[Fri Apr 1 15:41:38 2011].827374 msPostGISLayerFreeItemInfo called.<br>
[Fri Apr 1 15:41:38 2011].827384 msPostGISLayerGetItems called.<br>
[Fri Apr 1 15:41:38 2011].827395 msPostGISParseData called.<br>
[Fri Apr 1 15:41:38 2011].827482 msPostGISParseData:
unique_column=oid, srid=4326, geom_column_name=the_geom,
table_name=(select distinct ua.oid as oid, ua.the_geom as the_geom,
ua.id_region from unidades_academicas as ua, instituciones as i
WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 ) AS foo<br>
[Fri Apr 1 15:41:38 2011].827501 msPostGISLayerGetItems executing
SQL: select * from (select distinct ua.oid as oid, ua.the_geom as
the_geom, ua.id_region from unidades_academicas as ua, instituciones
as i WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 )
AS foo where false limit 0<br>
[Fri Apr 1 15:41:38 2011].836692 msPostGISLayerInitItemInfo called.<br>
[Fri Apr 1 15:41:38 2011].836786 msPostGISLayerInitItemInfo called.<br>
[Fri Apr 1 15:41:38 2011].836801 msPostGISLayerWhichShapes called.<br>
[Fri Apr 1 15:41:38 2011].836809 msPostGISParseData called.<br>
[Fri Apr 1 15:41:38 2011].836834 msPostGISParseData:
unique_column=oid, srid=4326, geom_column_name=the_geom,
table_name=(select distinct ua.oid as oid, ua.the_geom as the_geom,
ua.id_region from unidades_academicas as ua, instituciones as i
WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 ) AS foo<br>
[Fri Apr 1 15:41:38 2011].836843 msPostGISBuildSQL called.<br>
[Fri Apr 1 15:41:38 2011].836851 msPostGISBuildSQLItems called.<br>
[Fri Apr 1 15:41:38 2011].836936 msPostGISBuildSQLFrom called.<br>
[Fri Apr 1 15:41:38 2011].836954 msPostGISBuildSQLWhere called.<br>
[Fri Apr 1 15:41:38 2011].836962 msPostGISBuildSQLSRID called.<br>
[Fri Apr 1 15:41:38 2011].836971 msPostGISBuildSQLBox called.<br>
[Fri Apr 1 15:41:38 2011].837057 msPostGISLayerWhichShapes query:
select
"oid","id_region",encode(AsBinary(force_collection(force_2d("the_geom")),'NDR'),'hex')
as geom,"oid" from (select distinct ua.oid as oid, ua.the_geom as
the_geom, ua.id_region from unidades_academicas as ua, instituciones
as i WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 )
AS foo where the_geom &&
GeomFromText('POLYGON((-65.3706547152291
-31.5276277454608,-65.3706547152291
-29.281802102631,-61.3038893619969
-29.281802102631,-61.3038893619969
-31.5276277454608,-65.3706547152291 -31.5276277454608))',4326)<br>
[Fri Apr 1 15:41:38 2011].841359 msPostGISLayerWhichShapes got 65
records in result.<br>
<b>[Fri Apr 1 15:41:38 2011].841412 msPostGISLayerNextShape called.<br>
[Fri Apr 1 15:41:38 2011].842723 msPostGISLayerNextShape called.<br>
</b> [Fri Apr 1 15:41:38 2011].851353 msPostGISLayerOpen called:
the_geom from (select distinct ua.oid as oid, ua.the_geom as
the_geom, ua.id_region from unidades_academicas as ua, instituciones
as i WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 )
AS foo using SRID=4326 using UNIQUE oid<br>
[Fri Apr 1 15:41:38 2011].851438 msPostGISLayerOpen: Layer is
already open!<br>
<b> [Fri Apr 1 15:41:38 2011].851447 msPostGISLayerFreeItemInfo
called.<br>
[Fri Apr 1 15:41:38 2011].851456 msPostGISLayerGetItems called.<br>
</b>[Fri Apr 1 15:41:38 2011].851464 msPostGISParseData called.<br>
[Fri Apr 1 15:41:38 2011].851487 msPostGISParseData:
unique_column=oid, srid=4326, geom_column_name=the_geom,
table_name=(select distinct ua.oid as oid, ua.the_geom as the_geom,
ua.id_region from unidades_academicas as ua, instituciones as i
WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 ) AS foo<br>
[Fri Apr 1 15:41:38 2011].851498 msPostGISLayerGetItems executing
SQL: select * from (select distinct ua.oid as oid, ua.the_geom as
the_geom, ua.id_region from unidades_academicas as ua, instituciones
as i WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 )
AS foo where false limit 0<br>
[Fri Apr 1 15:41:38 2011].852399 msPostGISLayerInitItemInfo called.<br>
[Fri Apr 1 15:41:38 2011].852967 msPostGISLayerFreeItemInfo called.<br>
[Fri Apr 1 15:41:38 2011].852983 msPostGISLayerClose called:
the_geom from (select distinct ua.oid as oid, ua.the_geom as
the_geom, ua.id_region from unidades_academicas as ua, instituciones
as i WHERE i.univ_id = ua.univ_id AND i.id_tipo_institucion = 1 )
AS foo using SRID=4326 using UNIQUE oid<br>
[Fri Apr 1 15:41:38 2011].852996
msConnPoolRelease(UNIVERSIDADES,user=postgres
dbname=cpres_normalizada_ona password=postgres host=localhost
port=5433,0x7f0dd47a64d0)<br>
<br>
The lines in bold repets 65 times, i cut them because of the
restrict about mail-list characters.<br>
Any idea?<br>
<br>
Regards<br>
Oscar<br>
<br>
El 31/03/11 19:44, Lime, Steve D (DNR) escribió:
<blockquote
cite="mid:A7F7B3043D3BF0438F1206BAA3C9933C083128635E@MNMAIL05.ead.state.mn.us"
type="cite">
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Calibri","sans-serif"; color: rgb(31, 73,
125);">I guess we need more information. A script snippet,
confirmation the query is returning results, error messages,
etc…<o:p></o:p></span></p>
</blockquote>
</body>
</html>