Bug report #21434

Create SQL-Layer from DB-Manager

Added by Michael Otto over 5 years ago. Updated over 5 years ago.

Status:Closed
Priority:High
Assignee:-
Category:Python plugins
Affected QGIS version:3.6.0 Regression?:No
Operating System:Windows 10 Easy fix?:No
Pull Request or Patch supplied:Yes Resolution:duplicate
Crashes QGIS or corrupts data:No Copied to github as #:29251

Description

I will create a new Layer of a Oracle-Spatial DB by using a SQL-Command in DB-Manager.
The query works. Results are shown in the table.
But when i check "add as new layer" with id and geometry rows defined nothing will happens.
No layer is created and the following error appears on the python-log.

2019-03-01T08:52:39 WARNING Traceback (most recent call last):
File "C:/PROGRA~1/QGIS3~1.6/apps/qgis/./python/plugins\db_manager\dlg_sql_window.py", line 434, in loadSqlLayer
layer = self._getSqlLayer(self.filter)
File "C:/PROGRA~1/QGIS3~1.6/apps/qgis/./python/plugins\db_manager\dlg_sql_window.py", line 396, in _getSqlLayer
query = self._getSqlExecutableQuery()
AttributeError: 'DlgSqlWindow' object has no attribute '_getSqlExecutableQuery'

2019-03-01T08:52:56 WARNING Traceback (most recent call last):
File "C:/PROGRA~1/QGIS3~1.6/apps/qgis/./python/plugins\db_manager\dlg_sql_window.py", line 628, in setFilter
layer = self._getSqlLayer("")
File "C:/PROGRA~1/QGIS3~1.6/apps/qgis/./python/plugins\db_manager\dlg_sql_window.py", line 396, in _getSqlLayer
query = self._getSqlExecutableQuery()
AttributeError: 'DlgSqlWindow' object has no attribute '_getSqlExecutableQuery'


Related issues

Duplicates QGIS Application - Bug report #21353: Query from DB Manager SQL window no longer loads as new l... Closed 2019-02-22

History

#1 Updated by Alessandro Pasotti over 5 years ago

  • Duplicates Bug report #21353: Query from DB Manager SQL window no longer loads as new layer added

#2 Updated by Alessandro Pasotti over 5 years ago

  • Resolution set to duplicate
  • Status changed from Open to Closed

Also available in: Atom PDF