Magento – There has been an error processing your request?

In der aktuellen Routine sind mir wieder diverse Probleme untergekommen. Dieses mal beim installieren eine Theme-Packages von VES Themes. Die Installation verlief reibungslos und ich konnte mich an die Konfiguration machen. Jedoch war das Ergebnis im Frontend nicht zufriedenstellend.

Nach einem Blick in die Log /html/newshop/var/report

a:5:{i:0;s:2936:"SELECT SUM(order_items.qty_ordered) AS `ordered_qty`, `order_items`.`name` AS `order_items_name`, `order_items`.`product_id` AS `entity_id`, `e`.`entity_type_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`sku`, `e`.`has_options`, `e`.`required_options`, `e`.`created_at`, `e`.`updated_at`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`cost`, `e`.`created_at`, `e`.`delivery_time`, `e`.`gift_message_available`, `e`.`has_options`, `e`.`image_label`, `e`.`is_recurring`, `e`.`links_exist`, `e`.`links_purchased_separately`, `e`.`links_title`, `e`.`msrp`, `e`.`msrp_display_actual_price_type`, `e`.`msrp_enabled`, `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`.`tax_class_id`, `e`.`thumbnail`, `e`.`thumbnail_label`, `e`.`updated_at`, `e`.`url_key`, `e`.`url_path`, `e`.`visibility`, `e`.`weight`, `e`.`weight_type`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, 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`.`price`, `e`.`small_image`, `cat_index`.`position` AS `cat_index_position`, `e`.`name`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`weight`, `e`.`small_image`, `e`.`thumbnail`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`url_key`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`tax_class_id`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`delivery_time` FROM `sales_flat_order_item` AS `order_items`
INNER JOIN `sales_flat_order` AS `order` ON `order`.entity_id = order_items.order_id AND `order`.state <> 'canceled'
LEFT JOIN `catalog_product_entity` AS `e` ON (e.type_id NOT IN ('grouped', 'configurable', 'bundle')) AND e.entity_id = order_items.product_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
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '2' WHERE (parent_item_id IS NULL) AND (e.entity_id IN(1)) GROUP BY `order_items`.`product_id` HAVING (SUM(order_items.qty_ordered) > 0) ORDER BY `ordered_qty` DESC LIMIT 5

„;i:1;s:6168:“#0 /html/newshop/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /html/newshop/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /html/newshop/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /html/newshop/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‚SELECT SUM(orde…‘, Array)
#4 /html/newshop/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query(‚SELECT SUM(orde…‘, Array)
#5 /html/newshop/lib/Zend/Db/Adapter/Abstract.php(737): Varien_Db_Adapter_Pdo_Mysql->query(‚SELECT SUM(orde…‘, Array)
#6 /html/newshop/lib/Varien/Data/Collection/Db.php(734): Zend_Db_Adapter_Abstract->fetchAll(‚SELECT SUM(orde…‘, Array)
#7 /html/newshop/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(1045): Varien_Data_Collection_Db->_fetchAll(‚SELECT SUM(orde…‘)
#8 /html/newshop/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(871): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false)
#9 /html/newshop/lib/Varien/Data/Collection.php(741): Mage_Eav_Model_Entity_Collection_Abstract->load()
#10 /html/newshop/app/design/frontend/default/ves_fashion/template/ves/megamenu/widgets/product_list.phtml(18): Varien_Data_Collection->getIterator()
#11 /html/newshop/app/code/core/Mage/Core/Block/Template.php(241): include(‚/html/newshop/a…‘)
#12 /html/newshop/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(‚frontend/defaul…‘)
#13 /html/newshop/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#14 /html/newshop/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml()
#15 /html/newshop/app/code/community/Ves/Megamenu/Model/Widget.php(577): Mage_Core_Block_Abstract->toHtml()
#16 /html/newshop/app/code/community/Ves/Megamenu/Model/Widget.php(489): Ves_Megamenu_Model_Widget->renderLayoutHtml(‚product_list‘, Array)
#17 /html/newshop/app/code/community/Ves/Megamenu/Model/Widget.php(32): Ves_Megamenu_Model_Widget->renderWidgetProduct_listContent(Array, Array, ‚Best seller‘)
#18 /html/newshop/app/code/community/Ves/Megamenu/Model/Widget.php(531): Ves_Megamenu_Model_Widget->getWidgetContent(‚product_list‘, Array, ‚Best seller‘)
#19 /html/newshop/app/code/community/Ves/Megamenu/Block/Top.php(597): Ves_Megamenu_Model_Widget->renderContent(‚4′)
#20 /html/newshop/app/code/community/Ves/Megamenu/Block/Top.php(503): Ves_Megamenu_Block_Top->renderWidgetsInCol(Object(stdClass))
#21 /html/newshop/app/code/community/Ves/Megamenu/Block/Top.php(350): Ves_Megamenu_Block_Top->genTree(’44‘, 1, Object(Ves_Megamenu_Model_Megamenu))
#22 /html/newshop/app/code/community/Ves/Megamenu/Block/Top.php(61): Ves_Megamenu_Block_Top->getTree(‚1‘, true, ‚1‘)
#23 /html/newshop/app/code/core/Mage/Core/Block/Abstract.php(919): Ves_Megamenu_Block_Top->_toHtml()
#24 /html/newshop/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#25 /html/newshop/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Text_List->_toHtml()
#26 /html/newshop/app/code/core/Mage/Core/Block/Abstract.php(637): Mage_Core_Block_Abstract->toHtml()
#27 /html/newshop/app/code/core/Mage/Core/Block/Abstract.php(581): Mage_Core_Block_Abstract->_getChildHtml(‚topMenu‘, true)
#28 /html/newshop/app/design/frontend/default/ves_fashion/template/page/html/header.phtml(93): Mage_Core_Block_Abstract->getChildHtml(‚topMenu‘)
#29 /html/newshop/app/code/core/Mage/Core/Block/Template.php(241): include(‚/html/newshop/a…‘)
#30 /html/newshop/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(‚frontend/defaul…‘)
#31 /html/newshop/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#32 /html/newshop/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml()
#33 /html/newshop/app/code/core/Mage/Core/Block/Abstract.php(637): Mage_Core_Block_Abstract->toHtml()
#34 /html/newshop/app/code/core/Mage/Core/Block/Abstract.php(581): Mage_Core_Block_Abstract->_getChildHtml(‚header‘, true)
#35 /html/newshop/app/code/community/Ves/Tempcp/Helper/Framework.php(1102): Mage_Core_Block_Abstract->getChildHtml(‚header‘)
#36 /html/newshop/app/design/frontend/default/ves_fashion/template/page/1column.phtml(42): Ves_Tempcp_Helper_Framework->getModulesByPosition(‚header‘)
#37 /html/newshop/app/code/core/Mage/Core/Block/Template.php(241): include(‚/html/newshop/a…‘)
#38 /html/newshop/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(‚frontend/defaul…‘)
#39 /html/newshop/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#40 /html/newshop/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml()
#41 /html/newshop/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml()
#42 /html/newshop/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput()
#43 /html/newshop/app/code/core/Mage/Cms/Helper/Page.php(137): Mage_Core_Controller_Varien_Action->renderLayout()
#44 /html/newshop/app/code/core/Mage/Cms/Helper/Page.php(52): Mage_Cms_Helper_Page->_renderPage(Object(Mage_Cms_IndexController), ‚home‘)
#45 /html/newshop/app/code/core/Mage/Cms/controllers/IndexController.php(45): Mage_Cms_Helper_Page->renderPage(Object(Mage_Cms_IndexController), ‚home‘)
#46 /html/newshop/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Cms_IndexController->indexAction()
#47 /html/newshop/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch(‚index‘)
#48 /html/newshop/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#49 /html/newshop/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#50 /html/newshop/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#51 /html/newshop/index.php(87): Mage::run(“, ’store‘)
#52 {main}“;s:3:“url“;s:1:“/“;s:11:“script_name“;s:10:“/index.php“;s:4:“skin“;s:2:“de“;}

war klar, dass das Theme bzw. die Konfiguration sich nicht mit FlatCategory und FlatProducts vertragen.

So deaktiviert ihr die Flats:

Ob diese Funktion später noch nutzbar ist, werde ich hier weiter berichten.

Kommentar verfassen