OK, I created the table and evrything works fine.<br>Thanks a lot <br>I'll read the doc more carefully next time I have a problem ;-<br><br>G.<br><br><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"> <div><font size="2">see:</font></div> <div><font size="2"><a href="http://www.cartoweb.org/doc/cw3.3/xhtml/user.install.html#user.install.demo.details.demoRouting.databaseconfiguration">http://www.cartoweb.org/doc/cw3.3/xhtml/user.install.html#user.install.demo.details.demoRouting.databaseconfiguration</a></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% 50%; -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="oliver.christen@camptocamp.com"
href="mailto:oliver.christen@camptocamp.com">Oliver Christen</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> Monday, June 25, 2007 3:46 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> RE : Re: [Cartoweb-users] routing module</div> <div><br></div>the routing_results table is generated by the module, I think ; and actually, I can't find this table in my db... <br><br><b><i>Oliver Christen <<a href="mailto:oliver.christen@camptocamp.com">oliver.christen@camptocamp.com</a>></i></b> a écrit : <blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); padding-left: 5px; margin-left: 5px;"> <meta content="MSHTML
6.00.5730.11" name="GENERATOR"> <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="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% 50%; 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; -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-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> Monday, June 25, 2007 1:25 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> 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> <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<br> error"<br> [1]=><br> int(-1)<br> [2]=><br> int(1)<br> [3]=><br> int(1024)<br> [4]=><br> string(106) "SELECT<br> 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> }<br> [2]=><br> array(6) {<br> ["file"]=><br> string(54) "/home/gis2d3d/www/cartoweb3/include/pear/DB/common.php"<br> ["line"]=><br> <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> <br> [0]=><br> array(6) {<br> ["file"]=><br> string(47) "/home/gis2d3d/www/cartoweb3/include/pear/DB.php"<br> <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> {<br> ["file"]=><br> string(49) "/home/gis2d3d/www/cartoweb3/include/pear/PEAR.php"<br> ["line"]=><br> <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); padding-left: 5px; margin-left: 5px;"> <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% 50%; 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; -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-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> <div></div> <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>. <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> <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 </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>.