I'm running a regular feeds import from a SOAP service, with some of the fields being long/lat fields.

I've mapped this correctly to the appropriate Location fields in Drupal, and for the majority of the nodes this works fine, however for some nodes I'm getting the error:
SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'field_location_lid' at row 1

Some of the nodes don't have a long/lat set, but for these, the value is either 0,0 or null, so the location field should not even be trying to save a location.

I've had a look through the location feeds code, but can't work it out.

Anyone else come across this issue before?

Thanks,

Edwin

Comments

mcdoolz’s picture

I'm experiencing the same.
SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'field_address_lid' at row 1

ymeiner’s picture

It is a problem when there is no location at all. I am trying to find a solution for it to. meanwhile i just entered a zip code that i know that is not in use

jeffschuler’s picture

I was experiencing this, too... Removed and re-added my location mappings and it worked.

killtheliterate’s picture

Also experiencing this problem. Encouraging to know that I'm not alone, at least.

killtheliterate’s picture

I've tried again and again to circumvent this error. It would seem that locations feeds imports fine, until I'm importing to more than 4 location fields. I've tried removing the mappings, using different test fields, etc... Once I've mapped 5 location fields in my importer, I begin to see this error.

---
Edit:

It seems like this is actually occuring if a location field is empty... So, is it requisite that a, say, csv, when importing into locations, must have all fields filled in?

killtheliterate’s picture

Here's my feed log. Obviously, the majority of my fields are specific to my use case, but you'll notice that Feeds doesn't get upset until it reaches an empty field that I've mapped to a location cck field. Below the feeds log error is the pdo exception that's in dblog.

SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'field_address_served_lid' at row 1
Original item

array (
  'document to be served' => 'Lawsuit',
  'document id' => '1111SAC01012012',
  'document out date' => '1/1/2012',
  'due date' => '02/01/12',
  'existing poe name' => 'Jamba Juice',
  'existing poe address' => '12345 Yellow Brick Rd',
  'existing poe city' => 'Denver',
  'existing poe phone' => '(720) 111-1111',
  'existing bank name' => 'Wells Fargo',
  'existing bank address' => '54321 Red Brick St',
  'existing bank city' => 'Denver',
  'existing bank phone' => '(719) 111-1111',
  'court date' => '08/01/12',
  'discovery date' => '01/01/12',
  'first name' => 'Joe',
  'last name' => 'Joe',
  'address 1' => '111 Purple Place',
  'address 1 city' => 'Denver',
  'address 1 state' => 'Colorado',
  'address 1 zip' => '80210',
  'address 1 phone' => '(303) 111-1111',
  'social' => '111-22-3333',
  'court county' => 'Denver',
  'business name (name of the business if the business is being sued)' => 'A Scam Enterprises',
  'address 2 (business address)' => '888 Orange Way',
  'address 2 city' => 'Denver',
  'address 2 state' => 'Colorado',
  'address 2 zip' => '80203',
  'address 2 phone' => '(303) 222-2222',
  'manner' => '',
  'is this a new home address?' => '',
  'address served' => '',
  'city' => '',
  'state' => '',
  'zip' => '',
  'county' => '',
  'new or different job?' => '',
  'poe name' => '',
  'poe address' => '',
  'poe city' => '',
  'poe state' => '',
  'poe zip' => '',
  'poe phone' => '',
  'new or different bank?' => '',
  'bank name' => '',
  'bank address' => '',
  'bank city' => '',
  'bank state' => '',
  'bank zip' => '',
  'bank phone' => '',
  'serve date' => '',
  'serve fee' => '',
  'skip fee' => '',
  'poe fee' => '',
  'bank fee' => '',
  'total fee' => '',
  'comments' => '',
)
Entity

