<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
<META content="MSHTML 6.00.6000.16705" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>Hi</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>which version of mapserver do you have ?</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2></FONT> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=tamax@geoaim.es href="mailto:tamax@geoaim.es">tamax</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=oliver.christen@camptocamp.com
href="mailto:oliver.christen@camptocamp.com">Oliver Christen</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, September 09, 2008 4:46
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Cartoweb-dev] New bug
?</DIV>
<DIV><BR></DIV>
<P>HI ! </P>
<P>Here the logs : </P>
<P>It is not take a $queryString properly, as you can see : <FONT
color=#ff0000>WHERE (gid IN )</FONT> </P>
<P>Maybe, it is a mapscript problem... </P>
<P>Thanks for all. </P>
<P> </P><PRE style="BACKGROUND-COLOR: #c0c0c0">CartoWeb version: 3.4.0 [$Revision: 1.7 $]
class: SoapFaultWrapper
message: MapServer error: Error in msDrawMap(): Failed to draw layer named 'nucleo_relleno1'.
Error in prepare_database(): Error executing POSTGIS DECLARE (the actual query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT "gid"::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text from nucleos as foo WHERE (<FONT color=#ff0000>gid IN </FONT>) and (the_geom && setSRID( 'BOX3D(465851.078571429 4413198.574,592083.181428571 4501561.046)'::BOX3D,-1) )'
Postgresql reports the error as 'ERROR: syntax error at or near ")" at character 152
'
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.net/documentation/
Mappostgis.c - version of Jan 23/2004.
Backtrace:
file: 226 - /var/www/www/cartoweb/coreplugins/images/server/ServerImages.php
call: ServerContext->checkMsErrors()
file: 311 - /var/www/www/cartoweb/server/Cartoserver.php
call: ServerImages->drawMainmap(Object(Images))
file: 349 - /var/www/www/cartoweb/server/Cartoserver.php
call: Cartoserver->doGetMap(Object(MapRequest))
file: 370 - /var/www/www/cartoweb/server/Cartoserver.php
call: Cartoserver->callWithExceptionCheck("doGetMap", Object(MapRequest))
file: 76 - /var/www/www/cartoweb/server/MapResultCache.php
call: Cartoserver->cacheGetMap(Object(MapRequest))
file: 178 - /var/www/www/cartoweb/server/MapResultCache.php
call: MapResultCache->getMapResultFromServer(Object(MapRequest))
file: 380 - /var/www/www/cartoweb/server/Cartoserver.php
call: MapResultCache->getMap(Object(MapRequest))
file: 104 - /var/www/www/cartoweb/client/CartoserverService.php
call: Cartoserver->getMap(Object(MapRequest))
file: 165 - /var/www/www/cartoweb/client/CartoserverService.php
call: CartoserverService->callDirect("getMap", Object(MapRequest))
file: 233 - /var/www/www/cartoweb/client/CartoserverService.php
call: CartoserverService->callFunction("getMap", Object(MapRequest))
file: 948 - /var/www/www/cartoweb/client/Cartoclient.php
call: CartoserverService->getMap(Object(MapRequest))
file: 1086 - /var/www/www/cartoweb/client/Cartoclient.php
call: Cartoclient->getMapResultFromRequest(Object(MapRequest))
file: 1261 - /var/www/www/cartoweb/client/Cartoclient.php
call: Cartoclient->doMain()
file: 38 - /var/www/www/cartoweb/htdocs/client.php
call: Cartoclient->main()
file: 3 - /var/www/www/cartoweb/htdocs/alcarria.php
call: require_once("/var/www/www/cartoweb/htdocs/client.php")
</PRE><PRE style="BACKGROUND-COLOR: #c0c0c0">
</PRE><PRE style="BACKGROUND-COLOR: #c0c0c0"><FONT size=medium><STRONG>Calling Location.Recenter onBeforeAjaxCall()</STRONG></FONT>
<FONT size=medium><STRONG>Calling AjaxPlugins.Common.onBeforeAjaxCall()</STRONG></FONT>
<FONT color=#000000>Initiating AJAX request
</FONT><FONT color=#000000>Pending actions: 1
</FONT><FONT color=#000000>GET params:
ajaxActionRequest=Location.Recenter&
</FONT><FONT color=#000000>POST params:
search_nombre=&search_config=nucleo_relleno1&search_sort_column=nombre&search_sort_direction=asc&search_number=&posted=1&js_folder_idx=1&selection_type=&selection_coords=&features=&id_recenter_layer=nucleo_relleno1&id_recenter_ids=22&shortcut_doit=0&openNodes=&layers[]=alc_landsat&pdfOrientation=portrait&pdfTitle=&pdfNote=&pdfLegend=0&tool=zoomin&shortcut_id=-1&pdfFormat=A4&pdfResolution=96&
</FONT><FONT color=#000000>Waiting for response...
</FONT><FONT color=#000000>Response received!</FONT>
<FONT color=red>Error: AjaxHandler.actionRequest(): received response is malformed!</FONT>
<FONT size=medium><STRONG>Calling AjaxPlugins.Common.onAfterAjaxCall()</STRONG></FONT>
<FONT color=gray>Clearing DHTML drawings...</FONT>
<FONT color=gray>Clearing stored features...</FONT>
<FONT size=medium><STRONG>--- Action Location.Recenter complete ---</STRONG></FONT>
</PRE>
<P> </P>
<P> </P>
<P>On Mon, 8 Sep 2008 10:23:31 +0200, "Oliver Christen" wrote: </P>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid; WIDTH: 100%">
<DIV><FONT size=2>Hi</FONT> </DIV>
<DIV><FONT size=2>could you show me the complet error message stack please
?</FONT> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV
style="FONT: 10pt arial; font-size-adjust: none; font-stretch: normal">-----
Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4 0% 50%; FONT: 10pt arial; font-size-adjust: none; font-stretch: normal; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial"><STRONG>From:</STRONG>
<A title=tamax@geoaim.es href="mailto:tamax@geoaim.es">tamax</A> </DIV>
<DIV
style="FONT: 10pt arial; font-size-adjust: none; font-stretch: normal"><STRONG>To:</STRONG>
<A title=cartoweb-dev@lists.maptools.org
href="mailto:cartoweb-dev@lists.maptools.org">cartoweb-dev@lists.maptools.org</A>
</DIV>
<DIV
style="FONT: 10pt arial; font-size-adjust: none; font-stretch: normal"><STRONG>Sent:</STRONG>
Thursday, September 04, 2008 9:12 PM </DIV>
<DIV
style="FONT: 10pt arial; font-size-adjust: none; font-stretch: normal"><STRONG>Subject:</STRONG>
[Cartoweb-dev] New bug ? </DIV>
<DIV><BR></DIV>
<P>Hi to everyone ! </P>
<P>First I would like to give you my congratulations for this great work,
It is very useful to a lot of people like me. </P>
<P>I was working with search plugin using data base postgres/postgis for
raster information. The search work great </P>
<P>but When I clicked on the result it wasnt working fine. I release that
the problem was in this file :
coreplugins/mapquery/server/ServerMapquery.php </P>
<P><FONT color=#ff0000>Line (89), at databaseQueryString function: return
array("$idAttribute IN ($queryString)");</FONT> </P>
<P>I dont know if is mapserver/mapscript bug or cartoweb's one. </P>
<P>If I replace that line with this one, works fine : return
array("$idAttribute=$queryString"); </P>
<P>I am using : php5-mapscript 4.10.0-5.1+etc </P>
<P>Cartoweb : 3.40 </P>
<P>SOrry, if is not a correct place to post </P>
<P>Thanks ! </P>
<P> </P>
<P> </P>
<HR>
<P> </P>_______________________________________________<BR>Cartoweb-dev
mailing
list<BR>Cartoweb-dev@lists.maptools.org<BR>http://lists.maptools.org/mailman/listinfo/cartoweb-dev<BR></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>