<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16788" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>hi<BR><BR>the srid of the routing_results table is set to -1,
maybe this is the cause of the problem.<BR>you can try to change the srid of the
table, otherwise drop the table, create it anew and modify the srid when
adding the geometry column reference:<BR>SELECT
AddGeometryColumn('','routing_results','the_geom','4326','MULTILINESTRING',2);</FONT></DIV>
<DIV><FONT size=2><BR>regards<BR>Oliver</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=karolitab@gmail.com href="mailto:karolitab@gmail.com">Karol
Briones</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=cartoweb-users@lists.maptools.org
href="mailto:cartoweb-users@lists.maptools.org">cartoweb-users@lists.maptools.org</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, January 29, 2009 2:26
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [Cartoweb-users] -ERROR:
Operation on two geometries with differentSRIDs</DIV>
<DIV><BR></DIV>Hello List,<BR><BR>I try to use the routing plugin, but I have
a problem with the SRID, I follow all steps to adapt the plugin into my
proyect, in my layers I use srid=4326, and in the tables of the plugin I
change the srid from the database and the layers to srid=4326, exist any file
that I have to change too?.<BR>This is the error:<BR><BR><PRE style="BORDER-RIGHT: 0pt; BORDER-TOP: 0pt; BORDER-LEFT: 0pt; BORDER-BOTTOM: 0pt; FONT-FAMILY: verdana,sans-serif"><B>Class : SoapFaultWrapper<BR>Message : MapServer error: Error in msDrawMap(): Failed to draw layer named 'graph'.<BR><BR>
Error in msPOSTGISLayerWhichShapes(): Error executing POSTGIS SQL statement (in FETCH ALL): DECLARE mycursor BINARY CURSOR FOR SELECT asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text from (SELECT the_geom, gid from routing_results where results_id IN (10)) as foo WHERE the_geom && setSRID('BOX3D(150609.329116945 608504.8625,153344 610417.7625)'::BOX3D, -1 )<BR>
-ERROR: Operation on two geometries with different SRIDs<BR><BR>Backtrace:<BR><BR>file: 226 - C:\ms4w\apps\cartoweb3\coreplugins\images\server\ServerImages.php<BR>call: ServerContext->checkMsErrors()<BR><BR>file: 311 - C:\ms4w\apps\cartoweb3\server\Cartoserver.php<BR>
call: ServerImages->drawMainmap(Object(Images))<BR><BR>file: 349 - C:\ms4w\apps\cartoweb3\server\Cartoserver.php<BR>call: Cartoserver->doGetMap(Object(MapRequest))<BR><BR>file: 370 - C:\ms4w\apps\cartoweb3\server\Cartoserver.php<BR>
call: Cartoserver->callWithExceptionCheck("doGetMap", Object(MapRequest))<BR><BR>file: 76 - C:\ms4w\apps\cartoweb3\server\MapResultCache.php<BR>call: Cartoserver->cacheGetMap(Object(MapRequest))<BR><BR>file: 184 - C:\ms4w\apps\cartoweb3\server\MapResultCache.php<BR>
call: MapResultCache->getMapResultFromServer(Object(MapRequest))<BR><BR>file: 380 - C:\ms4w\apps\cartoweb3\server\Cartoserver.php<BR>call: MapResultCache->getMap(Object(MapRequest))<BR><BR>file: 104 - C:\ms4w\apps\cartoweb3\client\CartoserverService.php<BR>
call: Cartoserver->getMap(Object(MapRequest))<BR><BR>file: 165 - C:\ms4w\apps\cartoweb3\client\CartoserverService.php<BR>call: CartoserverService->callDirect("getMap", Object(MapRequest))<BR><BR>file: 233 - C:\ms4w\apps\cartoweb3\client\CartoserverService.php<BR>
call: CartoserverService->callFunction("getMap", Object(MapRequest))<BR><BR>file: 948 - C:\ms4w\apps\cartoweb3\client\Cartoclient.php<BR>call: CartoserverService->getMap(Object(MapRequest))<BR><BR>file: 1086 - C:\ms4w\apps\cartoweb3\client\Cartoclient.php<BR>
call: Cartoclient->getMapResultFromRequest(Object(MapRequest))<BR><BR>file: 1261 - C:\ms4w\apps\cartoweb3\client\Cartoclient.php<BR>call: Cartoclient->doMain()<BR><BR>file: 38 - C:\ms4w\apps\cartoweb3\htdocs\client.php<BR>
call: Cartoclient->main()<BR></B><BR clear=all></PRE>Thanks for your help
=).<BR>-- <BR>Thanks and Regards<BR>Karol<BR>
<P>
<HR>
<P></P>_______________________________________________<BR>Cartoweb-users
mailing
list<BR>Cartoweb-users@lists.maptools.org<BR>http://lists.maptools.org/mailman/listinfo/cartoweb-users<BR></BLOCKQUOTE></BODY></HTML>