[Cartoweb-users] RE: mapquery issue

[zze-SIGALE PORTANERI F ext RD-BIZZ-SOP]

To continue on this thread, is there any limitation in cartoweb/mapscript to perform $mslayer->getShape() operations on postgis tables with INT4 index values?

I tried to query an element with its idcapt set to 2147483647 with success, while 2147483648 (i.e. 2^32)   fails!!!!!

Any tips would be appreciate here...

Franck

> _____________________________________________ 
> De : 	zze-SIGALE PORTANERI F ext RD-BIZZ-SOP  
> Envoyé :	jeudi 22 mars 2007 18:44
> À :	'cartoweb-users at lists.maptools.org'
> Cc :	'Sylvain Pasche'
> Objet :	RE: mapquery issue
> 
> Just to add some new stuff here:
> 
> The mapfile layer definition defines :
> 
>     METADATA
>        "id_attribute_string" "idcapt|string"
>     END
> 
> The Postgresql table is defined as follow:
> 
> CREATE TABLE capteurs
> (
>   idcapt varchar NOT NULL,
>   geom geometry,
>   "type" varchar,
>   CONSTRAINT capteurs_pkey PRIMARY KEY (idcapt),
>   CONSTRAINT "SRID_GEOM_RULE" CHECK (srid(geom) = -1),
>   CONSTRAINT "TYPE_GEOM_RULE" CHECK (geometrytype(geom) = 'POINT'::text OR geom IS NULL)
> ) 
> WITH OIDS;
> 
> I notice that for capteurs element where the field "idcapt" is a numeric value ('1', '400'> ...> ) , everything is OK
> BUT if some alphanumeric apears in that field ('3F', 'F40'..), the mapquery getShapes() query fails as described> ...> 
> 
> Any reason?
> 
> Franck 
> 
> _____________________________________________ 
> De : 	zze-SIGALE PORTANERI F ext RD-BIZZ-SOP  
> Envoyé :	jeudi 22 mars 2007 17:12
> À :	'cartoweb-users at lists.maptools.org'
> Cc :	'Sylvain Pasche'
> Objet :	mapquery issue
> 
> 
> Hi,
> 
> I have a mapquery plugin issue: While doing a queryByBbox() request on a area where one element must be found, the cartoclient display the following error: 
> 
> class CartocommonException { protected $message = 'Error [8, Trying to get property of non-object, /exec/applis/sglpgo/G01R00C02/cartoweb3/coreplugins/query/server/ServerQuery.php, 122] Backtrace: file: 200 - /exec/applis/sglpgo/G01R00C02/cartoweb3/common/Common.php call: Common::cartowebErrorHandler() file: 122 - /exec/applis/sglpgo/G01R00C02/cartoweb3/coreplugins/query/server/ServerQuery.php call: Common::cartowebErrorHandler() file: 122 - /exec/applis/sglpgo/G01R00C02/cartoweb3/coreplugins/query/server/ServerQuery.php call: ServerQuery::resultToTable() file: 227 -
> ...
> 
> Adding traces to the log and trying to analyse it, it looks like the serveurMapquery plugin found one element and the extractResults  $msLayer->getResult($i) return an object as follow:
> 
> Thu Mar 22 16:25:22 2007,703 [30941] DEBUG ServerMapquery - class stdClass {
>   public $shapeindex = 1841530366;
>   public $tileindex = -1;
>   public $classindex = 6;
> }
> 
> Which is return a shape to the ServerQuery plugin as follow:
> 
> Thu Mar 22 16:25:22 2007,704 [30941] DEBUG ServerQuery - resultshape=
> Thu Mar 22 16:25:22 2007,705 [30941] DEBUG ServerQuery - array (
>   0 => false,
> )
> 
> Any clue?
> 
> 
> Thanks in advance,
> Franck
> 
> 
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/cartoweb-users/attachments/20070323/9d2b67c6/attachment.html