too long

Question

my situation: 1-column.phml

 echo $this->getLayout()
    ->createBlock('catalog/product_list')
    ->setTemplate('page/html/home-block-top.phtml')
    ->toHtml(); 

then home-block-top.phtml

$_productCollection2 = Mage::getResourceModel('reports/product_collection')->addViewsCount();
$_productCollection2->addCategoryFilter( Mage::getModel('catalog/category')->load(87) );
Mage::getSingleton('catalog/product_status')->addVisibleFilterToCollection($_productCollection2);
Mage::getSingleton('catalog/product_visibility')->addVisibleInCatalogFilterToCollection($_productCollection2);
$_productCollection2->setPageSize(4)->setCurPage(1);

I get this error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'report_table_views.entity_id' in 'on clause'

Someone can help me? Thanks

Answer 1

I don't think you can use those filters in a reports collection if you use addViewsCount. I guess if you need addViewsCount you could create a product collection out of the product ids of the report, and then apply the filters. Something like this:

$mostViewed = Mage::getResourceModel('reports/product_collection')->addViewsCount();
$productIds = array();

foreach ($mostViewed as $product) {
   $productIds[] = $product->getId();
}

// Load a collection of the most viewed products and then apply the desired filters
$_productCollection2 = Mage::getModel('catalog/product')->getCollection()->addAttributeToFilter('entity_id', array('in' => $productIds));
$_productCollection2->addCategoryFilter( Mage::getModel('catalog/category')->load(87) );
Mage::getSingleton('catalog/product_status')->addVisibleFilterToCollection($_productCollection2);
Mage::getSingleton('catalog/product_visibility')->addVisibleInCatalogFilterToCollection($_productCollection2);
$_productCollection2->setPageSize(4)->setCurPage(1);

I think something like that might work, not sure if there are better ways though. I hope it helps!