<!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.5730.11" name=GENERATOR></HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>hi</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>a DB error message is certainly not a valid id.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV>ERREUR: la relation �routing_results_seq� n'existe pas</DIV>
<DIV> </DIV>
<DIV><FONT size=2>you are missing a sequence named "</FONT><FONT
size=3>routing_results_seq" on the table "routing_results"</FONT></DIV>
<DIV><FONT size=2>I presume it should work if you add one.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>regards</FONT></DIV>
<DIV><FONT size=2>Oliver</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=goutosig@yahoo.fr href="mailto:goutosig@yahoo.fr">guillaume
champlong</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=cartoweb-users@lists.maptools.org
href="mailto:cartoweb-users@lists.maptools.org">carto web</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, June 25, 2007 1:25 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Cartoweb-users] routing
module</DIV>
<DIV><BR></DIV><PRE>hi,<BR><BR>here's the result after adding the line you said:<BR><BR> type object<BR>obj<BR>object(DB_Error)#322 (8) {<BR> ["error_message_prefix"]=><BR> string(0) ""<BR> ["mode"]=><BR> int(1)<BR> ["level"]=><BR> int(1024)<BR> ["code"]=><BR> int(-1)<BR> ["message"]=><BR> string(23) "DB Error: unknown error"<BR> ["userinfo"]=><BR> string(106) "SELECT NEXTVAL('routing_results_seq') [nativecode=ERREUR: la relation �routing_results_seq� n'existe pas]"<BR> ["backtrace"]=><BR> array(26) {<BR> [0]=><BR> array(6) {<BR> ["file"]=><BR> string(47) "/home/gis2d3d/www/cartoweb3/include/pear/DB.php"<BR> ["line"]=><BR> int(888)<BR> ["function"]=><BR> string(10) "PEAR_Error"<BR> ["class"]=><BR> string(10) "PEAR_Error"<BR> ["type"]=><BR> string(2) "->"<BR> ["args"]=><BR> array(5) {<BR> [0]=><BR> string(23) "DB Error: unknown
error"<BR> [1]=><BR> int(-1)<BR> [2]=><BR> int(1)<BR> [3]=><BR> int(1024)<BR> [4]=><BR> string(106) "SELECT NEXTVAL('routing_results_seq') [nativecode=ERREUR: la relation �routing_results_seq� n'existe pas]"<BR> }<BR> }<BR> [1]=><BR> array(6) {<BR> ["file"]=><BR> string(49) "/home/gis2d3d/www/cartoweb3/include/pear/PEAR.php"<BR> ["line"]=><BR> int(557)<BR> ["function"]=><BR> string(8) "DB_Error"<BR> ["class"]=><BR> string(8) "DB_Error"<BR> ["type"]=><BR> string(2) "->"<BR> ["args"]=><BR> array(4) {<BR> [0]=><BR> int(-1)<BR> [1]=><BR> int(1)<BR> [2]=><BR> int(1024)<BR> [3]=><BR> string(106) "SELECT NEXTVAL('routing_results_seq') [nativecode=ERREUR: la relation �routing_results_seq� n'existe pas]"<BR> }<BR>
}<BR> [2]=><BR> array(6) {<BR> ["file"]=><BR> string(54) "/home/gis2d3d/www/cartoweb3/include/pear/DB/common.php"<BR> ["line"]=><BR> int(1834)<BR> ["function"]=><BR> string(10) "raiseError"<BR> ["class"]=><BR> string(4) "PEAR"<BR> ["type"]=><BR> string(2) "->"<BR> ["args"]=><BR> array(7) {<BR> [0]=><BR> object(DB_Error)#321 (8) {<BR> ["error_message_prefix"]=><BR> string(0) ""<BR> ["mode"]=><BR> int(1)<BR> ["level"]=><BR> int(1024)<BR> ["code"]=><BR> int(-1)<BR> ["message"]=><BR> string(23) "DB Error: unknown error"<BR> ["userinfo"]=><BR> string(106) "SELECT NEXTVAL('routing_results_seq') [nativecode=ERREUR: la relation �routing_results_seq� n'existe pas]"<BR> ["backtrace"]=><BR> array(29) {<BR>
[0]=><BR> array(6) {<BR> ["file"]=><BR> string(47) "/home/gis2d3d/www/cartoweb3/include/pear/DB.php"<BR> ["line"]=><BR> int(888)<BR> ["function"]=><BR> string(10) "PEAR_Error"<BR> ["class"]=><BR> string(10) "PEAR_Error"<BR> ["type"]=><BR> string(2) "->"<BR> ["args"]=><BR> array(5) {<BR> [0]=><BR> string(23) "DB Error: unknown error"<BR> [1]=><BR> int(-1)<BR> [2]=><BR> int(1)<BR> [3]=><BR> NULL<BR> [4]=><BR> string(106) "SELECT NEXTVAL('routing_results_seq') [nativecode=ERREUR: la relation �routing_results_seq� n'existe pas]"<BR> }<BR> }<BR> [1]=><BR> array(6)
{<BR> ["file"]=><BR> string(49) "/home/gis2d3d/www/cartoweb3/include/pear/PEAR.php"<BR> ["line"]=><BR> int(557)<BR> ["function"]=><BR> string(8) "DB_Error"<BR> ["class"]=><BR> string(8) "DB_Error"<BR> ["type"]=><BR> string(2) "->"<BR> ["args"]=><BR> array(4) {<BR> [0]=><BR> int(-1)<BR> [1]=><BR> int(1)<BR> [2]=><BR> NULL<BR> [3]=><BR> string(106) "SELECT NEXTVAL('routing_results_seq') [nativecode=ERREUR: la relation �routing_results_seq� n'existe pas]"<BR> }<BR> }<BR><BR>apparently, there is no sequence on the routing_results table, whereas there should, is that it?<BR>so what to do?<BR><BR>thanks<BR>G.<BR></PRE><B><I>Oliver
Christen <oliver.christen@camptocamp.com></I></B> a écrit :
<BLOCKQUOTE class=replbq
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: rgb(16,16,255) 2px solid">
<META content="MSHTML 6.00.5730.11" name=GENERATOR>
<STYLE></STYLE>
<DIV><FONT size=2>Hi</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>SELECT Object id #336 doesnt look like correct
sql.</FONT></DIV>
<DIV><FONT size=2>I would say some error occured when the sql was
generated.</FONT></DIV>
<DIV><FONT size=2>the $resultsId variable doesnt seem to be replaced
correctly.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>try to add:</FONT></DIV>
<DIV><FONT size=2>x($resultsId);</FONT></DIV>
<DIV><FONT size=2>at the beginning of the the getNodes function in
ServerDemoRouting.php</FONT></DIV>
<DIV><FONT size=2>this will display the content of the variable and stop
further execution of the program.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Let me know whats the result</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>regards</FONT></DIV>
<DIV><FONT size=2>Oliver</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: rgb(0,0,0) 2px solid; MARGIN-RIGHT: 0px">
<DIV
style="FONT: 10pt arial; font-size-adjust: none; font-stretch: normal">-----
Original Message ----- </DIV>
<DIV
style="BACKGROUND: rgb(228,228,228) 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"><B>From:</B>
<A title=goutosig@yahoo.fr href="mailto:goutosig@yahoo.fr">guillaume
champlong</A> </DIV>
<DIV
style="FONT: 10pt arial; font-size-adjust: none; font-stretch: normal"><B>To:</B>
<A title=cartoweb-users@lists.maptools.org
href="mailto:cartoweb-users@lists.maptools.org">carto web</A> </DIV>
<DIV
style="FONT: 10pt arial; font-size-adjust: none; font-stretch: normal"><B>Sent:</B>
Sunday, June 24, 2007 7:18 PM</DIV>
<DIV
style="FONT: 10pt arial; font-size-adjust: none; font-stretch: normal"><B>Subject:</B>
[Cartoweb-users] routing module</DIV>
<DIV><BR></DIV>hi,<BR><BR>I have a problem with my routing module;
everything works on pgsql (functions, etc) but when I launch a research in
my cartoclient, I have this error:<BR><BR><PRE>class: SoapFaultWrapper<BR>message: Error quering routing database Message: DB Error: unknown error Userinfo: INSERT INTO routing_results SELECT Object id #336, 1182704023, gid, the_geom FROM route500_44 WHERE edge_id = 533 [nativecode=ERREUR: erreur de syntaxe sur ou pr�s de �id� at character 43]<BR>Backtrace:<BR><BR>file: 69 - /www/cartoweb3/projects/carene/plugins/demoRouting/server/ServerDemoRouting.php<BR>call: Utils::checkDbError(Object(DB_Error), "Error quering routing database")</PRE>here's
the mapfile layer:<BR>LAYER<BR> NAME
"graph"<BR> TYPE
LINE<BR> STATUS
ON<BR> CONNECTIONTYPE
postgis<BR> CONNECTION "user=my_user
password=my_passwd host=localhost dbname=my_db"<BR>
DATA "the_geom from
routing_results"<BR> TEMPLATE
"ttt"<BR>END<BR> I specified the name of the column containing
the name of the towns in the routing.ini (client side), as well as the
name of the vertices table.<BR><BR>can you tell me where this problem
comes from?<BR><BR>thanks
<DIV></DIV>
<HR SIZE=1>
Ne gardez plus qu'une seule adresse mail ! <A
href="http://www.trueswitch.com/yahoo-fr/">Copiez vos mails</A> vers
Yahoo! Mail
<DIV></DIV>
<HR>
<DIV></DIV>_______________________________________________<BR>Cartoweb-users
mailing
list<BR>Cartoweb-users@lists.maptools.org<BR>http://lists.maptools.org/mailman/listinfo/cartoweb-users<BR></BLOCKQUOTE></BLOCKQUOTE><BR>
<P>
<HR SIZE=1>
Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions !
Profitez des connaissances, des opinions et des expériences des internautes
sur <A
href="http://fr.rd.yahoo.com/evt=42054/*http://fr.answers.yahoo.com">Yahoo!
Questions/Réponses</A>.
<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>