Checkout issue

When I try to checkout, I keep getting this error. Is there a tutorial out there that shows how to set everything up in the checkout and shipping configuration?

Status message
The website encountered an unexpected error. Please try again later.

Posted: Oct 4, 2011


rfay Randy Fay on October 4, 2011

This is an error, and there has to be more information somewhere. Either please provide the full text of the error (and a complete recipe of what you do to get it) or look in admin/reports/dblog to see what happens there.

scott.carlton on November 13, 2011

Try to checkout and I get this

The website encountered an unexpected error. Please try again later.

When I look at the report I see this.

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'users.profile_id' in 'order clause': SELECT users.uid AS entity_id, :entity_type AS entity_type, NULL AS revision_id, :bundle AS bundle FROM {users} users WHERE (users.status = :db_condition_placeholder_0) AND (users.uid = :db_condition_placeholder_1) HAVING (bundle IN (:db_condition_placeholder_2)) ORDER BY users.profile_id DESC; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => 1 [:db_condition_placeholder_2] => user [:entity_type] => user [:bundle] => user ) in commerce_addressbook_get_saved_addresses() (line 492 of /home/aip/public_html/sites/all/modules/commerce_addressbook/commerce_addressbook.module).

Only happens if I am logged in as a user but if anonymous everything is fine.

rfay Randy Fay on November 13, 2011

It looks like commerce_addressbook is looking for a field that does not exist in the database. This commonly happens with:

1. People not running update.php after updating
2. Running mismatched version of software (like an old commerce_addressbook, or an old commerce, or ...)

scott.carlton on November 13, 2011

Ya, I updated my database and modules, but this doesn't fix the error. It happen after updating the modules to the recommend through drupal. My hands are up in the air.....Everything was going so good.

scott.carlton on November 13, 2011

I had a field for user to sign up through address field with billing and shipping address which I guess was the issue. Deleted the fields from the user and seem to fix the problem. How do I connect a user address to the store?

rfay Randy Fay on November 13, 2011

So... because there's no consistent way for Drupal users to have address information associated with them, and because the relationship of customers to Drupal users is not necessarily one to one, we use a Commerce-specific profile entity to track customers. Surely somebody will roll an approach that ties this to Drupal users, but to my knowledge it hasn't happened yet.

Humphreybas on February 20, 2012

Ran into the same problems lately. My drupal suggested some updates and without really looking at them I started updating. I guess he updated from some dev versions to beta versions or normal versions.
Than the update script also ran into some trouble if I remember correctly (fixed the issues today but ran into them some weeks ago).
Solution for me: update commerce and all of its dependencies and commerce adressbook to the dev version.