Advertisement
Guest User

Untitled

a guest
Apr 24th, 2017
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.13 KB | None | 0 0
  1. a:5:{i:0;s:3751:"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.vendor' in 'where clause', query was: SELECT FLOOR((ROUND(((e.min_price -(e.min_price/(1+(CASE e.tax_class_id WHEN 1 THEN 0.1900 WHEN 2 THEN 0.0700 WHEN 3 THEN 0.1900 WHEN 4 THEN 0.0700 ELSE 0 END))*CASE e.tax_class_id WHEN 1 THEN 0.1900 WHEN 2 THEN 0.0700 WHEN 3 THEN 0.1900 WHEN 4 THEN 0.0700 ELSE 0 END)+((e.min_price-(e.min_price/(1+(CASE e.tax_class_id WHEN 1 THEN 0.1900 WHEN 2 THEN 0.0700 WHEN 3 THEN 0.1900 WHEN 4 THEN 0.0700 ELSE 0 END))*CASE e.tax_class_id WHEN 1 THEN 0.1900 WHEN 2 THEN 0.0700 WHEN 3 THEN 0.1900 WHEN 4 THEN 0.0700 ELSE 0 END))*CASE e.tax_class_id WHEN 1 THEN 0.1900 WHEN 2 THEN 0.0700 WHEN 3 THEN 0.1900 WHEN 4 THEN 0.0700 ELSE 0 END))) * 1, 2)) / 1000) + 1 AS `range`, COUNT(*) AS `count` FROM `catalog_product_index_price` AS `e`
  2. 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 = '4' WHERE 1=1 AND (e.vendor IN('168', '221', '123', '13306', '390', '522')) AND (e.vendor IN('168', '221', '123', '13306', '390', '522')) AND (e.vendor IN('168', '221', '123', '13306', '390', '522')) AND (e.vendor IN('168', '221', '123', '13306', '390', '522')) AND ( e.website_id = '1' ) AND ( e.customer_group_id = 0) AND ((e.min_price -(e.min_price/(1+(CASE e.tax_class_id WHEN 1 THEN 0.1900 WHEN 2 THEN 0.0700 WHEN 3 THEN 0.1900 WHEN 4 THEN 0.0700 ELSE 0 END))*CASE e.tax_class_id WHEN 1 THEN 0.1900 WHEN 2 THEN 0.0700 WHEN 3 THEN 0.1900 WHEN 4 THEN 0.0700 ELSE 0 END)+((e.min_price-(e.min_price/(1+(CASE e.tax_class_id WHEN 1 THEN 0.1900 WHEN 2 THEN 0.0700 WHEN 3 THEN 0.1900 WHEN 4 THEN 0.0700 ELSE 0 END))*CASE e.tax_class_id WHEN 1 THEN 0.1900 WHEN 2 THEN 0.0700 WHEN 3 THEN 0.1900 WHEN 4 THEN 0.0700 ELSE 0 END))*CASE e.tax_class_id WHEN 1 THEN 0.1900 WHEN 2 THEN 0.0700 WHEN 3 THEN 0.1900 WHEN 4 THEN 0.0700 ELSE 0 END)) IS NOT NULL) GROUP BY FLOOR((ROUND(((e.min_price -(e.min_price/(1+(CASE e.tax_class_id WHEN 1 THEN 0.1900 WHEN 2 THEN 0.0700 WHEN 3 THEN 0.1900 WHEN 4 THEN 0.0700 ELSE 0 END))*CASE e.tax_class_id WHEN 1 THEN 0.1900 WHEN 2 THEN 0.0700 WHEN 3 THEN 0.1900 WHEN 4 THEN 0.0700 ELSE 0 END)+((e.min_price-(e.min_price/(1+(CASE e.tax_class_id WHEN 1 THEN 0.1900 WHEN 2 THEN 0.0700 WHEN 3 THEN 0.1900 WHEN 4 THEN 0.0700 ELSE 0 END))*CASE e.tax_class_id WHEN 1 THEN 0.1900 WHEN 2 THEN 0.0700 WHEN 3 THEN 0.1900 WHEN 4 THEN 0.0700 ELSE 0 END))*CASE e.tax_class_id WHEN 1 THEN 0.1900 WHEN 2 THEN 0.0700 WHEN 3 THEN 0.1900 WHEN 4 THEN 0.0700 ELSE 0 END))) * 1, 2)) / 1000) + 1 ORDER BY FLOOR((ROUND(((e.min_price -(e.min_price/(1+(CASE e.tax_class_id WHEN 1 THEN 0.1900 WHEN 2 THEN 0.0700 WHEN 3 THEN 0.1900 WHEN 4 THEN 0.0700 ELSE 0 END))*CASE e.tax_class_id WHEN 1 THEN 0.1900 WHEN 2 THEN 0.0700 WHEN 3 THEN 0.1900 WHEN 4 THEN 0.0700 ELSE 0 END)+((e.min_price-(e.min_price/(1+(CASE e.tax_class_id WHEN 1 THEN 0.1900 WHEN 2 THEN 0.0700 WHEN 3 THEN 0.1900 WHEN 4 THEN 0.0700 ELSE 0 END))*CASE e.tax_class_id WHEN 1 THEN 0.1900 WHEN 2 THEN 0.0700 WHEN 3 THEN 0.1900 WHEN 4 THEN 0.0700 ELSE 0 END))*CASE e.tax_class_id WHEN 1 THEN 0.1900 WHEN 2 THEN 0.0700 WHEN 3 THEN 0.1900 WHEN 4 THEN 0.0700 ELSE 0 END))) * 1, 2)) / 1000) + 1 ASC";i:1;s:5406:"#0 /Applications/MAMP/htdocs/timste-felgen/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
  3. #1 /Applications/MAMP/htdocs/timste-felgen/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
  4. #2 /Applications/MAMP/htdocs/timste-felgen/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
  5. #3 /Applications/MAMP/htdocs/timste-felgen/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT FLOOR((R...', Array)
  6. #4 /Applications/MAMP/htdocs/timste-felgen/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SELECT FLOOR((R...', Array)
  7. #5 /Applications/MAMP/htdocs/timste-felgen/lib/Zend/Db/Adapter/Abstract.php(811): Varien_Db_Adapter_Pdo_Mysql->query('SELECT FLOOR((R...', Array)
  8. #6 /Applications/MAMP/htdocs/timste-felgen/app/code/core/Mage/Catalog/Model/Resource/Layer/Filter/Price.php(282): Zend_Db_Adapter_Abstract->fetchPairs(Object(Varien_Db_Select))
  9. #7 /Applications/MAMP/htdocs/timste-felgen/app/code/core/Mage/Catalog/Model/Layer/Filter/Price.php(158): Mage_Catalog_Model_Resource_Layer_Filter_Price->getCount(Object(Mage_Catalog_Model_Layer_Filter_Price), 1000)
  10. #8 /Applications/MAMP/htdocs/timste-felgen/app/code/core/Mage/Catalog/Model/Layer/Filter/Price.php(115): Mage_Catalog_Model_Layer_Filter_Price->getRangeItemCounts(1000)
  11. #9 /Applications/MAMP/htdocs/timste-felgen/app/code/core/Mage/Catalog/Model/Layer/Filter/Price.php(314): Mage_Catalog_Model_Layer_Filter_Price->getPriceRange()
  12. #10 /Applications/MAMP/htdocs/timste-felgen/app/code/core/Mage/Catalog/Model/Layer/Filter/Abstract.php(151): Mage_Catalog_Model_Layer_Filter_Price->_getItemsData()
  13. #11 /Applications/MAMP/htdocs/timste-felgen/app/code/core/Mage/Catalog/Model/Layer/Filter/Abstract.php(120): Mage_Catalog_Model_Layer_Filter_Abstract->_initItems()
  14. #12 /Applications/MAMP/htdocs/timste-felgen/app/code/core/Mage/Catalog/Model/Layer/Filter/Abstract.php(109): Mage_Catalog_Model_Layer_Filter_Abstract->getItems()
  15. #13 /Applications/MAMP/htdocs/timste-felgen/app/code/core/Mage/Catalog/Block/Layer/Filter/Abstract.php(132): Mage_Catalog_Model_Layer_Filter_Abstract->getItemsCount()
  16. #14 /Applications/MAMP/htdocs/timste-felgen/app/design/frontend/rwdx/default/template/catalog/layer/view.phtml(46): Mage_Catalog_Block_Layer_Filter_Abstract->getItemsCount()
  17. #15 /Applications/MAMP/htdocs/timste-felgen/app/code/core/Mage/Core/Block/Template.php(241): include('/Applications/M...')
  18. #16 /Applications/MAMP/htdocs/timste-felgen/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/rwdx/d...')
  19. #17 /Applications/MAMP/htdocs/timste-felgen/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
  20. #18 /Applications/MAMP/htdocs/timste-felgen/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Template->_toHtml()
  21. #19 /Applications/MAMP/htdocs/timste-felgen/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
  22. #20 /Applications/MAMP/htdocs/timste-felgen/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Text_List->_toHtml()
  23. #21 /Applications/MAMP/htdocs/timste-felgen/app/code/core/Mage/Core/Block/Abstract.php(641): Mage_Core_Block_Abstract->toHtml()
  24. #22 /Applications/MAMP/htdocs/timste-felgen/app/code/core/Mage/Core/Block/Abstract.php(585): Mage_Core_Block_Abstract->_getChildHtml('left_first', true)
  25. #23 /Applications/MAMP/htdocs/timste-felgen/app/design/frontend/rwdx/default/template/page/2columns-left.phtml(56): Mage_Core_Block_Abstract->getChildHtml('left_first')
  26. #24 /Applications/MAMP/htdocs/timste-felgen/app/code/core/Mage/Core/Block/Template.php(241): include('/Applications/M...')
  27. #25 /Applications/MAMP/htdocs/timste-felgen/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/rwdx/d...')
  28. #26 /Applications/MAMP/htdocs/timste-felgen/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
  29. #27 /Applications/MAMP/htdocs/timste-felgen/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Template->_toHtml()
  30. #28 /Applications/MAMP/htdocs/timste-felgen/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml()
  31. #29 /Applications/MAMP/htdocs/timste-felgen/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput()
  32. #30 /Applications/MAMP/htdocs/timste-felgen/app/code/core/Mage/Catalog/controllers/CategoryController.php(161): Mage_Core_Controller_Varien_Action->renderLayout()
  33. #31 /Applications/MAMP/htdocs/timste-felgen/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Catalog_CategoryController->viewAction()
  34. #32 /Applications/MAMP/htdocs/timste-felgen/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('view')
  35. #33 /Applications/MAMP/htdocs/timste-felgen/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
  36. #34 /Applications/MAMP/htdocs/timste-felgen/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch()
  37. #35 /Applications/MAMP/htdocs/timste-felgen/app/Mage.php(683): Mage_Core_Model_App->run(Array)
  38. #36 /Applications/MAMP/htdocs/timste-felgen/index.php(83): Mage::run('', 'store')
  39. #37 {main}";s:3:"url";s:25:"/timste-felgen/alufelgen/";s:11:"script_name";s:24:"/timste-felgen/index.php";s:4:"skin";s:7:"default";}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement