[Qgis-developer] Incompatibilities between QGIS Spatialite and Spatialite (CLI and GIS) created files

[Noli Sicad]

Hi,

File created using CLI (command line interface)  in Spatialite could
not be opened in QGIS 1.5 and (QGIS 1.4) in Windows 7 and XP. And vice
versa i.e. spatialite created in QGIS 1.5 could not be opened as well
in Spatialite-GIS.

Please note that Spatialite test database could not open property in
QGIS 1.4 and QGIS 1.5. You can open the file but it will not render
the geometry polygon.

I am trying to create a Spatialite file from a Shapefile.

Steps In QGIS 1.5
1. Load Shapefile
2. Save Shapefile to Spatialite - Spatialite file successful created.
3. Remove Shapefile from Qgis.
4. Open Spatialte file that was created in QGIS - It is rendered
5. OK, no problem

Steps in Spatialite CLI using Spatialite 2.4
1. Create a Spatialite database
3. Initalise the database (.read init_spatialite-2.4.sql ASCII)
2. Load Shapeflle (.loadshp)
3. Inspect tables (.tables)
4. Close command line

Now, the problems.

In QGIS - Problem in opening Spatialite file created by Spatialite CLI in QGIS.

It ask you for layers to open. You can select any tables, yet it will
not render the polygons. You can see the attributes though.

In Spatialite-GIS - Problem in opening QGIS created spatialite file.

Error Screen
"Missing or invalid Spatial Metadata tables
- spatial_ref_sys
- geometry_columns"

I examined theSpatialite file created in QGIS 1.5 using Spatialite
CLI, the 2 metadata tables are present.

What causes these incompatibilities and any solution to the problem?

Problem in Geoserver with Spatialite.
http://groups.google.com/group/spatialite-users/browse_thread/thread/4099a32ef20e6a19

Thanks.

Noli