error calculating error reach length

Question

Hi,

I try RiverGis with baldEagle exemple, but when Calculating river reach lengths an error occur :

ProgrammingError('ERREUR: erreur de syntaxe sur ou pr\xc3\xa8s de \xc2\xab INSERT \xc2\xbb\nLINE 30: INSERT INTO "zz_river_gis"."Endpoints"(geom, "RiverCode"...\n ^\n',)

Process aborted!

I have no space or special character in my names folders, and I changed Bald Eagle to BaldEagle.

Comments

Can you please share complete log from the plugin window? Also please turn on debugging mode in Settings > Options and General tab before starting your job.

---

here :

Current projection is EPSG:102728
Connection established.
Created connection to river database: sig_2@172.23.210.23
Current DB schema is: zz_river_gis
There are some objects registered in the database.

Building stream centerlines topology...
NodesTable already exists inside RiverGIS registry.
StreamCenterlines already exists inside RiverGIS registry.
Done.

Calculating river reach(es) lengths and their end stations...
Endpoints already exists inside RiverGIS registry.
ProgrammingError('ERREUR:  erreur de syntaxe sur ou pr\xc3\xa8s de \xc2\xab INSERT \xc2\xbb\nLINE 30:     INSERT INTO "zz_river_gis"."Endpoints"(geom, "RiverCode"...\n             ^\n',)
Process aborted!

---

RiverGIS log doesn't show much info about the error... sorry.
What are your database user permissions? Are you a superuser (postgres)?
Does the error occur when you work on other data?
Could you try to change your QGIS interface language to English for a while and check if it is the same?

---

Hi, i have the same error in english...

I am not a superuser but i have all rights in my schema zz_river_gis (i work on a global PG server)

Importing datas on my schema  works fine. First menu Building stream centerlines topology also works.

I tried to work on data i created and i have the same error...

---

We need detailed description of the error. Please copy the SQL from https://gist.github.com/erpas/d1c9ce950a565ef67047 and run it in DB Manager or pgAdmin. This is a code that calculates the lengths. Hopefully this way we will get some more information about the error.

---

error in db manager is :

ERREUR:  erreur de syntaxe sur ou près de « INSERT »
LINE 29:     INSERT INTO "zz_river_gis"."Endpoints"(geom, "RiverCode"...
             ^

---

I think my postgre version 8.4 is bad. I will try with 9.4!

Answer 1

RiverGIS needs PostgreSQL ver. 9. The recommended version is 9.4 along with the PostGIS 2.2.