Re: [pmapper-users] Search does not work.
Laura I cannot reproduce your problem using p.mapper 4.2, MS 6.0.1 and Postgres 9. Everything's ok with the Postgis layer and identify/select. I use a data definition like DATA "the_geom from (select * from cities1000) \ AS foo USING UNIQUE geonameid using SRID=4326" But I doubt that the subselect has any influence. Maybe somebody else had similar problems and discovered the reason for it. I don't know if setting the DEBUG in the map file produces helpful output. Best regards Armin On 07/10/2011 20:16, Laura Larghero wrote: > Hello Armin, sorry for sending this mail to your personal email, I > emailed it yesterday to 'pmapper-users@lists.sourceforge.net', but don’t > know if it worked. > > I’m using Ubuntu, MapServer 6, p.mapper 4.2.0, PostgreSQL 8.4 > > Identify function is not working for a layer defined as CONNECTIONTYPE > POSTGIS. > > When I pick an element, it shows the popup window with the correct field > names (RESULT_HEADERS) and the correct number of rows, but always shows > the first rows defined in the PostGIS table. This is the “departamentos” > layer. > > The PostGIS field names are defined in lowercase letters. > > It woks fine with a shape layer. This is the “ejes_pl_total” layer. > > What’s wrong in my mapfile? > > I would appreciate any help!! > > Thank you, Laura > > > > > HERE IS MY MAPFILE > > > > > MAP > > NAME siiasgis > > EXTENT 366582.247191515 6127918.53905545 858252.132029213 6671738.39330106 > > SIZE 400 300 > > SHAPEPATH "../../../pmapper_demodata" > > SYMBOLSET "../common/symbols/siiasgis.sym" > > FONTSET "../common/fonts/fonts.txt" > > CONFIG "PROJ_LIB" "/usr/share/proj" > > CONFIG "MS_ERRORFILE" "/var/log/mapserver/mapserver.log" > > CONFIG "CPL_DEBUG" "OFF" > > CONFIG "PROJ_DEBUG" "OFF" > > IMAGETYPE png > > INTERLACE OFF > > LEGEND > > IMAGECOLOR -1 -1 -1 > > LABEL > > FONT "vera" > > ANGLE FOLLOW > > COLOR 0 0 0 > > ENCODING "UTF-8" > > TYPE truetype > > SIZE 8 > > END > > STATUS ON > > TRANSPARENT ON > > END > > DEBUG 2 > > OUTPUTFORMAT > > NAME png > > DRIVER "GD/PNG" > > MIMETYPE "image/png" > > IMAGEMODE RGB > > FORMATOPTION INTERLACE=OFF > > TRANSPARENT OFF > > END > > OUTPUTFORMAT > > NAME png8 > > DRIVER "GD/PNG" > > MIMETYPE "image/png" > > IMAGEMODE PC256 > > FORMATOPTION INTERLACE=OFF > > TRANSPARENT OFF > > END > > OUTPUTFORMAT > > NAME GTiff > > DRIVER "GDAL/GTiff" > > MIMETYPE "image/tiff" > > IMAGEMODE RGB > > END > > OUTPUTFORMAT > > NAME imagemap > > MIMETYPE "text/html" > > FORMATOPTION SKIPENDTAG=OFF > > DRIVER imagemap > > END > > # > > # Start of web interface definition > > # > > WEB > > TEMPLATE "map.html" > > IMAGEPATH "/var/tmp/mapserver/" > > IMAGEURL "/ms_tmp/" > > METADATA > > "wms_encoding" "UTF-8" > > "wms_title" "Mapserver WMS SIIAS" > > "wms_abstract" "" > > "wms_srs" "EPSG:32721" > > "wms_onlineresource" > "http://localhost:80/cgi-bin/mapserv?map=/var/www/siiasgis/siiasgis.map"; > > END > > END # Web > > REFERENCE > > EXTENT 366582.28125 6127927.0 858252.0625 6671738.5 > > IMAGE "../../images/uruguay.jpg" > > SIZE 149 149 > > COLOR -1 -1 -1 > > OUTLINECOLOR 255 0 0 > > END # Reference > > PROJECTION > > "init=epsg:32721" > > END > > #== START OF LAYER SECTION =# > > LAYER > > NAME "ejes_pl_total" > > STATUS ON > > TYPE LINE > > DATA "ejes_pl_total" > > DUMP TRUE > > SIZEUNITS pixels > > PROJECTION > > "init=epsg:32721" > > END > > TOLERANCE 5 > > TOLERANCEUNITS pixels > > CLASS > > STYLE > > OUTLINECOLOR 102 102 102 > > WIDTH 2 > > END > > NAME "Calles" > > TEMPLATE void > > END > > METADATA > > "description" "Calles" > > "wms_title" "ejes_pl_total" > > "wms_abstract" "ejes_pl_total" > > "wms_extent" "366582.290141166 6127927.10038269 858252.0151745 > 6671738.21181725" > > "gml_include_items" "all" > > "RESULT_FIELDS" "CODLOC,NOMBLOC,NOMBRE_INE,NOMBRE,DEPTO,COD_NOMBRE" > > "RESULT_HEADERS" "Codigo,Localidad,Nombre INE,Cod > Departamento,Departamento" > > END > > END # Layer > > LAYER > > NAME "departamentos" > > STATUS ON > > TYPE POLYGON > > DATA "the_geom from departamentos USING UNIQUE id USING SRID=32721" > > CONNECTIONTYPE POSTGIS > > CONNECTION "user= password=x host=localhost port=5432 dbname=" > > DUMP TRUE > > OPACITY 100 > > SIZEUNITS pixels > > TOLERANCE 5 > > TOLERANCEUNITS pixels > > PROJECTION > > "init=epsg:32721" > > END > > CLASS > > STYLE > > OUTLINECOLOR 102 102 102 > > WIDTH 3 > > END > > NAME "Departamentos" > > TEMPLATE void > > END > > METADATA > > "description" "Departamentos" > > "wms_title" "departamentos" > > "wms_abstract" "departamentos" > > "wms_extent" "366582.290141166 6127927.10038269 858252.0151745 > 6671738.21181725" > > "gml_include_items" "all" > > "RESULT_FIELDS" "id,descripcion" > >
Re: [pmapper-users] Search does not work.
Dear Armin, thank you very much for your response I could fix it, I really lacked the METADATA section Greetings Richard Montevideo, Uruguay >Mensaje original >De: armin.bur...@gmail.com >Fecha: 21/01/2010 12:12 >Para: "richardcam...@adinet.com.uy" >CC: >Asunto: Re: [pmapper-users] Search does not work. > >just noticed that you're mainly missing the template tag for the >layer, so *no* query will work. see > >http://svn.pmapper. net/trac/wiki/DocManual#LayerGroupDescriptionsandFieldsforQueries > > >On Thu, Jan 21, 2010 at 12:16 PM, richardcam...@adinet.com.uy > wrote: >> Estimado Nahum, la versión de pmapper es la 4 stable, adjunto parte >> archivos de configuración: >> Archivo .map >> LAYER >> CONNECTIONTYPE postgis >> DATA "the_geom from v_callepuerta USING UNIQUE gid >> USING SRID=32721" >> TYPE point >> CONNECTION "user=montevimap password=xxx >> dbname=nucleo host=desgis.imm.gub.uy port=5432" >> NAME "busqueda" >> STATUS OFF >> DUMP TRUE >> END >> >> Archivo search.xml >> >> >> >> > minlength="1" dependfld="cmcncd"> >> pgsql: //montevimap:x...@desgis.imm.gub. >> uy/nucleo >> SELECT nom_calle FROM v_callepuerta WHERE nom_calle >> ='[search]' >> >> >> >> > sort="asc" minlength="1" dependfld="cmcncd"> >> pgsql: >> //montevimap:x...@desgis.imm.gub.uy/nucleo >> SELECT num_puerta FROM >> v_callepuerta WHERE num_puerta ='[search]' >> >> >> >> >> >> Definición tabla postgrs. >> Columna | Tipo | Modificadores >> +---+--- >> gid | bigint | >> cod_nombre_via | integer | >> nom_calle | character varying | >> num_puerta | integer | >> letra | character(5) | >> paridad | character(1) | >> the_geom | geometry >> >> Muchas gracias por cualquier ayuda, otras busquedas si me funcionan >> pero no logro que esta funciones. >> >> Richard >> Montevideo, Uruguay >> >> English >> Dear Nahum, pmapper version is 4 stable, attached some configuration >> files: >> Archive. Map >> LAYER >> CONNECTIONTYPE postgis >> DATA "the_geom from v_callepuerta USING UNIQUE gid >> USING SRID = 32721" >> TYPE point >> CONNECTION "user = montevimap password = xxx dbname = >> nucleo desgis.imm.gub.uy host = port = 5432" >> NAME "Search" >> STATUS OFF >> DUMP TRUE >> END >> >> File search.xml >> >> >> >> >> pgsql: / / montevimap:x...@desgis.imm.gub.uy >> /nucleo >> nom_calle SELECT FROM v_callepuerta WHERE nom_calle = '[search]' >> >> >> >> >> > sort="asc" minlength="1" dependfld="cmcncd"> >> pgsql: / / >> montevimap:x...@desgis.imm.gub.uy /nucleo >> num_puerta SELECT FROM >> v_callepuerta WHERE num_puerta = '[search]' >> >> >> >> >> >> Definition postgres table. >> Column | Type | Modifiers >> --- --- >> gid | bigint | >> cod_nombre_via | integer | >> nom_calle | character varying | >> num_puerta | integer | >> letter | character (5) | >> parity | character (1) | >> the_geom | geometry >> >> Thank you very much for any help, if I run other searches but can not >> get these functions. >> >> Richard >> Montevideo, Uruguay >> >> Spanish >> ¿Cómo tienes definido tu .map y el archivo de configuración de >> búsquedas? >> ¿Qué versión de pmapper tienes?. >> >> English >> How is defined your .map file and search.xml file? &
Re: [pmapper-users] Search does not work.
just noticed that you're mainly missing the template tag for the layer, so *no* query will work. see http://svn.pmapper.net/trac/wiki/DocManual#LayerGroupDescriptionsandFieldsforQueries On Thu, Jan 21, 2010 at 12:16 PM, richardcam...@adinet.com.uy wrote: > Estimado Nahum, la versión de pmapper es la 4 stable, adjunto parte > archivos de configuración: > Archivo .map > LAYER > CONNECTIONTYPE postgis > DATA "the_geom from v_callepuerta USING UNIQUE gid > USING SRID=32721" > TYPE point > CONNECTION "user=montevimap password=xxx > dbname=nucleo host=desgis.imm.gub.uy port=5432" > NAME "busqueda" > STATUS OFF > DUMP TRUE > END > > Archivo search.xml > > > wildcard="0"> > sort="asc" > minlength="1" dependfld="cmcncd"> > encoding="UTF-8">pgsql://montevimap:x...@desgis.imm.gub. > uy/nucleo > SELECT nom_calle FROM v_callepuerta > WHERE nom_calle > ='[search]' > > > > sort="asc" minlength="1" dependfld="cmcncd"> > pgsql: > //montevimap:x...@desgis.imm.gub.uy/nucleo > SELECT num_puerta FROM > v_callepuerta WHERE num_puerta ='[search]' > > > > > > Definición tabla postgrs. > Columna | Tipo | Modificadores > +---+--- > gid | bigint | > cod_nombre_via | integer | > nom_calle | character varying | > num_puerta | integer | > letra | character(5) | > paridad | character(1) | > the_geom | geometry > > Muchas gracias por cualquier ayuda, otras busquedas si me funcionan > pero no logro que esta funciones. > > Richard > Montevideo, Uruguay > > English > Dear Nahum, pmapper version is 4 stable, attached some configuration > files: > Archive. Map > LAYER > CONNECTIONTYPE postgis > DATA "the_geom from v_callepuerta USING UNIQUE gid > USING SRID = 32721" > TYPE point > CONNECTION "user = montevimap password = xxx dbname = > nucleo desgis.imm.gub.uy host = port = 5432" > NAME "Search" > STATUS OFF > DUMP TRUE > END > > File search.xml > > > > > pgsql: / / montevimap:x...@desgis.imm.gub.uy > /nucleo > nom_calle SELECT FROM v_callepuerta WHERE nom_calle = '[search]' > > > > > sort="asc" minlength="1" dependfld="cmcncd"> > pgsql: / / > montevimap:x...@desgis.imm.gub.uy /nucleo > num_puerta SELECT FROM > v_callepuerta WHERE num_puerta = '[search]' > > > > > > Definition postgres table. > Column | Type | Modifiers > --- --- > gid | bigint | > cod_nombre_via | integer | > nom_calle | character varying | > num_puerta | integer | > letter | character (5) | > parity | character (1) | > the_geom | geometry > > Thank you very much for any help, if I run other searches but can not > get these functions. > > Richard > Montevideo, Uruguay > > Spanish > ¿Cómo tienes definido tu .map y el archivo de configuración de > búsquedas? > ¿Qué versión de pmapper tienes?. > > English > How is defined your .map file and search.xml file? > Wich pmapper version you have? > > Saludos. > Nahum > > 2010/1/20 richardcam...@adinet.com.uy > - Ocultar texto citado - > >> llo everyone, sorry for my English. >> I have configured and installed the viewer pmapper, the only problem > I >> have is with the search, the same achievements on Postgres with >> PostGIS, work correctly on some tables, but in others does not > search >> me. >> I use both geometry tables or views both with the corresponding > column >> the_geom and gid. >> The log tells me that there is an error with the gid, but it exists >> and it's OK, I can properly display the layer in the map view. >> Deputy log with errors. >> >> [20-Jan-2010 17:27:17] PHP Warning: pg_query () [ function.pg-query ]: Query failed: ERROR: syntax error >> at or near "FROM" at character 257 in / inetpub / wwwroot / maps / >> incphp / query / squery.php on line 704 >> [20-Jan-2010 17:27:17] P. MAPPER: PG for error Query: SELECT gid, >> xmin (box3d (the_geom)), >> ymin (box3d (the_geom)), >> xmax (box3d (the_geom)), >> ymax (box3d (the_geom)), >> >> FROM x_sig_busqueda >> WHERE nom_calle ILIKE '% COLONIA%' >> LIMIT 301 >> [20-Jan-2010 17:27:17] PHP Warning: pg_numrows (): supplied argument >> is not
Re: [pmapper-users] Search does not work.
The SQL used is missing the result fields and therefore the SQL is not correct (the comma at the end of the line before "FROM...") . Try to add the result fields in the layer definition like METADATA ... "RESULT_FIELDS" "NAME, ISO2_CODE, POPULATION, GTOPO30" "RESULT_HEADERS" "Name,Country,Inhabitants,Altitude" ... END # Metadata If they are not defined normally *all* fields are defined, but there might be a bug. I never define layers without them (I do not want to display the column names literally in the result, normally... ), so I have not stumbled over this problem armin On Thu, Jan 21, 2010 at 12:16 PM, richardcam...@adinet.com.uy wrote: > Estimado Nahum, la versión de pmapper es la 4 stable, adjunto parte > archivos de configuración: > Archivo .map > LAYER > CONNECTIONTYPE postgis > DATA "the_geom from v_callepuerta USING UNIQUE gid > USING SRID=32721" > TYPE point > CONNECTION "user=montevimap password=xxx > dbname=nucleo host=desgis.imm.gub.uy port=5432" > NAME "busqueda" > STATUS OFF > DUMP TRUE > END > > Archivo search.xml > > > wildcard="0"> > sort="asc" > minlength="1" dependfld="cmcncd"> > encoding="UTF-8">pgsql://montevimap:x...@desgis.imm.gub. > uy/nucleo > SELECT nom_calle FROM v_callepuerta > WHERE nom_calle > ='[search]' > > > > sort="asc" minlength="1" dependfld="cmcncd"> > pgsql: > //montevimap:x...@desgis.imm.gub.uy/nucleo > SELECT num_puerta FROM > v_callepuerta WHERE num_puerta ='[search]' > > > > > > Definición tabla postgrs. > Columna | Tipo | Modificadores > +---+--- > gid | bigint | > cod_nombre_via | integer | > nom_calle | character varying | > num_puerta | integer | > letra | character(5) | > paridad | character(1) | > the_geom | geometry > > Muchas gracias por cualquier ayuda, otras busquedas si me funcionan > pero no logro que esta funciones. > > Richard > Montevideo, Uruguay > > English > Dear Nahum, pmapper version is 4 stable, attached some configuration > files: > Archive. Map > LAYER > CONNECTIONTYPE postgis > DATA "the_geom from v_callepuerta USING UNIQUE gid > USING SRID = 32721" > TYPE point > CONNECTION "user = montevimap password = xxx dbname = > nucleo desgis.imm.gub.uy host = port = 5432" > NAME "Search" > STATUS OFF > DUMP TRUE > END > > File search.xml > > > > > pgsql: / / montevimap:x...@desgis.imm.gub.uy > /nucleo > nom_calle SELECT FROM v_callepuerta WHERE nom_calle = '[search]' > > > > > sort="asc" minlength="1" dependfld="cmcncd"> > pgsql: / / > montevimap:x...@desgis.imm.gub.uy /nucleo > num_puerta SELECT FROM > v_callepuerta WHERE num_puerta = '[search]' > > > > > > Definition postgres table. > Column | Type | Modifiers > --- --- > gid | bigint | > cod_nombre_via | integer | > nom_calle | character varying | > num_puerta | integer | > letter | character (5) | > parity | character (1) | > the_geom | geometry > > Thank you very much for any help, if I run other searches but can not > get these functions. > > Richard > Montevideo, Uruguay > > Spanish > ¿Cómo tienes definido tu .map y el archivo de configuración de > búsquedas? > ¿Qué versión de pmapper tienes?. > > English > How is defined your .map file and search.xml file? > Wich pmapper version you have? > > Saludos. > Nahum > > 2010/1/20 richardcam...@adinet.com.uy > - Ocultar texto citado - > >> llo everyone, sorry for my English. >> I have configured and installed the viewer pmapper, the only problem > I >> have is with the search, the same achievements on Postgres with >> PostGIS, work correctly on some tables, but in others does not > search >> me. >> I use both geometry tables or views both with the corresponding > column >> the_geom and gid. >> The log tells me that there is an error with the gid, but it exists >> and it's OK, I can properly display the layer in the map view. >> Deputy log with errors. >> >> [20-Jan-2010 17:27:17] PHP Warning: pg_query () [ function.pg-query ]: Query failed: ERROR: syntax error >> at or near "FROM" at character 257 in / inetpub / wwwroot / maps / >> incphp / query / squery.php on line 704 >> [20-Jan-2010 17:27:17] P. MAPPER: PG for error Query: SELECT gid, >>
Re: [pmapper-users] Search does not work.
Estimado Nahum, la versión de pmapper es la 4 stable, adjunto parte archivos de configuración: Archivo .map LAYER CONNECTIONTYPE postgis DATA "the_geom from v_callepuerta USING UNIQUE gid USING SRID=32721" TYPE point CONNECTION "user=montevimap password=xxx dbname=nucleo host=desgis.imm.gub.uy port=5432" NAME "busqueda" STATUS OFF DUMP TRUE END Archivo search.xml pgsql://montevimap:x...@desgis.imm.gub. uy/nucleo SELECT nom_calle FROM v_callepuerta WHERE nom_calle ='[search]' pgsql: //montevimap:x...@desgis.imm.gub.uy/nucleo SELECT num_puerta FROM v_callepuerta WHERE num_puerta ='[search]' Definición tabla postgrs. Columna | Tipo| Modificadores +---+--- gid| bigint| cod_nombre_via | integer | nom_calle | character varying | num_puerta | integer | letra | character(5) | paridad| character(1) | the_geom | geometry Muchas gracias por cualquier ayuda, otras busquedas si me funcionan pero no logro que esta funciones. Richard Montevideo, Uruguay English Dear Nahum, pmapper version is 4 stable, attached some configuration files: Archive. Map LAYER CONNECTIONTYPE postgis DATA "the_geom from v_callepuerta USING UNIQUE gid USING SRID = 32721" TYPE point CONNECTION "user = montevimap password = xxx dbname = nucleo desgis.imm.gub.uy host = port = 5432" NAME "Search" STATUS OFF DUMP TRUE END File search.xml pgsql: / / montevimap:x...@desgis.imm.gub.uy /nucleo nom_calle SELECT FROM v_callepuerta WHERE nom_calle = '[search]' pgsql: / / montevimap:x...@desgis.imm.gub.uy /nucleo num_puerta SELECT FROM v_callepuerta WHERE num_puerta = '[search]' Definition postgres table. Column | Type | Modifiers --- --- gid | bigint | cod_nombre_via | integer | nom_calle | character varying | num_puerta | integer | letter | character (5) | parity | character (1) | the_geom | geometry Thank you very much for any help, if I run other searches but can not get these functions. Richard Montevideo, Uruguay Spanish ¿Cómo tienes definido tu .map y el archivo de configuración de búsquedas? ¿Qué versión de pmapper tienes?. English How is defined your .map file and search.xml file? Wich pmapper version you have? Saludos. Nahum 2010/1/20 richardcam...@adinet.com.uy - Ocultar texto citado - > llo everyone, sorry for my English. > I have configured and installed the viewer pmapper, the only problem I > have is with the search, the same achievements on Postgres with > PostGIS, work correctly on some tables, but in others does not search > me. > I use both geometry tables or views both with the corresponding column > the_geom and gid. > The log tells me that there is an error with the gid, but it exists > and it's OK, I can properly display the layer in the map view. > Deputy log with errors. > > [20-Jan-2010 17:27:17] PHP Warning: pg_query () [ function.pg-query ]: Query failed: ERROR: syntax error > at or near "FROM" at character 257 in / inetpub / wwwroot / maps / > incphp / query / squery.php on line 704 > [20-Jan-2010 17:27:17] P. MAPPER: PG for error Query: SELECT gid, > xmin (box3d (the_geom)), > ymin (box3d (the_geom)), > xmax (box3d (the_geom)), > ymax (box3d (the_geom)), > >FROM x_sig_busqueda > WHERE nom_calle ILIKE '% COLONIA%' > LIMIT 301 > [20-Jan-2010 17:27:17] PHP Warning: pg_numrows (): supplied argument > is not a valid PostgreSQL result resource in / inetpub / wwwroot / map > s / incphp / query / squery.php on line 708 > > > Thank you very much for any help. > Greetings > Richard > > > -- > Throughout its 18-year history, RSA Conference consistently attracts the > world's best and brightest in the field, creating opportunities for > Conference > attendees to learn about information security's most important issues > through > interactions with peers, luminaries and emerging and established companies. > http://p.sf.net/sfu/rsaconf-dev2dev > ___
Re: [pmapper-users] Search does not work.
Spanish ¿Cómo tienes definido tu .map y el archivo de configuración de búsquedas? ¿Qué versión de pmapper tienes?. English How is defined your .map file and search.xml file? Wich pmapper version you have? Saludos. Nahum 2010/1/20 richardcam...@adinet.com.uy > llo everyone, sorry for my English. > I have configured and installed the viewer pmapper, the only problem I > have is with the search, the same achievements on Postgres with > PostGIS, work correctly on some tables, but in others does not search > me. > I use both geometry tables or views both with the corresponding column > the_geom and gid. > The log tells me that there is an error with the gid, but it exists > and it's OK, I can properly display the layer in the map view. > Deputy log with errors. > > [20-Jan-2010 17:27:17] PHP Warning: pg_query () [ function.pg-query ]: Query failed: ERROR: syntax error > at or near "FROM" at character 257 in / inetpub / wwwroot / maps / > incphp / query / squery.php on line 704 > [20-Jan-2010 17:27:17] P. MAPPER: PG for error Query: SELECT gid, > xmin (box3d (the_geom)), > ymin (box3d (the_geom)), > xmax (box3d (the_geom)), > ymax (box3d (the_geom)), > >FROM x_sig_busqueda > WHERE nom_calle ILIKE '% COLONIA%' > LIMIT 301 > [20-Jan-2010 17:27:17] PHP Warning: pg_numrows (): supplied argument > is not a valid PostgreSQL result resource in / inetpub / wwwroot / map > s / incphp / query / squery.php on line 708 > > > Thank you very much for any help. > Greetings > Richard > > > -- > Throughout its 18-year history, RSA Conference consistently attracts the > world's best and brightest in the field, creating opportunities for > Conference > attendees to learn about information security's most important issues > through > interactions with peers, luminaries and emerging and established companies. > http://p.sf.net/sfu/rsaconf-dev2dev > ___ > pmapper-users mailing list > pmapper-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/pmapper-users > -- Nahum Castro González León, Guanajuato, México -- Throughout its 18-year history, RSA Conference consistently attracts the world's best and brightest in the field, creating opportunities for Conference attendees to learn about information security's most important issues through interactions with peers, luminaries and emerging and established companies. http://p.sf.net/sfu/rsaconf-dev2dev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
[pmapper-users] Search does not work.
llo everyone, sorry for my English. I have configured and installed the viewer pmapper, the only problem I have is with the search, the same achievements on Postgres with PostGIS, work correctly on some tables, but in others does not search me. I use both geometry tables or views both with the corresponding column the_geom and gid. The log tells me that there is an error with the gid, but it exists and it's OK, I can properly display the layer in the map view. Deputy log with errors. [20-Jan-2010 17:27:17] PHP Warning: pg_query () [ function.pg-query ]: Query failed: ERROR: syntax error at or near "FROM" at character 257 in / inetpub / wwwroot / maps / incphp / query / squery.php on line 704 [20-Jan-2010 17:27:17] P. MAPPER: PG for error Query: SELECT gid, xmin (box3d (the_geom)), ymin (box3d (the_geom)), xmax (box3d (the_geom)), ymax (box3d (the_geom)), FROM x_sig_busqueda WHERE nom_calle ILIKE '% COLONIA%' LIMIT 301 [20-Jan-2010 17:27:17] PHP Warning: pg_numrows (): supplied argument is not a valid PostgreSQL result resource in / inetpub / wwwroot / map s / incphp / query / squery.php on line 708 Thank you very much for any help. Greetings Richard -- Throughout its 18-year history, RSA Conference consistently attracts the world's best and brightest in the field, creating opportunities for Conference attendees to learn about information security's most important issues through interactions with peers, luminaries and emerging and established companies. http://p.sf.net/sfu/rsaconf-dev2dev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users