So I decided to try this with 7.0 and looked again at the mapset. It turns out that the folder is there but not the sqlite.db.
So perhaps we need to add to the WIKI that you might need to create the sqlite.db However, when I tried to create the database, it doesn’t seem to work. db.createdb driver=sqlite database=$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db dbmi: db_create_database() not implemented dbmi: db_create_database() not implemented No error. Just no database. Michael ____________________ C. Michael Barton Director, Center for Social Dynamics & Complexity Professor of Anthropology, School of Human Evolution & Social Change Head, Graduate Faculty in Complex Adaptive Systems Science Arizona State University voice: 480-965-6262 (SHESC), 480-965-8130/727-9746 (CSDC) fax: 480-965-7671 (SHESC), 480-727-0709 (CSDC) www: http://www.public.asu.edu/~cmbarton, http://csdc.asu.edu > On Sep 5, 2015, at 11:26 AM, Markus Neteler <[email protected]> wrote: > > On Sat, Sep 5, 2015 at 7:51 PM, Michael Barton <[email protected]> wrote: >> I don’t know if this is bad advice in the GRASS WIKI or a bug in a GRASS >> database module. I have some vector files that were somehow imported into a >> dbf DBMS last year. I wanted to switch them all to sqlite. The GRASS WIKI >> advises… >> >> Convert automatically all GRASS 6 vector maps to GRASS 7 (including >> attribute transfer from DBF to SQLite) > > > https://grasswiki.osgeo.org/wiki/Convert_all_GRASS_6_vector_maps_to_GRASS_7 > > ... > >> The vectors already had GRASS 7 topology, but I ran v.rebuild.all just to be >> sure. No problem. >> >> db.connect -d ran with no problem >> >> But v.db.reconnect.all -cd did not create tables in the sqlite database > > But the sqlite file is there? > >> and corrupted the existing connection of the first table it hit. >> Fortunately, I >> made a backup of the mapset before I started this. > > Perhaps a problem on Mac? > This is strange - I have converted so many mapsets like that ..., even > with lots of vector maps inside. > The wiki page is there for a long time, I didn't see such reports so far. > >> GRASS 7.1.svn (Spain_fieldwork_medlands_ERTS89_Z30):~ > v.db.reconnect.all >> -cd >> >> -------------------------------------------------------------------------------- >> Reconnecting vector map <catastro@surveyboundaries> (1 of 9)... >> -------------------------------------------------------------------------------- >> Copying table <catastro> to target database... >> Traceback (most recent call last): >> File >> "/Applications/GRASS/GRASS-7.1.app/Contents/MacOS/scripts/db.droptable", >> line 99, in <module> >> main() >> File >> "/Applications/GRASS/GRASS-7.1.app/Contents/MacOS/scripts/db.droptable", >> line 77, in main >> used = grass.db.db_table_in_vector(table) >> File >> "/Applications/GRASS/GRASS-7.1.app/Contents/MacOS/etc/python/grass/script/db.py", >> line 184, in db_table_in_vector >> from vector import vector_db >> ImportError: No module named vector > > Maybe something got broken in GRASS 7.1? > > I would definitely use 7.0 for such operations. > > Markus > >> ERROR: Unable to drop table <catastro> >> GRASS 7.1.svn (Spain_fieldwork_medlands_ERTS89_Z30):~ > >> >> Michael >> ____________________ >> C. Michael Barton >> Director, Center for Social Dynamics & Complexity >> Professor of Anthropology, School of Human Evolution & Social Change >> Head, Graduate Faculty in Complex Adaptive Systems Science >> Arizona State University >> >> voice: 480-965-6262 (SHESC), 480-965-8130/727-9746 (CSDC) >> fax: 480-965-7671 (SHESC), 480-727-0709 (CSDC) >> www: http://www.public.asu.edu/~cmbarton, http://csdc.asu.edu _______________________________________________ grass-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-dev
