Below my (scary) error_log. Thanks for your help.
[25-Nov-2008 17:28:48] PHP Warning: [MapServer Error]: msDrawMap(): Failed to
draw layer named 'monumenti_postgis'.
in D:\ms4w\apps\pmapper-3.1-beta4\prova_postgis\incphp\map.php on line 316
[25-Nov-2008 17:28:48] PHP Warning: [MapServer Error]: prepare_database():
Error executing POSTGIS DECLARE (the actual query) statement: 'DECLARE mycursor
BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text from (select
the_geom, * from monumenti_postgis) AS new_tab WHERE the_geom &&
setSRID('BOX3D(2572022.42731278 4228206,2580362.57268722 4232175)'::BOX3D,
find_srid('','monumenti_postgis','the_geom') )'
Postgresql reports the error as 'ERROR: column reference "the_geom" is
ambiguous
LINE 1: ...SOR FOR SELECT asbinary(force_collection(force_2d(the_geom))...
^
'
More Help:
Error with POSTGIS data variable. You specified 'check your .map file'.
Standard ways of specifiying are :
(1) 'geometry_column from geometry_table'
(2) 'geometry_column from (sub query) as foo using unique column name using
SRID=srid#'
Make sure you put in the 'using unique column name' and 'using SRID=#' clauses
in.
For more help, please see http://postgis.refractions. in
D:\ms4w\apps\pmapper-3.1-beta4\prova_postgis\incphp\map.php on line 316
[25-Nov-2008 17:28:48] PHP Fatal error: Call to a member function saveImage()
on a non-object in
D:\ms4w\apps\pmapper-3.1-beta4\prova_postgis\incphp\common.php on line 244
Stefano
> Date: Tue, 25 Nov 2008 16:20:58 +0100
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> CC: [email protected]
> Subject: Re: [pmapper-users] problem in connecting to PostGIS layers from
> p.mapper
>
> Stefano Gambini ha scritto:
> But is very strange...
>
> now you have to debug you application, looking at php error log but
> sorry I don't know where you watch at it on ms4w :(
>
> W
> > I threw IE away :), added
> > your string in .map, tried with (IE again), Mozilla and Chrome but had
> > the same result: neverending LOADING bar
> > ------------------------------------------------------------------------
> > Date: Tue, 25 Nov 2008 15:53:10 +0100
> > From: [EMAIL PROTECTED]
> > To: [EMAIL PROTECTED]
> > CC: [email protected]
> > Subject: Re: [pmapper-users] problem in connecting to PostGIS layers
> > from p.mapper
> >
> > Stefano Gambini ha scritto:
> >
> > Hi Walter,
> > Thanks for the prompt reply.
> > Change you suggest applied but still not working. I have this message
> > in the state bar:
> > "Errore nella visualizzazione della pagina" and a popup window with:
> > Linea: 93
> > Carattere: 17
> > Errore: Errore di sintassi
> > Codice 0
> > URL: http://localhost/pmapper/prova_postgis/map.phtml
> >
> >
> > ahhh this tell me that are you using IE :(...
> > I think it's a derivated error for postgis layer
> >
> > Notice I can open the underlying raster (rectifyvilla_aerea_e_logoi).
> > It's only when i tick the postgis layer in the TOC that the application
> > gets stuck.
> >
> >
> > Clear .. depend on this postgis layer
> >
> > Try to put in map file a sql like this:
> >
> > DATA "the_geom from (select the_geom, * from monumenti_postgis) AS new_tab
> > USING UNIQUE gid"
> >
> > without SRID if you are sure that in you geometry_columns table is
> > specified the srid for your
> > monumenti_postgis table
> >
> > W
> >
> >
> > Stefano
> >
> >
> >
> > Date: Tue, 25 Nov 2008 15:30:10 +0100
> > From: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
> > To: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
> > CC: [email protected]
> > <mailto:[email protected]>
> > Subject: Re: [pmapper-users] problem in connecting to PostGIS
> > layers from p.mapper
> >
> > Stefano Gambini ha scritto:
> > Hi Stefano,
> >
> >
> >
> > I'm a new user and find some problem in connecting to PostGIS
> > layers from p.mapper.
> >
> > I have created a PostGIS layer of points and added to .map file
> > as follows:
> >
> > LAYER
> > NAME "monumenti_postgis"
> > TYPE POINT
> > CONNECTIONTYPE postgis
> > CONNECTION "user=postgres password=**** dbname=postgis
> > host=localhost port=5432"
> > STATUS ON
> > DATA "the_geom from monumenti_postgis USING UNIQUE oid USING
> > SRID = 32733"
> >
> >
> >
> > Are you sure that your monumenti_postgis table has OIDS?
> > Try to remove USING UNIQUE OID and replace with USING UNIQUE gid
> >
> >
> > TOLERANCE 10
> > TOLERANCEUNITS pixels
> > METADATA
> > "DESCRIPTION" "Monumenti a rischio"
> > "RESULT_FIELDS" "id,rischio,nome"
> > "RESULT_HEADERS" "Monumento ID,Classe sismica,Nome"
> > END # Metadata
> > CLASS
> > COLOR 0 0 255
> > END # Class
> > END # Layer
> >
> > Also added monumenti_postgis to config.ini:
> > allGroups = monumenti_postgis, rectifyvilla_aerea_e_logoi
> >
> > Still the LOADING bar goes on forever when I try to open it
> > from p.mapper
> >
> > Notice that I'm able to open monumenti_postgis with, ex, QGIS.
> >
> > Have a doubt: My general p.mapper folder is in
> > D:\ms4w\apps\pmapper-3.1-beta4\
> > whereas my particular project in
> > D:\ms4w\apps\pmapper-3.1-beta4\prova_postgis\
> >
> >
> >
> > is correct there isn't another place
> >
> > W
> >
> >
> >
> > _________________________________________________________________
> > Explore the seven wonders of the world
> >
> > http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE
> > <http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE>
> >
> > -------------------------------------------------------------------------
> > This SF.Net email is sponsored by the Moblin Your Move
> > Developer's challenge
> > Build the coolest Linux based applications with Moblin SDK &
> > win great prizes
> > Grand prize is a trip for two to an Open Source event anywhere
> > in the world
> > http://moblin-contest.org/redirect.php?banner_id=100&url=/
> > <http://moblin-contest.org/redirect.php?banner_id=100&url=/>
> > _______________________________________________
> > pmapper-users mailing list
> > [email protected]
> > <mailto:[email protected]>
> > https://lists.sourceforge.net/lists/listinfo/pmapper-users
> >
> >
> >
> > --
> >
> > Walter Lorenzetti
> > email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
> > skype: aiki74
> > Cell: (+39) 347-6597931 Tel+Fax: (+39) 0583 926684
> > Via di Tofori 123a 55010, Camigliano-S.Gemma Lucca
> > Italy
> >
> >
> >
> > _________________________________________________________________
> > Explore the seven wonders of the world
> >
> > http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE
> > <http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE>
> >
> > -------------------------------------------------------------------------
> > This SF.Net email is sponsored by the Moblin Your Move Developer's
> > challenge
> > Build the coolest Linux based applications with Moblin SDK & win great
> > prizes
> > Grand prize is a trip for two to an Open Source event anywhere in the
> > world
> > http://moblin-contest.org/redirect.php?banner_id=100&url=/
> > <http://moblin-contest.org/redirect.php?banner_id=100&url=/>
> > _______________________________________________
> > pmapper-users mailing list
> > [email protected]
> > <mailto:[email protected]>
> > https://lists.sourceforge.net/lists/listinfo/pmapper-users
> >
> >
> >
> >
> > --
> >
> > Walter Lorenzetti
> > email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
> > skype: aiki74
> > Cell: (+39) 347-6597931 Tel+Fax: (+39) 0583 926684
> > Via di Tofori 123a 55010, Camigliano-S.Gemma Lucca
> > Italy
> >
> > ------------------------------------------------------------------------
> > Discover the new Windows Vista Learn more!
> > <http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE>
>
>
> --
>
> Walter Lorenzetti
> email: [EMAIL PROTECTED]
> skype: aiki74
> Cell: (+39) 347-6597931 Tel+Fax: (+39) 0583 926684
> Via di Tofori 123a 55010, Camigliano-S.Gemma Lucca
> Italy
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> pmapper-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
_________________________________________________________________
News, entertainment and everything you care about at Live.com. Get it now!
http://www.live.com/getstarted.aspx
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
pmapper-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users
