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

[William Kyngesburye]

On Aug 11, 2010, at 10:23 PM, Noli Sicad wrote:

> Hi,
> 
> I just like to elaborate that the QGIS 1.4 and QGIS 1.5 have problem
> opening Spatialite database.
> 
> What causes this compatibility?
> 
> Please download the spatialite database  - subway_test.zip and try if
> you can open it properly.
> 
Or test it with the spatialite test db.

> 2. Spatialite test data not opening in Mac OS X QGIS 1.5
> 
> http://forum.qgis.org/viewtopic.php?f=2&t=6595&p=12421&hilit=spatialite#p12421
> 
> 3. Mac OS X QGIS 1.4 and 1.5 (build 13385) from KyngChaos with no success
> http://groups.google.com/group/spatialite-users/browse_thread/thread/a4801e0e563ac757
> 
More precisely, the problem on the Mac is display only.  see bug http://trac.osgeo.org/qgis/ticket/2760 (forgot about that).

The DB opens, and you can add layers.  The coordinate info is there, and you can even select features (no hilites, IIRC).  It's just that nothing displays.  Only on PPC Leopard (10.5).  Intel Leopard, and Snow (PPC not possible), are fine.

At one point I thought it might be something with Qt - I was building the Leopard version with Qt 4.6 Carbon (the older GUI API) and Snow version with Qt 4.6 Cocoa (for 64bit build).  For some reason, Nokia decided to not include PPC in the Cocoa build, which leaves out a lot of still-supported G5 Macs.  I switched to compiling my own Qt Cocoa for Leopard with PPC, but forgot to test the Spatialite problem until today, but it's still there.

Spatialite on PPC works fine via the sqlite3 utility.

-----
William Kyngesburye <kyngchaos*at*kyngchaos*dot*com>
http://www.kyngchaos.com/

"The beast is actively interested only in now, and, as it is always now and always shall be, there is an eternity of time for the accomplishment of objects."

- the wisdom of Tarzan