d.vect.thematic won't write grassrgb values, ERROR: You must provide <sql> or <input> option

[jamesp670]

The setup:

My uname output:

: GRASS 7.0.0svn (rlis-master-for-seven):~ > uname -a : Linux login.cluster 2.6.32-431.17.1.el6.x86_64 #1 SMP Wed May 7 23:32:49 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux

I built grass from source, using primarily deps supplied by

: yum install ​http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/\ : pgdg-redhat93-9.3-1.noarch.rpm

I just ([2014-12-28 23:08]) did svn up and rebuilt. The build is painless. GRASS works great, except for this bug. I haven't tried it with Spearfish, because getting Spearfish into postgresql seems difficult. I expect the bug to show up with any execution of d.vect.thematic -u against a pg-driven mapset.

What I expect:

When I run this command, which was constructed using the d.vect.thematic GUI:

: d.vect.thematic -f -s --verbose map=tract2010censusdp1_clipped_02@PERMANENT column=popden10 themetype=graduated_colors themecalc=custom_breaks breakpoints="0 500 1000 1500 2000 5000 10000 15000 20000 25000" colorscheme=green-red monitor=none -u

I expect no errors, and colors to be written to grassrgb thanks to the presence of the -u flag.

What I get:

: GRASS 7.0.0svn (rlis-master-for-seven):~ > d.vect.thematic -f -s --verbose map=tract2010censusdp1_clipped_02@PERMANENT column=popden10 themetype=graduated_colors themecalc=custom_breaks breakpoints="0 500 1000 1500 2000 5000 10000 15000 20000 25000"$ : : Creating column 'grassrgb' in table <tract2010censusdp1_clipped_02> : ERROR: You must provide <sql> or <input> option : ^{GTraceback (most recent call last): : File "/opt/yum-packages-installed-on-the-head-node/tmp/local/grass-7.0.0svn/scripts/d.vect.thematic", line 1105, in <module> : main() : File "/opt/yum-packages-installed-on-the-head-node/tmp/local/grass-7.0.0svn/scripts/d.vect.thematic", line 316, in main : grass.write_command('db.execute', database = database, driver = driver, stdin = sql) : File "/opt/yum-packages-installed-on-the-head-node/tmp/local/grass-7.0.0svn/etc/python/grass/script/core.py", line 483, in write_command : return handle_errors(returncode, returncode, args, kwargs) : File "/opt/yum-packages-installed-on-the-head-node/tmp/local/grass-7.0.0svn/etc/python/grass/script/core.py", line 308, in handle_errors : returncode=returncode) : grass.exceptions.CalledModuleError: Module run None ['db.execute', 'stdin=ALTER TABLE tract2010censusdp1_clipped_02 ADD COLUMN grassrgb varchar(11)', 'driver=pg', 'database=host=node01,dbname=rlis-gis'] ended with error : Process ended with non-zero return code 1. See errors in the (error) output. : GRASS 7.0.0svn (rlis-master-for-seven):~ > Thank you!}

[neteler]

Good catch. I was able to reproduce the error with the North Carolina dataset (needed for actually fixing it):

g.region vector=censusblk_swwake
d.mon wx0
d.vect.thematic -f -s map=censusblk_swwake column=TOTAL_POP themetype=graduated_colors \
  themecalc=custom_breaks breakpoints="0 500 1000 1500 2000 5000 10000 15000 20000 25000" \
  colorscheme=blue-red monitor=none -u

The db.execute call was incomplete. Fixed in r63803 and for relbranch70 in r63804.

Closing, feel free to reopen if the problem persists.