Hi everyone, I'm relatively new to using drupal, ubercart.
I have recently encounter this problem when trying to update my product kit. Error message below.

Error message
Notice: Undefined variable: all_products in uc_product_kit_load() (line 352 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Warning: Invalid argument supplied for foreach() in uc_product_kit_load() (line 352 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined variable: all_products in uc_product_kit_load() (line 352 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Warning: Invalid argument supplied for foreach() in uc_product_kit_load() (line 352 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 259 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 260 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 261 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 262 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined variable: discount in uc_product_kit_update() (line 283 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'shippable' at row 1: UPDATE {uc_products} SET model=:db_update_placeholder_0, list_price=:db_update_placeholder_1, cost=:db_update_placeholder_2, sell_price=:db_update_placeholder_3, weight=:db_update_placeholder_4, weight_units=:db_update_placeholder_5, default_qty=:db_update_placeholder_6, ordering=:db_update_placeholder_7, shippable=:db_update_placeholder_8 WHERE ( (vid = :db_condition_placeholder_0) ); Array ( [:db_update_placeholder_0] => tiger strap [:db_update_placeholder_1] => 0 [:db_update_placeholder_2] => 0 [:db_update_placeholder_3] => 0 [:db_update_placeholder_4] => 0 [:db_update_placeholder_5] => lb [:db_update_placeholder_6] => 0 [:db_update_placeholder_7] => 0 [:db_update_placeholder_8] => [:db_condition_placeholder_0] => 124 ) in uc_product_kit_update() (line 308 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module)

Would really appreciate if someone can help me up.
Thanks.

Comments

hellownurse’s picture

Similar problem occurs when editing the product page.

Error message

Warning: end() expects parameter 1 to be array, null given in file_managed_file_validate() (line 536 of C:\xampp\htdocs\PKG\modules\file\file.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 259 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 260 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 261 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 262 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 259 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 260 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 261 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 262 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 259 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 260 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 261 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 262 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 259 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 260 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 261 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 262 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 259 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 260 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 261 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 262 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 259 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 260 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 261 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 262 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 259 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 260 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 261 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 262 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 259 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 260 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 261 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 262 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 259 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 260 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 261 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined property: stdClass::$qty in uc_product_kit_update() (line 262 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
Notice: Undefined variable: discount in uc_product_kit_update() (line 283 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).
PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'shippable' at row 1: UPDATE {uc_products} SET model=:db_update_placeholder_0, list_price=:db_update_placeholder_1, cost=:db_update_placeholder_2, sell_price=:db_update_placeholder_3, weight=:db_update_placeholder_4, weight_units=:db_update_placeholder_5, default_qty=:db_update_placeholder_6, ordering=:db_update_placeholder_7, shippable=:db_update_placeholder_8 WHERE ( (vid = :db_condition_placeholder_0) ); Array ( [:db_update_placeholder_0] => 3-Ply Face Masks (Blue) / Tape Dispenser / Raincoat / Detergent / PVC Cabel / Swan Air Bubble Pak / Tarpaulin sheet / NiJi Spray Paint (Red) / tiger strap [:db_update_placeholder_1] => 0 [:db_update_placeholder_2] => 0 [:db_update_placeholder_3] => 0 [:db_update_placeholder_4] => 0 [:db_update_placeholder_5] => lb [:db_update_placeholder_6] => 0 [:db_update_placeholder_7] => -1 [:db_update_placeholder_8] => [:db_condition_placeholder_0] => 125 ) in uc_product_kit_update() (line 308 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).

longwave’s picture

Title: Product-Kit problem » Product kit throws several errors on save
Category: support » bug
longwave’s picture

Status: Active » Fixed

These should now be fixed in 7.x-3.x-dev, except for "Warning: end() expects parameter 1 to be array, null given in file_managed_file_validate()" which is a bug in Drupal core: #1049462: Usage of deprecated $form_state['clicked_button'] causes bugs during AJAX submissions by non-buttons

hellownurse’s picture

Hi longwave, I have downloaded the latest ubercart 7.x-3.x-dev, and I have try to update an existing product kit, and it still give me the following error.

DOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'shippable' at row 1: UPDATE {uc_products} SET model=:db_update_placeholder_0, list_price=:db_update_placeholder_1, cost=:db_update_placeholder_2, sell_price=:db_update_placeholder_3, weight=:db_update_placeholder_4, weight_units=:db_update_placeholder_5, default_qty=:db_update_placeholder_6, ordering=:db_update_placeholder_7, shippable=:db_update_placeholder_8 WHERE ( (vid = :db_condition_placeholder_0) ); Array ( [:db_update_placeholder_0] => 3-Ply Face Masks (Blue) / Detergent / NiJi Spray Paint (Red) / PVC Cabel / Raincoat / Swan Air Bubble Pak / Tape Dispenser / Tarpaulin sheet / tiger strap [:db_update_placeholder_1] => 0 [:db_update_placeholder_2] => 0 [:db_update_placeholder_3] => 0 [:db_update_placeholder_4] => 0 [:db_update_placeholder_5] => lb [:db_update_placeholder_6] => 0 [:db_update_placeholder_7] => -1 [:db_update_placeholder_8] => [:db_condition_placeholder_0] => 125 ) in uc_product_kit_update() (line 311 of C:\xampp\htdocs\PKG\modules\ubercart\uc_product_kit\uc_product_kit.module).

longwave’s picture

Status: Fixed » Active
simonswiss’s picture

same here, getting a similar error.

I have every single product set to "not shippable", i have checked in the database..


PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'shippable' at row 1: UPDATE {uc_products} SET model=:db_update_placeholder_0, list_price=:db_update_placeholder_1, cost=:db_update_placeholder_2, sell_price=:db_update_placeholder_3, weight=:db_update_placeholder_4, weight_units=:db_update_placeholder_5, default_qty=:db_update_placeholder_6, ordering=:db_update_placeholder_7, shippable=:db_update_placeholder_8 WHERE ( (vid = :db_condition_placeholder_0) ); 


simonswiss’s picture

Any idea what's going on here?

wayfarer_boy’s picture

Looks like the 'shippable' field in the db_merge call isn't an acceptable value (ie, it's empty), which is strange as the $obj->shippable variable is a boolean and the shippable field in the sql database is boolean. However, changing line 306 in uc_product_kit.module to
'shippable' => $obj->shippable ? 1 : 0,
is accepted by the db_merge function, and no error message appears.

So, is this the correct way to deal with this error - ie, does the Database API require booleans to be converted to integers - or is there something more mysterious going on here and this solution is merely a dirty hack?

longwave’s picture

longwave’s picture

Status: Active » Fixed

Committed #8.

Status: Fixed » Closed (fixed)

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