RE: [gdal-dev] OGR to Mysql problems

2010-03-04 Thread Pablo Carreira
> > 2)With v.out.ogr: > > I still get the error: > > "ERROR 1: MySQL error message:Duplicate entry '1' for key 'OGR_FID'" > > and only one row created at Mysql > > Please file a bug report with the needed details. > > Markus Done. Thanks for the help. Pablo.

Re: [gdal-dev] OGR to Mysql problems

2010-03-04 Thread Markus Neteler
On Thu, Mar 4, 2010 at 4:51 PM, Pablo Carreira wrote: > Hi Markus, after your email I have some new results: > > 1)With ogr2ogr: > SET GISBASE=C:\OSGeo4W\apps\grass\grass-6.4.0svn > > ogr2ogr -f mysql MYSQL:geodados,user=root,password=rcamargo,host=localhost > /grassdata/utmwgs23/geral/vector/area

RE: [gdal-dev] OGR to Mysql problems

2010-03-04 Thread Pablo Carreira
Hi Markus, after your email I have some new results: 1)With ogr2ogr: SET GISBASE=C:\OSGeo4W\apps\grass\grass-6.4.0svn ogr2ogr -f mysql MYSQL:geodados,user=root,password=rcamargo,host=localhost /grassdata/utmwgs23/geral/vector/areas_recuperacao_trabalhado/head -overwrite -lco spatial_index=no -n

Re: [gdal-dev] OGR to Mysql problems

2010-03-04 Thread Markus Neteler
On Thu, Mar 4, 2010 at 1:27 PM, Pablo Carreira wrote: > Hi Even, > I don't know much of programming. I'am using the GRASS v.out.ogr tool to > export from GRASS to Mysql. > Do you think it's a GRASS bug? Hi Pablo, how old is your GRASS version? > I had tryied ogr2ogr from command line in window

RE: [gdal-dev] OGR to Mysql problems

2010-03-04 Thread Pablo Carreira
Hi Even, I don't know much of programming. I'am using the GRASS v.out.ogr tool to export from GRASS to Mysql. Do you think it's a GRASS bug? I had tryied ogr2ogr from command line in windows but I got this error: c:\>ogr2ogr -f mysql MYSQL:geodados,user=root,password=xx,host=localhost /gra

Re: [gdal-dev] OGR to Mysql problems

2010-03-03 Thread Even Rouault
Pablo, 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(). Best regards, Even Le Wednesday 03 March 2010 21:00:47 Pablo Carreira, vous avez écrit : > Hi, I'

[gdal-dev] OGR to Mysql problems

2010-03-03 Thread Pablo Carreira
Hi, I'am trying to export some vectors to Mysql but 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. Any help?