[GRASS-dev] [GRASS GIS] #1143: WinGrass64RC7 - db.execute

GDAL · August 28, 2010, 7:38am

#1143: WinGrass64RC7 - db.execute
----------------------------------+-----------------------------------------
Reporter: hellik | Owner: grass-dev@…
Type: defect | Status: new
Priority: normal | Milestone: 6.4.0
Component: Database | Version: 6.4.0 RCs
Keywords: wingrass, db.execute | Platform: MSWindows Vista
Cpu: x86-32 |
----------------------------------+-----------------------------------------
Hi,

in WinGRASS-6.4.0RC7-1-Setup.exe, db.execute is greyed out in the wxgui-
pulldown-menue Database -> Query -> SQL statement (=db.execute).

after typing db.execute in the wxgui-command-line, the whole wxgui
freezes.

but in the msys-commandline I get the help for db.execute

{{{
GRASS 6.4> db.execute --help

Beschreibung:
Führt jegliche SQL-Abfrage aus.

Schlüsselwörter:
Datenbank, Attributtabelle, SQL

Benutzung:
db.execute [-i] [input=name] [driver=name] [database=name]
[--verbose] [--quiet]

Flags:
   -i Ignoriere SQL-Fehler und fahre fort.
  --v Detaillierter Ausgabemodus
  --q Schweigsamer Ausgabemodus

Parameter:
      input Name der Datei, die SQL-Befehle enthält.
     driver Treibername
              Optionen:
dbf,dbf.manifest,odbc,odbc.manifest,ogr,ogr.manifest,
                       pg,pg.manifest,sqlite,sqlite.manifest
               Standard: dbf
   database Datenbankname
               Standard: $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/
}}}

and with

{{{
GRASS 6.4> db.execute --ui
}}}

in the msys-commandline, the db.execute-wxgui pops up.

Helmut

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

GDAL · September 1, 2010, 9:23pm

#1143: WinGrass64RC7 - db.execute
----------------------------------+-----------------------------------------
Reporter: hellik | Owner: grass-dev@…
Type: defect | Status: new
Priority: blocker | Milestone: 6.4.0
Component: Database | Version: 6.4.0 RCs
Keywords: wingrass, db.execute | Platform: MSWindows Vista
Cpu: x86-32 |
----------------------------------+-----------------------------------------
Changes (by martinl):

* priority: normal => blocker

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/1143#comment:1>
GRASS GIS <http://grass.osgeo.org>

GDAL · September 1, 2010, 10:10pm

#1143: WinGrass64RC7 - db.execute
----------------------------------+-----------------------------------------
Reporter: hellik | Owner: grass-dev@…
Type: defect | Status: new
Priority: blocker | Milestone: 6.4.0
Component: Database | Version: 6.4.0 RCs
Keywords: wingrass, db.execute | Platform: MSWindows Vista
Cpu: x86-32 |
----------------------------------+-----------------------------------------

Comment(by martinl):

Replying to [ticket:1143 hellik]:
> in WinGRASS-6.4.0RC7-1-Setup.exe, db.execute is greyed out in the wxgui-
pulldown-menue Database -> Query -> SQL statement (=db.execute).

hopefully fixed in r43388.

> after typing db.execute in the wxgui-command-line, the whole wxgui
freezes.

seems to work on my PC.

Martin

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/1143#comment:2>
GRASS GIS <http://grass.osgeo.org>

GDAL · September 2, 2010, 4:05pm

#1143: WinGrass64RC7 - db.execute
----------------------------------+-----------------------------------------
Reporter: hellik | Owner: grass-dev@…
Type: defect | Status: new
Priority: blocker | Milestone: 6.4.0
Component: Database | Version: 6.4.0 RCs
Keywords: wingrass, db.execute | Platform: MSWindows Vista
Cpu: x86-32 |
----------------------------------+-----------------------------------------

Comment(by martinl):

Replying to [comment:2 martinl]:
> Replying to [ticket:1143 hellik]:
> > in WinGRASS-6.4.0RC7-1-Setup.exe, db.execute is greyed out in the
wxgui-pulldown-menue Database -> Query -> SQL statement (=db.execute).
>
> hopefully fixed in r43388.
>
> > after typing db.execute in the wxgui-command-line, the whole wxgui
freezes.
>
> seems to work on my PC.

Could anyone confirm that the bug was fixed? The only one blocker for
6.4.0... Thanks.

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/1143#comment:3>
GRASS GIS <http://grass.osgeo.org>

GDAL · September 2, 2010, 5:32pm

#1143: WinGrass64RC7 - db.execute
----------------------------------+-----------------------------------------
Reporter: hellik | Owner: grass-dev@…
Type: defect | Status: new
Priority: blocker | Milestone: 6.4.0
Component: Database | Version: 6.4.0 RCs
Keywords: wingrass, db.execute | Platform: MSWindows Vista
Cpu: x86-32 |
----------------------------------+-----------------------------------------

Comment(by hellik):

Replying to [comment:3 martinl]:
> Replying to [comment:2 martinl]:
> > Replying to [ticket:1143 hellik]:
> > > in WinGRASS-6.4.0RC7-1-Setup.exe, db.execute is greyed out in the
wxgui-pulldown-menue Database -> Query -> SQL statement (=db.execute).
> >
> > hopefully fixed in r43388.
> >
> > > after typing db.execute in the wxgui-command-line, the whole wxgui
freezes.
> >
> > seems to work on my PC.
>
> Could anyone confirm that the bug was fixed? The only one blocker for
6.4.0... Thanks.

