<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE></TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1528" name=GENERATOR></HEAD>
<BODY text=#000000 bgColor=#ffffff>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff
size=2></FONT> </DIV>
<DIV><SPAN class=060371915-21022006></SPAN><FONT face=Arial><FONT
color=#0000ff><FONT size=2>Oups, the txt colums that appears in my previous
mail was manually added for tests...<SPAN class=060371915-21022006>
:-(</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=060371915-21022006><FONT face=Arial color=#0000ff size=2>read
this: </FONT></SPAN></DIV>
<DIV><SPAN class=060371915-21022006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=060371915-21022006></SPAN><FONT face=Arial><FONT
color=#0000ff><FONT size=2><FONT face="Courier New" color=#000000>demo_plugins=#
\d
roads_europe_vertices;<BR>
Table "public.roads_europe_vertices"<BR> Column
|
Type
|
Modifiers
<BR>---------+-------------------+-----------------------------------------------------------------------<BR> id
| integer | not null
default nextval('public.roads_europe_vertices_id_seq'::text)<BR> geom_id |
integer | not
null<BR>Indexes:<BR> "roads_europe_vertices_geom_id_key"
UNIQUE, btree (geom_id)<BR> "roads_europe_vertices_id_idx"
btree (id)</FONT><BR></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2> </DIV><SPAN
class=060371915-21022006></SPAN></FONT></FONT></FONT>
<DIV><FONT face=Tahoma size=2><B>Envoyé :</B> mardi 21 février 2006
16:10<BR><B>À :</B>
cartoweb-users@lists.maptools.org<BR><B>Objet :</B> issues with the
demoPlugins installation<BR></FONT><BR></DIV>
<DIV></DIV>Hi all,<BR><BR>I tried to follow the installation notes for the
demoPlugin add-on :<BR><BR>First I think it may have few typo in the manual
section "1.2.4.2.2. Graph Importation", first step:<BR>
<BLOCKQUOTE>You wrote: <BR><PRE class=screen>$ CREATE TABLE roads_europe (gid int UNIQUE, source_id int, target_id int);
$ SELECT AddGeometryColumn('roads_europe', 'the_geom', -1, 'MULTILINESTRING', 2 );
$ INSERT INTO roads_europe (gid, the_geom) (SELECT gid, the_geom FROM roads_europe);</PRE><BR>To
avoid some errors during the nexts steps, I had to launch:<BR><PRE class=screen>$ CREATE TABLE roads_europe (gid int UNIQUE, source_id int, target_id int);
$ SELECT AddGeometryColumn('roads_europe', 'the_geom', -1, 'MULTILINESTRING', 2 );
$ INSERT INTO roads_europe (gid, the_geom) (SELECT gid, the_geom FROM roads_europe<FONT color=#ff0000><B>_tmp</B></FONT>); <<
<B><FONT color=#ff0000>$ ALTER TABLE roads_europe ADD COLUMN edge_id int; <FONT color=#000000><<</FONT></FONT></B>
</PRE></BLOCKQUOTE><BR>But after the whole process, I have the following
failure message under CartoWeb:<BR><BR>
<BLOCKQUOTE>Userinfo: SELECT txt, geom_id FROM roads_europe_vertices WHERE txt
!= '' ORDER BY txt [nativecode=ERROR: column "txt" does not exist]
<BR></BLOCKQUOTE><BR>It seems that the create_graph_tables creates the
table roads_europe_vertices with no txt column...!!!<BR>
<BLOCKQUOTE><TT>demo_plugins=# \d
roads_europe_vertices;<BR>
Table "public.roads_europe_vertices"<BR> Column
|
Type
|
Modifiers
<BR>---------+-------------------+-----------------------------------------------------------------------<BR> id
| integer | not
null default
nextval('public.roads_europe_vertices_id_seq'::text)<BR> geom_id |
integer | not
null<BR> txt | character varying |
<BR>Indexes:<BR> "roads_europe_vertices_geom_id_key" UNIQUE,
btree (geom_id)<BR> "roads_europe_vertices_id_idx" btree
(id)<BR></TT><TT></TT><BR></BLOCKQUOTE><BR>Any idea?<BR><BR>Thanks in
advance.<BR><PRE class=moz-signature cols="72">--
Franck
</PRE></BODY></HTML>