[Geomoose-users] Layer Display Error

[Matej Mailing]

Hi,

try to execute this query from the PostgreSQL console as the same user
as specified in the mapfile and in the same db:
"SELECT the_geom FROM Agenda"

Perhaps it is some upper/lowercase issue or maybe wrong DB selected ...

Regards,
Matej

2012/10/19 Efstathios Arapostathis <e.arapostathis at gmail.com>:
> Hi guys,
>
>   Apparently I have not used geomoose for a long period of time, so I'm
> stucked again in issues that I have solved in the past.
> I was wondering if you could provide me with some feedback. I'm having
> problems in displaying a postgis layer in geomoose 2.6. I'm getting a pink
> image and when I'm trying to follow the link (from mozilla firefox on the
> sub menu tools-->page info-->multimedia) no error message is provided.
> Instead a popup window appears in order to save mapserv.exe file(!!)
>
> I enabled debug in the map file and this is the log I'm receiving. I cannot
> really understand it. Could anyone help me please?
>
> [Fri Oct 19 11:20:39 2012].971000 CGI Request 1 on process 4992
> [Fri Oct 19 11:20:37 2012].936000 CGI Request 1 on process 3524
> [Fri Oct 19 11:20:37 2012].940000 msDrawMap(): rendering using outputformat
> named agg/png (AGG/PNG).
> [Fri Oct 19 11:20:40 2012].106000 msPostGISLayerWhichShapes(): Query error.
> Error (ERROR:  relation "agenda" does not exist
> LINE 1: ...e_2D("the_geom"),'NDR'),'hex') as geom,"gid" from Agenda whe...
>                                                              ^
> ) executing query: select
> encode(ST_AsBinary(ST_Force_2D("the_geom"),'NDR'),'hex') as geom,"gid" from
> Agenda where the_geom && GeomFromText('POLYGON((2646964.79596457
> 4577985.29374734,2646964.79596457 4584071.59212366,2657943.06415043
> 4584071.59212366,2657943.06415043 4577985.29374734,2646964.79596457
> 4577985.29374734))',find_srid('','Agenda','the_geom'))
> [Fri Oct 19 11:20:40 2012].106000 msDrawMap(): Image handling error. Failed
> to draw layer named 'Agenda'.
> [Fri Oct 19 11:20:38 2012].473000 CGI Request 1 on process 4848
> [Fri Oct 19 11:20:38 2012].619000 msDrawMap(): rendering using outputformat
> named agg/png (AGG/PNG).
> [Fri Oct 19 11:20:40 2012].199000 msPostGISLayerWhichShapes(): Query error.
> Error (ERROR:  relation "agenda" does not exist
> LINE 1: ...e_2D("the_geom"),'NDR'),'hex') as geom,"gid" from Agenda whe...
>
>
> "Agenda" Is the name of the Table of the "CulturalGIS" database. It is a
> POINT PostGIS Layer, I'm attaching the map file.
>
> Thanks in advance for any responses
> Stathis
>
> _______________________________________________
> Geomoose-users mailing list
> Geomoose-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/geomoose-users
>