[Cartoweb-users] calling id_recenter from search plugin

[Dirk Jesko]

Hi,

sounds like the same problem I had. If it is the same, it is a bug in 
mapserver version 4.10 and possibly some 4.8. Have a look at the 
attached ServerMapquery.php. I added some quotes in line 179 which 
solved the problem. Try changing your 
coreplugins\mapquery\server\ServerMapquery.php.


Regards,
Dirk



WochteR wrote:
> Hi,
> I have troubles with recentering an object.
> Plugin search works fine, but when I clicked on result I obtain this issue:
>
> Failure
>
> Class : SoapFaultWrapper
> Message : MapServer error: Error in msDrawMap(): Failed to draw layer named 'zastavba'.
>
> Error in prepare_database(): Error executing POSTGIS DECLARE (the actual query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT vyznamnost::text,gid::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text from kzarovce_zastavba WHERE (gid = 'gid IN (620)') and (the_geom && setSRID( 'BOX3D(-469330.214285714 -1273120,-464958.785714286 -1270060)'::BOX3D,find_srid('','kzarovce_zastavba','the_geom') ))' 
>
> Postgresql reports the error as 'ERROR:  invalid input syntax for integer: "gid IN (620)"
> '
>
> 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.
> --------------------------
>
> It is very mysterious, because on my laptop it works good.
> This issue is displayed from server where I moved working cartoweb project.
> Need I change anything in php.ini or something else?
> I don't know what to do...
>
> Thanx for advice
>
> wochter
> _______________________________________________
> Cartoweb-users mailing list
> Cartoweb-users at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/cartoweb-users
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/cartoweb-users/attachments/20070510/ded68820/ServerMapquery-0001.html