I'm having issues with a .sqlite database that I generate from PostGIS using ogr2ogr. The data appears to export into SQLite properly, and it loads in TileMill fine, but when I try to add any of the layers in QGIS it tells me:
Invalid layer. <layer name> is an invalid layer and cannot be loaded.
I was thinking that maybe my version of QGIS is running a slightly older version of SpatiaLite, so I decided to try exporting the data to a different version of SpatiaLite database. Is this an option in ogr2ogr?