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
Cartoweb-users@lists.maptools.org
http://lists.maptools.org/mailman/listinfo/cartoweb-users