stdClass::__set_state(array(
   'type' => 'document',
   'changed' => 1335209532,
   'created' => 1335209532,
   'language' => 'und',
   'status' => 1,
   'promote' => 1,
   'sticky' => 0,
   'uid' => '1',
   'revision' => false,
   'comment' => 2,
   'menu' => 
  array (
    'link_title' => '',
    'mlid' => 0,
    'plid' => 0,
    'menu_name' => 'main-menu',
    'weight' => 0,
    'options' => 
    array (
    ),
    'module' => 'menu',
    'expanded' => 0,
    'hidden' => 0,
    'has_children' => 0,
    'customized' => 0,
    'parent_depth_limit' => 8,
  ),
   'log' => 'Created by FeedsNodeProcessor',
   'feeds_item' => 
  stdClass::__set_state(array(
     'entity_id' => 0,
     'entity_type' => 'node',
     'id' => 'document_importer',
     'feed_nid' => 0,
     'imported' => 1335209532,
     'hash' => 'a66d9db7be9d2af34e841aa776144588',
     'url' => '',
     'guid' => '1111SAC01012012',
  )),
   'field_document_id' => 
  array (
    'und' => 
    array (
      0 => 
      array (
        'value' => '1111SAC01012012',
        'format' => 'plain_text',
      ),
    ),
  ),
   'title' => '1111SAC01012012',
   'field_ourfile' => 
  array (
    'und' => 
    array (
      0 => 
      array (
        'value' => '',
        'format' => 'plain_text',
      ),
    ),
  ),
   'field_document_type' => 
  array (
    'und' => 
    array (
      0 => 
      array (
        'value' => 'Lawsuit',
        'format' => 'plain_text',
      ),
    ),
  ),
   'field_document_out_date' => 
  array (
    'und' => 
    array (
      0 => 
      array (
        'timezone' => 'America/Denver',
        'offset' => 0,
        'date' => 
        FeedsDateTime::__set_state(array(
           'granularity' => 
          array (
            0 => 'year',
            1 => 'month',
            2 => 'day',
            3 => 'zone',
          ),
           '_serialized_time' => NULL,
           '_serialized_timezone' => NULL,
           'date' => '2012-01-01 00:00:00',
           'timezone_type' => 3,
           'timezone' => 'America/Denver',
        )),
        'value' => '2012-01-01 00:00:00',
        'timezone_db' => 'America/Denver',
        'date_type' => 'datetime',
      ),
    ),
  ),
   'field_due_date' => 
  array (
    'und' => 
    array (
      0 => 
      array (
        'timezone' => 'America/Denver',
        'offset' => 0,
        'date' => 
        FeedsDateTime::__set_state(array(
           'granularity' => 
          array (
            0 => 'year',
            1 => 'month',
            2 => 'day',
            3 => 'zone',
          ),
           '_serialized_time' => NULL,
           '_serialized_timezone' => NULL,
           'date' => '2012-02-01 00:00:00',
           'timezone_type' => 3,
           'timezone' => 'America/Denver',
        )),
        'value' => '2012-02-01 00:00:00',
        'timezone_db' => 'America/Denver',
        'date_type' => 'datetime',
      ),
    ),
  ),
   'field_existing_poe' => 
  array (
    'und' => 
    array (
      0 => 
      array (
        'name' => 'Jamba Juice',
        'street' => '12345 Yellow Brick Rd',
        'additional' => '',
        'city' => 'Denver',
        'province' => '',
        'postal_code' => '',
        'country' => 'us',
        'locpick' => false,
        'latitude' => 0,
        'longitude' => 0,
        'source' => 0,
        'is_primary' => 0,
        'delete_location' => false,
        'fax' => '',
        'phone' => '(720) 111-1111',
        'location_settings' => 
        array (
          'form' => 
          array (
            'fields' => 
            array (
              'name' => 
              array (
                'default' => '',
                'collect' => '1',
                'weight' => '2',
              ),
              'street' => 
              array (
                'default' => '',
                'collect' => '1',
                'weight' => '4',
              ),
              'additional' => 
              array (
                'default' => '',
                'collect' => '0',
                'weight' => '6',
              ),
              'city' => 
              array (
                'default' => '',
                'collect' => '1',
                'weight' => '8',
              ),
              'province' => 
              array (
                'default' => '',
                'collect' => '1',
                'weight' => '10',
                'widget' => 'autocomplete',
              ),
              'postal_code' => 
              array (
                'default' => '',
                'collect' => '1',
                'weight' => '12',
              ),
              'country' => 
              array (
                'default' => 'us',
                'collect' => '4',
                'weight' => '14',
              ),
              'locpick' => 
              array (
                'default' => false,
                'collect' => '0',
                'weight' => '20',
                'nodiff' => true,
              ),
              'phone' => 
              array (
                'default' => '',
                'collect' => '1',
                'weight' => '25',
              ),
              'lid' => 
              array (
                'default' => false,
              ),
              'latitude' => 
              array (
                'default' => 0,
              ),
              'longitude' => 
              array (
                'default' => 0,
              ),
              'source' => 
              array (
                'default' => 0,
              ),
              'is_primary' => 
              array (
                'default' => 0,
              ),
              'delete_location' => 
              array (
                'default' => false,
                'nodiff' => true,
              ),
              'fax' => 
              array (
                'default' => '',
                'collect' => 0,
                'weight' => 30,
              ),
            ),
          ),
          'display' => 
          array (
            'hide' => 
            array (
              'name' => 0,
              'street' => 0,
              'additional' => 0,
              'city' => 0,
              'province' => 0,
              'postal_code' => 0,
              'country' => 0,
              'locpick' => 0,
              'phone' => 0,
              'province_name' => 0,
              'country_name' => 0,
              'map_link' => 0,
              'coords' => 0,
            ),
          ),
        ),
        'lid' => '759',
      ),
    ),
  ),
   'field_existing_bank' => 
  array (
    'und' => 
    array (
      0 => 
      array (
        'name' => 'Wells Fargo',
        'street' => '54321 Red Brick St',
        'additional' => '',
        'city' => 'Denver',
        'province' => '',
        'postal_code' => '',
        'country' => 'us',
        'locpick' => false,
        'latitude' => 0,
        'longitude' => 0,
        'source' => 0,
        'is_primary' => 0,
        'delete_location' => false,
        'fax' => '',
        'phone' => '(719) 111-1111',
        'location_settings' => 
        array (
          'form' => 
          array (
            'fields' => 
            array (
              'name' => 
              array (
                'default' => '',
                'collect' => '1',
                'weight' => '2',
              ),
              'street' => 
              array (
                'default' => '',
                'collect' => '1',
                'weight' => '4',
              ),
              'additional' => 
              array (
                'default' => '',
                'collect' => '0',
                'weight' => '6',
              ),
              'city' => 
              array (
                'default' => '',
                'collect' => '1',
                'weight' => '8',
              ),
              'province' => 
              array (
                'default' => '',
                'collect' => '1',
                'weight' => '10',
                'widget' => 'autocomplete',
              ),
              'postal_code' => 
              array (
                'default' => '',
                'collect' => '1',
                'weight' => '12',
              ),
              'country' => 
              array (
                'default' => 'us',
                'collect' => '4',
                'weight' => '14',
              ),
              'locpick' => 
              array (
                'default' => false,
                'collect' => '0',
                'weight' => '20',
                'nodiff' => true,
              ),
              'phone' => 
              array (
                'default' => '',
                'collect' => '1',
                'weight' => '25',
              ),
              'lid' => 
              array (
                'default' => false,
              ),
              'latitude' => 
              array (
                'default' => 0,
              ),
              'longitude' => 
              array (
                'default' => 0,
              ),
              'source' => 
              array (
                'default' => 0,
              ),
              'is_primary' => 
              array (
                'default' => 0,
              ),
              'delete_location' => 
              array (
                'default' => false,
                'nodiff' => true,
              ),
              'fax' => 
              array (
                'default' => '',
                'collect' => 0,
                'weight' => 30,
              ),
            ),
          ),
          'display' => 
          array (
            'hide' => 
            array (
              'name' => 0,
              'street' => 0,
              'additional' => 0,
              'city' => 0,
              'province' => 0,
              'postal_code' => 0,
              'country' => 0,
              'locpick' => 0,
              'phone' => 0,
              'province_name' => 0,
              'country_name' => 0,
              'map_link' => 0,
              'coords' => 0,
            ),
          ),
        ),
        'lid' => '758',
      ),
    ),
  ),
   'field_court_date' => 
  array (
    'und' => 
    array (
      0 => 
      array (
        'timezone' => 'America/Denver',
        'offset' => 0,
        'date' => 
        FeedsDateTime::__set_state(array(
           'granularity' => 
          array (
            0 => 'year',
            1 => 'month',
            2 => 'day',
            3 => 'zone',
          ),
           '_serialized_time' => NULL,
           '_serialized_timezone' => NULL,
           'date' => '2012-08-01 00:00:00',
           'timezone_type' => 3,
           'timezone' => 'America/Denver',
        )),
        'value' => '2012-08-01 00:00:00',
        'timezone_db' => 'America/Denver',
        'date_type' => 'datetime',
      ),
    ),
  ),
   'field_discovery_date' => 
  array (
    'und' => 
    array (
      0 => 
      array (
        'timezone' => 'America/Denver',
        'offset' => 0,
        'date' => 
        FeedsDateTime::__set_state(array(
           'granularity' => 
          array (
            0 => 'year',
            1 => 'month',
            2 => 'day',
            3 => 'zone',
          ),
           '_serialized_time' => NULL,
           '_serialized_timezone' => NULL,
           'date' => '2012-01-01 00:00:00',
           'timezone_type' => 3,
           'timezone' => 'America/Denver',
        )),
        'value' => '2012-01-01 00:00:00',
        'timezone_db' => 'America/Denver',
        'date_type' => 'datetime',
      ),
    ),
  ),
   'field_first_name' => 
  array (
    'und' => 
    array (
      0 => 
      array (
        'value' => 'Joe',
        'format' => 'plain_text',
      ),
    ),
  ),
   'field_last_name' => 
  array (
    'und' => 
    array (
      0 => 
      array (
        'value' => 'Joe',
        'format' => 'plain_text',
      ),
    ),
  ),
   'field_ssn' => 
  array (
    'und' => 
    array (
      0 => 
      array (
        'value' => '111-22-3333',
        'format' => 'plain_text',
      ),
    ),
  ),
   'field_manner' => 
  array (
    'und' => 
    array (
      0 => 
      array (
        'value' => '',
        'format' => 'plain_text',
      ),
    ),
  ),
   'field_address_1' => 
  array (
    'und' => 
    array (
      0 => 
      array (
        'name' => '',
        'street' => '111 Purple Place',
        'additional' => '',
        'city' => 'Denver',
        'province' => 'CO',
        'postal_code' => '80210',
        'country' => 'us',
        'locpick' => false,
        'latitude' => 0,
        'longitude' => 0,
        'source' => 0,
        'is_primary' => 0,
        'delete_location' => false,
        'fax' => '',
        'phone' => '(303) 111-1111',
        'location_settings' => 
        array (
          'form' => 
          array (
            'fields' => 
            array (
              'name' => 
              array (
                'default' => '',
                'collect' => '0',
                'weight' => '2',
              ),
              'street' => 
              array (
                'default' => '',
                'collect' => '1',
                'weight' => '4',
              ),
              'additional' => 
              array (
                'default' => '',
                'collect' => '0',
                'weight' => '6',
              ),
              'city' => 
              array (
                'default' => '',
                'collect' => '1',
                'weight' => '8',
              ),
              'province' => 
              array (
                'default' => '',
                'collect' => '1',
                'weight' => '10',
                'widget' => 'autocomplete',
              ),
              'postal_code' => 
              array (
                'default' => '',
                'collect' => '1',
                'weight' => '12',
              ),
              'country' => 
              array (
                'default' => 'us',
                'collect' => '4',
                'weight' => '14',
              ),
              'locpick' => 
              array (
                'default' => false,
                'collect' => '0',
                'weight' => '20',
                'nodiff' => true,
              ),
              'phone' => 
              array (
                'default' => '',
                'collect' => '1',
                'weight' => '25',
              ),
              'lid' => 
              array (
                'default' => false,
              ),
              'latitude' => 
              array (
                'default' => 0,
              ),
              'longitude' => 
              array (
                'default' => 0,
              ),
              'source' => 
              array (
                'default' => 0,
              ),
              'is_primary' => 
              array (
                'default' => 0,
              ),
              'delete_location' => 
              array (
                'default' => false,
                'nodiff' => true,
              ),
              'fax' => 
              array (
                'default' => '',
                'collect' => 0,
                'weight' => 30,
              ),
            ),
          ),
          'display' => 
          array (
            'hide' => 
            array (
              'name' => 0,
              'street' => 0,
              'additional' => 0,
              'city' => 0,
              'province' => 0,
              'postal_code' => 0,
              'country' => 0,
              'locpick' => 0,
              'phone' => 0,
              'province_name' => 0,
              'country_name' => 0,
              'map_link' => 0,
              'coords' => 0,
            ),
          ),
        ),
        'lid' => '756',
      ),
    ),
  ),
   'field_court_county' => 
  array (
    'und' => 
    array (
      0 => 
      array (
        'value' => 'Denver',
        'format' => 'plain_text',
      ),
    ),
  ),
   'field_address_2' => 
  array (
    'und' => 
    array (
      0 => 
      array (
        'name' => 'A Scam Enterprises',
        'street' => '888 Orange Way',
        'additional' => '',
        'city' => 'Denver',
        'province' => 'CO',
        'postal_code' => '80203',
        'country' => 'us',
        'locpick' => false,
        'latitude' => 0,
        'longitude' => 0,
        'source' => 0,
        'is_primary' => 0,
        'delete_location' => false,
        'fax' => '',
        'phone' => '(303) 222-2222',
        'location_settings' => 
        array (
          'form' => 
          array (
            'fields' => 
            array (
              'name' => 
              array (
                'default' => '',
                'collect' => '1',
                'weight' => '2',
              ),
              'street' => 
              array (
                'default' => '',
                'collect' => '1',
                'weight' => '4',
              ),
              'additional' => 
              array (
                'default' => '',
                'collect' => '0',
                'weight' => '6',
              ),
              'city' => 
              array (
                'default' => '',
                'collect' => '1',
                'weight' => '8',
              ),
              'province' => 
              array (
                'default' => '',
                'collect' => '1',
                'weight' => '10',
                'widget' => 'autocomplete',
              ),
              'postal_code' => 
              array (
                'default' => '',
                'collect' => '1',
                'weight' => '12',
              ),
              'country' => 
              array (
                'default' => 'us',
                'collect' => '4',
                'weight' => '14',
              ),
              'locpick' => 
              array (
                'default' => false,
                'collect' => '0',
                'weight' => '20',
                'nodiff' => true,
              ),
              'phone' => 
              array (
                'default' => '',
                'collect' => '1',
                'weight' => '25',
              ),
              'lid' => 
              array (
                'default' => false,
              ),
              'latitude' => 
              array (
                'default' => 0,
              ),
              'longitude' => 
              array (
                'default' => 0,
              ),
              'source' => 
              array (
                'default' => 0,
              ),
              'is_primary' => 
              array (
                'default' => 0,
              ),
              'delete_location' => 
              array (
                'default' => false,
                'nodiff' => true,
              ),
              'fax' => 
              array (
                'default' => '',
                'collect' => 0,
                'weight' => 30,
              ),
            ),
          ),
          'display' => 
          array (
            'hide' => 
            array (
              'name' => 0,
              'street' => 0,
              'additional' => 0,
              'city' => 0,
              'province' => 0,
              'postal_code' => 0,
              'country' => 0,
              'locpick' => 0,
              'phone' => 0,
              'province_name' => 0,
              'country_name' => 0,
              'map_link' => 0,
              'coords' => 0,
            ),
          ),
        ),
        'lid' => '757',
      ),
    ),
  ),
   'field_new_home_address' => 
  array (
    'und' => 
    array (
      0 => 
      array (
        'value' => '',
        'format' => 'plain_text',
      ),
    ),
  ),
   'field_new_job' => 
  array (
    'und' => 
    array (
      0 => 
      array (
        'value' => '',
        'format' => 'plain_text',
      ),
    ),
  ),
   'field_new_bank' => 
  array (
    'und' => 
    array (
      0 => 
      array (
        'value' => '',
        'format' => 'plain_text',
      ),
    ),
  ),
   'field_serve_date' => 
  array (
    'und' => 
    array (
      0 => 
      array (
        'timezone' => 'America/Denver',
        'offset' => 0,
        'date' => 
        FeedsDateTime::__set_state(array(
           'granularity' => 
          array (
            0 => 'zone',
          ),
           '_serialized_time' => NULL,
           '_serialized_timezone' => NULL,
           'date' => '2012-04-23 13:32:12',
           'timezone_type' => 3,
           'timezone' => 'America/Denver',
        )),
        'value' => '2012-04-23 13:32:12',
        'timezone_db' => 'America/Denver',
        'date_type' => 'datetime',
      ),
    ),
  ),
   'body' => 
  array (
    'und' => 
    array (
      0 => 
      array (
        'value' => '',
        'format' => 'plain_text',
      ),
    ),
  ),
   'field_address_served' => 
  array (
    'und' => 
    array (
      0 => 
      array (
        'lid' => false,
        'name' => '',
        'street' => '',
        'additional' => '',
        'city' => '',
        'province' => '',
        'postal_code' => '',
        'country' => 'us',
        'locpick' => false,
        'latitude' => 0,
        'longitude' => 0,
        'source' => 0,
        'is_primary' => 0,
        'delete_location' => false,
        'fax' => '',
        'phone' => '',
        'location_settings' => 
        array (
          'form' => 
          array (
            'fields' => 
            array (
              'name' => 
              array (
                'default' => '',
                'collect' => '0',
                'weight' => '2',
              ),
              'street' => 
              array (
                'default' => '',
                'collect' => '1',
                'weight' => '4',
              ),
              'additional' => 
              array (
                'default' => '',
                'collect' => '0',
                'weight' => '6',
              ),
              'city' => 
              array (
                'default' => '',
                'collect' => '1',
                'weight' => '8',
              ),
              'province' => 
              array (
                'default' => '',
                'collect' => '1',
                'weight' => '10',
                'widget' => 'autocomplete',
              ),
              'postal_code' => 
              array (
                'default' => '',
                'collect' => '1',
                'weight' => '12',
              ),
              'country' => 
              array (
                'default' => 'us',
                'collect' => '4',
                'weight' => '14',
              ),
              'locpick' => 
              array (
                'default' => false,
                'collect' => '0',
                'weight' => '20',
                'nodiff' => true,
              ),
              'phone' => 
              array (
                'default' => '',
                'collect' => '1',
                'weight' => '25',
              ),
              'lid' => 
              array (
                'default' => false,
              ),
              'latitude' => 
              array (
                'default' => 0,
              ),
              'longitude' => 
              array (
                'default' => 0,
              ),
              'source' => 
              array (
                'default' => 0,
              ),
              'is_primary' => 
              array (
                'default' => 0,
              ),
              'delete_location' => 
              array (
                'default' => false,
                'nodiff' => true,
              ),
              'fax' => 
              array (
                'default' => '',
                'collect' => 0,
                'weight' => 30,
              ),
            ),
          ),
          'display' => 
          array (
            'hide' => 
            array (
              'name' => 0,
              'street' => 0,
              'additional' => 0,
              'city' => 0,
              'province' => 0,
              'postal_code' => 0,
              'country' => 0,
              'locpick' => 0,
              'phone' => 0,
              'province_name' => 0,
              'country_name' => 0,
              'map_link' => 0,
              'coords' => 0,
            ),
          ),
        ),
      ),
    ),
  ),
   'is_new' => true,
   'timestamp' => 1335209532,
   'nid' => '217',
   'vid' => '217',
   'tnid' => 0,
   'translate' => 0,
   'field_document_servable' => 
  array (
    'und' => 
    array (
      0 => 
      array (
        'value' => 'yes',
      ),
    ),
  ),
   'field_liberty_completed' => 
  array (
    'und' => 
    array (
      0 => 
      array (
        'value' => 'no',
      ),
    ),
  ),
))

