I am getting the following error after upgrading the Commerce core from 1.15 to 1.17
Notice: Undefined index: product_id in commerce_product_reference_get_first_product_id() (line 487 of D:\VPSite\sites\all\modules\commerce\modules\product_reference\commerce_product_reference.module).
and
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND cpr.field_subject_area_product_id = cp.product_id) WHERE (cp.product_id IN ' at line 1: SELECT cp.product_id AS product_id FROM {commerce_product} cp INNER JOIN {field_data_field_subject_area} cpr ON (cpr.entity_type = 'taxonomy_term' AND cpr.entity_id = 1 AND cpr.revision_id = AND cpr.field_subject_area_product_id = cp.product_id) WHERE (cp.product_id IN (:db_condition_placeholder_0)) AND (cp.status = :db_condition_placeholder_1) ORDER BY cpr.delta ASC; Array ( [:db_condition_placeholder_0] => [:db_condition_placeholder_1] => 1 ) in commerce_product_reference_get_first_product_id() (line 510 of D:\VPSite\sites\all\modules\commerce\modules\product_reference\commerce_product_reference.module).
it is not a feature request but yes it seems to be a bug.
I website is a live website, when i update commerce core it is giving this error message. Kidnly help.
Closed: works as designed
1.17
Product reference
I was able to solve the issue. The error was commerce module was taking field_subject_area as a product field instead of an entity reference field which it actually was.
after deleting the field I was able to upgrade the commerce module without any errors.