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
Comment #1
hellownurse CreditAttribution: hellownurse commentedSimilar 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).
Comment #2
longwaveComment #3
longwaveThese 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
Comment #4
hellownurse CreditAttribution: hellownurse commentedHi 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).
Comment #5
longwaveComment #6
simonswiss CreditAttribution: simonswiss commentedsame here, getting a similar error.
I have every single product set to "not shippable", i have checked in the database..
Comment #7
simonswiss CreditAttribution: simonswiss commentedAny idea what's going on here?
Comment #8
wayfarer_boy CreditAttribution: wayfarer_boy commentedLooks 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?
Comment #9
longwaveLooks like #8 is the right fix. See #749190: can't pass FALSE to db_update and #403840: Cast numeric values at the level of the DB driver
Comment #10
longwaveCommitted #8.