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" <[email protected]> To: [email protected] 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=geol...@permanent,geology ~>v.dissolve input=geol...@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 [email protected] 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. _______________________________________________ grass-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-user
