[GRASS-user] Re: Error using v.db.addcol in a WinGRASS OSGEO4W

[Helena Herrera]

Hi

After some help from Antonio we limited my problem to v.colors
Instead of running v.db.addcol I will be running db.execute directly and It
works just fine (probably one of the problems was the path that was a
mixture of "/" and "\")
Now, when I try to run v.colors in my OSGEO4W I get:
      0 [main] sh 2708 open_stackdumpfile: Dumping stack
trace to sh.exe.stackdump
DBMI-DBF driver error:
Table '' doesn't exist
ERROR: Unable to describe table <>

Scanning values ...
Looking up colors ...
      0 [main] sh 4884 open_stackdumpfile: Dumping stack
trace to sh.exe.stackdump
C:/OSGeo4W/apps/grass/grass-6.4.1svn/scripts/v.colors: line
296:  5984 Done                    v.db.select
map="$GIS_OPT_MAP" layer="$GIS_OPT_LAYER"
column="$GIS_OPT_COLUMN"
      2916                       | sort -n
       704                       | grep '^[-0-9]'
      1812                       | uniq
      1852                       | r.what.color -i
in="tmp_colr_$$"
      3068                       | sed -e 's/: /|/'
      4068                       | grep -v '|\*$'
      4884 Segmentation fault      (core dumped) | ( while
read LINE; do
    VALUE=`echo $LINE | cut -f1 -d'|'`; COLR=`echo $LINE |
cut -f2 -d'|'`; echo "UPDATE $TABLE SET $GIS_OPT_RGB_COLUMN
= '$COLR' WHERE $GIS_OPT_COLUMN = $VALUE;"
>>"${TEMPFILE}_vcol.sql";
done )
ERROR: No values found in color range
rm: cannot lstat
`C:\\DWEISdata/Brazil/Regional/.tmp/3404.0_vcol.sql': No
such file or directory

But exacly with the same command I'm able to run in a WinGRASS (even an
older one).
My OSGEO4w is from 6.4.1 and my winGRASS (that is working) is 6.4.0

On Thu, Nov 18, 2010 at 5:23 PM, Helena Herrera <helenaherrera1980 at gmail.com
> wrote:

> Greetings
>
> I'm running WinGRASS in a OSGEO4W and when I run v.db.addcol I get a
> strange error:
>
> v.db.addcol map=v7 at Regional columns=GRASSRGB VARCHAR(11)
>
>       0 [main] sh 4404 open_stackdumpfile: Dumping stack
> trace to sh.exe.stackdump
> or even:
> v.db.addcol map=v7 at Regional columns=AI VARCHAR(11)
>
>       0 [main] sh 1508 open_stackdumpfile: Dumping stack
> trace to sh.exe.stackdump
>       0 [main] sh 4680 open_stackdumpfile: Dumping stack
> trace to sh.exe.stackdump
> C:/OSGeo4W/apps/grass/grass-6.4.1svn/scripts/v.db.addcol: [:
> : integer expression expected
>
> Then If I try to run in v.colors I get:
> v.colors map=v7 at Regional column=cat color=aspectcolr
>
>       0 [main] sh 2196 open_stackdumpfile: Dumping stack
> trace to sh.exe.stackdump
>       0 [main] sh 5544 open_stackdumpfile: Dumping stack
> trace to sh.exe.stackdump
> ERROR: Column <cat> not found
> or even:
> Scanning values ...
>       0 [main] sh 5652 open_stackdumpfile: Dumping stack
> trace to sh.exe.stackdump
> ERROR: Scanning data range
> or:
>      0 [main] sh 208 open_stackdumpfile: Dumping stack
> trace to sh.exe.stackdump
>       0 [main] sh 2304 open_stackdumpfile: Dumping stack
> trace to sh.exe.stackdump
> C:/OSGeo4W/apps/grass/grass-6.4.1svn/scripts/v.colors: [: :
> integer expression expected
> Scanning values ...
> Looking up colors ...
> ERROR: No values found in color range
> rm: cannot lstat
> `C:\\DWEISdata/Brazil/Regional/.tmp/3548.0_vcol.sql': No
> such file or directory
>
> I believe the error might be in v.db.connect
> I tried to find If I had any error during compilation but I don't think so.
> Here goes the Error LOG (and I attached config.log).
> GRASS GIS compilation log
> -------------------------
> Started compilation: Wed Sep 15 00:33:24 GMTDT 2010
> --
> Errors in:
> No errors detected.
> --
> Finished compilation: Wed Sep 15 00:52:48 GMTDT 2010
>
> The thing is, that I don't get this error in any other function and neither
> in distributted winGRASS.
>
> Any sugfgestion?
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/grass-user/attachments/20101118/bcbb2be4/attachment.html