Download & Extend

User warnings on install

Project:Simple Geo
Version:6.x-1.1
Component:Code
Category:bug report
Priority:critical
Assigned:Unassigned
Status:active

Issue Summary

Upon install, I get the following errors. My best guess is that it's an issue when using innodb tables. I haven't had a chance to test with myisam.

user warning: The used table type doesn't support SPATIAL indexes query: simple_geo_install /* Administrator : simple_geo_install */ ALTER TABLE Funimation_simple_geo_area ADD COLUMN area POLYGON NOT NULL, ADD SPATIAL INDEX area_index(area) in /Users/EidolonNight/Documents/Aptana Studio Workspace/Funimation/drupal/sites/all/modules/simple_geo/simple_geo.install on line 21.

user warning: The used table type doesn't support SPATIAL indexes query: simple_geo_install /* Administrator : simple_geo_install */ ALTER TABLE Funimation_simple_geo_position ADD COLUMN position POINT NOT NULL, ADD SPATIAL INDEX position_index(position) in /Users/EidolonNight/Documents/Aptana Studio Workspace/Funimation/drupal/sites/all/modules/simple_geo/simple_geo.install on line 25.

user warning: Unknown column 'position' in 'field list' query: simple_geo_position /* Administrator : simple_geo_position */ SELECT AsText(position) FROM Funimation_simple_geo_position WHERE nid = 1 AND type='user' in /Users/EidolonNight/Documents/Aptana Studio Workspace/Funimation/drupal/sites/all/modules/simple_geo/simple_geo.module on line 463.

Comments

#1

This patch should fix the issue

AttachmentSize
simple_geo.install.patch 523 bytes
nobody click here