[Cartoweb-users] Re: [Cartoweb-dev] New bug ?

[Oliver Christen]

Hi

which version of mapserver do you have ?


  ----- Original Message ----- 
  From: tamax 
  To: Oliver Christen 
  Sent: Tuesday, September 09, 2008 4:46 PM
  Subject: Re: [Cartoweb-dev] New bug ?


  HI ! 

  Here the logs : 

  It is not take a $queryString properly, as you can see :  WHERE (gid IN ) 

  Maybe, it is a mapscript problem... 

  Thanks for all.  

   

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 (gid IN ) 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")
 
Calling Location.Recenter onBeforeAjaxCall()
Calling AjaxPlugins.Common.onBeforeAjaxCall()
Initiating AJAX request
Pending actions: 1
GET params:
ajaxActionRequest=Location.Recenter&
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&
Waiting for response...
Response received!
Error: AjaxHandler.actionRequest(): received response is malformed!
Calling AjaxPlugins.Common.onAfterAjaxCall()
Clearing DHTML drawings...
Clearing stored features...
--- Action Location.Recenter complete --- 
 

   

  On Mon, 8 Sep 2008 10:23:31 +0200, "Oliver Christen" wrote: 

     
    Hi 
    could you show me the complet error message stack please ? 
      ----- Original Message ----- 
      From: tamax 
      To: cartoweb-dev at lists.maptools.org 
      Sent: Thursday, September 04, 2008 9:12 PM 
      Subject: [Cartoweb-dev] New bug ? 


      Hi to everyone ! 

      First I would like to give you my congratulations for this great work, It is very useful to a lot of people like me. 

      I was working with search plugin using data base postgres/postgis for raster information. The search work great 

      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 

      Line (89), at databaseQueryString function: return array("$idAttribute IN ($queryString)"); 

      I dont know if is mapserver/mapscript bug or cartoweb's one. 

      If I replace that line with this one, works fine : return array("$idAttribute=$queryString"); 

      I am using : php5-mapscript 4.10.0-5.1+etc 

      Cartoweb : 3.40 

      SOrry, if is not a correct place to post 

      Thanks ! 

       

       


--------------------------------------------------------------------------

       

      _______________________________________________
      Cartoweb-dev mailing list
      Cartoweb-dev at lists.maptools.org
      http://lists.maptools.org/mailman/listinfo/cartoweb-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/cartoweb-users/attachments/20080910/a2d2f234/attachment.html