Skip to main content
Tweeted twitter.com/StackGIS/status/872517208529829896
added 338 characters in body
Source Link

EDIT: I've tried eliminating the joins by creating a table with all the necessary data. In this case, I have:

            DATA "geom from portfolios.area_aggregates_join using SRID=4326 using unique aggregates_id"

Yet I still get the same error. That "and ()" at the end of the final query that's causing the syntax error is bothering me.

EDIT: I've tried eliminating the joins by creating a table with all the necessary data. In this case, I have:

            DATA "geom from portfolios.area_aggregates_join using SRID=4326 using unique aggregates_id"

Yet I still get the same error. That "and ()" at the end of the final query that's causing the syntax error is bothering me.

removed thank you and help me
Source Link
Vince
  • 20.3k
  • 16
  • 48
  • 65

I'm sure something's changed in the way I'm supposed to configure the mapfile, but I can't figure out what it is. Can anyone help me?

Thank you!

I'm sure something's changed in the way I'm supposed to configure the mapfile, but I can't figure out what it is. Can anyone help me?

Thank you!

I'm sure something's changed in the way I'm supposed to configure the mapfile, but I can't figure out what it is.

Source Link

PostGIS layer works in Mapserver 6.4 but fails in 7

I have the following layer defined in a mapfile:

            LAYER

                NAME "aggregates"
                #STATUS OFF
                TYPE POLYGON
                CONNECTIONTYPE POSTGIS
                CONNECTION "host=localhost port=5432 dbname=*** user=*** password=***"
                DATA "geom FROM (SELECT b.geom AS geom, a.peril_id, a.portfolio_id, a.tiv, a.thematic_tiv, a.aggregates_id FROM schema.aggregates a INNER JOIN gisdata.adm_1 b on a.gid = b.gid) AS c using SRID=4326 using unique aggregates_id"

                PROJECTION
                    "proj=longlat"
                    "ellps=WGS84"
                    "datum=WGS84"
                    "no_defs"
                END

            END

This works in Mapserver 6.4. However, when I try to use this with Mapserver 7, I get the following errors logged when I try to generate tiles:

            [Wed Jun  7 03:42:43 2017].502983 msDrawMap(): rendering using outputformat named png (AGG/PNG).
            [Wed Jun  7 03:42:43 2017].503018 msDrawMap(): WMS/WFS set-up and query, 0.000s
            [Wed Jun  7 03:42:43 2017].523359 msPostGISLayerWhichShapes(): Error (ERROR:  syntax error at or near ")"
            LINE 1: ...2300166285,129.462890606979 36.6292300166285))',4326) and ()
                                                                          ^
            ) executing query: select "thematic_tiv",encode(ST_AsBinary(ST_Force2D("geom"),'NDR'),'hex') as geom,"aggregates_id" from (SELECT b.geom AS geom, a.peril_id, a.portfolio_id, a.tiv, a.thematic_tiv, a.aggregates_id FROM portfolios.aggregates a INNER JOIN gisdata.adm_1 b on a.gid = b.gid) AS c where geom && ST_GeomFromText('POLYGON((129.462890606979 36.6292300166285,129.462890606979 68.6423395678331,179.999999974944 68.6423395678331,179.999999974944 36.6292300166285,129.462890606979 36.6292300166285))',4326) and ()
            [Wed Jun  7 03:42:43 2017].523377 msPostGISLayerWhichShapes(): Query error. Error executing query. Check server logs
            [Wed Jun  7 03:42:43 2017].523434 msDrawMap(): Image handling error. Failed to draw layer named 'area_aggregates_tiv'.
            [Wed Jun  7 03:42:43 2017].523927 msFreeMap(): freeing map at 0x560aa573b6c0.

I'm sure something's changed in the way I'm supposed to configure the mapfile, but I can't figure out what it is. Can anyone help me?

Thank you!