[Mapserver-users] msPOSTGISLayerWhichShapes() error

[Bill Wheaton]

Hello folks--

I have a problem that I think is related to mapserver versions, but I'd  
like to know for sure or see if anyone thinks it might be something  
else.

I'm developing on MS 3.6.4 (w/ PHP/Mapscript) and postgreSQL 0.7.3 on  
Macos X .  I moved my site to an ISP (pghoster) which is running MS  
3.6.3.  I know that I shouldn't assume that anything is backwards  
compatible, but...

My code works fine on my development system, but I get this error on  
pghoster (the ISP):

Warning :  MapServer Error in msPOSTGISLayerWhichShapes():  
prep_DB:Error executing POSTGIS  DECLARE statement (0.6 failed -  
retried 0.5 and it failed too).  DECLARE mycursor BINARY CURSOR FOR  
SELECT  
ship_name::text,asbinary(force_collection(force_2d(the_ln_geom)),'NDR'), 
OID::text from ship_voy using UNIQUE oid WHERE (voyage_id > 0) and  
(the_ln_geom && setSRID( 'BOX3D(-180 -90,180 90)'::BOX3D,4008) )  in  
/home/virtual/site170/fst/var/www/html/mapping.gis on line 728

My map file looks like this:
LAYER
     CONNECTIONTYPE postgis
     NAME "voyages"
     CONNECTION "user=xxxx password=xxxx dbname=xxxx host=xxxx"
     DATA "the_ln_geom from ship_voy USING UNIQUE oid USING SRID=4008"
     STATUS OFF
     TEMPLATE ""
     TYPE LINE
     LABELITEM "ship_name"
etc...

And my PHP/Mapscript code looks like this:
     $sql_map= ("voyage_id > 0");
     $selected_layer = $map->getlayerbyname(voyages);
     $selected_layer->setFilter("($sql_map)");
     $selected_layer->set(status, MS_ON);

Also, I had some trouble moving the database to the ISP and handling  
the geometry columns, etc., but I think that I finally worked that  
out-- but maybe not?

Before I ask the ISP about upgrading their version of MS to 3.6.4 (or  
greater?), I just wanted to try to confirm that that was the problem.   
Could it be something else??

Any information is greatly appreciated.

Bill.