When i select to show Most Viewed products in modules like JM Products, JM Products spotlight, etc i have an error in my web
SELECT COUNT(_table_views.event_id) AS `views`, `e`.*, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`anada`, `e`.`anada_value`, `e`.`bodega`, `e`.`bodega_value`, `e`.`cost`, `e`.`created_at`, `e`.`do_zona`, `e`.`do_zona_value`, `e`.`enable_googlecheckout`, `e`.`gift_message_available`, `e`.`has_options`, `e`.`image_label`, `e`.`is_imported`, `e`.`is_recurring`, `e`.`links_exist`, `e`.`links_purchased_separately`, `e`.`links_title`, `e`.`name`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`price`, `e`.`price_type`, `e`.`price_view`, `e`.`recurring_profile`, `e`.`required_options`, `e`.`shipment_type`, `e`.`short_description`, `e`.`sku`, `e`.`sku_type`, `e`.`small_image`, `e`.`small_image_label`, `e`.`special_from_date`, `e`.`special_price`, `e`.`special_to_date`, `e`.`subtipo`, `e`.`subtipo_value`, `e`.`tax_class_id`, `e`.`thumbnail`, `e`.`thumbnail_label`, `e`.`updated_at`, `e`.`url_key`, `e`.`url_path`, `e`.`variedaduva`, `e`.`visibility`, `e`.`weight`, `e`.`weight_type`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(`price_index`.`tier_price`, LEAST(`price_index`.`min_price`, `price_index`.`tier_price`), `price_index`.`min_price`) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `e`.`name`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`small_image`, `e`.`thumbnail`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`tax_class_id`, `e`.`url_key`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`is_imported`, `e`.`do_zona`, `e`.`do_zona_value`, `e`.`anada`, `e`.`anada_value`, `e`.`subtipo`, `e`.`subtipo_value`, `e`.`bodega`, `e`.`bodega_value`, `e`.`variedaduva` FROM `report_event` AS `_table_views`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = _table_views.object_id AND e.entity_type_id = 4
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = ‘1’ AND price_index.customer_group_id = 0 WHERE (_table_views.event_type_id = ‘1’) GROUP BY `e`.`entity_id` HAVING (views > 0) ORDER BY `views` desc LIMIT 5
Trace:
#0 /srv/www/www.siglosgourmet.com/lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#1 /srv/www/www.siglosgourmet.com/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /srv/www/www.siglosgourmet.com/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘SELECT COUNT(_t…’, Array)
#3 /srv/www/www.siglosgourmet.com/lib/Varien/Db/Adapter/Pdo/Mysql.php(333): Zend_Db_Adapter_Pdo_Abstract->query(‘SELECT COUNT(_t…’, Array)
#4 /srv/www/www.siglosgourmet.com/lib/Zend/Db/Adapter/Abstract.php(734): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#5 /srv/www/www.siglosgourmet.com/lib/Varien/Data/Collection/Db.php(783): Zend_Db_Adapter_Abstract->fetchAll(Object(Varien_Db_Select), Array)
#6 /srv/www/www.siglosgourmet.com/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(954): Varien_Data_Collection_Db->_fetchAll(Object(Varien_Db_Select))
#7 /srv/www/www.siglosgourmet.com/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(794): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false)
#8 /srv/www/www.siglosgourmet.com/lib/Varien/Data/Collection.php(740): Mage_Eav_Model_Entity_Collection_Abstract->load()
#9 /srv/www/www.siglosgourmet.com/app/code/local/JoomlArt/JmProducts/Block/List.php(65): Varien_Data_Collection->count()
#10 /srv/www/www.siglosgourmet.com/app/code/core/Mage/Core/Block/Abstract.php(758): JoomlArt_JmProducts_Block_List->_toHtml()
#11 /srv/www/www.siglosgourmet.com/app/code/core/Mage/Core/Model/Email/Template/Filter.php(191): Mage_Core_Block_Abstract->toHtml()
#12 [internal function]: Mage_Core_Model_Email_Template_Filter->blockDirective(Array)
#13 /srv/www/www.siglosgourmet.com/lib/Varien/Filter/Template.php(134): call_user_func(Array, Array)
#14 /srv/www/www.siglosgourmet.com/app/code/core/Mage/Core/Model/Email/Template/Filter.php(502): Varien_Filter_Template->filter(‘<div>{{block ty…’)
#15 /srv/www/www.siglosgourmet.com/app/code/core/Mage/Cms/Block/Page.php(100): Mage_Core_Model_Email_Template_Filter->filter(‘<div>{{block ty…’)
#16 /srv/www/www.siglosgourmet.com/app/code/core/Mage/Core/Block/Abstract.php(758): Mage_Cms_Block_Page->_toHtml()
#17 /srv/www/www.siglosgourmet.com/app/code/core/Mage/Core/Block/Abstract.php(525): Mage_Core_Block_Abstract->toHtml()
#18 /srv/www/www.siglosgourmet.com/app/code/core/Mage/Core/Block/Abstract.php(472): Mage_Core_Block_Abstract->_getChildHtml(‘cms_page’, true)
#19 /srv/www/www.siglosgourmet.com/app/code/core/Mage/Page/Block/Html/Wrapper.php(52): Mage_Core_Block_Abstract->getChildHtml(”, true, true)
#20 /srv/www/www.siglosgourmet.com/app/code/core/Mage/Core/Block/Abstract.php(758): Mage_Page_Block_Html_Wrapper->_toHtml()
#21 /srv/www/www.siglosgourmet.com/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#22 /srv/www/www.siglosgourmet.com/app/code/core/Mage/Core/Block/Abstract.php(758): Mage_Core_Block_Text_List->_toHtml()
#23 /srv/www/www.siglosgourmet.com/app/code/core/Mage/Core/Block/Abstract.php(525): Mage_Core_Block_Abstract->toHtml()
#24 /srv/www/www.siglosgourmet.com/app/code/core/Mage/Core/Block/Abstract.php(476): Mage_Core_Block_Abstract->_getChildHtml(‘content’, true)
#25 /srv/www/www.siglosgourmet.com/app/design/frontend/default/jm_adamite/template/page/2columns-right.phtml(120): Mage_Core_Block_Abstract->getChildHtml(‘content’)
#26 /srv/www/www.siglosgourmet.com/app/code/core/Mage/Core/Block/Template.php(216): include(‘/srv/www/www.si…’)
#27 /srv/www/www.siglosgourmet.com/app/code/core/Mage/Core/Block/Template.php(247): Mage_Core_Block_Template->fetchView(‘frontend/defaul…’)
#28 /srv/www/www.siglosgourmet.com/app/code/core/Mage/Core/Block/Template.php(261): Mage_Core_Block_Template->renderView()
#29 /srv/www/www.siglosgourmet.com/app/code/core/Mage/Core/Block/Abstract.php(758): Mage_Core_Block_Template->_toHtml()
#30 /srv/www/www.siglosgourmet.com/app/code/core/Mage/Core/Model/Layout.php(529): Mage_Core_Block_Abstract->toHtml()
#31 /srv/www/www.siglosgourmet.com/app/code/core/Mage/Core/Controller/Varien/Action.php(389): Mage_Core_Model_Layout->getOutput()
#32 /srv/www/www.siglosgourmet.com/app/code/core/Mage/Cms/Helper/Page.php(130): Mage_Core_Controller_Varien_Action->renderLayout()
#33 /srv/www/www.siglosgourmet.com/app/code/core/Mage/Cms/Helper/Page.php(52): Mage_Cms_Helper_Page->_renderPage(Object(Mage_Cms_IndexController), ‘home’)
#34 /srv/www/www.siglosgourmet.com/app/code/core/Mage/Cms/controllers/IndexController.php(45): Mage_Cms_Helper_Page->renderPage(Object(Mage_Cms_IndexController), ‘home’)
#35 /srv/www/www.siglosgourmet.com/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Cms_IndexController->indexAction()
#36 /srv/www/www.siglosgourmet.com/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(253): Mage_Core_Controller_Varien_Action->dispatch(‘index’)
#37 /srv/www/www.siglosgourmet.com/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http) )
#38 /srv/www/www.siglosgourmet.com/app/code/core/Mage/Core/Model/App.php(340): Mage_Core_Controller_Varien_Front->dispatch()
#39 /srv/www/www.siglosgourmet.com/app/Mage.php(627): Mage_Core_Model_App->run(Array)
#40 /srv/www/www.siglosgourmet.com/index.php(80): Mage::run(”, ‘store’)
#41 {main}
Error log record number: 236996167579
1 answer
Hi xinxeta!
I have checked again our demo but there’s no problem with most viewed.
I couldn’t access your FTP via login information you supplied. Please try to upgrade the modules to the latest version, if it not helps, please check and give us the correct login information via this support ticket OKN-314-51387. We will check again for you.