Catchable fatal error

[notset4life]

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?

[BlindSide]

Do you have any products in your store?

[notset4life]

Yes, about 3000

[DrByte]

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 ?

[notset4life]

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

[DrByte]

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?

[notset4life]

I've attached a screenshot.

thanks for the help so far.

[DrByte]

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:

<td><pre><?php print_r($products_array); ?></pre></td>

This will bust the table-layout, but will show you what data it thinks it's supposed to put into the pulldown menu.
Will need another screenshot ;)

[notset4life]

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)

[DrByte]

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">&nbsp;</td>
                    <td class="smallText" align="left">&nbsp;</td>

change that to:

<?php if (sizeof($products_array) > 0) { ?>
                    <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">&nbsp;</td>
                    <td class="smallText" align="left">&nbsp;</td>
<?php } else { ?>
                    <td class="smallText" align="left" colspan="6">&nbsp;</td>
<?php } ?>