Bug report #7560

import of shapefile into spatialite through db manager fails if there is a DATE column

Added by Mathieu Pellerin - nIRV over 9 years ago. Updated over 9 years ago.

Category:DB Manager
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.

modis_firms_20130509.zip (195 KB) Mathieu Pellerin - nIRV, 2013-04-09 09:09 PM

Associated revisions


#1 Updated by Jürgen Fischer over 9 years ago

  • Priority changed from Normal to Severe/Regression

#2 Updated by Jürgen Fischer over 9 years ago

  • Status changed from Open to Closed

#3 Updated by Mathieu Pellerin - nIRV over 9 years ago

That was fast. Kudos Jef.

Also available in: Atom PDF