<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="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <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="border-left: 2px solid rgb(0, 0, 0); padding-right: 0px; padding-left: 5px; margin-left: 5px; margin-right: 0px;"> <div style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;">----- Original Message ----- </div> <div style="background: rgb(228, 228, 228) none repeat scroll 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"><b>From:</b> <a
title="goutosig@yahoo.fr" href="mailto:goutosig@yahoo.fr">guillaume champlong</a> </div> <div style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; 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-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"><b>Sent:</b> Sunday, June 24, 2007 7:18 PM</div> <div style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; 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>.