there seems to be no nightly build from last night
(http://josef.fsv.cvut.cz/wingrass/grass64/). so I have to compile for
myself first.

Helmut

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/1143#comment:4>
GRASS GIS <http://grass.osgeo.org>

GDAL · September 2, 2010, 5:44pm

#1143: WinGrass64RC7 - db.execute
----------------------------------+-----------------------------------------
Reporter: hellik | Owner: grass-dev@…
Type: defect | Status: new
Priority: blocker | Milestone: 6.4.0
Component: Database | Version: 6.4.0 RCs
Keywords: wingrass, db.execute | Platform: MSWindows Vista
Cpu: x86-32 |
----------------------------------+-----------------------------------------

Comment(by martinl):

Replying to [comment:4 hellik]:

> there seems to be no nightly build from last night
(http://josef.fsv.cvut.cz/wingrass/grass64/). so I have to compile for
myself first.

hm, the Windows server is not responding. I need to ask the admin... So
unfortunately the builds are missing.

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/1143#comment:5>
GRASS GIS <http://grass.osgeo.org>

GDAL · September 2, 2010, 7:16pm

#1143: WinGrass64RC7 - db.execute
----------------------------------+-----------------------------------------
Reporter: hellik | Owner: grass-dev@…
Type: defect | Status: new
Priority: blocker | Milestone: 6.4.0
Component: Database | Version: 6.4.0 RCs
Keywords: wingrass, db.execute | Platform: MSWindows Vista
Cpu: x86-32 |
----------------------------------+-----------------------------------------

Comment(by hellik):

Replying to [comment:4 hellik]:
> Replying to [comment:3 martinl]:
> > Replying to [comment:2 martinl]:
> > > Replying to [ticket:1143 hellik]:
> > > > in WinGRASS-6.4.0RC7-1-Setup.exe, db.execute is greyed out in the
wxgui-pulldown-menue Database -> Query -> SQL statement (=db.execute).
> > >
> > > hopefully fixed in r43388.
> > >
> > > > after typing db.execute in the wxgui-command-line, the whole wxgui
freezes.
> > >
> > > seems to work on my PC.
> >
> > Could anyone confirm that the bug was fixed? The only one blocker for
6.4.0... Thanks.
>
> there seems to be no nightly build from last night
(http://josef.fsv.cvut.cz/wingrass/grass64/). so I have to compile for
myself first.
>
> Helmut

starting grass64 inside
C:\OSGeo4W\usr\src\grass64svn\bin.i686-pc-mingw32

db.execute isn't greyed out and db.execute also works from the wxgui-
commandline, there's no GUI-freezing.

I'll build locally a WinGrass64-installer and try this also.

Helmut

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/1143#comment:6>
GRASS GIS <http://grass.osgeo.org>

GDAL · September 2, 2010, 7:53pm

#1143: WinGrass64RC7 - db.execute
------------------------------+---------------------------------------------
  Reporter: hellik | Owner: grass-dev@…
      Type: defect | Status: closed
  Priority: blocker | Milestone: 6.4.0
Component: Database | Version: 6.4.0 RCs
Resolution: fixed | Keywords: wingrass, db.execute
  Platform: MSWindows Vista | Cpu: x86-32
------------------------------+---------------------------------------------
Changes (by hellik):

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

Comment:

Replying to [comment:6 hellik]:
> Replying to [comment:4 hellik]:
> > Replying to [comment:3 martinl]:
> > > Replying to [comment:2 martinl]:
> > > > Replying to [ticket:1143 hellik]:
> > > > > in WinGRASS-6.4.0RC7-1-Setup.exe, db.execute is greyed out in
the wxgui-pulldown-menue Database -> Query -> SQL statement (=db.execute).
> > > >
> > > > hopefully fixed in r43388.
> > > >
> > > > > after typing db.execute in the wxgui-command-line, the whole
wxgui freezes.
> > > >
> > > > seems to work on my PC.
> > >
> > > Could anyone confirm that the bug was fixed? The only one blocker
for 6.4.0... Thanks.
> >
> > there seems to be no nightly build from last night
(http://josef.fsv.cvut.cz/wingrass/grass64/). so I have to compile for
myself first.
> >
> > Helmut
>
> starting grass64 inside
> C:\OSGeo4W\usr\src\grass64svn\bin.i686-pc-mingw32
>
> db.execute isn't greyed out and db.execute also works from the wxgui-
commandline, there's no GUI-freezing.
>
> I'll build locally a WinGrass64-installer and try this also.
>
> Helmut

also tried with a self built WinGrass64-installer (r43388) - installed in
C:\Program Files\GRASS-64-SVN - all works fine now.

thanks for the fix.

I'll close the ticket.

Helmut

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/1143#comment:7>
GRASS GIS <http://grass.osgeo.org>

GDAL · September 3, 2010, 12:00pm

#1143: WinGrass64RC7 - db.execute
------------------------------+---------------------------------------------
  Reporter: hellik | Owner: grass-dev@…
      Type: defect | Status: closed
  Priority: blocker | Milestone: 6.4.0
Component: Database | Version: 6.4.0 RCs
Resolution: fixed | Keywords: wingrass, db.execute
  Platform: MSWindows Vista | Cpu: x86-32
------------------------------+---------------------------------------------

Comment(by martinl):

Replying to [comment:5 martinl]:
> Replying to [comment:4 hellik]:
>
> > there seems to be no nightly build from last night
(http://josef.fsv.cvut.cz/wingrass/grass64/). so I have to compile for
myself first.
>
> hm, the Windows server is not responding. I need to ask the admin... So
unfortunately the builds are missing.

daily builds are back.

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/1143#comment:8>
GRASS GIS <http://grass.osgeo.org>