[Zoo-discuss] problem ZOO-proyect WPS and GRASS

[Markus Neteler]

Hi Pablo,

On Tue, May 13, 2014 at 5:35 PM, pablo zader <pzader at gmail.com> wrote:
> Hello list
>
> I have a problem trying to run a WPS process through QGIS. (attach print
> screen)
>
> TRACE : GDLA error while import. Unable to create input location from input
> /tmp/zoo-project/tmpXCXRn6/input_0 GDAL log: Location <workLocation> created
> Default driver / database set to: driver: sqlite database:
> $GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db DBMI-SQLite driver error:
> Error in sqlite3_prepare(): near "JOIN": syntax error ERROR: Unable to
> create table: 'create table input (cat integer, AREA double precision,
> PERIMETER double precision, URUGUAY_ integer, X double precision, Y double
> precision, NOMBRE varchar ( 7 ), JOIN integer)'

I suppose that using "JOIN" as column name is a problem since it is a keyword:

https://www.sqlite.org/lang_keywords.html

You may try to rename that column.

best,
Markus

-- 
http://courses.neteler.org
http://gis.cri.fmach.it/neteler/