cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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}

3 REPLIES

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

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.



Problem solved? Click Accept as Solution!

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

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

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

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...

WebAuxilium