Error on checkout page. Fields from customer profilers unusable for other entities. [#1321230]

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'taxonomy_term_data.status' in 'where clause': SELECT taxonomy_term_data.tid AS entity_id, :entity_type AS entity_type, NULL AS revision_id FROM {taxonomy_term_data} taxonomy_term_data WHERE (taxonomy_term_data.status = :db_condition_placeholder_0) AND (taxonomy_term_data.uid = :db_condition_placeholder_1) AND (vocabulary_machine_name IN (:db_condition_placeholder_2)) ORDER BY taxonomy_term_data.profile_id DESC; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => 1 [:db_condition_placeholder_2] => taxonomy_name [:entity_type] => taxonomy_term ) în EntityFieldQuery->execute() (linia 1117 din /drupal_path/includes/entity.inc).

where "taxonnomy_name" is the taxonomy name of a term reference for the product type in the cart.
the error continues to show even i deleted the term reference field for the product type.

what else i can say is that for this taxonomy has custom fields defined, one/some of them field already used for other entities as customer billiing profile.

Comments

Comment #1

rszrama CreditAttribution: rszrama commented 25 October 2011 at 18:11

Can you provide more details on your configuration? We need enough info to be able to reproduce the error to debug it.

Comment #2

vasike

Ramnicu Valcea

CreditAttribution: vasike commented 25 October 2011 at 21:17

i think i found something.
i installed http://drupal.org/project/commerce_devel and noticed some messages that point to addressbook from the module http://drupal.org/project/commerce_addressbook
i go to the new (addressbook approach) field and i got also errors.

i just delete the addressbook from the customer profile and the issues vanished.

as i said in the first post, there are fields defined in the customer profiles, that i want to use in other entities.
once this "reusing" of a customer profile implemented the errors won't stop wher the addresbook involved.

so maybe this should be moved to the "right" project/module.

sorry i can't provide more feedback but it was a critical/unexpected issue that i need to make it history.

thanks

Comment #3

vasike

Ramnicu Valcea

CreditAttribution: vasike commented 27 October 2011 at 07:21

Title:	Error on check out page	» Error on checkout page. Fields from customer profilers unusable for other entities.
Project:	Commerce Core	» Commerce Addressbook
Component:	Checkout	» Code

move to Commerce Addressbook.

Comment #4

svendecabooter

Dutch

Gent

CreditAttribution: svendecabooter commented 27 December 2011 at 08:34

Status:

Active

» Fixed

This problem has now been addressed.
Previously the code assumed that all entities with an addressfield would be eligible for having addressbook functionality, but that resulted in errors such as those above. Right now this is much better limited, with a focus on customer profile entities now, and supposedly user entities later on.
So your problem would be fixed in the upcoming first release of this module.