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:[email protected]] 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 <[email protected]>: > 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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/qgis-user -- Alexander Bruy _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
