Magento Forum

   
Errors on product description page
 
contactlenzen
Jr. Member
 
Total Posts:  6
Joined:  2009-03-17
 

We are moving our OSCommerce stores to Magento but now we receive errors on the product description page, can someone tell us what we are doing wrong and how to solve this.

We really don’t know why this happens.

SELECT `e`.*, `_table_website_id`.`website_id`, `links`.`link_id`, `_price_rule`.`rule_price` AS `_rule_priceFROM `catalog_product_entity` AS `e`
 
INNER JOIN `catalog_product_website` AS `_table_website_idON (_table_website_id.product_id=e.entity_id) AND (_table_website_id.website_id=1)
 
INNER JOIN `catalog_product_enabled_index` AS `enabled_indexON enabled_index.product_id=e.entity_id AND enabled_index.store_id='1' AND enabled_index.visibility IN (24)
 
INNER JOIN `catalog_product_link` AS `linksON links.linked_product_id=e.entity_id AND links.link_type_id=4
 LEFT JOIN 
`catalogrule_product_price` AS `_price_ruleON _price_rule.product_id e.entity_id AND _price_rule.rule_date '2009-03-27' AND _price_rule.website_id '1' AND _price_rule.customer_group_id '0' WHERE (e.entity_id NOT IN (SELECT product_id FROM sales_flat_quote_item WHERE quote_id=0)) AND (links.product_id='47') AND (e.entity_id!='47'ORDER BY `positionasc LIMIT 4


Trace
:
#0 /home/admin/contactlenzenwinkel.nl/magento/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/admin/contactlenzenwinkel.nl/magento/lib/Zend/Db/Adapter/Abstract.php(457): Zend_Db_Statement->execute(Array)
#2 /home/admin/contactlenzenwinkel.nl/magento/lib/Zend/Db/Adapter/Pdo/Abstract.php(230): Zend_Db_Adapter_Abstract->query('SELECT `e`.*, `...', Array)
#3 /home/admin/contactlenzenwinkel.nl/magento/lib/Varien/Db/Adapter/Pdo/Mysql.php(258): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `e`.*, `...', Array)
#4 /home/admin/contactlenzenwinkel.nl/magento/lib/Zend/Db/Adapter/Abstract.php(668): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#5 /home/admin/contactlenzenwinkel.nl/magento/lib/Varien/Data/Collection/Db.php(761): Zend_Db_Adapter_Abstract->fetchAll(Object(Varien_Db_Select), Array)
#6 /home/admin/contactlenzenwinkel.nl/magento/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(845): Varien_Data_Collection_Db->_fetchAll(Object(Varien_Db_Select))
#7 /home/admin/contactlenzenwinkel.nl/magento/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(702): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false)
#8 /home/admin/contactlenzenwinkel.nl/magento/app/code/core/Mage/Catalog/Block/Product/List/Upsell.php(65): Mage_Eav_Model_Entity_Collection_Abstract->load()
#9 /home/admin/contactlenzenwinkel.nl/magento/app/code/core/Mage/Catalog/Block/Product/List/Upsell.php(85): Mage_Catalog_Block_Product_List_Upsell->_prepareData()
#10 /home/admin/contactlenzenwinkel.nl/magento/app/code/core/Mage/Core/Block/Abstract.php(642): Mage_Catalog_Block_Product_List_Upsell->_beforeToHtml()
#11 /home/admin/contactlenzenwinkel.nl/magento/app/code/core/Mage/Core/Block/Abstract.php(503): Mage_Core_Block_Abstract->toHtml()
#12 /home/admin/contactlenzenwinkel.nl/magento/app/code/core/Mage/Core/Block/Abstract.php(454): Mage_Core_Block_Abstract->_getChildHtml('upsell_products', true)
#13 /home/admin/contactlenzenwinkel.nl/magento/app/design/frontend/default/default/template/catalog/product/view.phtml(130): Mage_Core_Block_Abstract->getChildHtml('upsell_products')
#14 /home/admin/contactlenzenwinkel.nl/magento/app/code/core/Mage/Core/Block/Template.php(144): include('/home/admin/con...')
#15 /home/admin/contactlenzenwinkel.nl/magento/app/code/core/Mage/Core/Block/Template.php(176): Mage_Core_Block_Template->fetchView('frontend/defaul...')
#16 /home/admin/contactlenzenwinkel.nl/magento/app/code/core/Mage/Core/Block/Template.php(193): Mage_Core_Block_Template->renderView()
#17 /home/admin/contactlenzenwinkel.nl/magento/app/code/core/Mage/Core/Block/Abstract.php(643): Mage_Core_Block_Template->_toHtml()
#18 /home/admin/contactlenzenwinkel.nl/magento/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#19 /home/admin/contactlenzenwinkel.nl/magento/app/code/core/Mage/Core/Block/Abstract.php(643): Mage_Core_Block_Text_List->_toHtml()
#20 /home/admin/contactlenzenwinkel.nl/magento/app/code/core/Mage/Core/Block/Abstract.php(503): Mage_Core_Block_Abstract->toHtml()
#21 /home/admin/contactlenzenwinkel.nl/magento/app/code/core/Mage/Core/Block/Abstract.php(454): Mage_Core_Block_Abstract->_getChildHtml('content', true)
#22 /home/admin/contactlenzenwinkel.nl/magento/app/design/frontend/default/default/template/page/2columns-right.phtml(56): Mage_Core_Block_Abstract->getChildHtml('content')
#23 /home/admin/contactlenzenwinkel.nl/magento/app/code/core/Mage/Core/Block/Template.php(144): include('/home/admin/con...')
#24 /home/admin/contactlenzenwinkel.nl/magento/app/code/core/Mage/Core/Block/Template.php(176): Mage_Core_Block_Template->fetchView('frontend/defaul...')
#25 /home/admin/contactlenzenwinkel.nl/magento/app/code/core/Mage/Core/Block/Template.php(193): Mage_Core_Block_Template->renderView()
#26 /home/admin/contactlenzenwinkel.nl/magento/app/code/core/Mage/Core/Block/Abstract.php(643): Mage_Core_Block_Template->_toHtml()
#27 /home/admin/contactlenzenwinkel.nl/magento/app/code/core/Mage/Core/Model/Layout.php(525): Mage_Core_Block_Abstract->toHtml()
#28 /home/admin/contactlenzenwinkel.nl/magento/app/code/core/Mage/Core/Controller/Varien/Action.php(339): Mage_Core_Model_Layout->getOutput()
#29 /home/admin/contactlenzenwinkel.nl/magento/app/code/core/Mage/Catalog/controllers/ProductController.php(129): Mage_Core_Controller_Varien_Action->renderLayout()
#30 /home/admin/contactlenzenwinkel.nl/magento/app/code/core/Mage/Core/Controller/Varien/Action.php(367): Mage_Catalog_ProductController->viewAction()
#31 /home/admin/contactlenzenwinkel.nl/magento/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(163): Mage_Core_Controller_Varien_Action->dispatch('view')
#32 /home/admin/contactlenzenwinkel.nl/magento/app/code/core/Mage/Core/Controller/Varien/Front.php(158): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#33 /home/admin/contactlenzenwinkel.nl/magento/app/Mage.php(457): Mage_Core_Controller_Varien_Front->dispatch()
#34 /home/admin/contactlenzenwinkel.nl/magento/index.php(52): Mage::run()
#35 {main}

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top