https://issues.qgis.org/https://issues.qgis.org/favicon.ico2013-06-22T00:32:11ZQGIS Issue TrackingQGIS Application - Bug report #8099: Spatialite errors not meaningfulhttps://issues.qgis.org/issues/8099?journal_id=422522013-06-22T00:32:11ZJürgen Fischerjef@norbit.de
<ul><li><strong>Subject</strong> changed from <i>Spatialite errors not meaninful</i> to <i>Spatialite errors not meaningful</i></li></ul> QGIS Application - Bug report #8099: Spatialite errors not meaningfulhttps://issues.qgis.org/issues/8099?journal_id=422532013-06-22T00:33:10ZJürgen Fischerjef@norbit.de
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Closed</i></li></ul><p>Fixed in changeset <a class="changeset" href="https://issues.qgis.org/projects/qgis/repository/revisions/ef838c799f2a7e01b2057adc04c29d4bb484c2b7" title="fix #8099: useful error message on table_info">ef838c799f2a7e01b2057adc04c29d4bb484c2b7</a>.</p> QGIS Application - Bug report #8099: Spatialite errors not meaningfulhttps://issues.qgis.org/issues/8099?journal_id=422552013-06-22T00:42:11ZMatthias Kuhn
<ul><li><strong>Status</strong> changed from <i>Closed</i> to <i>Reopened</i></li></ul><p>This patch does not solve the problem on a database with existing tables, but missing columns.</p>
<p>ogr2ogr produced such a database here:<br /><pre>
sqlite> PRAGMA table_info(geometry_columns);
0|f_table_name|VARCHAR|0||0
1|f_geometry_column|VARCHAR|0||0
2|geometry_type|INTEGER|0||0
3|coord_dimension|INTEGER|0||0
4|srid|INTEGER|0||0
5|geometry_format|VARCHAR|0||0
sqlite> PRAGMA table_info(spatial_ref_sys);
0|srid|INTEGER|0||0
1|auth_name|TEXT|0||0
2|auth_srid|TEXT|0||0
3|srtext|TEXT|0||0
</pre></p>
<p>This also makes me wonder if the columns being checked here are really all needed?</p> QGIS Application - Bug report #8099: Spatialite errors not meaningfulhttps://issues.qgis.org/issues/8099?journal_id=452212013-10-01T05:12:32ZJürgen Fischerjef@norbit.de
<ul><li><strong>Status</strong> changed from <i>Reopened</i> to <i>Closed</i></li></ul><p>Fixed in changeset <a class="changeset" href="https://issues.qgis.org/projects/qgis/repository/revisions/ef838c799f2a7e01b2057adc04c29d4bb484c2b7" title="fix #8099: useful error message on table_info">ef838c799f2a7e01b2057adc04c29d4bb484c2b7</a>.</p>