[GRASS-user] Error in sqlite3_step()

[Moritz Lennert]

On 02/04/09 22:22, Craig Leat wrote:
> 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?

What does v.db.connect -p show for each of the two maps ?

Moritz