Hi,

Your table has a constraint  concerning projection. Maybe you should try 
this:
DATA "the_geom FROM t473175 USING UNIQUE gid USING SRID=4326"


Is there any interesting information in your log files (with ms4w --> 
ms4w/Apache/logs/*.log) ?

Fernando Bordignon a écrit :
> Hi
>
> First, sorry by my english. I have a new project with pmapper
> (pmapper-4.0.beta2, ms4w and Postgresql 8.3). My problem is with a
> postgresql table. The definition is
>
> CREATE TABLE t473175
> (  gid serial NOT NULL,
>   __gid integer,
>   categoria_ character varying(80),
>   humedad_ma numeric,
>   humedad_mi numeric,
>   the_geom geometry,
>   CONSTRAINT t473175_pkey PRIMARY KEY (gid),
>   CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2),
>   CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) =
> 'MULTIPOLYGON'::text OR the_geom IS NULL),
>   CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 4326) )
> WITH (OIDS=FALSE);
> ALTER TABLE t473175 OWNER TO postgres;
>
> Then i use GVSig for testing the table t473175 and the display is OK.
> When i need to see the layer with pmapper the interfase show a black
> window (not show anything layer). If i delete the layer t473175 in the
> configuration map the interface is OK. The layer definition is:
>
> LAYER
>     NAME "grilla"
>       TYPE POLYGON
>       STATUS DEFAULT
>     CONNECTIONTYPE postgis
>       CONNECTION "user=postgres password=XXXX dbname=espacial host=localhost"
>       DATA "the_geom FROM t473175 USING UNIQUE gid "
>       TOLERANCE 3
>       TOLERANCEUNITS pixels
>       TEMPLATE "void"
>       PROJECTION
>                       "init=epsg:4326"
>       END
>       METADATA
>               "DESCRIPTION"    "Grilla"
>               "RESULT_FIELDS"  "gid"
>               "RESULT_HEADERS" "ID Celda"
>               "ows_title"      "grilla"
>     END
>     CLASS
>        NAME 'grilla'
>               STYLE
>                       outlinecolor   90 90 90
>                       color              128 60 0
>               END
>     END
>       TRANSPARENCY 60
>   END
>
> The error in "errorphp" is
>
> [21-Aug-2009 10:06:15] PHP Fatal error:  Object expected as argument.
> in C:\ms4w\apps\pmapper\pmapper-4.0.beta2\incphp\map\map.php on line
> 789
>
> The table  t473175 have 122 rows.  If i generate the table  t473175
> with more tan 200 rows the layer is show OK in pmapper (with the same
> configuration).
>
> ¿ The problem is the rows quantity? help me
>
> Thanks
>
>
>
>   

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users

Reply via email to