QGIS 3.6 - can't load new Postgis layer using DB Manager

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

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
_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Reply | Threaded
Open this post in threaded view
|

Re: QGIS 3.6 - can't load new Postgis layer using DB Manager

Jürgen E. Fischer
Hi Czenda,

On Thu, 28. Feb 2019 at 20:21:05 -0700, CzendaZdenda wrote:

> *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'
See https://issues.qgis.org/issues/21353


Jürgen

--
Jürgen E. Fischer           norBIT GmbH             Tel. +49-4931-918175-31
Dipl.-Inf. (FH)             Rheinstraße 13          Fax. +49-4931-918175-50
Software Engineer           D-26506 Norden            https://www.norbit.de
QGIS release manager (PSC)  Germany                    IRC: jef on FreeNode

norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH
Rheinstrasse 13, 26506 Norden
GF: Juergen Fischer, Nils Kutscher HR: Amtsgericht Aurich HRB 100827
Datenschutzerklaerung: https://www.norbit.de/83/

_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

signature.asc (844 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: QGIS 3.6 - can't load new Postgis layer using DB Manager

CzendaZdenda
Thanks a lot Jürgen :)

For now, I just changed "_getSqlExecutableQuery()" to
"_getExecutableSqlQuery()" at DB Manager plugin.

Have a nice day :)



--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
_______________________________________________
Qgis-user mailing list
[hidden email]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user