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?
On Tue, Aug 30, 2016 at 7:31 PM, Tyler Veinot <tylerkvei...@gmail.com>
> Thanks I will try that in the morning
> Sent from my Bell Sony device over Canada’s largest network.
> ---- SaekBinko wrote ----
> Try to recover geometry typing a command
> SELECT RecoverGeometryColumn('', 'Geometry', , '', 'XY');
>  - table name
>  - epsg code
>  - 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.
> Sent from the Quantum GIS - User mailing list archive at Nabble.com.
> Qgis-user mailing list
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Qgis-user mailing list
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user