Saek; I tried the suggestions with no luck, then decided to try a rename, the table now it works. Apparently spatilite does not like the name wmain for a table name. I could only get it to work by adding an extension, I am assuming there is a corruption somewhere and the database cannot agree if the table exists or not. Any thoughts on why this occurred? Tyler
On Tue, Aug 30, 2016 at 7:31 PM, Tyler Veinot <tylerkvei...@gmail.com> wrote: > Thanks I will try that in the morning > > Sent from my Bell Sony device over Canada’s largest network. > > ---- SaekBinko wrote ---- > > > Hi, > > Try to recover geometry typing a command > > SELECT RecoverGeometryColumn('[1]', 'Geometry', [2], '[3]', 'XY'); > > Where: > [1] - table name > [2] - epsg code > [3] - geometry type > > I had similar problem some time ago, and recovering geometry helped me. > > > Also try to open that Spatialite database in Spatialite GUI - nice app to > perform some actions using Spatialite. > > > > -- > View this message in context: http://osgeo-org.1560.x6. > nabble.com/Spatilite-and-QGIS-issue-tp5283146p5283153.html > Sent from the Quantum GIS - User mailing list archive at Nabble.com. > _______________________________________________ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user >
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user