SQLSTATE[42S22]: Column not found: 1054 Unknown column 'giftwrap' in 'field list'

[vikramchitnis]

i had re indexing, flush all cache but when i click on oreder in backend got this error plz need of solutions There has been an error processing your request SQLSTATE[42S22]: Column not found: 1054 Unknown column 'giftwrap' in 'field list' Trace: #0 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #1 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #2 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #3 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `giftwra...', Array) #4 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `giftwra...', Array) #5 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/design/adminhtml/default/default/template/sales/order/view/tab/info.phtml(97): Varien_Db_Adapter_Pdo_Mysql->query('SELECT `giftwra...') #6 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/code/core/Mage/Core/Block/Template.php(241): include('/var/sentora/ho...') #7 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('adminhtml/defau...') #8 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView() #9 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/code/core/Mage/Adminhtml/Block/Template.php(81): Mage_Core_Block_Template->_toHtml() #10 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Adminhtml_Block_Template->_toHtml() #11 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/code/core/Mage/Adminhtml/Block/Widget/Tabs.php(303): Mage_Core_Block_Abstract->toHtml() #12 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/design/adminhtml/default/default/template/widget/tabs.phtml(38): Mage_Adminhtml_Block_Widget_Tabs->getTabContent(Object(Mage_Adminhtml_Block_Sales_Order_View_Tab_Info)) #13 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/code/core/Mage/Core/Block/Template.php(241): include('/var/sentora/ho...') #14 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('adminhtml/defau...') #15 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView() #16 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/code/core/Mage/Adminhtml/Block/Template.php(81): Mage_Core_Block_Template->_toHtml() #17 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Adminhtml_Block_Template->_toHtml() #18 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml() #19 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Text_List->_toHtml() #20 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/code/core/Mage/Core/Block/Abstract.php(637): Mage_Core_Block_Abstract->toHtml() #21 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/code/core/Mage/Core/Block/Abstract.php(581): Mage_Core_Block_Abstract->_getChildHtml('left', true) #22 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/design/adminhtml/default/default/template/page.phtml(58): Mage_Core_Block_Abstract->getChildHtml('left') #23 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/code/core/Mage/Core/Block/Template.php(241): include('/var/sentora/ho...') #24 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('adminhtml/defau...') #25 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView() #26 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/code/core/Mage/Adminhtml/Block/Template.php(81): Mage_Core_Block_Template->_toHtml() #27 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Adminhtml_Block_Template->_toHtml() #28 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml() #29 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput() #30 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/code/core/Mage/Adminhtml/controllers/Sales/OrderController.php(128): Mage_Core_Controller_Varien_Action->renderLayout() #31 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Adminhtml_Sales_OrderController->viewAction() #32 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('view') #33 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #34 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch() #35 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/app/Mage.php(684): Mage_Core_Model_App->run(Array) #36 /var/sentora/hostdata/choicenshop/public_html/choicenshop_com/index.php(87): Mage::run('', 'store') #37 {main}

[Dhiren Vasoya]

Hi @vikramchitnis,

Have you install any 3rd party extension or made any changes recently which may have reason for this error?

If yes, then try disabling the extension from XML file or revert the change you made and try again.

[getwaysolution]

Hello;

I am getting same error. I have tried to disabled extension but still getting error. I have installed this checkout extension: 

http://shop.cogzidel.com/products/facile-onestepcheckout

Please advice me for solution.

Thanks

[Help_Fr]

Hello,

I've got a similar trouble after installing the patch

So, i've delete local.xml to doa new install and then it was ok for me

See my post

https://community.magento.com/t5/Security-Patches/Supee-8788-SQLSTATE-42S22-Column-not-found-1054-Un...