[Geomoose-users] Layer Display Error

[Efstathios Arapostathis]

Yes you are right,

  I renamed the table replacing the first letter with a capital ("Agenda"
instead of "agenda") but constraints were built when the table was
"agenda". I renamed the table again and it works now.

Many thanks Matej.
Stathis





On Fri, Oct 19, 2012 at 11:48 AM, Matej Mailing <mailing at tam.si> wrote:

> 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
> >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geomoose-users/attachments/20121019/e9603e9f/attachment.html>