Bug report #7560
import of shapefile into spatialite through db manager fails if there is a DATE column
|Affected QGIS version:||master||Regression?:||No|
|Operating System:||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||16501|
This regressed in the last week or so.
Step to reproduce:
1. Create a spatialite file
2. Open DB Manager and enter into your newly createwd spatialite file
3. Click on the import toolbar button and select the shapefile attached to this issue (MODIS FIRMS fire detection data)
5. When clicking on ok to import, you'll get an 'ERROR 4: acq_date type not supported'.
Opening the .dbf, the acq_date column is defined as a date field. I imported FIRMS shapefiles less than 2 weeks ago and I was not seeing this issue.