Hi all, dropping a shp with a strange prj (attached, recognized as EPSG:102091) into a gpkg results in an error [0]. What is worse, the db becomes apparently unusable. Data available, I can do further tests if useful. Thanks.
---
[0]
An error has occurred while executing Python code:
RuntimeError: In ExecuteSQL(): sqlite3_prepare_v2(SELECT srid FROM
gpkg_spatial_ref_sys WHERE table_name = 'animals'): no such column: srid
Traceback (most recent call last):
File "/usr/share/qgis/python/plugins/db_manager/db_model.py", line
438, in rowCount
self._refreshIndex(parent, True)
File "/usr/share/qgis/python/plugins/db_manager/db_model.py", line
489, in _refreshIndex
if item.populate():
File "/usr/share/qgis/python/plugins/db_manager/db_model.py", line
180, in populate
tables = database.tables()
File "/usr/share/qgis/python/plugins/db_manager/db_plugins/plugin.py",
line 510, in tables
tables = self.connector.getTables(schema.name if schema else None,
sys_tables)
File
"/usr/share/qgis/python/plugins/db_manager/db_plugins/gpkg/connector.py",
line 274, in getTables
vectors = self.getVectorTables(schema)
File
"/usr/share/qgis/python/plugins/db_manager/db_plugins/gpkg/connector.py",
line 346, in getVectorTables
srid = self._fetchOne('SELECT srid FROM gpkg_spatial_ref_sys WHERE
table_name = %s' % self.quoteString(lyr.GetName()))
File
"/usr/share/qgis/python/plugins/db_manager/db_plugins/gpkg/connector.py",
line 104, in _fetchOne
sql_lyr = self.gdal_ds.ExecuteSQL(sql.encode('UTF-8'))
File "/usr/lib/python2.7/dist-packages/osgeo/gdal.py", line 1966, in
ExecuteSQL
return _gdal.Dataset_ExecuteSQL(self, *args, **kwargs)
RuntimeError: In ExecuteSQL(): sqlite3_prepare_v2(SELECT srid FROM
gpkg_spatial_ref_sys WHERE table_name = 'animals'):
no such column: srid
--
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
https://www.google.com/trends/explore?date=all&geo=IT&q=qgis,arcgis
animals.prj
Description: application/esri-crs
_______________________________________________ QGIS-Developer mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
