I am trying to configure a "Geospatial data reference" type field for a custom content type. When I click the "Save" button wile in the edit mode, I see the following error:

user warning: Table 'stringsn_drp01.drup_drup_content_type_snow_report' doesn't exist query: SELECT DISTINCT(drup_content_type_snow_report.vid),field_report_location_geo FROM drup_drup_content_type_snow_report ORDER BY field_report_location_geo in /home4/stringsn/public_html/drupldev/sites/all/modules/geo/modules/geo_data/geo_data.module on line 302.

I do have table
drup_content_type_snow_report
...but not:
drup_drup_content_type_snow_report

Thank you

Comments

gagarine’s picture

gagarine commented

Same problem with same version on fresh install with only rules, cck, geo and geocode...

    * user warning: Table 'geotest.geo' doesn't exist query: SELECT * FROM geo WHERE name = 'field_my_geo_field' in /Users/simon/Sites/drupal-test-geo/sites/all/modules/geo/includes/geo.api.inc on line 168.
    * user warning: Table 'geotest.geo' doesn't exist query: INSERT INTO geo (name, title, handler, geo_type, srid, indexed, data) VALUES ('field_my_geo_field', 'My Geo', 'GeoSQLMySQL', 0, -1, -1, 'a:2:{s:6:\"schema\";N;s:5:\"count\";N;}') in /Users/simon/Sites/drupal-test-geo/includes/common.inc on line 3467.
    * user warning: Table 'geotest.geo' doesn't exist query: SELECT * FROM geo ORDER BY title in /Users/simon/Sites/drupal-test-geo/sites/all/modules/geo/includes/geo.api.inc on line 130.
    * user warning: Table 'geotest.geo' doesn't exist query: SELECT * FROM geo WHERE name = 'field_my_geo_field' in /Users/simon/Sites/drupal-test-geo/sites/all/modules/geo/includes/geo.api.inc on line 168.
    * user warning: Table 'geotest.geo' doesn't exist query: INSERT INTO geo (name, title, handler, geo_type, srid, indexed, data) VALUES ('field_my_geo_field', 'My Geo', 'GeoSQLMySQL', 0, -1, -1, 'a:2:{s:6:\"schema\";N;s:5:\"count\";N;}') in /Users/simon/Sites/drupal-test-geo/includes/common.inc on line 3467.
    * user warning: Table 'geotest.geo' doesn't exist query: SELECT * FROM geo ORDER BY title in /Users/simon/Sites/drupal-test-geo/sites/all/modules/geo/includes/geo.api.inc on line 130.

The table geo is not create on the installation. After disable, uninstall and install again the geo module the table geo is created. Strange... I try to reproduce the bug without success.

Something i see in geo.install

Now we have

function geo_schema() {

  $schema = array(
    'geo' => array(
         'fields' => array(
        'gid' => array(
          'type' => 'serial',
          'not null' => TRUE,
        ),
....

But habitually we use

function geo_schema() {
 $schema['geo'] = array(
     'fields' => array(
        'gid' => array(
          'type' => 'serial',
          'not null' => TRUE,
        ),
 .....

I think this change nothing... but anyway it's more drupal style.