search

AnimeshN / communitgygis-geonode

0 stars 2 forks source link

Layer fails to upload when an attribute contains a space #1

Closed jfox13-nd closed 5 years ago

jfox13-nd commented 5 years ago

There seems to be an issue when uploading geospatial data where the data fails to upload with certain shapefiles. This is likely because the attribute table contains attributes with spaces, as evidenced by the following error message one of the users at TDSC received:

Unexpected exception Unsupported ALTER TABLE command : ALTER TABLE Farm ponds_vikramgad_v1 RENAME COLUMN "Status as" TO "status-as"

jfox13-nd commented 5 years ago

I tried to upload the same layer on the online GeoNode demo, it has the same issue

jfox13-nd commented 5 years ago

Found the solution: Not at all a problem with an attribute table, the file name had a space in it, removing the space fixed the problem (Farm ponds_vikramgad_v1 was changed to Farm_ponds_vikramgad_v1)