When I create a new geo field, I see this warning:

user warning: Table 'drupal.content_field_geo4' doesn't exist query: CREATE SPATIAL INDEX drupal6_content_field_geo4_field_geo4_geo_idx ON content_field_geo4 (field_geo4_geo) in C:\xampp\htdocs\drupal\6\modules\geo\db\mysql_spatial.inc on line 30.

In the query,you can see that the table prefix must appear in the table name and not in the index name...

Comments

plopesc’s picture

plopesc
he/him
Primary language Spanish
commented

Hello!
I've solved this problem changing the line 30 in the geo\db\mysql_spatial.inc file:

Previous: db_query("CREATE SPATIAL INDEX {". $table ."}_${field}_idx ON {$table} ($field)");
Actually: db_query("CREATE SPATIAL INDEX {$table}_${field}_idx ON {". $table ."} ($field)");

This is my first Issue and I don't know how to upload this change to the repossitory...
Some body can explain me how to do it??

Thanks in Advance!!

allie micka’s picture

allie micka
she/her
commented
Status: Active » Fixed

Fixed. Thanks a lot!

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.