[GRASS-dev] [GRASS GIS] #2517: d.vect.thematic won't write grassrgb values, ERROR: You must provide <sql> or <input> option

[GRASS GIS]

#2517: d.vect.thematic won't write grassrgb values, ERROR: You must provide <sql>
or <input> option
-------------------------------------------------+--------------------------
 Reporter:  jamesp670                            |       Owner:  grass-dev@…              
     Type:  defect                               |      Status:  new                      
 Priority:  normal                               |   Milestone:  7.0.0                    
Component:  Vector                               |     Version:  svn-releasebranch70      
 Keywords:  d.vect.thematic postgresql grassrgb  |    Platform:  Linux                    
      Cpu:  x86-64                               |  
-------------------------------------------------+--------------------------
 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 at 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 at 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!

-- 
Ticket URL: <http://trac.osgeo.org/grass/ticket/2517>
GRASS GIS <http://grass.osgeo.org>