Opened 13 years ago
Last modified 7 years ago
#984 new defect
v.out.ogr to MySQL does not work propely
|Reported by:||pablotcarreira||Owned by:|
|Keywords:||wingrass, v.out.ogr, mysql||Cc:|
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.
Change History (3)
comment:1 by , 12 years ago
comment:2 by , 12 years ago
comment:3 by , 7 years ago
|Milestone:||6.4.0 → 6.4.6|
Replying to pablotcarreira:
closing the ticket?