Hi,

I am getting the error below when I try to create a new customer profile. I click on Store->Customer Profile->Add a customer profile. That triggered the error.

My environment is:
Windows 7
Apache 2.2
php 5.2.13
pgsql 9.0

PDOException: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "" LINE 7: ...r_billing0.commerce_customer_billing_profile_id = '') AND (f... ^: SELECT COUNT(*) AS expression FROM (SELECT 1 AS expression FROM {field_data_commerce_customer_billing} field_data_commerce_customer_billing0 INNER JOIN {commerce_order} commerce_order ON commerce_order.order_id = field_data_commerce_customer_billing0.entity_id WHERE (field_data_commerce_customer_billing0.commerce_customer_billing_profile_id = :db_condition_placeholder_0) AND (field_data_commerce_customer_billing0.deleted = :db_condition_placeholder_1) AND (commerce_order.status NOT IN (:db_condition_placeholder_2, :db_condition_placeholder_3, :db_condition_placeholder_4)) AND (field_data_commerce_customer_billing0.entity_type = :db_condition_placeholder_5) ) subquery; Array ( [:db_condition_placeholder_0] => [:db_condition_placeholder_1] => 0 [:db_condition_placeholder_2] => cart [:db_condition_placeholder_3] => checkout_checkout [:db_condition_placeholder_4] => checkout_review [:db_condition_placeholder_5] => commerce_order ) in field_sql_storage_field_storage_query() (line 553 of C:\development\drupal\drupal7p\modules\field\modules\field_sql_storage\field_sql_storage.module).

Comments

rszrama’s picture

You're getting the error when you load the page or when you submit the form?

Hugo Estrada’s picture

When I load the page.

googletorp’s picture

Status: Active » Needs review

I've created a patch for this in my sandbox: 8979e88

rszrama’s picture

Status: Needs review » Fixed

Thanks, committed!

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.