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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> a écrit : hi
a DB error message is certainly not a valid id.
ERREUR: la relation �routing_results_seq� 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 �routing_results_seq� 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
�routing_results_seq� 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 �routing_results_seq� 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 �routing_results_seq� 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 �routing_results_seq� 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 �routing_results_seq� 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 <[EMAIL PROTECTED]> 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�s de �id� 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
[email protected]
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
[email protected]
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._______________________________________________
Cartoweb-users mailing list
[email protected]
http://lists.maptools.org/mailman/listinfo/cartoweb-users
