Error on Checkout

Did you use the latest dev version of Address Field? There should be no schema problems with it.

There's a warning about the uninstall process on the project page; it's still a work in progress thanks to a core issue with the removal of fields on uninstall. Additionally, if your site is an update from an older version to the beta, that also wasn't supported.

Here's the pertinent issue; for now I'm going to mark this one closed unless you can come up with steps to reproduce the Address Field problem on a clean install:

#858722: Cannot reinstall Commerce modules after uninstall due to field deletion failure

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'commerce_customer_address_xnl' in 'field list': INSERT INTO {field_data_commerce_customer_address} (entity_type, entity_id, revision_id, bundle, delta, language, ...

I have same errorcode when changing addressfield-module from alpha to dev-version.

I need to do this to apply fields for Belgian addresses conform xnal-standards.

Please advise.

As w/ Commerce, database updates weren't supported during Address Field alpha releases; Address Field really just needs to be turned into beta. Can you rebuild this site? If not, you should be able to completely uninstall addressfield and reinstall it, manually adding back an Address Field onto your customer profile types.

I was able to rebuild by simply deleting the addressfield-module-folder on the server and replace it with a recently made backup.
Thank you for the follow-up.
Kind regards,
W.

Great, glad to hear it.

Hi,

I had the same problem and solved it by running this SQL queries. It will simply add the missing columns.

ALTER TABLE `field_data_commerce_customer_address` ADD `commerce_customer_address_xnl` longtext;
ALTER TABLE `field_data_commerce_customer_address` ADD `commerce_customer_address_name_line` varchar(255);
ALTER TABLE `field_data_commerce_customer_address` ADD `commerce_customer_address_first_name` varchar(255);
ALTER TABLE `field_data_commerce_customer_address` ADD `commerce_customer_address_last_name` varchar(255);
ALTER TABLE `field_data_commerce_customer_address` ADD `commerce_customer_address_organisation_name` varchar(255);
ALTER TABLE `field_data_commerce_customer_address` ADD `commerce_customer_address_xal` longtext;
ALTER TABLE `field_revision_commerce_customer_address` ADD `commerce_customer_address_xnl` longtext;
ALTER TABLE `field_revision_commerce_customer_address` ADD `commerce_customer_address_name_line` varchar(255);
ALTER TABLE `field_revision_commerce_customer_address` ADD `commerce_customer_address_first_name` varchar(255);
ALTER TABLE `field_revision_commerce_customer_address` ADD `commerce_customer_address_last_name` varchar(255);
ALTER TABLE `field_revision_commerce_customer_address` ADD `commerce_customer_address_organisation_name` varchar(255);
ALTER TABLE `field_revision_commerce_customer_address` ADD `commerce_customer_address_xal` longtext;

Same error here, checkout gives WSOD as fields don't exist in database.

Here's the code for an update hook to add the fields to an existing install:

Steps:

* Change EXAMPLE_ to your module name, e.g mymodule_update_7001
* Add to your module's .install file
* Run update.php to apply database updates.

<?php
/**
 * Add new fields for Address Field module
 */
function EXAMPLE_update_7001(){
  $ret = array();

  $fields = array(
    'commerce_customer_address_xnl' => array(
      'description' => "XML contents of the xNL element.",
      'type' => 'text',
      'size' => 'big',
      'not null' => FALSE,
    ),
    'commerce_customer_address_name_line' => array(
      'description' => 'Contents of a primary NameLine element in the xNL XML.',
      'type' => 'varchar',
      'length' => 255,
      'not null' => FALSE,
      'default' => '',
    ),
    'commerce_customer_address_first_name' => array(
      'description' => 'Contents of the FirstName element of a primary PersonName element in the xNL XML.',
      'type' => 'varchar',
      'length' => 255,
      'not null' => FALSE,
      'default' => '',
    ),
    'commerce_customer_address_last_name' => array(
      'description' => 'Contents of the LastName element of a primary PersonName element in the xNL XML.',
      'type' => 'varchar',
      'length' => 255,
      'not null' => FALSE,
      'default' => '',
    ),
    'commerce_customer_address_organisation_name' => array(
      'description' => 'Contents of a primary OrganisationName element in the xNL XML.',
      'type' => 'varchar',
      'length' => 255,
      'not null' => FALSE,
      'default' => '',
    ),
    'commerce_customer_address_xal' => array(
      'description' => "XML contents of the address xAL element.",
      'type' => 'text',
      'size' => 'big',
      'not null' => FALSE,
    ),
  );
  foreach($fields as $field => $definition){
    if( ! db_field_exists('field_data_commerce_customer_address', $field)){
      db_add_field('field_data_commerce_customer_address', $field, $definition);
    }
    if( ! db_field_exists('field_revision_commerce_customer_address', $field)){
      db_add_field('field_revision_commerce_customer_address', $field, $definition);
    }
  }

  return $ret;
}
?>

Thanks for the interesting module,

DT

Let's actually solve the issue via #1174262: Column not found: 1054 Unknown column 'field_address_xnl', as that's the proper queue to put an update function in. We'll need to support this since we moved to beta in DC before going beta in Address field.

Great solution davidwhthomas, it worked for me! Thanks!