Re: [pmapper-users] search for....... Warning: pg_numrows() expects parameter 1
Not sure to understand... You should chose between: - pmapper 4.2 and postgis <= 1.5 - pmapper dev (try this: http://www.pmapper.net/dl/pmapper-dev.zip) and postgis >= 2. But careful, this is not a DEVELOPMENT version! - search en replace every xmin by ST_xmin, etc like here: http://svn.pmapper.net/trac/changeset/1272 in you pmapper install and use postgis >= 2 Le 09/10/2012 09:08, miguel miguelito a écrit : > Hi Thomas Thanks for your reply. > > Use pmapper-4.2.0-MS4W. it recommends you, maybe need to change > operating system, postgis. > > --- El *mar, 9/10/12, Thomas RAFFIN //* escribió: > > > De: Thomas RAFFIN > Asunto: Re: [pmapper-users] search for... Warning: > pg_numrows() expects parameter 1 > Para: pmapper-users@lists.sourceforge.net > Fecha: martes, 9 de octubre, 2012 01:30 > > Hi, > > With postgis 2, you need a recent pmapper. What version are you using > please? > > Thomas > Le 08/10/2012 20:18, miguel miguelito a écrit : > > Hello > > Friends'm on the verge of madness happens that the search for > ... fails, use win7, ms4w_3.0.6, postgis 2 data tables are drawn > on the pmapper, pear install MDB2. > > HolaAmigos estoy al borde de la locura sucede que el buscar > por... no da resultado, uso win7, ms4w_3.0.6, postgis 2, los datos > de tablas se dibujan en el pmapper, instale el pear MDB2. > > config_default.xml- version="1.0"> $ description="sectores"> name="sectores"> description="Sector" wildcard="0" > > > > > name="descrip" description="via" wildcard="0"> > encoding="UTF-8">pgsql://postgres:123456@localhost/catas > SELECT DISTINCT descrip FROM vias1 WHERE > descrip ='[search]' > > > > > map file---LAYERNAME 'vias1'TYPE LINEDUMP > trueTEMPLATE fooOnlyForWMSGetFeatureInfo EXTENT 383230.235738 > 8242604.834650 400453.717167 8252242.309691 CONNECTIONTYPE > postgisCONNECTION "dbname='catas' host=localhost port=5432 > user='postgres' password='123456' sslmode=disable"DATA 'geom > FROM "vias1" USING UNIQUE gid USING srid=4326'METADATA > "LAYER_ENCODING" "UTF-8" "DESCRIPTION" "vias1" > "RESULT_FIELDS" "descrip" "RESULT_HEADERS" "Descripcion" > "ows_title" "vias1"END#STATUS DEFAULT#METADATA# > 'ows_title' 'vias1'#ENDSTATUS OFF TRANSPARENCY 100 > PROJECTION'proj=longlat' 'datum=WGS84''no_defs'END > CLASS NAME 'vias1'STYLE WIDTH 0.91 > COLOR 229 149 93 ENDEND END > > > > LOG ERROR DE APACHE--[Mon > Oct 08 12:02:24 2012] [error] [client 127.0.0.1] Incorrect setting > for 'error_log' in 'php.ini'. Set to a valid file name., referer: > http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 > 2012] [error] [client 127.0.0.1] PHP Warning: pg_query(): in > C:\\ms4w\\apps\\pmapper\\pmapper-4.2.0\\incphp\\query\\squery.php > on line 712, referer: > http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 > 2012] [error] [client 127.0.0.1] P.MAPPER: PG Query error for : > SELECT gid, , referer: > http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 > 2012] [error] [client 127.0.0.1] > xmin(box3d(geom)), , referer: > http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 > 2012] [error] [client 127.0.0.1] > ymin(box3d(geom)), , referer: > http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 > 2012] [error] > > [client 127.0.0.1] xmax(box3d(geom)), , referer: > http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 > 2012] [error] [client 127.0.0.1] > ymax(box3d(geom)), , referer: > http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 > 2012] [error] [client 127.0.0.1] descrip , > referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 > 12:02:24 2012] [error] [client 127.0.0.1]FROM > "vias1&qu
Re: [pmapper-users] search for....... Warning: pg_numrows() expects parameter 1
Hi, With postgis 2, you need a recent pmapper. What version are you using please? Thomas Le 08/10/2012 20:18, miguel miguelito a écrit : > Hello > Friends'm on the verge of madness happens that the search for ... fails, use > win7, ms4w_3.0.6, postgis 2 data tables are drawn on the pmapper, pear > install MDB2. > HolaAmigos estoy al borde de la locura sucede que el buscar por... no da > resultado, uso win7, ms4w_3.0.6, postgis 2, los datos de tablas se dibujan en > el pmapper, instale el pear MDB2. > config_default.xml- > $ description="sectores"> > description="Sector" wildcard="0" > > > type="postgis" name="vias1"> description="via" wildcard="0"> connectiontype="db" sort="asc"> encoding="UTF-8">pgsql://postgres:123456@localhost/catas > SELECT DISTINCT descrip FROM vias1 WHERE descrip ='[search]' > > > > map file---LAYERNAME 'vias1'TYPE LINEDUMP true > TEMPLATE fooOnlyForWMSGetFeatureInfo EXTENT 383230.235738 8242604.834650 > 400453.717167 8252242.309691CONNECTIONTYPE postgisCONNECTION > "dbname='catas' host=localhost port=5432 user='postgres' password='123456' > sslmode=disable"DATA 'geom FROM "vias1" USING UNIQUE gid USING srid=4326' >METADATA "LAYER_ENCODING" "UTF-8" "DESCRIPTION" "vias1" > "RESULT_FIELDS" "descrip" "RESULT_HEADERS" "Descripcion" > "ows_title" "vias1"END#STATUS DEFAULT#METADATA# > 'ows_title' 'vias1'#ENDSTATUS OFFTRANSPARENCY 100PROJECTION > 'proj=longlat''datum=WGS84''no_defs'ENDCLASS NAME > 'vias1'STYLE WIDTH 0.91 COLOR 229 149 93 END > END END > > LOG ERROR DE APACHE--[Mon Oct 08 12:02:24 > 2012] [error] [client 127.0.0.1] Incorrect setting for 'error_log' in > 'php.ini'. Set to a valid file name., referer: > http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] > [client 127.0.0.1] PHP Warning: pg_query(): in > C:\\ms4w\\apps\\pmapper\\pmapper-4.2.0\\incphp\\query\\squery.php on line > 712, referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 > 2012] [error] [client 127.0.0.1] P.MAPPER: PG Query error for : SELECT gid, , > referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] > [error] [client 127.0.0.1] xmin(box3d(geom)), , > referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] > [error] [client 127.0.0.1] ymin(box3d(geom)), , > referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] > [error] > [client 127.0.0.1] xmax(box3d(geom)), , referer: > http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] > [client 127.0.0.1] ymax(box3d(geom)), , referer: > http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] > [client 127.0.0.1] descrip , referer: > http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] > [client 127.0.0.1] FROM "vias1" , referer: > http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] > [client 127.0.0.1]WHERE descrip ILIKE '%JR.APACHETA%' , > referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] > [error] [client 127.0.0.1]LIMIT 301, referer: > http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] > [client > 127.0.0.1] PHP Warning: pg_numrows() expects parameter 1 to be resource, > boolean given in > C:\\ms4w\\apps\\pmapper\\pmapper-4.2.0\\incphp\\query\\squery.php on line > 716, referer: http://localhost/pmapper/map_default.phtml > > Saludos Miguel Cisneros > -- > Don't let slow site performance ruin your business. Deploy New Relic APM > Deploy New Relic app performance management and know exactly > what is happening inside your Ruby, Python, PHP, Java, and .NET app > Try New Relic at no cost today and get our sweet Data Nerd shirt too! > http://p.sf.net/sfu/newrelic-dev2dev > ___ > pmapper-users mailing list > pmapper-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/pmapper-users > > -- Don't let slow site performance ruin your business. Deploy New Relic APM Deploy New Relic app performance management and know exactly what is happening inside your Ruby, Python, PHP, Java, and .NET app Try New Relic at no cost today and get
[pmapper-users] search for....... Warning: pg_numrows() expects parameter 1
Hello Friends'm on the verge of madness happens that the search for ... fails, use win7, ms4w_3.0.6, postgis 2 data tables are drawn on the pmapper, pear install MDB2. HolaAmigos estoy al borde de la locura sucede que el buscar por... no da resultado, uso win7, ms4w_3.0.6, postgis 2, los datos de tablas se dibujan en el pmapper, instale el pear MDB2. config_default.xml- $ pgsql://postgres:123456@localhost/catas SELECT DISTINCT descrip FROM vias1 WHERE descrip ='[search]' map file---LAYER NAME 'vias1' TYPE LINE DUMP true TEMPLATE fooOnlyForWMSGetFeatureInfo EXTENT 383230.235738 8242604.834650 400453.717167 8252242.309691 CONNECTIONTYPE postgis CONNECTION "dbname='catas' host=localhost port=5432 user='postgres' password='123456' sslmode=disable" DATA 'geom FROM "vias1" USING UNIQUE gid USING srid=4326' METADATA "LAYER_ENCODING" "UTF-8" "DESCRIPTION" "vias1" "RESULT_FIELDS" "descrip" "RESULT_HEADERS" "Descripcion" "ows_title" "vias1" END #STATUS DEFAULT #METADATA # 'ows_title' 'vias1' #END STATUS OFF TRANSPARENCY 100 PROJECTION 'proj=longlat' 'datum=WGS84' 'no_defs' END CLASS NAME 'vias1' STYLE WIDTH 0.91 COLOR 229 149 93 END END END LOG ERROR DE APACHE--[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] Incorrect setting for 'error_log' in 'php.ini'. Set to a valid file name., referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] PHP Warning: pg_query(): in C:\\ms4w\\apps\\pmapper\\pmapper-4.2.0\\incphp\\query\\squery.php on line 712, referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] P.MAPPER: PG Query error for : SELECT gid, , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] xmin(box3d(geom)), , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] ymin(box3d(geom)), , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] xmax(box3d(geom)), , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] ymax(box3d(geom)), , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] descrip , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] FROM "vias1" , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] WHERE descrip ILIKE '%JR.APACHETA%' , referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] LIMIT 301, referer: http://localhost/pmapper/map_default.phtml[Mon Oct 08 12:02:24 2012] [error] [client 127.0.0.1] PHP Warning: pg_numrows() expects parameter 1 to be resource, boolean given in C:\\ms4w\\apps\\pmapper\\pmapper-4.2.0\\incphp\\query\\squery.php on line 716, referer: http://localhost/pmapper/map_default.phtml Saludos Miguel Cisneros -- Don't let slow site performance ruin your business. Deploy New Relic APM Deploy New Relic app performance management and know exactly what is happening inside your Ruby, Python, PHP, Java, and .NET app Try New Relic at no cost today and get our sweet Data Nerd shirt too! http://p.sf.net/sfu/newrelic-dev2dev ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search for...
Armin Burger-2 wrote: > > seems there are a bit too many escaping backslashes added. Check your > php.ini file for > >magic_quotes_gpc > and >magic_quotes_runtime > > and if they're set to On, try to set them to Off and see if the problem > still appears. > > Armin > > On 12/07/2008 13:12, Salvator*eL*arosa wrote: >> >> >> pag66 wrote: >>> Try to use this >>> metadata >>> "LAYER_ENCODING" "UTF-8" >>> end >>> in your layer definition >>> I think it solve your problem >>> >> >> Thanks for your reply, but it don't work for me! >> >> My pm_debug is: >> >> [12-Jul-2008 15:05:04] P.MAPPER debug info >> Searcharray in search.php->getSearchParameters() >> Array >> ( >> [nome] => SANT\'ANGELO LE FRATTE >> [mode] => search >> [PHPSESSID] => 2ff4c48f24cec5f8a11633fccc7744d9 >> ) >> >> [12-Jul-2008 15:05:04] P.MAPPER debug info >> Parameters for searchArray >> file: query.php->q_execAttributeQuery >> >> Array >> ( >> [nome] => SANT\'ANGELO LE FRATTE >> [mode] => search >> [PHPSESSID] => 2ff4c48f24cec5f8a11633fccc7744d9 >> ) >> >> [12-Jul-2008 15:05:04] P.MAPPER debug info >> P.MAPPER Warning: no UNIQUE field specified for PostGIS table >> 'public.comuni_pit'. Trying using OID field... >> [12-Jul-2008 15:05:04] P.MAPPER debug info >> P.MAPPER-DEBUG: squery.php/dumpPGQueryResults() - SQL Cmd: >> SELECT gid, >> xmin(box3d(the_geom)), >> ymin(box3d(the_geom)), >> xmax(box3d(the_geom)), >> ymax(box3d(the_geom)), >> nome,istat >> FROM public.comuni_pit >>WHERE nome = 'SANT\\\'ANGELO LE FRATTE' >>LIMIT 301 >> >> >> Bye >> >> >> - >> Salvatore Larosa >> GPG: 0xE504BBE2 (FP: D9B2 CA87 81CD 1B91 E24D 3B42 D0F7 FA01 E504 BBE2) > > > - > Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! > Studies have shown that voting for your favorite open source project, > along with a healthy diet, reduces your potential for chronic lameness > and boredom. Vote Now at http://www.sourceforge.net/community/cca08 > ___ > pmapper-users mailing list > pmapper-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/pmapper-users > > Thank you very much, the problem is disappears! - Salvatore Larosa GPG: 0xE504BBE2 (FP: D9B2 CA87 81CD 1B91 E24D 3B42 D0F7 FA01 E504 BBE2) -- View this message in context: http://www.nabble.com/search-for...-tp17648809p18419253.html Sent from the pmapper users mailing list archive at Nabble.com. - Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search for...
seems there are a bit too many escaping backslashes added. Check your php.ini file for magic_quotes_gpc and magic_quotes_runtime and if they're set to On, try to set them to Off and see if the problem still appears. Armin On 12/07/2008 13:12, Salvator*eL*arosa wrote: > > > pag66 wrote: >> Try to use this >> metadata >> "LAYER_ENCODING" "UTF-8" >> end >> in your layer definition >> I think it solve your problem >> > > Thanks for your reply, but it don't work for me! > > My pm_debug is: > > [12-Jul-2008 15:05:04] P.MAPPER debug info > Searcharray in search.php->getSearchParameters() > Array > ( > [nome] => SANT\'ANGELO LE FRATTE > [mode] => search > [PHPSESSID] => 2ff4c48f24cec5f8a11633fccc7744d9 > ) > > [12-Jul-2008 15:05:04] P.MAPPER debug info > Parameters for searchArray > file: query.php->q_execAttributeQuery > > Array > ( > [nome] => SANT\'ANGELO LE FRATTE > [mode] => search > [PHPSESSID] => 2ff4c48f24cec5f8a11633fccc7744d9 > ) > > [12-Jul-2008 15:05:04] P.MAPPER debug info > P.MAPPER Warning: no UNIQUE field specified for PostGIS table > 'public.comuni_pit'. Trying using OID field... > [12-Jul-2008 15:05:04] P.MAPPER debug info > P.MAPPER-DEBUG: squery.php/dumpPGQueryResults() - SQL Cmd: > SELECT gid, > xmin(box3d(the_geom)), > ymin(box3d(the_geom)), > xmax(box3d(the_geom)), > ymax(box3d(the_geom)), > nome,istat > FROM public.comuni_pit >WHERE nome = 'SANT\\\'ANGELO LE FRATTE' >LIMIT 301 > > > Bye > > > - > Salvatore Larosa > GPG: 0xE504BBE2 (FP: D9B2 CA87 81CD 1B91 E24D 3B42 D0F7 FA01 E504 BBE2) - Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search for...
pag66 wrote: > > Try to use this > metadata > "LAYER_ENCODING" "UTF-8" > end > in your layer definition > I think it solve your problem > Thanks for your reply, but it don't work for me! My pm_debug is: [12-Jul-2008 15:05:04] P.MAPPER debug info Searcharray in search.php->getSearchParameters() Array ( [nome] => SANT\'ANGELO LE FRATTE [mode] => search [PHPSESSID] => 2ff4c48f24cec5f8a11633fccc7744d9 ) [12-Jul-2008 15:05:04] P.MAPPER debug info Parameters for searchArray file: query.php->q_execAttributeQuery Array ( [nome] => SANT\'ANGELO LE FRATTE [mode] => search [PHPSESSID] => 2ff4c48f24cec5f8a11633fccc7744d9 ) [12-Jul-2008 15:05:04] P.MAPPER debug info P.MAPPER Warning: no UNIQUE field specified for PostGIS table 'public.comuni_pit'. Trying using OID field... [12-Jul-2008 15:05:04] P.MAPPER debug info P.MAPPER-DEBUG: squery.php/dumpPGQueryResults() - SQL Cmd: SELECT gid, xmin(box3d(the_geom)), ymin(box3d(the_geom)), xmax(box3d(the_geom)), ymax(box3d(the_geom)), nome,istat FROM public.comuni_pit WHERE nome = 'SANT\\\'ANGELO LE FRATTE' LIMIT 301 Bye - Salvatore Larosa GPG: 0xE504BBE2 (FP: D9B2 CA87 81CD 1B91 E24D 3B42 D0F7 FA01 E504 BBE2) -- View this message in context: http://www.nabble.com/search-for...-tp17648809p18418496.html Sent from the pmapper users mailing list archive at Nabble.com. - Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search for...
Try to use this metadata "LAYER_ENCODING" "UTF-8" end in your layer definition I think it solve your problem -- View this message in context: http://www.nabble.com/search-for...-tp17648809p18244826.html Sent from the pmapper users mailing list archive at Nabble.com. - Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
Re: [pmapper-users] search for...
Salvator*eL*arosa wrote: > > Hello everyone, > I have a problem with apostrophes in research > an attribute! > The fields with SANT'ANTONIO, SANT'AGATA produce > no result! > > Someone knows how can I fix? > Someone has some ideas about? Thanks! - Salvatore Larosa GPG: 0xE504BBE2 (FP: D9B2 CA87 81CD 1B91 E24D 3B42 D0F7 FA01 E504 BBE2) -- View this message in context: http://www.nabble.com/search-for...-tp17648809p17942108.html Sent from the pmapper users mailing list archive at Nabble.com. - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
[pmapper-users] search for...
Hello everyone, I have a problem with apostrophes in research an attribute! The fields with SANT'ANTONIO, SANT'AGATA produce no result! Someone knows how can I fix? - Salvatore Larosa GPG: 0xE504BBE2 (FP: D9B2 CA87 81CD 1B91 E24D 3B42 D0F7 FA01 E504 BBE2) -- View this message in context: http://www.nabble.com/search-for...-tp17648809p17648809.html Sent from the pmapper users mailing list archive at Nabble.com. - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users