Spatialite layer - impossible save edits with multiple selections field

[qgib]

Author Name: Darek Bobak (Darek Bobak)
Original Redmine Issue: 12899
Affected QGIS version: master
Redmine category:data_provider/spatialite

---

When in field properties of spatialite layer I choose Value Relation for widget properties and allow multiple selections for the field (see attached screenshot) it is not possible to save edits, I'm receiving the following error:

Could not commit changes to layer sites_pts kopia
Errors: ERROR: 1 attribute value change(s) not applied.
  Provider errors:
      SQLite error: unrecognized token: "{"
    SQL: 

Here is the info of my QGIS configuration:

QGIS version 2.9.0-Master              QGIS code revision 7aae459
Compiled against Qt 4.8.5              Running against Qt 4.8.5
Compiled against GDAL/OGR 1.11.2       Running against GDAL/OGR 1.11.2
Compiled against GEOS 3.4.2-CAPI-1.8.2 Running against GEOS 3.4.2-CAPI-1.8.2 r3921
PostgreSQL Client Version 9.2.4        SpatiaLite Version 4.1.1
QWT Version 5.2.3                      PROJ.4 Version 480
QScintilla2 Version 2.7.2
This copy of QGIS writes debugging output.

---

• Zrzut_ekranu_2015-06-06_19.38.35.png (Darek Bobak)
• sample_map.qgs (Darek Bobak)
• sites_db.sqlite (Darek Bobak)

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

I cannot confirm here. Maybe it depends on the data type of columns? Attaching a sample project/data would help a lot the troubleshooting.

---

• status_id was changed from Open to Feedback
• category_id was configured as Data Provider/SpatiaLite

[qgib]

Author Name: Darek Bobak (Darek Bobak)

---

Yes, indeed, when I've added a new layer (which source was the same as the problematic one), this new layer works as it expected. But the old layer (added some times ago, probably in the older version of QGIS) still does not allow to use multiple selections. I'm attaching project and the spatialite database. The problematic layer is "sites_pts_problem", the "sites_pts_ok" is a working one. The "tmp" field is the field with multiple selections and the table "dic_date_types" is a source of values.

---

• 8788 was configured as sites_db.sqlite
• 8787 was configured as sample_map.qgs

---

• sites_db.sqlite (Darek Bobak)
• sample_map.qgs (Darek Bobak)

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• status_id was changed from Feedback to Open
• priority_id was changed from Normal to Low
• os_version was changed from 8.1 64 bit Pro Polish to
• operating_system was changed from Windows to
• fixed_version_id was configured as Future Release - Lower Priority

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

@integer@ columns cannot contain multiple selections. Use text fields (like the tmp from the working layer).

---

• resolution was changed from to invalid
• status_id was changed from Open to Closed