0

When I try create a new database, Spatialite plugin return the dialog error box:

The SQL query seems to be invalid, no such table: views_goemetry_columns

When I click in OK button, a second dialog box (Transform database into SpatiaLite) is open with the text :

This database seems to be a valid SQLite database but not a valid SpatiaLite One
Would you like QSpatiaLite to automatically transform it to SpatiaLite (information won't be lost) ?

When I click in the YES button, a new dialog error box open with the text:

Unable to convert Database to SpatiaLite

When I click in OK button, another dialog error box open with the text:

The SQL query seems to be invalid.

The database was set up, but I can't import spatial layers. How resolve this problem?

nmtoken
13.6k5 gold badges39 silver badges91 bronze badges
asked Sep 18, 2012 at 13:44
4
  • 2
    "whe I try to create a new database" Using what? Commented Sep 18, 2012 at 14:17
  • I got the same problem, so thank you for your answer, but how do you then import spatialitegui into QGIS ? Commented Jan 18, 2013 at 9:51
  • You don't import spatialite_gui. You just use the file that this tool creates. Thats the point of spatialite / sqlite. Commented Jan 18, 2013 at 10:01
  • To say it the other way round: You create the database table with the gui, but you can fill/modify/show the data with Qgis. Commented Jan 18, 2013 at 11:07

1 Answer 1

3

as Ragi Yaser Burhum alread stated:>>"when I try to create a new database" Using what?<<

the easiest and safest way to create a spatialite-database : use the free spatialitegui ( gaia-gis.it/fossil/spatialite_gui/index) from the spatialite developer and then import into qgis... seems like your database is missing the geometry columns and is therefore a simple nonspatial sqlite databse

answered Sep 18, 2012 at 16:29
2
  • 1
    gaia-gis.it/fossil/spatialite_gui/index simply copying & pasting the URL above doesn't work since it's using https Commented Sep 18, 2012 at 16:42
  • Rayner and Kurt, Commented Sep 20, 2012 at 19:00

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.