Re: [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 
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

Re: [Qgis-user] Spatilite and QGIS issue

[SaekBinko]

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