[Qgis-user] QGIS 3.6 - can't load new Postgis layer using DB Manager

[CzendaZdenda]

Hi all,

I am using Windows 10 64-bit, via OSGEO4W I have installed QGIS. Everything
works ok, but when I update QGIS to version 3.6.0-Noosa and QGIS
3.4.5-Madeira (as LTR) I can't load new Postgis layers using DB Manager and
its query window. I can add directly whole table (with geometry column)
using 'Add to Canvas'. But when I want to "Load" layer from query window, I
get an error:

*QGIS 3.6.0*
File
"D:/OSGeo4W64/apps/qgis-ltr/./python/plugins\db_manager\dlg_sql_window.py",
line 396, in loadSqlLayer
layer = self._getSqlLayer(self.filter)
File
"D:/OSGeo4W64/apps/qgis-ltr/./python/plugins\db_manager\dlg_sql_window.py",
line 358, in _getSqlLayer
query = self._getSqlExecutableQuery()
AttributeError: 'DlgSqlWindow' object has no attribute
'_getSqlExecutableQuery'


*QGIS 3.4.5*
File "D:/OSGeo4W64/apps/qgis/./python/plugins\db_manager\dlg_sql_window.py",
line 434, in loadSqlLayer
layer = self._getSqlLayer(self.filter)
File "D:/OSGeo4W64/apps/qgis/./python/plugins\db_manager\dlg_sql_window.py",
line 396, in _getSqlLayer
query = self._getSqlExecutableQuery()
AttributeError: 'DlgSqlWindow' object has no attribute
'_getSqlExecutableQuery'

I can also load new Postgis layer using pyqgis. When I open old projects old
layers are loaded without any problem also.

It looks like GUI issue (DlgSqlWindow).

Maybe it is not connected with updating to new QGIS version, but does
anybody know, how to fix it?

Thanks,
Czenda

             



--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html