[Done v2.0.0]Error deleting ALL attribs: Cannot use object of type queryFactoryResult

[digidiva-kathy]

I received this e-mail after upgrading a client from 1.3.7 to 1.3.8a:

I'm currently inserting some new product in my shop and I realized that I may have done the attributes wrong for one of the items. Before the upgrade I would just click on that item's attributes and hit "delete ALL product attributes for blah blah blah" and then I would simply redo it. Now when I go to delete All attributes I get the following message...

Fatal error: Cannot use object of type queryFactoryResult as array in /home/hersite/public_html/shop/admin/includes/functions/general.php on line 2089

I tried searching, but there were so many threads that it was difficult to sort through them all to look for what applies here. Any ideas?

Thanks!

[DrByte]

a bug!

There's a small error in the function that is used to delete attributes, which only manifests when the product has Download Files attached to it.

To fix it, edit this file:
/admin/includes/functions/general.php

around line 2082, you'll see the following code.
Make the following change by adding the ->fields text as shown:

////
// Delete all product attributes
  function zen_delete_products_attributes($delete_product_id) {
    global $db;
    // delete associated downloads
    $products_delete_from= $db->Execute("select pa.products_id, pad.products_attributes_id from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " pad  where pa.products_id='" . $delete_product_id . "' and pad.products_attributes_id= pa.products_attributes_id");
    while (!$products_delete_from->EOF) {
      $db->Execute("delete from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " where products_attributes_id = '" . $products_delete_from->fields['products_attributes_id'] . "'");
      $products_delete_from->MoveNext();
    }

    $db->Execute("delete from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . $delete_product_id . "'");
}

[hugo13]

a bug!

this bug is back with PHP5.3 support == http://www.zen-cart.com/forum/showthread.php?t=140960
because $products_delete_from->fields['products_attributes_id'] is lost again

same with banner_monthly.php == http://www.zen-cart.com/forum/showpo...1&postcount=23

[DrByte]

Yes. The PHP 5.3 files must be merged with any other fixes you've applied to your site.
The PHP 5.3 patch was kept as minimalist as possible.