Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Error when browsing anything in frontend… Unknown column?! 
 
leecollings
Jr. Member
 
Total Posts:  16
Joined:  2009-03-17
 

Has anyone else come across this problem? It only happens when I try clicking on a menu item, or viewing any product…

It’s driving me absolutely insane!!

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘used_in_product_listing’ in ‘where clause’
Trace:
#0 /home7/partyman/public_html/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home7/partyman/public_html/lib/Zend/Db/Adapter/Abstract.php(457): Zend_Db_Statement->execute(Array)
#2 /home7/partyman/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(230): Zend_Db_Adapter_Abstract->query(’SELECT `eav_att...’, Array)
#3 /home7/partyman/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(259): Zend_Db_Adapter_Pdo_Abstract->query(’SELECT `eav_att...’, Array)
#4 /home7/partyman/public_html/lib/Zend/Db/Adapter/Abstract.php(668): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#5 /home7/partyman/public_html/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Config.php(78): Zend_Db_Adapter_Abstract->fetchAll(Object(Varien_Db_Select))
#6 /home7/partyman/public_html/app/code/core/Mage/Catalog/Model/Config.php(272): Mage_Catalog_Model_Resource_Eav_Mysql4_Config->getAttributesUsedInListing()
#7 /home7/partyman/public_html/app/code/core/Mage/Catalog/Model/Config.php(234): Mage_Catalog_Model_Config->getAttributesUsedInProductListing()
#8 /home7/partyman/public_html/app/code/core/Mage/Catalog/Model/Layer.php(118): Mage_Catalog_Model_Config->getProductAttributes()
#9 /home7/partyman/public_html/app/code/core/Mage/Catalog/Model/Layer.php(102): Mage_Catalog_Model_Layer->prepareProductCollection(Object(Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection))
#10 /home7/partyman/public_html/app/code/core/Mage/Catalog/Model/Layer.php(293): Mage_Catalog_Model_Layer->getProductCollection()
#11 /home7/partyman/public_html/app/code/core/Mage/Catalog/Model/Layer.php(220): Mage_Catalog_Model_Layer->_getSetIds()
#12 /home7/partyman/public_html/app/code/core/Mage/Catalog/Block/Layer/View.php(90): Mage_Catalog_Model_Layer->getFilterableAttributes()
#13 /home7/partyman/public_html/app/code/core/Mage/Catalog/Block/Layer/View.php(53): Mage_Catalog_Block_Layer_View->_getFilterableAttributes()
#14 /home7/partyman/public_html/app/code/core/Mage/Core/Block/Abstract.php(199): Mage_Catalog_Block_Layer_View->_prepareLayout()
#15 /home7/partyman/public_html/app/code/core/Mage/Core/Model/Layout.php(445): Mage_Core_Block_Abstract->setLayout(Object(Mage_Core_Model_Layout))
#16 /home7/partyman/public_html/app/code/core/Mage/Core/Model/Layout.php(229): Mage_Core_Model_Layout->addBlock(’Mage_Catalog_Bl...’, ‘catalog.leftnav’)
#17 /home7/partyman/public_html/app/code/core/Mage/Core/Model/Layout.php(195): Mage_Core_Model_Layout->_generateBlock(Object(Mage_Core_Model_Layout_Element), Object(Mage_Core_Model_Layout_Element))
#18 /home7/partyman/public_html/app/code/core/Mage/Core/Model/Layout.php(200): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
#19 /home7/partyman/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(295): Mage_Core_Model_Layout->generateBlocks()
#20 /home7/partyman/public_html/app/code/core/Mage/Catalog/controllers/CategoryController.php(94): Mage_Core_Controller_Varien_Action->generateLayoutBlocks()
#21 /home7/partyman/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(367): Mage_Catalog_CategoryController->viewAction()
#22 /home7/partyman/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(247): Mage_Core_Controller_Varien_Action->dispatch(’view’)
#23 /home7/partyman/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(158): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#24 /home7/partyman/public_html/app/Mage.php(457): Mage_Core_Controller_Varien_Front->dispatch()
#25 /home7/partyman/public_html/index.php(52): Mage::run()
#26 {main}

I have re-uploaded 1.3 successfully, which got me past a different problem, with logging into the Admin page. That I can now do. But I still receive this.

I have seen some reference to using SSH to install packages or extensions into the server, which I cannot do, I keep getting messages stating ‘directory not found’ or command unknown.

Has anyone else had this problem? Or does anyone have any idea to help me? It’s coming up to two weeks I’ve been without a fully functioning e-commerce store.

Thanks guys, and Happy Easter!

 
Magento Community Magento Community
Magento Community
Magento Community
 
leecollings
Jr. Member
 
Total Posts:  16
Joined:  2009-03-17
 

If it helps at all, I went through the extensions individually, reinstalled them to see if anything was chucking out an error.

This is what I got back…

downloading Mage_Core_Modules-1.3.0.tgz ...
Starting to download Mage_Core_Modules-1.3.0.tgz (1,537,439 bytes)
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ...done: 1,537,439 bytes
install ok: channel://connect.magentocommerce.com/core/Mage_Core_Modules-1.3.0

Fatal error: Exception thrown without a stack frame in Unknown on line 0

Does this help finding out this little annoyance at all?

It would be so nice to finally get this gremlin fixed, and overcome.
I’ll thank anyone in advance for their help and support!

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