<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>You're hitting a bug that exists in QGIS 2.16 and 2.18 - They are
working on a resolution. <br>
</p>
<p>See Below: <br>
</p>
<p><a class="moz-txt-link-freetext" href="http://hub.qgis.org/issues/15847">http://hub.qgis.org/issues/15847</a></p>
<br>
<div class="moz-cite-prefix">On 12/11/2016 08:39 PM, custard wrote:<br>
</div>
<blockquote
cite="mid:2ddf4f6c64c57cc35888c5a3f2139cdc6fe36525@webmail.westnet.com.au"
type="cite">Hi All,
<div><br>
</div>
<div>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?</div>
<div><br>
</div>
<div>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:</div>
<div>_____</div>
<div>
<p style="margin:0px;">Could not commit changes to layer
layername</p>
<p style="margin:0px;"><br>
</p>
<p style="margin:0px;">Errors: SUCCESS: 1 geometries were
changed.</p>
<p style="margin:0px;"> SUCCESS: 1 attribute value(s) changed.</p>
<p style="margin:0px;"> ERROR: 4 feature(s) not added.</p>
<p style="margin:0px;"> </p>
<p style="margin:0px;"> Provider errors:</p>
<p style="margin:0px;"> SQLite error: UNIQUE constraint failed:
LayerName.pkuid</p>
<p style="margin:0px;"> SQL: INSERT INTO
"layername"("geometry","pkuid","Code","Lith","Description","Quality","code1","lith1","description1","quality1")
VALUES (ST_Multi(GeomFromWKB(?, 28351)),?,?,?,?,?,?,?,?,?)</p>
<p style="margin:0px;">____</p>
<p style="margin:0px;"><br>
</p>
<p style="margin:0px;">I'm not populaing the pkuid data, so I
think QGIS is auto filling this.</p>
<p style="margin:0px;">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.</p>
<p style="margin:0px;">
If QGIS is auto filling this column, ought it not be handling
the splitting case too?</p>
<p style="margin:0px;"><br>
</p>
<p style="margin:0px;">Thoughts?</p>
<p style="margin:0px;">-ramon.</p>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
------------------------------------------------
Randal Hale
North River Geographic Systems, Inc
<a class="moz-txt-link-freetext" href="http://www.northrivergeographic.com">http://www.northrivergeographic.com</a>
423.653.3611 <a class="moz-txt-link-abbreviated" href="mailto:rjhale@northrivergeographic.com">rjhale@northrivergeographic.com</a>
twitter:rjhale <a class="moz-txt-link-freetext" href="http://about.me/rjhale">http://about.me/rjhale</a>
<a class="moz-txt-link-freetext" href="http://www.northrivergeographic.com/introduction-to-quantum-gis">http://www.northrivergeographic.com/introduction-to-quantum-gis</a>
<a class="moz-txt-link-freetext" href="https://www.facebook.com/NRGSInc">https://www.facebook.com/NRGSInc</a></pre>
</body>
</html>