[Qgis-user] DB manager error

Gustavo Martínez gmpuljak at yahoo.com.ar
Fri Oct 28 12:09:26 PDT 2016



Hi, 

I'm using QGIS 2.99.0-Master rev. b2587b7 on Ubuntu 16.04 64bits.

When I tried to open a SQL query on a POSTGIS database I've got the following error while trying to open the saved connection to the database: 

2016-10-28T15:58:35	1	Traceback (most recent call last):

			  File "/usr/share/qgis/python/plugins/db_manager/db_model.py", line 440, in rowCount

			    self._refreshIndex(parent, True)

			  File "/usr/share/qgis/python/plugins/db_manager/db_model.py", line 491, in _refreshIndex

			    if item.populate():

			  File "/usr/share/qgis/python/plugins/db_manager/db_model.py", line 166, in populate

			    if not connection.connect():

			  File "/usr/share/qgis/python/plugins/db_manager/db_plugins/postgis/plugin.py", line 99, in connect

			    return self.connectToUri(uri)

			  File "/usr/share/qgis/python/plugins/db_manager/db_plugins/plugin.py", line 108, in connectToUri

			    self.db = self.databasesFactory(self, uri)

			  File "/usr/share/qgis/python/plugins/db_manager/db_plugins/postgis/plugin.py", line 69, in databasesFactory

			    return PGDatabase(connection, uri)

			  File "/usr/share/qgis/python/plugins/db_manager/db_plugins/postgis/plugin.py", line 107, in __init__

			    Database.__init__(self, connection, uri)

			  File "/usr/share/qgis/python/plugins/db_manager/db_plugins/plugin.py", line 217, in __init__

			    self.connector = self.connectorsFactory(uri)

			  File "/usr/share/qgis/python/plugins/db_manager/db_plugins/postgis/plugin.py", line 110, in connectorsFactory

			    return PostGisDBConnector(uri)

			  File "/usr/share/qgis/python/plugins/db_manager/db_plugins/postgis/connector.py", line 67, in __init__

			    self.connection = psycopg2.connect(expandedConnInfo.encode('utf-8'))

			  File "/usr/lib/python3/dist-packages/psycopg2/__init__.py", line 164, in connect

			    conn = _connect(dsn, connection_factory=connection_factory, async=async)

			TypeError: argument 1 must be str, not bytes


I can load postgis layers from the same connection without problems.
What can I do?
Thanks,



Gustavo


			



More information about the Qgis-user mailing list