dblog

PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'field_address_served_lid' at row 1: INSERT INTO {field_data_field_address_served} (entity_type, entity_id, revision_id, bundle, delta, language, field_address_served_lid) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6); Array ( [:db_insert_placeholder_0] => node [:db_insert_placeholder_1] => 222 [:db_insert_placeholder_2] => 222 [:db_insert_placeholder_3] => document [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => und [:db_insert_placeholder_6] => ) in field_sql_storage_field_storage_write() (line 448 of /Users/killtheliterate/Sites/public_html/dbg-lib.local/modules/field/modules/field_sql_storage/field_sql_storage.module).
digitalfrontiersmedia’s picture

You should also check your data to make sure there aren't illegal characters etc. in the data messing up the import. This was the cause of my errors of the type above.

killtheliterate’s picture

I've tried many different ways of making sure everything is uft-8. Would it be helpful for me to upload a sample csv and module of the feed importer?

elliotttf’s picture

Assigned: Unassigned » elliotttf

I'm able to reproduce the problem locally, working on a fix now.

elliotttf’s picture

Status: Active » Fixed

A fix has been deployed in 7.x-1.6. I don't know if this also affects the D6 version but I haven't made the change there. Thanks killtheliterate for the debug output!

Status: Fixed » Closed (fixed)

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

geefin’s picture

I still had this occurring with 7.x-1.6.

'Fixed it' by adding a default country and a province of 'NULL' in the incoming feed.

mikel1’s picture

I'm having this problem with 7.x-1.6 as well. I have a default country in the content type. I am only setting latitude and longitude in my feed though. When they are not present or are 0 I get the error described at the beginning of this thread. Will open a new ticket against 7.x-1.6