[GRASS-dev] [GRASS GIS] #1512: problem sql query on wingrass

#1512: problem sql query on wingrass
-------------------------+--------------------------------------------------
Reporter: madi | Owner: grass-dev@…
     Type: defect | Status: new
Priority: critical | Milestone:
Component: Default | Version: svn-develbranch6
Keywords: | Platform: MSWindows XP
      Cpu: Unspecified |
-------------------------+--------------------------------------------------
The problem raises when I try to run a sql query on geology map in nc
dataset. The program gets stuck when I try to raise SQL builder.

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/1512&gt;
GRASS GIS <http://grass.osgeo.org>

#1512: problem sql query on wingrass
-------------------------+--------------------------------------------------
Reporter: madi | Owner: grass-dev@…
     Type: defect | Status: new
Priority: critical | Milestone:
Component: wxGUI | Version: svn-develbranch6
Keywords: sqlbuilder | Platform: MSWindows XP
      Cpu: Unspecified |
-------------------------+--------------------------------------------------
Changes (by martinl):

  * keywords: => sqlbuilder
  * component: Default => wxGUI

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/1512#comment:1&gt;
GRASS GIS <http://grass.osgeo.org>

#1512: problem sql query on wingrass
-------------------------+--------------------------------------------------
Reporter: madi | Owner: grass-dev@…
     Type: defect | Status: new
Priority: critical | Milestone: 6.4.2
Component: wxGUI | Version: svn-develbranch6
Keywords: sqlbuilder | Platform: MSWindows XP
      Cpu: Unspecified |
-------------------------+--------------------------------------------------
Changes (by martinl):

  * milestone: => 6.4.2

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/1512#comment:2&gt;
GRASS GIS <http://grass.osgeo.org>

#1512: problem sql query on wingrass
-------------------------+--------------------------------------------------
Reporter: madi | Owner: grass-dev@…
     Type: defect | Status: new
Priority: critical | Milestone: 6.4.2
Component: wxGUI | Version: svn-develbranch6
Keywords: sqlbuilder | Platform: MSWindows XP
      Cpu: Unspecified |
-------------------------+--------------------------------------------------

Comment(by madi):

http://imageshack.us/f/535/screenshot12q.png/
http://imageshack.us/photo/my-images/11/screenshot15i.png/

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/1512#comment:3&gt;
GRASS GIS <http://grass.osgeo.org>

#1512: problem sql query on wingrass
-------------------------+--------------------------------------------------
Reporter: madi | Owner: grass-dev@…
     Type: defect | Status: new
Priority: critical | Milestone: 6.5.0
Component: wxGUI | Version: svn-develbranch6
Keywords: sqlbuilder | Platform: MSWindows XP
      Cpu: Unspecified |
-------------------------+--------------------------------------------------
Changes (by hamish):

  * milestone: 6.4.2 => 6.5.0

Comment:

Same here on linux, latest 6.5svn. I think related to the recent file re-
shuffle.

{{{
Traceback (most recent call last):
   File "/home/hamish/grass/svn/grass65/dist.x86_64
-unknown-linux-gnu/etc/wxpython/dbmgr/manager.py", line
2036, in OnBuilder

evtheader = self.OnBuilderEvt)
   File "/home/hamish/grass/svn/grass65/dist.x86_64
-unknown-linux-gnu/etc/wxpython/dbmgr/sqlbuilder.py", line
60, in __init__

self.dbInfo = dbm_base.VectorDBInfo(self.vectmap)
NameError
:
global name 'dbm_base' is not defined
}}}

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/1512#comment:4&gt;
GRASS GIS <http://grass.osgeo.org>

#1512: problem sql query on wingrass
-------------------------+--------------------------------------------------
Reporter: madi | Owner: grass-dev@…
     Type: defect | Status: new
Priority: critical | Milestone: 6.5.0
Component: wxGUI | Version: svn-develbranch6
Keywords: sqlbuilder | Platform: MSWindows XP
      Cpu: Unspecified |
-------------------------+--------------------------------------------------

Comment(by hamish):

(it works fine in 6.4svn)

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/1512#comment:5&gt;
GRASS GIS <http://grass.osgeo.org>

#1512: problem sql query on wingrass
-------------------------+--------------------------------------------------
Reporter: madi | Owner: grass-dev@…
     Type: defect | Status: new
Priority: critical | Milestone: 6.5.0
Component: wxGUI | Version: svn-develbranch6
Keywords: sqlbuilder | Platform: MSWindows XP
      Cpu: Unspecified |
-------------------------+--------------------------------------------------

Comment(by neteler):

Please try attached patch (madi, you can manually even do that on your
windows machine).
I compared sqlbuilder to the version in GRASS 7 which should be closer
than 6.4.

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/1512#comment:6&gt;
GRASS GIS <http://grass.osgeo.org>

#1512: problem sql query on wingrass
-------------------------+--------------------------------------------------
Reporter: madi | Owner: grass-dev@…
     Type: defect | Status: new
Priority: critical | Milestone: 6.5.0
Component: wxGUI | Version: svn-develbranch6
Keywords: sqlbuilder | Platform: MSWindows XP
      Cpu: Unspecified |
-------------------------+--------------------------------------------------

Comment(by hamish):

Replying to [comment:6 neteler]:
> Please try attached patch

patch works for me in 6.5svn

thanks

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/1512#comment:7&gt;
GRASS GIS <http://grass.osgeo.org>

#1512: problem sql query on wingrass
---------------------------+------------------------------------------------
  Reporter: madi | Owner: grass-dev@…
      Type: defect | Status: closed
  Priority: critical | Milestone: 6.5.0
Component: wxGUI | Version: svn-develbranch6
Resolution: fixed | Keywords: sqlbuilder
  Platform: MSWindows XP | Cpu: Unspecified
---------------------------+------------------------------------------------
Changes (by neteler):

  * status: new => closed
  * resolution: => fixed

Comment:

Fixed in r49803. the winGRASS snapshot will contain the fix tomorrow
morning at circa 4am UTC.

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/1512#comment:8&gt;
GRASS GIS <http://grass.osgeo.org>