[Qgis-user] Spatilite and QGIS issue

[Tyler Veinot]

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 <tylerkveinot at 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 at lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160831/2a48e9af/attachment.html>