In QGIS I have a spatialite DB full of roads. I'd like to do a Difference operation (Vector > Geometry Tools > Difference
) with another layer in order to keep roads only available in a given zone. The difference works fine but once I try to save that new layer to a Spatialite DB I get OGR error saying that it can't insert GEOMETRYCOLLECTION where a MULTILINESTRING is expected.
I don't know how to fix that and what to do.
Following the @she_weeds' answer it was suggested to try saving that layer to another format and then to Spatialite. Saving it to GeoJSON worked, I could convert it to Spatialite after that and import it to my QGIS project (even if the auto-import didn't worked at first).
Even if everything works now using this workaround, I will update QGIS to latest version too.