v.out.ogr to MySQL does not work propely

[pablotcarreira]

With OSGeo4W version When try v.out.ogr some vectors to Mysql I got the following problem: ERROR 1: MySQL error message:Duplicate entry '1' for key 'OGR_FID'

For every vector it try to use the same OGR_FID and at the end It exports only the first vector becouse the other has duplicated FID.

the command is the following: v.out.ogr --verbose input=areas_vector@geral type=area dsn=MYSQL:geobase,user=root,password=xxxxx,host=localhost format=MySQL olayer=teste3 -c lco=spatial_index=no

I had sent a message to gdal-devel and here is the answer:

This could happen if you pass to CreateFeature() features that have the same id set by OGRFeature::SetFID() as being 1... Check with OGRFeature::GetFID() what you pass to CreateFeature(). Even

With ogr2ogr utilitie the GRASS->MySQL works fine.

[hellik]

Replying to pablotcarreira:

With OSGeo4W version When try v.out.ogr some vectors to Mysql I got the following problem: ERROR 1: MySQL error message:Duplicate entry '1' for key 'OGR_FID'

For every vector it try to use the same OGR_FID and at the end It exports only the first vector becouse the other has duplicated FID.

the command is the following: v.out.ogr --verbose input=areas_vector@geral type=area dsn=MYSQL:geobase,user=root,password=xxxxx,host=localhost format=MySQL olayer=teste3 -c lco=spatial_index=no

I had sent a message to gdal-devel and here is the answer:

This could happen if you pass to CreateFeature() features that have the same id set by OGRFeature::SetFID() as being 1... Check with OGRFeature::GetFID() what you pass to CreateFeature(). Even

With ogr2ogr utilitie the GRASS->MySQL works fine.

closing the ticket?