[Qgis-user] Newly added SpatiaLite fields now missing in attribute table

[Chrest, David]

OK, that's really too bad. That pretty much eliminates me using spatiaLite layers. Hope this gets fixed soon.
At the end of the web page in http://hub.qgis.org/issues/8923 two SQL commands are mentioned as fixing the problem. I executed the two following commands in the SQL window in the QspatiaLite plugin.
UPDATE geometry_columns_statistics set last_verified = 0
SELECT UpdateLayerStatistics('geometry_table_name')
Then my missing fields reappear.

-----Original Message-----
From: Alexander Bruy [mailto:alexander.bruy at gmail.com] 
Sent: Thursday, March 13, 2014 2:58 PM
To: Chrest, David
Cc: qgis-user
Subject: Re: [Qgis-user] Newly added SpatiaLite fields now missing in attribute table

Hi,

this is known issue, see http://hub.qgis.org/issues/8923.

2014-03-13 20:21 GMT+02:00 Chrest, David <davidc at rti.org>:
> Using QGIS 2.01. Yesterday I added some fields in my simple SpatiaLite 
> polygon layer. Specifically “x, y” fields so that I could move labels, 
> as well as a field to hold just the labels I need. So I come in today, 
> open up my .qgs project and the labels are missing. I open up my 
> attribute table and the three fields I added are not visible in the 
> table and are not recognized in any field lists. However, I see they 
> are there existing in the layer when I view in the DB Manager as well 
> as the qspatiaLite plugin. Anybody know how to get these added fields 
> back into my attribute table so I can continue with labeling and make a map?
>
> Thanks so much.
>
>
>
> David Chrest
>
> Research GIS Analyst
>
> RTI International
>
> 3040 Cornwallis Rd, PO Box 12194
>
> Research Triangle Park, NC  27709-2194
>
>
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user



--
Alexander Bruy