[GRASSLIST:127] Creating vector from MySQL database (GRASS 6.1)

GRASS GRASS user
1

When I execute

v.in.db driver=mysql
database="host=ecolmod-mysql,dbname=renpatch_renosterbos"
table=def_renosterbos x=X y=Y z=RX key=_ID 'where=(_RUN = 5) AND
(_YEAR=99)' output=def_renosterbos_run_5_year_99_2

I get a Segmentation fault and an empty vector layer is created - am I doing something wrong or is it a bug?

Rainer

--
Rainer M. Krug, Dipl. Phys. (Germany), MSc Conservation Biology (UCT)

Department of Conservation Ecology
University of Stellenbosch
Matieland 7602
South Africa

2

Hello Rainer,

On Wed, 15 Mar 2006 12:22:22 +0200 Rainer M Krug <rkrug@sun.ac.za>
wrote:

When I execute

v.in.db driver=mysql
database="host=ecolmod-mysql,dbname=renpatch_renosterbos"
table=def_renosterbos x=X y=Y z=RX key=_ID 'where=(_RUN = 5) AND
(_YEAR=99)' output=def_renosterbos_run_5_year_99_2

I get a Segmentation fault and an empty vector layer is created - am
I doing something wrong or is it a bug?

Untested:
use your quotes slightly different:
v.in.db driver=mysql
database="host=ecolmod-mysql,dbname=renpatch_renosterbos"
table=def_renosterbos x=X y=Y z=RX key=_ID where="(_RUN = 5) AND
(_YEAR=99)" output=def_renosterbos_run_5_year_99_2

Perhaps this helps.

  Stephan

--
GDF Hannover - Solutions for spatial data analysis and remote sensing
Hannover Office - Mengendamm 16d - D-30177 Hannover
Internet: www.gdf-hannover.de - Email: holl@gdf-hannover.de
Phone : ++49-(0)511.39088507 - Fax: ++49-(0)511.39088508

3

Hello Rainer,

On Wed, 15 Mar 2006 13:51:25 +0200 Rainer M Krug <rkrug@sun.ac.za>
wrote:

Thanks, but Ho difference - empty vector layer and "Segmentation
fault"

Another thing I could imagine is the key-column beginning with an
underscore. Do you have the possibility to temporary create another
ID-column inside your data-table (perhaps use the OID-column if
present?) to see if that is a problem?

Best

  Stephan

Rainer

Stephan Holl wrote:
> Hello Rainer,
>
> On Wed, 15 Mar 2006 12:22:22 +0200 Rainer M Krug <rkrug@sun.ac.za>
> wrote:
>
>> When I execute
>>
>> v.in.db driver=mysql
>> database="host=ecolmod-mysql,dbname=renpatch_renosterbos"
>> table=def_renosterbos x=X y=Y z=RX key=_ID 'where=(_RUN = 5) AND
>> (_YEAR=99)' output=def_renosterbos_run_5_year_99_2
>>
>> I get a Segmentation fault and an empty vector layer is created -
>> am I doing something wrong or is it a bug?
>
> Untested:
> use your quotes slightly different:
> v.in.db driver=mysql
> database="host=ecolmod-mysql,dbname=renpatch_renosterbos"
> table=def_renosterbos x=X y=Y z=RX key=_ID where="(_RUN = 5) AND
> (_YEAR=99)" output=def_renosterbos_run_5_year_99_2
>
> Perhaps this helps.
>
> Stephan
>
>
>

--
GDF Hannover - Solutions for spatial data analysis and remote sensing
Hannover Office - Mengendamm 16d - D-30177 Hannover
Internet: www.gdf-hannover.de - Email: holl@gdf-hannover.de
Phone : ++49-(0)511.39088507 - Fax: ++49-(0)511.39088508