[GRASS-user] Error in sqlite3_step()

Craig Leat craig.leat at gmail.com
Thu Apr 2 16:22:12 EDT 2009


I am receiving the following error when patching two point vector maps:
v.patch -e in=SBC1,SBC2 out=SBC_0607
Patching vector map <SBC1 at craig>...
DBMI-SQLite driver error:
Error in sqlite3_step():
SQL logic error or missing database

ERROR: Cannot insert new record: 'insert into SBC_0607 values ( 64510,
       'Dwelling', 'The Msunduzi', 37)'

The attribute tables look like this :
v.info -c SBC1
Displaying column types/names for database connection of layer 1:
INTEGER|cat
CHARACTER|CLASS_NAME
CHARACTER|LM
INTEGER|WARD

v.info -c SBC2
Displaying column types/names for database connection of layer 1:
INTEGER|cat
CHARACTER|CLASS_NAME
CHARACTER|LM
INTEGER|WARD

I have checked disk space and file size of the sqlite db - no problems
there. Any ideas why sqlite chokes on cat 64510?

sqlite 3.4.2
grass 6.5
ubuntu 7.10

Thanks,

Craig


More information about the grass-user mailing list