search

3dcitydb / 3dcitydb-qgis-explorer

QGIS Plugin for working the the 3DCityDB
GNU General Public License v2.0
7 stars 5 forks source link

Error getting SRS from Database #6

Open andreasborgardt opened 3 years ago

andreasborgardt commented 3 years ago

Hi,

i'm runnig Postgresql 13.8 with PostGIS 3.1.4 on Debian 8.4. When I try to use your Plugin the following error occurs in QGIS.

QGIS-Log:

File "C:\Users/........../AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\3dcitydb-qgis-explorer-master\db\postgresql.py", line 157, in srs cursor.execute(SQL) psycopg2.errors.InFailedSqlTransaction: current transaction is aborted, commands ignored until end of transaction block

         During handling of the above exception, another exception occurred:

         Traceback (most recent call last):
          File "C:\Users/aborgardt/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\3dcitydb-qgis-explorer-master\citydb_explorer_dockwidget.py", line 130, in _database_connection
          self.srs = self.db_interface.srs
          File "C:\Users/........../AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\3dcitydb-qgis-explorer-master\db\postgresql.py", line 159, in srs
          raise PostgreSQLInterfaceException("Error getting SRS from Database")
         3dcitydb-qgis-explorer-master.db.postgresql.PostgreSQLInterfaceException: Error getting SRS from Database

Importer/Exporter-Log:

[15:33:43 INFO] SRID: 25832 (Projected) [15:33:43 INFO] gml:srsName: urn:ogc:def:crs,crs:EPSG::25832,crs:EPSG::7837

The table database_srs ist filled. It seems to be everything alright...

Best Andreas

muratkendir commented 3 years ago

@andreasborgardt It seems like project variables confused about path at: "C:\Users/aborgardt/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\3dcitydb-qgis-explorer-master\citydb_explorer_dockwidget.py"

Did you tried to use on a new project created on Debian system or do you using an existing project, which created on a windows machine?

Note: I tested same extension on Ubuntu without any connection problem.