ERROR in attributes cells in spatialite layer table

[qgib]

Author Name: enrico ferreguti (@enricofer)
Original Redmine Issue: 10567
Affected QGIS version: 2.2.0
Redmine category:data_provider/spatialite

---

When I load a spatialite view as layer I see it right on map and I can get info, but when I open the attributes table I get always ERROR values. The view was create with Qspatialite plugin.

---

• issue.jpg (enrico ferreguti)

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

it is a plugin or QGIS issue? what happens if you create the view in DB manager? or from the SL command line? or SL gui?

---

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

[qgib]

Author Name: Antonio Locandro (Antonio Locandro)

---

Having the same issue, it is a QGIS issue as I used the spatialite icon to add the layer. I created the view outside of QGIS directly using spatialite_gui so this means the problem is within QGIS.

When you use the identify results button you get the table information but if you open the attribute table what you get is ERROR in all the cells.

When I try to select one single feature from the view using the select tool all the features get selected, so this may be also related to this issue.

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Antonio Locandro wrote:

Having the same issue, it is a QGIS issue as I used the spatialite icon to add the layer. I created the view outside of QGIS directly using spatialite_gui so this means the problem is within QGIS.

When you use the identify results button you get the table information but if you open the attribute table what you get is ERROR in all the cells.

When I try to select one single feature from the view using the select tool all the features get selected, so this may be also related to this issue.

I have just tested on QGIS 2.4 on Linux and I can't replicate the same issue. I used a SL database created empty in QGIS 2.4 and imported a shapefile in it with DB manager. The view then was done using spatialite_gui.

Please attach the SL db that contains the layer and the view.

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Closing for lack of feedback, please reopen if necessary.

---

• resolution was changed from to worksforme
• status_id was changed from Feedback to Closed