[GRASS-dev] [GRASS GIS] #1866: broken db driver communication in winGRASS 7

[GRASS GIS]

#1866: broken db driver communication in winGRASS 7
------------------------------+---------------------------------------------
 Reporter:  martinl           |       Owner:  grass-dev@…              
     Type:  defect            |      Status:  new                      
 Priority:  blocker           |   Milestone:  7.0.0                    
Component:  Database          |     Version:  unspecified              
 Keywords:  sqlite, wingrass  |    Platform:  MSWindows 2K             
      Cpu:  Unspecified       |  
------------------------------+---------------------------------------------

Comment(by hellik):

 Replying to [comment:34 hamish]:
 >
 > is the overpass vector map in the current mapset? You may be seeing the
 effect of the db.* modules only working for databases linked from maps in
 the current mapset, unless you explicitly set database= to the real path,
 not the default which may expand $MAPSET to the current mapset, not the
 other mapset's dir name.

 it seems the case here

 {{{
 v.info map=overpasses at PERMANENT
 +----------------------------------------------------------------------------+
  | Name:            overpasses
 |
  | Mapset:          PERMANENT
 |
  | Location:        nc_spm_08_grass7
 |
  | Database:        C:\grassdata
 |
  | Title:           North Carolina NCDOT overpasses
 |
  | Map scale:       1:1
 |
  | Name of creator: NCDOT GIS, Raleigh, North Carolina
 |
  | Organization:    NC OneMap
 |
  | Source date:     January 2007
 |
  | Timestamp (first layer): none
 |
 |----------------------------------------------------------------------------|
  | Map format:      native
 |
 |----------------------------------------------------------------------------|
  |   Type of map: Vektor (level: 2)
 |
  |
 |
  |   Number of points:       17754           Number of centroids:  0
 |
  |   Number of lines:        0               Number of boundaries: 0
 |
  |   Number of areas:        0               Number of islands:    0
 |
  |
 |
  |   Map is 3D:              No
 |
  |   Number of dblinks:      1
 |
  |
 |
  |   Projection: Lambert Conformal Conic
 |
  |
 |
  |               N:   317794.03225579    S:    14710.42725429
 |
  |               E:   929375.80949981    W:   126286.43250027
 |
  |
 |
  |   Digitization threshold: 0
 |
  |   Comment:
 |
  |     Data from http://www.ncdot.org/it/gis/DataDistribution/ (Bridge
 Maps)  |
 +----------------------------------------------------------------------------+
 }}}

 {{{
 g.mapset -p
 PERMANENT
 }}}

 {{{
 db.describe overpasses
 table:overpasses
 description:
 insert:?
 delete:?
 ncols:7
 nrows:17754
 column:cat
 description:
 type:INTEGER
 len:20
 scale:0
 precision:0
 default:
 nullok:yes
 select:?
 update:?
 [...]
 }}}

 {{{
 g.mapset -p
 user1
 }}}

 {{{
 db.describe overpasses
 DBMI-SQLite driver error:
 Error in sqlite3_prepare(): select * from overpasses where
 oid < 0
 no such table: overpasses
 ERROR: Kann Tabelle <overpasses> nicht beschreiben.
 }}}

-- 
Ticket URL: <https://trac.osgeo.org/grass/ticket/1866#comment:35>
GRASS GIS <http://grass.osgeo.org>