Error when adding query results via DB Manager

[qgib]

Author Name: Topi Tjukanov (@tjukanovt)
Original Redmine Issue: 21469
Affected QGIS version: 3.4.5
Redmine category:db_manager

---

When trying to add a new layer from PostGIS query results via DB Manager (Load as new layer) the layer doesn't get added, but instead I get the following error:

An error has occurred while executing Python code: 

AttributeError: 'DlgSqlWindow' object has no attribute '_getSqlExecutableQuery' 
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'


Python version: 3.7.0 (v3.7.0:1bf9cc5093, Jun 27 2018, 04:59:51) [MSC v.1914 64 bit (AMD64)] 
QGIS version: 3.6.0-Noosa Noosa, 58734527ab 

Python Path:
C:/PROGRA~1/QGIS3~1.6/apps/qgis/./python
C:/Users/T T/AppData/Roaming/QGIS/QGIS3\profiles\default/python
C:/Users/T T/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins
C:/PROGRA~1/QGIS3~1.6/apps/qgis/./python/plugins
C:\Program Files\QGIS 3.6\bin\python37.zip
C:\PROGRA~1\QGIS3~1.6\apps\Python37\DLLs
C:\PROGRA~1\QGIS3~1.6\apps\Python37\lib
C:\Program Files\QGIS 3.6\bin
C:\PROGRA~1\QGIS3~1.6\apps\Python37
C:\PROGRA~1\QGIS3~1.6\apps\Python37\lib\site-packages
C:\PROGRA~1\QGIS3~1.6\apps\Python37\lib\site-packages\win32
C:\PROGRA~1\QGIS3~1.6\apps\Python37\lib\site-packages\win32\lib
C:\PROGRA~1\QGIS3~1.6\apps\Python37\lib\site-packages\Pythonwin
C:/Users/T T/AppData/Roaming/QGIS/QGIS3\profiles\default/python

Error is in both 3.6 Nooa and 3.4.5 LTR

---

Related issue(s): #29370 (duplicates)
Redmine related issue(s): 21554

---

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Already fixed and backported, wait for the new builds/point releases.

---

• resolution was changed from to invalid
• status_id was changed from Open to Closed

[qgib]

Author Name: Alessandro Pasotti (@elpaso)

---

• duplicated was configured as query as view works in 2.14 LTR and does not in 3.4.5 LTR #29370