search

qgis / QGIS

QGIS is a free, open source, cross platform (lin/win/mac) geographical information system (GIS)
https://qgis.org
GNU General Public License v2.0
10.29k stars 2.96k forks source link

DB Manager is not showing the result after a SQL query #26242

Closed qgib closed 6 years ago

qgib commented 6 years ago

Author Name: Etienne Trimaille (@Gustry) Original Redmine Issue: 18352 Affected QGIS version: 3.1(master) Redmine category:db_manager Assignee: Paul Blottiere

On QGIS Master 3.1, after I run a simple query such as select * from my_table, the result panel stays empty.

The query works well in QGIS 3.0 and in PgAdmin. But in 3.1, I can guess that the query is running because the panel is disabled while the query is running in the background. But then, the window is reactivated again but the result is not displayed.

It might be related to the display with MacOS?

qgib commented 6 years ago

Author Name: Giovanni Manghi (@gioman)

qgib commented 6 years ago

Author Name: Keith Jenkins (@kgjenkins)

I don't think it is related to MacOS, since I'm seeing the same problem with QGIS 3.1.0-Master (5b8599e9bb) on Windows.

It works when I run a query via Virtual Layers, but not with PostGIS directly, in which case I see a "Task Complete" notification, but no results.

The following Python error is logged:

WARNING
Traceback (most recent call last):
  File "C:/PROGRA~1/QGIS2~1.18/apps/qgis-dev/./python/plugins\db_manager\dlg_sql_window.py", line 233, in executeSqlCompleted
  if self.modelAsync.task.status() == QgsTask.Complete:
AttributeError: 'NoneType' object has no attribute 'status'
qgib commented 6 years ago

Author Name: Regis Haubourg (@haubourg)

PR here [[https://github.com/qgis/QGIS/pull/6553]]

qgib commented 6 years ago

Author Name: Paul Blottiere (Paul Blottiere)

Applied in changeset 6bdee5b79e667812fe0e7848da3be999cd197f82.

qgib commented 6 years ago

Author Name: Giovanni Manghi (@gioman)