I'm trying to export some table data to a shapefile. As the data doesn't have any geometry information, I'd expect a pure DBF-file to be created instead of a SHP-file (plus some more like prj, shx and dbf).
But instead, I get an error:
Export to vector file D:\a.shp failed. Error: Storing metadata for the specified URI is not supported
Export to GeoPackage works with the exact same parameters, though.
As mentioned in the error message, the problem was with storing the metadata. So whatever this metadata actually is in this case, disabling the "Persist layer metadata"-option will make the export work and the DBF-file is created. Also ensure you uncheck any geometry-field from the export.
Finally the SHPT-field should be left empty (although that won't prevent the export from functioning, but just creates a table having an empty geometry-column).
Be aware, though, that the new table isn't directly added to the map even though the "Add saved file to map" option is active, probably because we didn't really create a shapefile, although we requested QGIS to do so. So you have to manually add it via Layer -> Add Layer -> Add vector layer (strange, I know), and here you can add any arbitrary file:
