Did I miss a step?
Thanks.

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'commerce_product.profile_id' in 'order clause': SELECT commerce_product.product_id AS entity_id, commerce_product.type AS bundle, :entity_type AS entity_type, NULL AS revision_id FROM {commerce_product} commerce_product WHERE (commerce_product.status = :db_condition_placeholder_0) AND (commerce_product.uid = :db_condition_placeholder_1) AND (type IN (:db_condition_placeholder_2)) ORDER BY commerce_product.profile_id DESC; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => 1 [:db_condition_placeholder_2] => deal [:entity_type] => commerce_product )

Comments

wjaspers’s picture

wjaspers CreditAttribution: wjaspers commented
Priority: Normal » Critical
Status: Active » Closed (duplicate)

This has already been addressed. The cause is trying to use an Addressfield on entities other than Commerce Profiles.
See the patch (needs community review): #1310072: Checkout crashes if Address field attached to Entities which are not customer_profiles

nirdeshm’s picture

nirdeshm CreditAttribution: nirdeshm commented

Thanks wjaspers but in my case I am seeing this error on the default "Billing" profile - the one and only customer profile that was installed along with commerce.