[GRASSLIST:10542] Re: v.in.db problems

[Nick Cahill]

I got that error too, when I gave my new vector the same name as the  
database table it was reading from. Try giving your output vector a  
different name so there isn't a conflict of two db tables with the  
same name.

Nick Cahill



On Feb 24, 2006, at 1:11 AM, Chris Fonnesbeck wrote:

> I am trying to create a new vector from a MySQL database table that
> has x-y coordinates, using the following command:
>
> GRASS 6.1.cvs (florida):~ > v.in.db driver=mysql database=florida
> table=mortality x=longitude y=latitude key=recid output=mortality
>
> However, I get the following error, which is confusing. Why is it
> trying to overwrite the table? I thought it just uses the information
> in the table to create the layer:
>
> WARNING: The vector 'mortality' already exists and will be  
> overwritten.
> 5699 points written to vector
> DBMI-MySQL driver error:
> Cannot create table:
> CREATE TABLE mortality ( RECID INT, DATE VARCHAR(6), FILEDBY
> VARCHAR(20), FIELDID VARCHAR(10), FMPCASE VARCHAR(5), FMPDIST
> VARCHAR(2), SEX VARCHAR(1), LENGTH DOUBLE, LENEST VARCHAR(1), WEIGHT
> VARCHAR(20), REPYEAR DOUBLE, REPMONTH DOUBLE, REPDAY DOUBLE, REPBY
> VARCHAR(55), RECYEAR DOUBLE, RECMONTH DOUBLE, RECDAY DOUBLE, RECOVBY
> VARCHAR(28), NECYEAR DOUBLE, NECMONTH DOUBLE, NECDAY DOUBLE, NECBY
> VARCHAR(55), STATE VARCHAR(2), REGION VARCHAR(25), COUNTY VARCHAR(15),
> WATERWAY VARCHAR(40), LOCALITY VARCHAR(130), CONDCODE VARCHAR(1),
> DTHCODE VARCHAR(1), CAUSE VARCHAR(155), PHDORSAL VARCHAR(1), PHVENTRL
> VARCHAR(1), PHLATERL VARCHAR(1), PHSCARS VARCHAR(1), PHFLUKE
> VARCHAR(1), PHINTRNL VARCHAR(1), PHSITE VARCHAR(1), PHOTHER
> VARCHAR(1), SKULL VARCHAR(1), PARTSKEL VARCHAR(1), COMPSKEL
> VARCHAR(1), BLUBBER VARCHAR(1), MUSCLE VARCHAR(1), LIVER VARCHAR(1),
> KIDNEY VARCHAR(1), HEART VARCHAR(1), BRAIN VARCHAR(1), EYES
> VARCHAR(1), BLOOD VARCHAR(1), URINE VARCHAR(1), ENDOPARA VARCHAR(1),
> ECTOPARA VARCHAR(1), REPRO VARCHAR(1), FETUS VARCHAR(1), STOMACH
> VARCHAR(1), DUODENUM VARCHAR(1), CAECUM VARCHAR(1), SMINTEST
> VARCHAR(1), LGINTEST VARCHAR(1), OTHERMAT VARCHAR(150), DISPOSIT
> VARCHAR(69), COMPMEAS VARCHAR(1), SCARMEAS VARCHAR(1), HISTOREP
> VARCHAR(1), TOXICREP VARCHAR(1), VETREP VARCHAR(1), HEMREP VARCHAR(1),
> ORGANWTS VARCHAR(1), OTHERDAT VARCHAR(90), REMARKS VARCHAR(200),
> SNTANUS VARCHAR(20), SNTGENIT VARCHAR(20), SNTUMBIL VARCHAR(20),
> PEDGIRTH VARCHAR(20), ANUSGRTH VARCHAR(20), UMBGIRTH VARCHAR(20),
> AXILGRTH VARCHAR(20), LATSKIN VARCHAR(20), VENTSKIN VARCHAR(20),
> LBLUBOUT VARCHAR(20), VBLUBOUT VARCHAR(20), LBLUBIN VARCHAR(20),
> VBLUBIN VARCHAR(20), RTTEAT VARCHAR(20), LTTEAT VARCHAR(20), SNTFLIP
> VARCHAR(20), AXILLA VARCHAR(20), FLIPWID VARCHAR(20), FLUKELEN
> VARCHAR(20), FLUKEWID VARCHAR(20), TEETHUR VARCHAR(20), TEETHUL
> VARCHAR(20), TEETHLR VARCHAR(20), TEETHLL VARCHAR(20), NAILSRT
> VARCHAR(20), NAILSLFT VARCHAR(20), ACCID VARCHAR(10), ID VARCHAR(20),
> AGE VARCHAR(20), AGE_EST VARCHAR(1), CORRECT VARCHAR(100), CECUM
> VARCHAR(1), STRUCTUR VARCHAR(10), LONGITUDE DOUBLE, LATITUDE DOUBLE )
> Table 'mortality' already exists
>
> WARNING: Cannot create new table
> Bus error
>
> --
> Chris Fonnesbeck + Atlanta, GA + http://trichech.us
>