Bug report #5200
RT_Sql_layer: error python on startup
| Status: | Closed | ||
|---|---|---|---|
| Priority: | Normal | ||
| Assignee: | |||
| Category: | Python plugins | ||
| Affected QGIS version: | master | Regression?: | No |
| Operating System: | Easy fix?: | No | |
| Pull Request or Patch supplied: | No | Resolution: | invalid |
| Crashes QGIS or corrupts data: | No | Copied to github as #: | 14940 |
Description
Hi,
When I choose, in the RT_Sql_Layer a db-connection on postgis,
I have this python error:
An error has occured while executing Python code:
Traceback (most recent call last):
File "C:\\Users\\peri/.qgis/python/plugins\
t_sql_layer\\ManagerWindow.py", line 112, in dbConnectSlot
self.dbConnect( self.sender() )
File "C:\\Users\\peri/.qgis/python/plugins\
t_sql_layer\\ManagerWindow.py", line 168, in dbConnect
self.dbInfo()
File "C:\\Users\\peri/.qgis/python/plugins\
t_sql_layer\\ManagerWindow.py", line 251, in dbInfo
self.updateView()
File "C:\\Users\\peri/.qgis/python/plugins\
t_sql_layer\\ManagerWindow.py", line 318, in updateView
self.tabChanged( self.tabs.currentIndex() )
File "C:\\Users\\peri/.qgis/python/plugins\
t_sql_layer\\ManagerWindow.py", line 221, in tabChanged
self.txtMetadata.showDbInfo()
File "C:\\Users\\peri/.qgis/python/plugins\
t_sql_layer\\MetadataBrowser.py", line 34, in showDbInfo
gis_info = self.db.get_spatial_info()
File "C:\\Users\\peri/.qgis/python/plugins\
t_sql_layer\\connectors\\postgis.py", line 192, in get_spatial_info
self._exec_sql(c, "SELECT postgis_lib_version(), postgis_scripts_installed(), postgis_scripts_released(), postgis_geos_version(), postgis_proj_version(), postgis_uses_stats()")
File "C:\\Users\\peri/.qgis/python/plugins\
t_sql_layer\\connectors\\postgis.py", line 783, in _exec_sql
raise DbError(e)
DbError: function postgis_uses_stats() does not exist
LINE 1: ..., postgis_geos_version(), postgis_proj_version(), postgis_us...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
Query:
SELECT postgis_lib_version(), postgis_scripts_installed(), postgis_scripts_released(), postgis_geos_version(), postgis_proj_version(), postgis_uses_stats()
Python version:
2.7.2 (default, Jun 12 2011, 15:08:59) [MSC v.1500 32 bit (Intel)]
QGIS version:
1.9.90-Alpha Alpha, c5769bf
Python path: ['C:\\\\Users\\\\peri\\\\.qgis\\\\python\\\\plugins\\\\cswclient', 'C:/osgeo4w/apps/qgis-dev/./python', 'C:\\\\Users\\\\peri/.qgis/python', 'C:\\\\Users\\\\peri/.qgis/python/plugins', 'C:/osgeo4w/apps/qgis-dev/./python/plugins', 'C:\\\\osgeo4w\\\\apps\\\\orfeotoolbox\\\\python', 'C:\\\\', 'C:\\\\osgeo4w\\\\bin\\\\python27.zip', 'C:\\\\osgeo4w\\\\apps\\\\Python27\\\\DLLs', 'C:\\\\osgeo4w\\\\apps\\\\Python27\\\\lib', 'C:\\\\osgeo4w\\\\apps\\\\Python27\\\\lib\\\\plat-win', 'C:\\\\osgeo4w\\\\apps\\\\Python27\\\\lib\\\\lib-tk', 'C:\\\\osgeo4w\\\\apps\\\\qgis-dev\\\\bin', 'C:\\\\osgeo4w\\\\apps\\\\Python27', 'C:\\\\osgeo4w\\\\apps\\\\Python27\\\\lib\\\\site-packages', 'C:\\\\osgeo4w\\\\apps\\\\Python27\\\\lib\\\\site-packages\\\\PIL', 'C:\\\\osgeo4w\\\\apps\\\\Python27\\\\lib\\\\site-packages\\\\win32', 'C:\\\\osgeo4w\\\\apps\\\\Python27\\\\lib\\\\site-packages\\\\win32\\\\lib', 'C:\\\\osgeo4w\\\\apps\\\\Python27\\\\lib\\\\site-packages\\\\Pythonwin', 'C:\\\\osgeo4w\\\\apps\\\\Python27\\\\lib\\\\site-packages\\\\wx-2.8-msw-unicode', '.', 'C:\\\\Users\\\\peri\\\\.qgis\\\\python\\\\plugins\\\\QuickMultiAttributeEdit/forms', 'C:\\\\osgeo4w\\\\apps\\\\qgis-dev\\\\python\\\\plugins\\\\fTools\\\\tools']
I'm using postgis 2.0 beta3 version for windows
History
#1
Updated by Giuseppe Sucameli over 13 years ago
- Resolution set to invalid
- Assignee changed from Paolo Cavallini to Giuseppe Sucameli
- Status changed from Open to Closed
QGis trac is the wrong place to open ticket for non-core plugins.
I moved your ticket to the RT_Sql_layer plugin trac, now it's #5201.