[Cartoweb-users] routing module

guillaume champlong goutosig at yahoo.fr
Mon Jun 25 10:59:24 EDT 2007


OK, I created the table and evrything works fine.
Thanks a lot 
I'll read the doc more carefully next time I have a problem ;-

G.

Oliver Christen <oliver.christen at camptocamp.com> a écrit :     see:
 http://www.cartoweb.org/doc/cw3.3/xhtml/user.install.html#user.install.demo.details.demoRouting.databaseconfiguration
  
 regards
 Oliver
    ----- Original Message ----- 
   From:    guillaume    champlong 
   To: Oliver Christen 
   Sent: Monday, June 25, 2007 3:46 PM
   Subject: RE : Re: [Cartoweb-users]    routing module
   

the routing_results table is generated by the module, I think ;    and actually, I can't find this table in my db... 

Oliver    Christen <oliver.christen at camptocamp.com>    a écrit :             hi
      
     a DB error message is certainly not a valid      id.
      
     ERREUR:  la relation &#65533;routing_results_seq&#65533; n'existe pas
      
     you are missing a sequence named "routing_results_seq" on the table "routing_results"
     I presume it should work if you add one.
      
     regards
     Oliver
      
            -----        Original Message ----- 
       From:        guillaume        champlong 
       To:        carto web 
       Sent:        Monday, June 25, 2007 1:25 PM
       Subject:        Re: [Cartoweb-users] routing module
       


hi,

here's the result after adding the line you said:

 type object
