[GRASS-user] DBMI-DBF driver error with v.in.ogr grass 6.2.2 (worked with older grass)

[Lev Tarasov]

Hi;
    I'm trying to re-import some shape files that I had originally imported 
in fall 2007 with an older version of grass (not sure which one) but I now 
get a DBMI-DBF driver error with grass 6.2.2. How can I fix this? 
(Hopefully grass will at some point maintain backward compatibility)

Specifically:

GRASS 6.2.2 > v.in.ogr dsn=/u1/wrk/GIS/EAdatoct07.dir/ layer=Time19_NEW2 out=EA7o19kbb
Projection of input dataset and current location appear to match.
Proceeding with import...
Layer: Time19_NEW2
DBMI-DBF driver error:
SQL parser error in statement:
create table EA7o19kbb (cat integer, ID1 integer, Time integer)
Error in db_execute_immediate()
ERROR: Cannot create table: create table EA7o19kbb (cat integer, ID1
        integer, Time integer)

GRASS 6.2.2 > v.db.connect -p map=EA7o19kbb
WARNING: coor files of vector 'EA7o19kbb at lev' is larger than it should be
         (14 bytes excess).
Vector map <EA7o19kbb> is connected by:
layer <1> table <EA7o19kbb> in database </u1/wrk/GIS/EAmg7/lev/dbf/>  through driver <dbf> with key <cat>

The old file gives:

GRASS 6.2.2 > v.db.connect -p map=EA7o19k
Vector map <EA7o19k> is connected by:
layer <1> table <EA7o19k> in database </u1/wrk/GIS/EAmg7/lev/dbf/> through driver <dbf> with key <cat>


------------
details from files in /home/u1/wrk/GIS/EAmg7/lev/vector/EA7o19k

hist:
COMMAND: v.in.ogr -o dsn="/u1/wrk/GIS/EAdatoct07.dir/" output="EA7o19k" layer="Time19_NEW2" min_area=0.0001 snap=-1
GISDBASE: /u1/wrk/GIS
LOCATION: EAmg7 MAPSET: lev USER: lev DATE: Mon Nov 12 14:25:21 2007

dbln:
1 EA7o19k cat $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/ dbf


------------
projection, PERMANENT files:

GRASS 6.2.2 > g.proj -p
XY location (unprojected)

VAR:
DB_DRIVER: dbf
DB_DATABASE: $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/

PROJ_INFO:
name: Lambert Azimuthal Equal Area
proj: laea
ellps: wgs84
a: 6378137.0000000000
es: 0.0066943800
f: 298.2572235630
lat_0: 60.0000000000
lon_0: 20.0000000000


The input files are:
-rw-r--r-- 1 lev lev    130 2007-11-01 11:05 /u1/wrk/GIS/EAdatoct07.dir/Time19_NEW2.dbf
-rw-r--r-- 1 lev lev 109892 2007-11-01 11:05 /u1/wrk/GIS/EAdatoct07.dir/Time19_NEW2.shp
-rw-r--r-- 1 lev lev    116 2007-11-01 11:05 /u1/wrk/GIS/EAdatoct07.dir/Time19_NEW2.shx



Lev
                 email: lev{at]mun(dot)ca