Getting this error when trying to use a custom filter inside a custom theme.
I have set up the new attribute "is_featured" and its in an attribute set. I made a product that assigned it as featured (yes/no choice)
My home page (in the CMS section) is including the following "panel"
<block type="catalog/product" name="catalog.product_featured_list" template="catalog/product/featured_list.phtml" after="-"/>
featured_list.phtml looks like this:
<?php
$storeId = Mage::app()->getStore()->getId();
$_productCollection=Mage::getResourceModel('reports/product_collection')
->addAttributeToSelect(array('name', 'url', 'small_image', 'price', 'short_description'))
->addAttributeToFilter('is_featured', 1)
->addAttributeToFilter('status', 1)
->setPageSize(3)
->setStoreId($storeId)
->addStoreFilter($storeId);
$_helper = $this->helper('catalog/output');
?>
<?php if($_productCollection->count()): ?>
<section class="content-box clearfix">
<header>
<h2>Featured products</h2>
</header>
<ul class="featured-products">
<?php foreach ($_productCollection as $_product): ?>
<?php $_productNameStripped = $this->stripTags($_product->getName(), null, true); ?>
<li>
<h3>
<a href="<?php echo $_product->getProductUrl(); ?>" title="<?php echo $_productNameStripped; ?>">
<?php echo $_helper->productAttribute($_product, $_product->getName() , 'name'); ?>
</a>
</h3>
<a href="<?php echo $_product->getProductUrl(); ?>" title="<?php echo $_productNameStripped; ?>">
<img src="<?php echo $this->helper('catalog/image')->init($_product, 'small_image')->resize(212); ?>" width="200" height="200" alt="<?php echo $this->stripTags($this->getImageLabel($_product, 'small_image'), null, true) ?>" />
</a>
<div>
<ul class="clearfix">
<li>From £<?php echo number_format($_product->price, 2) ?></li>
<li>
<?php
$desct = nl2br($this->htmlEscape($_product->getShortDescription()));
$desct = strip_tags($_product->getShortDescription());
?>
<p>
<?
echo Mage::helper('core/string')->truncate($desct, '100');
?>
<a href="<?php echo $_product->getProductUrl(); ?>" title="<?php echo $_productNameStripped; ?>">
<?php echo $this->__('more details'); ?>
</a>
</p>
</li>
<li>
<form action="<?php echo $this->helper('checkout/cart')->getAddUrl($_product); //echo $this->getAddToCartUrl($_product); ?>" class="product-list-add-to-cart" method="get" id="product_addtocart_form_<?php echo $_product->getId()?>"<?php if($_product->getOptions()): ?> enctype="multipart/form-data"<?php endif; ?>>
<?php if(!$_product->isGrouped()): ?>
<label for="qty"><?php echo $this->__('Qty') ?>:</label>
<input type="text" class="input-text qty" name="qty" id="qty" maxlength="12" value="<?php echo ($this->getMinimalQty($_product)?$this->getMinimalQty($_product):1) ?>" />
<input type="hidden" name="product" value="<?php echo $_product->getId()?>" />
<?php endif; ?>
<button type="button" class="button" onclick="this.form.submit()"><span><span><?php echo $this->__('Add to Cart') ?></span></span></button>
</form>
</li>
</ul>
</div>
</li>
<?php endforeach; ?>
</ul>
</section>
<?php endif; ?>
It seems like the issue is with the collection at the start of the block. (I can remove this panel form the home page, and the site loads fine)
I'm pretty sure I have all the mentioned attributes available (is_featured looks to be the only custom one)
(this theme was inherited, so I'm not 100% versed in how it works! I'm simply copying it across)