obj
object(DB_Error)#322 (8) {
  ["error_message_prefix"]=>
  string(0) ""
 
 ["mode"]=>
  int(1)
  ["level"]=>
  int(1024)
  ["code"]=>
  int(-1)
  ["message"]=>
  string(23) "DB Error: unknown error"
  ["userinfo"]=>
  string(106) "SELECT NEXTVAL('routing_results_seq') [nativecode=ERREUR:  la relation &#65533;routing_results_seq&#65533; n'existe pas]"
  ["backtrace"]=>
  array(26) {
    [0]=>
    array(6) {
      ["file"]=>
      string(47) "/home/gis2d3d/www/cartoweb3/include/pear/DB.php"
      ["line"]=>
      int(888)
      ["function"]=>
      string(10) "PEAR_Error"
      ["class"]=>
      string(10) "PEAR_Error"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(5) {
        [0]=>
        string(23) "DB Error: unknown
 error"
        [1]=>
        int(-1)
        [2]=>
        int(1)
        [3]=>
        int(1024)
        [4]=>
        string(106) "SELECT
 NEXTVAL('routing_results_seq') [nativecode=ERREUR:  la relation &#65533;routing_results_seq&#65533; n'existe pas]"
      }
    }
    [1]=>
    array(6) {
      ["file"]=>
      string(49) "/home/gis2d3d/www/cartoweb3/include/pear/PEAR.php"
      ["line"]=>
      int(557)
      ["function"]=>
      string(8) "DB_Error"
      ["class"]=>
      string(8) "DB_Error"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(4) {
        [0]=>
        int(-1)
        [1]=>
        int(1)
        [2]=>
        int(1024)
        [3]=>
        string(106) "SELECT NEXTVAL('routing_results_seq') [nativecode=ERREUR:  la relation &#65533;routing_results_seq&#65533; n'existe pas]"
      }
   
 }
    [2]=>
    array(6) {
      ["file"]=>
      string(54) "/home/gis2d3d/www/cartoweb3/include/pear/DB/common.php"
      ["line"]=>
     
 int(1834)
      ["function"]=>
      string(10) "raiseError"
      ["class"]=>
      string(4) "PEAR"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(7) {
        [0]=>
        object(DB_Error)#321 (8) {
          ["error_message_prefix"]=>
          string(0) ""
          ["mode"]=>
          int(1)
          ["level"]=>
          int(1024)
          ["code"]=>
          int(-1)
          ["message"]=>
          string(23) "DB Error: unknown error"
          ["userinfo"]=>
          string(106) "SELECT NEXTVAL('routing_results_seq') [nativecode=ERREUR:  la relation &#65533;routing_results_seq&#65533; n'existe pas]"
          ["backtrace"]=>
          array(29) {
           
 [0]=>
            array(6) {
              ["file"]=>
              string(47) "/home/gis2d3d/www/cartoweb3/include/pear/DB.php"
             
 ["line"]=>
              int(888)
              ["function"]=>
              string(10) "PEAR_Error"
              ["class"]=>
              string(10) "PEAR_Error"
              ["type"]=>
              string(2) "->"
              ["args"]=>
              array(5) {
                [0]=>
                string(23) "DB Error: unknown error"
                [1]=>
                int(-1)
                [2]=>
                int(1)
                [3]=>
                NULL
                [4]=>
                string(106) "SELECT NEXTVAL('routing_results_seq') [nativecode=ERREUR:  la relation &#65533;routing_results_seq&#65533; n'existe pas]"
              }
            }
            [1]=>
            array(6)
 {
              ["file"]=>
              string(49) "/home/gis2d3d/www/cartoweb3/include/pear/PEAR.php"
              ["line"]=>
           
   int(557)
              ["function"]=>
              string(8) "DB_Error"
              ["class"]=>
              string(8) "DB_Error"
              ["type"]=>
              string(2) "->"
              ["args"]=>
              array(4) {
                [0]=>
                int(-1)
                [1]=>
                int(1)
                [2]=>
                NULL
                [3]=>
                string(106) "SELECT NEXTVAL('routing_results_seq') [nativecode=ERREUR:  la relation &#65533;routing_results_seq&#65533; n'existe pas]"
              }
            }

apparently, there is no sequence on the routing_results table, whereas there should, is that it?
so what to do?

thanks
G.

Oliver        Christen <oliver.christen at camptocamp.com> a écrit :                                    Hi
          
         SELECT Object id #336 doesnt look like correct          sql.
         I would say some error occured when the sql was          generated.
         the $resultsId variable doesnt seem to be replaced          correctly.
          
         try to add:
         x($resultsId);
         at the beginning of the the getNodes function in          ServerDemoRouting.php
         this will display the content of the variable and stop          further execution of the program.
          
         Let me know whats the result
          
         regards
         Oliver
                    -----            Original Message ----- 
           From:            guillaume            champlong 
           To:            carto web 
           Sent:            Sunday, June 24, 2007 7:18 PM
           Subject:            [Cartoweb-users] routing module
           

hi,

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:


class:   SoapFaultWrapper
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&#65533;s de &#65533;id&#65533; at character 43]
Backtrace:

file: 69 - /www/cartoweb3/projects/carene/plugins/demoRouting/server/ServerDemoRouting.php
call: Utils::checkDbError(Object(DB_Error), "Error quering routing database")
here's            the mapfile layer:
LAYER
                   NAME "graph"
        TYPE            LINE
        STATUS            ON
        CONNECTIONTYPE            postgis
        CONNECTION            "user=my_user password=my_passwd host=localhost            dbname=my_db"
        DATA "the_geom            from routing_results"
                   TEMPLATE "ttt"
END
 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.

can you tell            me where this problem comes from?

thanks            
           
---------------------------------
           Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers            Yahoo! Mail            
           
---------------------------------
            
_______________________________________________
Cartoweb-users            mailing            list
Cartoweb-users at lists.maptools.org
http://lists.maptools.org/mailman/listinfo/cartoweb-users

       
       
---------------------------------
       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 Yahoo!        Questions/Réponses.        
       
---------------------------------
        
_______________________________________________
Cartoweb-users        mailing        list
Cartoweb-users at lists.maptools.org
http://lists.maptools.org/mailman/listinfo/cartoweb-users

      

---------------------------------
   Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo!    Mail 

 		
---------------------------------
 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 Yahoo! Questions/Réponses.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/cartoweb-users/attachments/20070625/2cd6314a/attachment-0001.html


More information about the Cartoweb-users mailing list