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?
Error
Status message
The website encountered an unexpected error. Please try again later.
Comments
This is an error
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.
I get this same thing now.
Try to checkout and I get this
Error
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.
Did you run update.php?
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 ...)
Ran update.php
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.
Fixed
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?
Store uses commerce_customer_profile
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.
Same issue, different fix
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.
rfay i have this issue to,
rfay i have this issue to, have been trying to ignore it for a while,
glad you cleared that up. now i can deal with it . thank you