Not sure if it's helpful, but here is a list of installed spatialite/sqlite packages.<br>I noticed there is two packages called libspatialite2 and sqlite2, are those causing conflicts or something?<br>It looks like libspatialite2 is a (System Package) meaning it was installed during initial OS installation from the openSUSE DVD...<br>
<br>Were those two suppose to be gone when libspatialite5 and sqlite3 were installed?<br><br><br><br>saultdon@opensuse.linux:~> zypper se -si sqlite spatialite<br>Loading repository data...<br>Reading installed packages...<br>
<br>S | Name | Type | Version | Arch | Repository <br>--+-------------------------+---------+----------------+--------+---------------------<br>i | libqt4-sql-sqlite | package | 4.8.1-2.4.1 | x86_64 | openSUSE-12.2-Update<br>
i | libqt4-sql-sqlite-32bit | package | 4.8.1-2.4.1 | x86_64 | openSUSE-12.2-Update<br>i | libspatialite2 | package | 3.0.1-9.1 | x86_64 | (System Packages) <br>i | libspatialite5 | package | 4.0.0-1.1 | x86_64 | openSUSE-12.2-Geo <br>
i | libsqlite3-0 | package | 3.7.12.1-2.1.2 | x86_64 | openSUSE-12.2-Oss <br>i | libsqlite3-0-32bit | package | 3.7.12.1-2.1.2 | x86_64 | openSUSE-12.2-Oss <br>i | perl-DBD-SQLite | package | 1.35-3.1.2 | x86_64 | openSUSE-12.2-Oss <br>
i | php5-sqlite | package | 5.3.15-1.12.1 | x86_64 | openSUSE-12.2-Update<br>i | spatialite-gis | package | 1.0.0c-1.2 | x86_64 | openSUSE-12.2-Geo <br>i | spatialite-gui | package | 1.6.0-1.1 | x86_64 | openSUSE-12.2-Geo <br>
i | spatialite-tools | package | 4.0.0-1.1 | x86_64 | openSUSE-12.2-Geo <br>i | sqlite2 | package | 2.8.17-183.1.2 | x86_64 | openSUSE-12.2-Oss <br>i | sqlite3 | package | 3.7.12.1-2.1.2 | x86_64 | openSUSE-12.2-Oss <br>
i | sqlite3-devel | package | 3.7.12.1-2.1.2 | x86_64 | openSUSE-12.2-Oss<br><div class="gmail_extra"><br><br><div class="gmail_quote">On Sun, Dec 9, 2012 at 11:40 AM, Donovan Cameron <span dir="ltr"><<a href="mailto:sault.don@gmail.com" target="_blank">sault.don@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I created a sqlite/spatialite db from the spatialite_gui and started to import a bunch of shapefiles.<br><br>Some of the things I set were the CRS to EPSG:3005 "BC Albers" and the_geom as the name for the geometry field (type is set to auto...)<br>
<br>Then in spatialite_gui I expanded each new table and built a spatial index. I can also right click each the_geom table and see a valid "Map Preview".<br><br>But I can't open or load this .sqlite files into either spatialite_gis or qgis.<br>
So I think this could be a problem with my actual OS (openSUSE 12.2 x64 w/ KDE).<br><br>QGIS loads the layers as tables, not vectors.<br>spatialite_gis thrown an error:<br><br>Missing or invalid Spatial Metadata tables:<br>
- spatial_ref_sys<br>- geometry_columns<br><br>Sorry, cowardly quitting ...<br><br>But those tables are in the .sqlite db under the "Metadata" portion.<br><br>From the layer menu in QGIS, I can't create a layer in a sqlite db. It says that my layer is invalid and can't be created. Then I can't even see this sqlite database (that got created successfully, it's just the layer that failed creation) when navigating from the add vector window. But I can see it when trying to load from spatialite_gis but that throws the same error.<br>
<br>I noticed in the DB Manager plugin, it says that pyspatialite is missing and that package isn't available for openSUSE in the open build service, unless it goes by a different name...<br>
</blockquote></div><br></div>