cancel
Showing results for 
Search instead for 
Did you mean: 

1054 Unknown column 'status.value' in 'where clause' after SUPEE-6788/7405/7405-2 on 1.8.1

SOLVED
   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

1054 Unknown column 'status.value' in 'where clause' after SUPEE-6788/7405/7405-2 on 1.8.1

Hi together,

 

I would like to ask for help from you guys. After patching a 1.8.1 installation (I patched SUPEE-6788, SUPEE-7405 and SUPEE 7405-v2 in a row, so I can not tell, which one causes this... shame on me) I get this error:

 

 

 

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status.value' in 'where clause' in /src/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)

#1 /src/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /src/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /src/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `main_ta...', Array)
#4 /src/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `main_ta...', Array)
#5 /src/lib/Zend/Db/Adapter/Abstract.php(734): Varien_Db_Adapter_Pdo_Mysql->query('SELECT `main_ta...', Array)
#6 /src/lib/Varien/Data/Collection/Db.php(740): Zend_Db_Adapter_Abstract->fetchAll('SELECT `main_ta...', Array)
#7 /src/app/code/core/Mage/Core/Model/Resource/Db/Collection/Abstract.php(521): Varien_Data_Collection_Db->_fetchAll('SELECT `main_ta...', Array)
#8 /src/lib/Varien/Data/Collection/Db.php(572): Mage_Core_Model_Resource_Db_Collection_Abstract->getData()
#9 /src/lib/Varien/Data/Collection.php(741): Varien_Data_Collection_Db->load()
#10 /src/app/code/local/Magestore/Shopbybrand/Model/Observer.php(331): Varien_Data_Collection->getIterator()
#11 /src/app/code/core/Mage/Core/Model/App.php(1339): Magestore_Shopbybrand_Model_Observer->addToTopmenu(Object(Varien_Event_Observer))
#12 /src/app/code/core/Mage/Core/Model/App.php(1318): Mage_Core_Model_App->_callObserverMethod(Object(Magestore_Shopbybrand_Model_Observer), 'addToTopmenu', Object(Varien_Event_Observer))
#13 /src/app/Mage.php(448): Mage_Core_Model_App->dispatchEvent('page_block_html...', Array)
#14 /src/app/code/core/Mage/Page/Block/Html/Topmenu.php(74): Mage::dispatchEvent('page_block_html...', Array)
#15 /src/app/design/frontend/default/f002/template/page/html/topmenu.phtml(41): Mage_Page_Block_Html_Topmenu->getHtml('level-top')
#16 /src/app/code/core/Mage/Core/Block/Template.php(241): include('/www/htdocs/w01...')
#17 /src/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/defaul...')
#18 /src/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#19 /src/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml()
#20 /src/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#21 /src/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Text_List->_toHtml()
#22 /src/app/code/core/Mage/Core/Block/Abstract.php(637): Mage_Core_Block_Abstract->toHtml()
#23 /src/app/code/core/Mage/Core/Block/Abstract.php(581): Mage_Core_Block_Abstract->_getChildHtml('topMenu', true)
#24 /src/app/design/frontend/default/f002/template/page/html/header.phtml(51): Mage_Core_Block_Abstract->getChildHtml('topMenu')
#25 /src/app/code/core/Mage/Core/Block/Template.php(241): include('/www/htdocs/w01...')
#26 /src/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/defaul...')
#27 /src/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#28 /src/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml()
#29 /src/app/code/core/Mage/Core/Block/Abstract.php(637): Mage_Core_Block_Abstract->toHtml()
#30 /src/app/code/core/Mage/Core/Block/Abstract.php(581): Mage_Core_Block_Abstract->_getChildHtml('header', true)
#31 /src/app/design/frontend/default/f002/template/page/1column.phtml(42): Mage_Core_Block_Abstract->getChildHtml('header')
#32 /src/app/code/core/Mage/Core/Block/Template.php(241): include('/www/htdocs/w01...')
#33 /src/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/defaul...')
#34 /src/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#35 /src/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml()
#36 /src/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml()
#37 /src/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput()
#38 /src/app/code/core/Mage/Cms/Helper/Page.php(137): Mage_Core_Controller_Varien_Action->renderLayout()
#39 /src/app/code/core/Mage/Cms/Helper/Page.php(52): Mage_Cms_Helper_Page->_renderPage(Object(Mage_Cms_IndexController), 'home')
#40 /src/app/code/core/Mage/Cms/controllers/IndexController.php(45): Mage_Cms_Helper_Page->renderPage(Object(Mage_Cms_IndexController), 'home')
#41 /src/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Cms_IndexController->indexAction()
#42 /src/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('index')
#43 /src/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#44 /src/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#45 /src/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#46 /src/index.php(105): Mage::run('base', 'website')
#47 {main}";s:3:"url";s:1:"/";s:11:"script_name";s:10:"/index.php";s:4:"skin";s:7:"default";}

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: 1054 Unknown column 'status.value' in 'where clause' after SUPEE-6788/7405/7405-2 on 1.8.1

Hi @aaantz

There seems to be an error with Magestore Shop by brand extension.

/app/code/local/Magestore/Shopbybrand/Model/Observer.php

 You need to debug it or seek help from a developer.

---
Problem Solved Click Accept as Solution!:Magento Community India Forum

View solution in original post

2 REPLIES 2

Re: 1054 Unknown column 'status.value' in 'where clause' after SUPEE-6788/7405/7405-2 on 1.8.1

Hi @aaantz

There seems to be an error with Magestore Shop by brand extension.

/app/code/local/Magestore/Shopbybrand/Model/Observer.php

 You need to debug it or seek help from a developer.

---
Problem Solved Click Accept as Solution!:Magento Community India Forum

Re: 1054 Unknown column 'status.value' in 'where clause' after SUPEE-6788/7405/7405-2 on 1.8.1

Hi @Mukesh Tiwari

thank you for pointing me in the right direction! We had customized this extension some time ago - that might have caused the error.