I have had the same error message when trying to
store data in an SQLite DB file, using v.out.ogr.
Not even a very basic points map would work.
Only the first record, including geometry
and attributes would stored correctly, after that
every record would fail with:
"SQL logic error or missing database"
Unfortunately, this error is very unspecific. Like
SQLite's way of saying "something went really wrong,
but I have no clue what it was".
The problem seems, however, to be on the GRASS side
of things. I am inclined to believe this, because
ogr2ogr had no problems whatsoever dumping the exact
same dataset into the exact same SQLite file.
I tried finding the problem in the GRASS SQLite driver
for some time, but no luck.
Sorry about not being able to offer a solution at
this point. It is something that needs looking into.
Ben
----- Original Message -----
From: "Martin Mainzer" <martmai@gmx.de>
To: grass-user@lists.osgeo.org
Sent: Tuesday, June 16, 2009 5:45:23 PM GMT +00:00 GMT Britain, Ireland, Portugal
Subject: [GRASS-user] Problem with v.dissolve with the sqlite driver
Hello,
I just installed the grass 6.4.0 RC4 *.rpm from
http://download.opensuse.org/repositories/Application:/Geo/openSUSE_10.3
on my OpenSuse 10.3 machine.
And here I got a problem that looks for me like the one reported in 2007
(http://grass.itc.it/pipermail/grass5/2007-May/031340.html):
Within the spearfish dataset (nc_spm_08) I entered the sqlite mapset and
copied the geology map to the splite mapset with
~> g.copy vect=geology@PERMANENT,geology
~>v.dissolve input=geology@sqlite output=geology_diss layer=1
column=GEO_NAME
DBMI-SQLite driver error:
Cannot step:
SQL logic error or missing database
...
Did I make a mistake or is it a bug?
_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user
------
Files attached to this email may be in ISO 26300 format (OASIS Open Document Format). If you have difficulty opening them, please visit http://iso26300.info for more information.