https://issues.qgis.org/https://issues.qgis.org/favicon.ico2013-09-21T11:27:18ZQGIS Issue TrackingQGIS Application - Bug report #8638: Spatialite layers are added as tables without geometries or "Error 11 Connection to database failed" errorhttps://issues.qgis.org/issues/8638?journal_id=448262013-09-21T11:27:18ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Subject</strong> changed from <i>DB manager: Spatialite layers are added as tables without geometries</i> to <i>DB manager (on windows standalone): Spatialite layers are added as tables without geometries</i></li></ul><p>update: on qgis 2.0 installed with osgeo4w is ok, the described issue appear just on qgis 2.0 installed with the standalone installer and ONLY if the SL db was created with QGIS standalone.</p>
<p>In fact even in qgis standalone, if the SL db was created with qgis osgeo4w then it behaves as expected.</p>
<p>Note:</p>
<p>creating a new SL db with qgis standalone take several seconds, while is very fast on osgeo4w. The DB created with qgis standalone does also shows a long list of tables that do not show if the db was created with qgis osgeo4w.</p> QGIS Application - Bug report #8638: Spatialite layers are added as tables without geometries or "Error 11 Connection to database failed" errorhttps://issues.qgis.org/issues/8638?journal_id=448272013-09-21T11:29:36ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Category</strong> changed from <i>DB Manager</i> to <i>Build/Install</i></li><li><strong>Target version</strong> changed from <i>Future Release - High Priority</i> to <i>Version 2.0.0</i></li></ul><p>so after all this seems a packaging issue.</p> QGIS Application - Bug report #8638: Spatialite layers are added as tables without geometries or "Error 11 Connection to database failed" errorhttps://issues.qgis.org/issues/8638?journal_id=448282013-09-21T11:50:49ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Subject</strong> changed from <i>DB manager (on windows standalone): Spatialite layers are added as tables without geometries</i> to <i>(Windows) Spatialite layers are added as tables without geometries or "Error 11 Connection to database failed" error</i></li><li><strong>Category</strong> changed from <i>Build/Install</i> to <i>Data Provider/SpatiaLite</i></li></ul><p>This is so frustrating... now I removed qgis 2.0/standalone, cleaned the system and installed again qgis 2.0/osgeo4w and I see the same issues I was seening on standalone...</p>
<p>it takes a long to create the SL sb, and now I can't even import shapes in it (d&d from browser, for example) as I get</p>
<p>Error 11<br />Connection to database failed</p> QGIS Application - Bug report #8638: Spatialite layers are added as tables without geometries or "Error 11 Connection to database failed" errorhttps://issues.qgis.org/issues/8638?journal_id=448292013-09-21T11:59:47ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>File</strong> <a href="/attachments/download/6251/sl_samples.zip">sl_samples.zip</a> added</li><li><strong>Subject</strong> changed from <i>(Windows) Spatialite layers are added as tables without geometries or "Error 11 Connection to database failed" error</i> to <i>Spatialite layers are added as tables without geometries or "Error 11 Connection to database failed" error</i></li></ul><p>adding sample SL db, one "good" and one not, both created with the same qgis installation (osgeo4w).</p> QGIS Application - Bug report #8638: Spatialite layers are added as tables without geometries or "Error 11 Connection to database failed" errorhttps://issues.qgis.org/issues/8638?journal_id=449152013-09-24T09:57:49Zaperi2007 -aperi2007@gmail.com
<ul></ul><p>I see a problem using the<br />menu commando:</p>
<p>new -> new spatialite layer</p>
<p>when set a new file name it (qgis) start to create a new spatialite , and this tkae many second.<br />On my pc about 60 seconda, but effectively my pc ha a very fast ssd hd.</p>
<p>I see also that the create of a new db will use the journaling mode.<br />That method (journal write) solution is the more slow.<br />Expecially is evere single insert is inside a single transacion.</p>
<p>I see the jounraling file will grow slowly from to 4 Mbyte.<br />When a db spatialite is create it need to have insede a table (spatialite-ref-sys) with many SRS definitiion.</p>
<p>I guess they are all inseted as many single insrt every one insed a single commit session.</p>
<p>I guess really best should be to disable the journaling method for the DB creation file.</p>
<p>Also I guess more better could be that the user can choose if act on the spatialite using journal or not.</p>
<p>Regards,</p>
<p>Andrea.</p> QGIS Application - Bug report #8638: Spatialite layers are added as tables without geometries or "Error 11 Connection to database failed" errorhttps://issues.qgis.org/issues/8638?journal_id=450372013-09-26T23:50:17ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Target version</strong> changed from <i>Version 2.0.0</i> to <i>Future Release - High Priority</i></li></ul><blockquote>
<p>when set a new file name it (qgis) start to create a new spatialite , and this tkae many second.<br />On my pc about 60 seconda, but effectively my pc ha a very fast ssd hd.</p>
</blockquote>
<p>on "normal" Windows machines it takes ages to create the SL DB, I have also a high machine and it takes ages on Linux too.</p>
<p>Then the resulting DB is "useless":</p>
<p>the imported layers are "missing" the geometry part or it gives the</p>
<p>"Error 11 Connection to database failed"</p>
<p>for example when D&D from browser and/or DB Manager.</p> QGIS Application - Bug report #8638: Spatialite layers are added as tables without geometries or "Error 11 Connection to database failed" errorhttps://issues.qgis.org/issues/8638?journal_id=455962013-10-15T00:18:30ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Resolution</strong> set to <i>fixed</i></li><li><strong>Status</strong> changed from <i>Open</i> to <i>Closed</i></li></ul><p>seems fixed by</p>
<p>#e04b426f00f86a154ff74ed6bda5727086596b0f</p>