Re: [Qgis-user] Spatilite and QGIS issue

2016-08-31 Thread 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

Re: [Qgis-user] Spatilite and QGIS issue

2016-08-30 Thread 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