[GRASS-user] DBMI-DBF driver error

Markus Neteler neteler at osgeo.org
Mon Jul 19 08:04:14 EDT 2010


Hi Sandile,

update for the list. From your prompt
 GRASS 6.4.0RC5+39438 (SRTMDEM):~ >

I see that you installation is older than my version (6.4 from SVN)
where the problem
has already been solved.

I tried with Spearfish:

# go into no-data area of raster:
g.region n=4919210 s=4919070 w=589620 e=589830 nsres=10 ewres=10 -p
g.copy vect=fields,myfields
v.db.addcol myfields col="precip double precision"
v.rast.stats vector=myfields raster=elevation.10m colprefix=precip
... works ok in SVN.

Cheers
Markus

On Mon, Jul 19, 2010 at 8:53 AM, Sandile Gumede <akasandile at gmail.com> wrote:
> Hi Markus
>
> Here is the output:
>
...
> + g.message -v message=Processing category 262 (1/4)
> + g.remove MASK --quiet
> + GRASS_VERBOSE=0 r.mapcalc MASK=if(catchments_23218.0 == 262, 1, null())
> + unset n min max range mean stddev variance cf_var sum
> + r.univar -g map=trmm percentile=90
> + sed s+nan+NULL+g
> + eval n=0 null_cells=12 min=-NULL max=-NULL range=-NULL mean=-NULL
> mean_of_abs=-NULL stddev=-NULL variance=-NULL coeff_var=-NULL sum=0
> + n=0 null_cells=12 min=-NULL max=-NULL range=-NULL mean=-NULL
> mean_of_abs=-NULL stddev=-NULL variance=-NULL coeff_var=-NULL sum=0
> + cf_var=-NULL
> + [ 0 -eq 1 ]
> + eval value=${n}
> + value=0
> + [ 1 -eq 1 ]
> + echo prec_n

...
> + echo UPDATE catchments SET prec_sum=0 WHERE cat=733;
> + expr 4 + 1
> + CURRNUM=5
> + g.message -v Updating the database ...
> + db.execute
> input=/home/tgumede1/grassdata/Cape_Town/Original/SRTMDEM/PERMANENT/.tmp/tgumede1-desktop/23218.0.sql
> database=/home/tgumede1/grassdata/Cape_Town/Original/SRTMDEM/PERMANENT/dbf/
> driver=dbf
> DBMI-DBF driver error:
> SQL parser error: syntax error, unexpected NULL_VALUE processing 'NULL'
> in statement:
> UPDATE catchments SET prec_min=-NULL WHERE cat=262
> Error in db_execute_immediate()
>
> ERROR: Error while executing: 'UPDATE catchments SET prec_min=-NULL WHERE
>        cat=262'
...


More information about the grass-user mailing list