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
Comment #1
rszrama CreditAttribution: rszrama commentedYou're getting the error when you load the page or when you submit the form?
Comment #2
Hugo Estrada CreditAttribution: Hugo Estrada commentedWhen I load the page.
Comment #3
googletorp CreditAttribution: googletorp commentedI've created a patch for this in my sandbox: 8979e88
Comment #4
rszrama CreditAttribution: rszrama commentedThanks, committed!