Catchable fatal error

[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 } ?>

[notset4life]

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

thank much

[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. =)