<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div>Ah. Thanks.</div><div id="AppleMailSignature"><br></div><div id="AppleMailSignature">Can I echo Richard's request for a back port?</div><div id="AppleMailSignature"><br>-ramon.</div><div><br>On 12 Dec. 2016, at 09:46, Randal Hale <<a href="mailto:rjhale@northrivergeographic.com">rjhale@northrivergeographic.com</a>> wrote:<br><br></div><blockquote type="cite"><div>
  
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  
  
    <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>
  

</div></blockquote></body></html>