Error creating index using table prefix [#358255]

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

Comment #1

plopesc

he/him

Spanish

CreditAttribution: plopesc commented 13 January 2009 at 17:47

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!!