[postgis-users] postgis x Mapserver - the fight continues! :-)

[strk]

On Mon, Jul 19, 2004 at 03:41:00PM -0400, Ednardo Ferreira wrote:
> Thanks, any way for everybody. Let's go with my
> question.
> 
> Anyone told me use mappostis.c from CVS. How I get
> him?
> 
> Some people is asking same thing but I couldn't yet
> solve my problem. Thanks those are helping me.
> 
> how were the rounds today:
> 
> 1- I checked my postgis. It's 0.8.1. 
> 
> 2- I changed my Mapserver to 4.2.1. It generates the
> mapserv file and it's working, but it showed these
> messagens (and other similars) hundreds times during
> make proccess:
> 
> gcc -c -O2  -Wall -DIGNORE_MISSING_DATA  -DUSE_EPPL   
>  -DUSE_TIFF -DUSE_JPEG -D USE_GD_PNG -DUSE_GD_JPEG
> -DUSE_GD_WBMP -DUSE_GD_FT     -DUSE_POSTGIS   
> -I/usr/i nclude          -I/usr/local/pgsql/include   
>  shp2img.c -o shp2img.o
> gcc -O2  -Wall -DIGNORE_MISSING_DATA  -DUSE_EPPL    
> -DUSE_TIFF -DUSE_JPEG -DUSE _GD_PNG -DUSE_GD_JPEG
> -DUSE_GD_WBMP -DUSE_GD_FT     -DUSE_POSTGIS   
> -I/usr/incl ude          -I/usr/local/pgsql/include   
>  shp2img.o  -L. -lmap -lgd -L/usr/lib  -lgd -ljpeg
> -lfreetype -lpng -lz    -ltiff -ljpeg -lfreetype -lpng
> -lz    -ljpe g    -L/usr/local/pgsql/lib -lpq      -lm
> -lstdc++  -o shp2img
> 
> 3- Without posgis mapserver is working fine, but with
> postgis it shows our old friend:
> 
> msDrawMap(): Image handling error. Failed to draw
> layer named 'states'.
> prep_DB(): Query error. Error executing POSTGIS
> DECLARE (the actual query) statement: 'DECLARE
> mycursor BINARY CURSOR FOR SELECT
> asbinary(force_collection(force_2d()),'NDR'),OID::text
> from H�� WHERE && setSRID('BOX3D(-97.5
> 37.8194380657143,-82.122902 53.1859599342857)'::BOX3D,
> find_srid('','H��','') )'
> 
> Postgresql reports the error as 'ERROR: relation
> "h��" does not exist '

h�� ???
Check your mapfile (with an ascii reader) and report the
DATA line. It seems mapserver is reading crap from that line,
so you either wrote it or mapserver parser is broken.

--strk;