[Qgis-user] Splitting Spatialite layers

Randal Hale rjhale at northrivergeographic.com
Sun Dec 11 17:46:29 PST 2016


You're hitting a bug that exists in QGIS 2.16 and 2.18 - They are 
working on a resolution.

See Below:

http://hub.qgis.org/issues/15847


On 12/11/2016 08:39 PM, custard wrote:
> Hi All,
>
> As a  mostly shape/tab file user, I've been attempting to experiment 
> with spatialite dbs a bit recently, and am starting to get a bit more 
> used to them. I'm hitting a problem with splitting objects though, and 
> wondered if this annoyance counted as a bug?
>
> If I have a spatialite layer and split an object, that's fine. But 
> when I save the layer I get a "Could not commit changes to layer 
> LayerName" banner. If I press "Show more" then I get something like this:
> _____
>
> Could not commit changes to layer layername
>
>
> Errors: SUCCESS: 1 geometries were changed.
>
> SUCCESS: 1 attribute value(s) changed.
>
> ERROR: 4 feature(s) not added.
>
> Provider errors:
>
> SQLite error: UNIQUE constraint failed: LayerName.pkuid
>
> SQL: INSERT INTO 
> "layername"("geometry","pkuid","Code","Lith","Description","Quality","code1","lith1","description1","quality1") 
> VALUES (ST_Multi(GeomFromWKB(?, 28351)),?,?,?,?,?,?,?,?,?)
>
> ____
>
>
> I'm not populaing the pkuid data, so I think QGIS is auto filling this.
>
> I think that what's happening is that when QGIS splits the feature 
> both new parts have the same pkuid number. Certainly if I go in 
> manually and change the field I can save without errors.
>
> If QGIS is auto filling this column, ought it not be handling the 
> splitting case too?
>
>
> Thoughts?
>
> -ramon.
>
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
------------------------------------------------
Randal Hale
North River Geographic Systems, Inc
http://www.northrivergeographic.com
423.653.3611 rjhale at northrivergeographic.com
twitter:rjhale     http://about.me/rjhale
http://www.northrivergeographic.com/introduction-to-quantum-gis
https://www.facebook.com/NRGSInc

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20161211/b4a6f818/attachment.html>


More information about the Qgis-user mailing list