id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
15295	GeoDjango model creation fails for MySQL during tests	Adam Nelson	nobody	"When running runtests.py:

{{{
Failed to install index for geoapp.Country model: (1464, ""The used table type doesn't support SPATIAL indexes"")
Failed to install index for geoapp.City model: (1464, ""The used table type doesn't support SPATIAL indexes"")
Failed to install index for geoapp.State model: (1464, ""The used table type doesn't support SPATIAL indexes"")
Failed to install index for geoapp.Track model: (1464, ""The used table type doesn't support SPATIAL indexes"")
Failed to install index for geoapp.Feature model: (1464, ""The used table type doesn't support SPATIAL indexes"")
Failed to install index for geoapp.MinusOneSRID model: (1464, ""The used table type doesn't support SPATIAL indexes"")
Failed to install index for relatedapp.Location model: (1464, ""The used table type doesn't support SPATIAL indexes"")
Failed to install index for relatedapp.Parcel model: (1464, ""The used table type doesn't support SPATIAL indexes"")
Failed to install index for layermap.County model: (1464, ""The used table type doesn't support SPATIAL indexes"")
Failed to install index for layermap.CountyFeat model: (1464, ""The used table type doesn't support SPATIAL indexes"")
Failed to install index for layermap.City model: (1464, ""The used table type doesn't support SPATIAL indexes"")
Failed to install index for layermap.Interstate model: (1464, ""The used table type doesn't support SPATIAL indexes"")
Failed to install index for layermap.CityBase model: (1464, ""The used table type doesn't support SPATIAL indexes"")
}}}

This is because MySQL InnoDB does not support SPATIAL indexes.  Options:

 1. create a new variable for spatial_index that is set to true if using the MySQL backend with InnoDB
 1. or wrap table creation around a try...except that inserts spatial_index=False
 1. or do one of these for GeoDjango generally (not just the tests)"	Bug	closed	GIS	dev	Normal	fixed			Accepted	0	0	0	0	0	0