I have been trying to add multiple vector layers to a SpatiaLite database, however using the integrated DB Manager in QGIS 2.14.10 and 2.18.7, whenever I add a shapefile using the "Import Layer/File" button, and follow the menu, the item added does not have geometry, with only the attribute table appearing in the DB.
I can create DBs containing single layers using the "Save as..." right click menu option, but I can't save multiple vector layers into the same DB.
Other users have suggested using the QSpatiaLite plugin, however the plugin doesn't run when installed, and hasn't been updated in 6 years. QspatiaLite seemed like a good answer, if anyone knows of a similar plugin that has been upkept, please let me know.
Here is a snapshot of my SpatiaLite DB, with
GLA_Zips being the vector file that was added to the original
combined_mix sqlite file. Despite checking the
geometry column option in the import menu, the geometry still isn't imported. When I click
add to canvas in the context menu for the item, its added to the layers panel as a table, not a polygon vector file.