multiedit in attribute table not working properly in version >=3.22

[paolomartinis]

What is the bug or the crash?

Issue A:
When activating the Toggle multi edit mode in the Attribute Table for a generic database layer (e.g. a geopackage), Qgis raises the alert Changes to this form will not be saved. One field doesn't meet their constraints.,

Issue B:
Bypassing the issue by removing the unique identifier field from the Attributes Form fields list, by pressing the Toggle multi edit mode button Qgis says Attribute changes for multiple features applied.. Every subsequent change will apply to all the elements, not just the selected one.
This bug will cause data losses, in a critically way for Postgis or other remote database layers.
With QGIS 3.16 everything worked fine.
I found other threads online reporting the same problem, but no other issues here: e.g. https://gis.stackexchange.com/questions/417285/qgis-3-22-automatic-changes-by-multiedit-in-attribute-table

Steps to reproduce the issue

0. Load a generic geopackage layer (e.g. the training_data.gpkg from https://docs.qgis.org/3.22/en/docs/training_manual/foreword/intro.html#data-downloadlink )
   Issue A:
1. Open the Attribute Table for the selected layer in the geopackage
2. Toggle the Toggle multi edit mode button
   Issue B:
3. Open the Attributes Form tab in the Layer properties dialog
4. Change the mode from autogenerate to drag and drop designer
5. Remove the fid field from the Form layout list
6. Open the Attribute Table for the selected layer in the geopackage
7. Toggle the Toggle multi edit mode button
8. Try to change one value for only some selected elements

Versions

QGIS version
3.22.5-Białowieża
QGIS code revision
c272317
Qt version
5.15.2
Python version
3.9.5
GDAL/OGR version
3.4.2
PROJ version
9.0.0
EPSG Registry database version
v10.054 (2022-02-13)
GEOS version
3.10.2-CAPI-1.16.0
SQLite version
3.38.1
PDAL version
2.3.0
PostgreSQL client version
13.0
SpatiaLite version
5.0.1
QWT version
6.1.3
QScintilla2 version
2.11.5
OS version
Windows 7 Version 6.1 (Build 22000)

Active Python plugins
AnotherDXF2Shape
1.2.3
Cxf_in
9.2
db-style-manager_MOD
0.9.0_MOD
GeofabrykaToolbox
0.5
GroupStats
2.2.5
idrostudi_toolbox
1.21
ImportEpanetInpFiles
1.6.3
joinmultiplelines
Version 0.4.1
mmqgis
2021.9.10
MultiEdit
1.1
multiple_layers_tools
1.2
nominatim
1.4.1
ntv2_transformations
0.20
plugin_reloader
0.9.1
QCopycanvas
0.5
qepanet
2.5
QGIS3_Delft3D_FM
1.0
QuickMultiAttributeEdit3
version 3.0.3
scriptrunner3
3.0.5
SpreadsheetLayers
2.0.1
StreetView
3.2
TerrainShading
0.9.3
wnt
1.3.4
db_manager
0.1.20
grassprovider
2.12.99
MetaSearch
0.3.5
processing
2.12.99
sagaprovider
2.12.99

Supported QGIS version

• I'm running a supported QGIS version according to the roadmap.

New profile

• I tried with a new QGIS profile

Additional context

No response

[elpaso]

Maybe related to #47223

[szppaks]

I got the the same error with Postgres, ver >=3.22.
QGIS want to update all fields (include the unique ID field), not just the modified. This cause the " Changes to this form will not be saved. One field doesn't meet their constraints" alert.
So, we are downgrading to 3.16 LTR.

[LKajan]

I think this should be adressed as regression.
Multi editing works on 3.16 but on 3.22 and on latest nightly unique constraints prevents using multi editing completly.

[paolomartinis]

editing of multiple attributes works in qgis >3.16 only by using the "Modify the attributes of all selected features simultaneously" button after selecting some features...

So I think that the problem is connected only to the table view...

[paolomartinis]

@elpaso
according to you, can the solution of this issue can be sponsorized in any way? who can possibly take care of it? how can i contact her/him? staying downgraded to 3.16 is starting to become a real problem...

[elpaso]

@paolomartinis I'm looking at the issue.

Regarding issue A:

I think that it is caused by the layer not having any selected feature.

Here is my proposal to fix it: instead of showing the warning, we show a nice info.

[elpaso]

Next time please file two separate issues for A and B, it is easier for us to handle atomic issues.

[rekjuh]

Just in case someone who has the same problem finds this issue and has to use QGIS version 3.28.6. or < 3.30. where the bug hasn't been fixed:

My customer just had the same problem as described in here part A ("Changes to this form will not be saved. One field doesn't meet their constraints." while trying to use multiedit in attribute table).

The problem could be solved by opening the Properties of the layer in question and going to the Attribute forms page. As the problem is in this case the ID field, select that from the list. Under the "Constraints" are "Enforce not null constraint" and "Enforce unique constraint". Try unchecking them. You have to either have both of them or only one of them unchecked. Now multiediting is possible without the getting the "One field doesn't meet their constraints".

Note! ID field is maybe the most important field of your layer, so you usually want each feature to have unique ID or not a null value as ID. If you multiedit other fields, QGIS won't change the IDs but always double-check that they remain unchanged. Alternatively uncheck "Editable" in the same place you made the previous changes (Properties > Attribute forms > ID). Now the ID field cannot be edited while you edit other values.

[szppaks]

Thanks for the tip! rekjuh ***@***.***> ezt írta (időpont: 2024. jan. 18., Cs, 8:07):

…

*Just in case someone who has the same problem finds this issue and has to use QGIS version 3.28.6. or < 3.30. where the bug hasn't been fixed:* My customer just had the same problem as described in here part A ("Changes to this form will not be saved. One field doesn't meet their constraints." while trying to use multiedit in attribute table). The problem could be solved by opening the Properties of the layer in question and going to the *Attribute forms* page. As the problem is in this case the ID field, select that from the list. Under the "Constraints" are "Enforce not null constraint" and "Enforce unique constraint". Try unchecking them. You have to either have both of them or only one of them unchecked. Now multiediting is possible without the getting the "One field doesn't meet their constraints". *Note!* ID field is maybe the most important field of your layer, so you usually want each feature to have unique ID or not a null value as ID. If you multiedit other fields, QGIS won't change the IDs but always double-check that they remain unchanged. Alternatively uncheck "Editable" in the same place you made the previous changes (Properties > Attribute forms > ID). Now the ID field cannot be edited while you edit other values. image.png (view on web) <https://github.com/qgis/QGIS/assets/87303508/29426d7a-286d-4ca6-a18b-37ca6dada0ab> — Reply to this email directly, view it on GitHub <#48077 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AGBF6SMQULLGJQGX6UT6JCLYPDC2HAVCNFSM5SPAXGAKU5DIOJSWCZC7NNSXTN2JONZXKZKDN5WW2ZLOOQ5TCOBZG44TEMBQG4YQ> . You are receiving this because you commented.Message ID: ***@***.***>

[mugabonkundi]

Thanks a lot!