[QGIS-Developer] Creation error for Spatialite layer

Bo Victor Thomsen bo.victor.thomsen at gmail.com
Mon Mar 9 03:10:01 PDT 2020

Hi list -

I've stumbled into a severe - possible regression - error trying to 
crate a Spatialite layer with anĀ  autoincrementing id field.

Steps to recreate error:

 1. Create a spatialite layer in QGIS
 2. Check the "Create a autoincrementing primary key" checkbox (Which
    correctly create a autoincrementing pkid)
 3. create a record by digitizing
 4. Try to save the record

The following error message appears:

The SQL statement is obviously wrong, missing the name of pkid field

I get the error in both QGIS 3.10.3 - 64 bit and 3.12.0 - 64 bit on 
Windows 8.1

I remember doing this working correctly in QGIS ver. 2.x.

Can anyone confirm this error before i report it ?

Med venlig hilsen / Kind regards

Bo Victor Thomsen

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20200309/df0a8733/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ofnpgaljbfbhcdic.png
Type: image/png
Size: 11590 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20200309/df0a8733/attachment-0001.png>

More information about the QGIS-Developer mailing list