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

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘cat_index.visibility’ in ‘where clause’ after upgrade to 1.2.0.1
 
cmo525
Jr. Member
 
Total Posts:  3
Joined:  2008-08-31
 

I just upgraded from 1.1.6 to 1.2.0.1 and now I getting the following error when accessing the backend:

Fatal error: Call to a member function getBackend() on a non-object in /home/cmo525/public_html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php on line 379

And I get this error when accessing the frontend:

Magento Commerce
There has been an error processing your request.

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘cat_index.visibility’ in ‘where clause’
Trace:
#0 /home/cmo525/public_html/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/cmo525/public_html/lib/Zend/Db/Adapter/Abstract.php(457): Zend_Db_Statement->execute(Array)
#2 /home/cmo525/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(230): Zend_Db_Adapter_Abstract->query(’SELECT COUNT(DI...’, Array)
#3 /home/cmo525/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(258): Zend_Db_Adapter_Pdo_Abstract->query(’SELECT COUNT(DI...’, Array)
#4 /home/cmo525/public_html/lib/Zend/Db/Adapter/Abstract.php(761): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#5 /home/cmo525/public_html/lib/Varien/Data/Collection/Db.php(155): Zend_Db_Adapter_Abstract->fetchOne(Object(Varien_Db_Select), Array)
#6 /home/cmo525/public_html/lib/Varien/Data/Collection.php(181): Varien_Data_Collection_Db->getSize()
#7 /home/cmo525/public_html/lib/Varien/Data/Collection.php(167): Varien_Data_Collection->getLastPageNumber()
#8 /home/cmo525/public_html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(839): Varien_Data_Collection->getCurPage()
#9 /home/cmo525/public_html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(702): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false)
#10 /home/cmo525/public_html/app/code/core/Mage/Catalog/Block/Product/List.php(135): Mage_Eav_Model_Entity_Collection_Abstract->load()
#11 /home/cmo525/public_html/app/code/core/Mage/Core/Block/Abstract.php(642): Mage_Catalog_Block_Product_List->_beforeToHtml()
#12 /home/cmo525/public_html/app/code/core/Mage/Core/Model/Email/Template/Filter.php(74): Mage_Core_Block_Abstract->toHtml()
#13 /home/cmo525/public_html/lib/Varien/Filter/Template.php(128): Mage_Core_Model_Email_Template_Filter->blockDirective(Array)
#14 /home/cmo525/public_html/app/code/core/Mage/Cms/Block/Page.php(80): Varien_Filter_Template->filter(Array, Array)
#15 /home/cmo525/public_html/app/code/core/Mage/Core/Block/Abstract.php(643): Mage_Cms_Block_Page->_toHtml(’{{block type="c...’)
#16 /home/cmo525/public_html/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#17 /home/cmo525/public_html/app/code/core/Mage/Core/Block/Abstract.php(643): Mage_Core_Block_Text_List->_toHtml()
#18 /home/cmo525/public_html/app/code/core/Mage/Core/Block/Abstract.php(503): Mage_Core_Block_Abstract->toHtml()
#19 /home/cmo525/public_html/app/code/core/Mage/Core/Block/Abstract.php(454): Mage_Core_Block_Abstract->_getChildHtml()
#20 /home/cmo525/public_html/app/design/frontend/default/default/template/page/3columns.phtml(63): Mage_Core_Block_Abstract->getChildHtml(’content’, true)
#21 /home/cmo525/public_html/app/code/core/Mage/Core/Block/Template.php(144): include(’/home/cmo525/pu...’)
#22 /home/cmo525/public_html/app/code/core/Mage/Core/Block/Template.php(176): Mage_Core_Block_Template->fetchView(’content’)
#23 /home/cmo525/public_html/app/code/core/Mage/Core/Block/Template.php(193): Mage_Core_Block_Template->renderView(’frontend/defaul...’)
#24 /home/cmo525/public_html/app/code/core/Mage/Core/Block/Abstract.php(643): Mage_Core_Block_Template->_toHtml()
#25 /home/cmo525/public_html/app/code/core/Mage/Core/Model/Layout.php(525): Mage_Core_Block_Abstract->toHtml()
#26 /home/cmo525/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(325): Mage_Core_Model_Layout->getOutput()
#27 /home/cmo525/public_html/app/code/core/Mage/Cms/Helper/Page.php(92): Mage_Core_Controller_Varien_Action->renderLayout()
#28 /home/cmo525/public_html/app/code/core/Mage/Cms/controllers/IndexController.php(32): Mage_Cms_Helper_Page->renderPage()
#29 /home/cmo525/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(348): Mage_Cms_IndexController->indexAction(Object(Mage_Cms_IndexController), ‘home’)
#30 /home/cmo525/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(163): Mage_Core_Controller_Varien_Action->dispatch()
#31 /home/cmo525/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(174): Mage_Core_Controller_Varien_Router_Standard->match(’index’)
#32 /home/cmo525/public_html/app/Mage.php(450): Mage_Core_Controller_Varien_Front->dispatch(Object(Mage_Core_Controller_Request_Http))
#33 /home/cmo525/public_html/index.php(52): Mage::run()
#34 {main}

Magento is a trademark of Irubin Consulting Inc. DBA Varien. Copyright © 2008 Irubin Consulting Inc.

 
Magento Community Magento Community
Magento Community
Magento Community
 
medic
Sr. Member
 
Total Posts:  173
Joined:  2007-10-30
Sydney
 

I just have the same problem. grr. anyone?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Joey H
Member
 
Avatar
Total Posts:  49
Joined:  2008-07-29
St. Louis, MO
 

This was just a permissions problem for me… i have a php file that sets all the permissions

<?php

system('chmod -R 744 *');
system('find . -type d -exec chmod 755 {} \;');

?>

 
Magento Community Magento Community
Magento Community
Magento Community
 
Buyeco
Jr. Member
 
Total Posts:  4
Joined:  2008-12-30
 

Do not use the above code if you are on a hosd server, It will change as\ll of your file ownership to root and you will not be able to remove anything

 
Magento Community Magento Community
Magento Community
Magento Community
 
Brightwork
Jr. Member
 
Total Posts:  14
Joined:  2008-03-18
 

Is there any way to change all file permissions to the correct setting (like the script above), but so that it does not set the ownership to root?  Also, some files need to be something other than 755-- right?

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