Catchable fatal error

Under: Discount Coupons Product/Category Restrictions,

Product Restrictions

Coupon ID Coupon Name Product ID Product Name Allow Deny Remove
Displaying 0 to 0 (of 0 products) Page 0 of 0

Product Name

Catchable fatal error: Object of class queryFactoryResult could not be converted to string in /htdocs/catalog/admin/includes/functions/html_output.php on line 333

what's this about?

Do you have any products in your store?

Yes, about 3000

1. What version of Zen Cart are you using?
2. What addons/mods have you installed on your site?
3. How many coupons do you have created?
4. How many restrictions have you built?
5. Is it correct that this is only happening for "product" restrictions, and that the "category" restrictions area does not report any errors ?

1.3.7
One mod - MSRP thing
About 5 coupons
Restricted to 1 category
No product restrictions

To the right of the dropdown box under Product restrictions is
where that error message appears

Catchable fatal error: Object of class queryFactoryResult could not be converted to string in //htdocs/catalog/admin/includes/functions/html_output.php on line 333

notset4life:

Restricted to 1 category
No product restrictions

To the right of the dropdown box under Product restrictions is
where that error message appears

Catchable fatal error: Object of class queryFactoryResult could not be converted to string in //htdocs/catalog/admin/includes/functions/html_output.php on line 333

There are normally 2 dropdowns under Category Restrictions, and 3 dropdowns under Product Restrictions.

1. Do I understand correctly that you're seeing the 2 under Category Restrictions but only the first (left) one under Product Restrictions?
2. In that first dropdown under Product Restrictions, what is selected? Does it say "Top" or does it show the name of the category to which the product is already restricted above in the Category Restrictions section?

I've attached a screenshot.

thanks for the help so far.

1. Do any of your products' names contain any multibyte or non-english characters, including non-letters/numbers ?

2. Try this edit for debugging: /admin/coupon_restrict.php
   approx line 287:<td class="smallText" valign="top"><?php echo HEADER_PRODUCT_NAME; ?></td> <td class="smallText" align="left"><?php echo zen_draw_pull_down_menu('products_drop', $products_array, $current_category_id); ?></td>Add this ABOVE that:```

1. I don't believe the products contain any "illegal" characters.

I added the lines and it just added a product drop down list with nothing in it.

If I choose a category, the error goes away. (TOP has no Products)

Something seems odd with your database.
However, this bandage approach may work:

/admin/coupon_restrict.php
around line 286 you have:<form name="restrict_category" method="post" action="<?php echo zen_href_link('coupon_restrict.php', zen_get_all_get_params(array('info', 'action', 'x', 'y')) . 'action=add_product&info=' . $cInfo->restrict_id, 'NONSSL'); ?>"> <td class="smallText" valign="top"><?php echo HEADER_PRODUCT_NAME; ?></td> <td class="smallText" align="left"><?php echo zen_draw_pull_down_menu('products_drop', $products_array, $current_category_id); ?></td> <td class="smallText" align="left"><?php echo zen_draw_pull_down_menu('restrict_status', $restrict_array); ?></td> <td class="smallText" align="left"><input type="submit" name="add" value="Add"></td> <td class="smallText" align="left"> </td> <td class="smallText" align="left"> </td>change that to:```
[B]<?php if (sizeof($products_array) > 0) { ?>[/B]
<form name="restrict_category" method="post" action="<?php echo zen_href_link('coupon_restrict.php', zen_get_all_get_params(array('info', 'action', 'x', 'y')) . 'action=add_product&info=' . $cInfo->restrict_id, 'NONSSL'); ?>">
<td class="smallText" valign="top"><?php echo HEADER_PRODUCT_NAME; ?></td>
<td class="smallText" align="left"><?php echo zen_draw_pull_down_menu('products_drop', $products_array, $current_category_id); ?></td>
<td class="smallText" align="left"><?php echo zen_draw_pull_down_menu('restrict_status', $restrict_array); ?></td>
<td class="smallText" align="left"><input type="submit" name="add" value="Add"></td>
<td class="smallText" align="left"> </td>
<td class="smallText" align="left"> </td>
[B]<?php } else { ?>
<td class="smallText" align="left" colspan="6"> </td>

don't undertand any of this, but it resolved the issue.

thank much

Actually I was getting this same error. 1.3.7 ...upgraded from 1.3.0.2 The product restrictions area initially has the errors, but seems to work after I select a category.

Seems like it's because the 'Top' category is the default but I don't have any products at the top, so it produced the error. Selecting a category with products removes the error and displays the product drop-down for the category. So, seems more like just a check is missing for the 0 products...which your fix should fix. =)

deadeye:

Actually I was getting this same error. 1.3.7 ...upgraded from 1.3.0.2 The product restrictions area initially has the errors, but seems to work after I select a category.

Seems like it's because the 'Top' category is the default but I don't have any products at the top, so it produced the error. Selecting a category with products removes the error and displays the product drop-down for the category. So, seems more like just a check is missing for the 0 products...which your fix should fix. =)

Actually I spoke to soon. That doesn't fix the issue I'm seeing. lol It doesn't really matter, just seems like a check is missing.

for PHP 5.2 people and error message see if this helps - thread