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
