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

Page 1 of 2
front end search not working
 
hemisha
Jr. Member
 
Total Posts:  29
Joined:  2012-08-07
 

I successfully upgrade the magento 1.7 smile

Everything working fine for me but the front end search is not working :(

Its give me result when I m typing but when I click submit (for get all result) its is give me error.

Error is

Column not found: 1054 Unknown column ‘e.sku’ in ‘on clause’

I tried all option available online but luck :(

Please help me out for this ...thanks in advance .

 
Magento Community Magento Community
Magento Community
Magento Community
 
hemisha
Jr. Member
 
Total Posts:  29
Joined:  2012-08-07
 

Any one Plssssssssssss......

 
Magento Community Magento Community
Magento Community
Magento Community
 
Sindre|ProperHost
Mentor
 
Avatar
Total Posts:  1158
Joined:  2008-04-24
 

Can you please post the complete error message (stack trace). Do you have any 3. party extensions installed which may not be compatible with Magento 1.7?

 
Magento Community Magento Community
Magento Community
Magento Community
 
hemisha
Jr. Member
 
Total Posts:  29
Joined:  2012-08-07
 

Thanks for your reply

here is error

a:5:{i:0;s:77:\"SQLSTATE[42S22]: Column not found: 1054 Unknown column \’e.sku\’ in \’on clause\’\";i:1;s:4628:\"#0 /var/www/posturite/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/posturite/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /var/www/posturite/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /var/www/posturite/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(\’SELECT FLOOR((R...\’, Array)
#4 /var/www/posturite/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query(\’SELECT FLOOR((R...\’, Array)
#5 /var/www/posturite/lib/Zend/Db/Adapter/Abstract.php(808): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#6 /var/www/posturite/app/code/core/Mage/Catalog/Model/Resource/Layer/Filter/Price.php(274): Zend_Db_Adapter_Abstract->fetchPairs(Object(Varien_Db_Select))
#7 /var/www/posturite/app/code/core/Mage/Catalog/Model/Layer/Filter/Price.php(158): Mage_Catalog_Model_Resource_Layer_Filter_Price->getCount(Object(Mage_Catalog_Model_Layer_Filter_Price), 100)
#8 /var/www/posturite/app/code/core/Mage/Catalog/Model/Layer/Filter/Price.php(115): Mage_Catalog_Model_Layer_Filter_Price->getRangeItemCounts(100)
#9 /var/www/posturite/app/code/core/Mage/Catalog/Model/Layer/Filter/Price.php(314): Mage_Catalog_Model_Layer_Filter_Price->getPriceRange()
#10 /var/www/posturite/app/code/core/Mage/Catalog/Model/Layer/Filter/Abstract.php(151): Mage_Catalog_Model_Layer_Filter_Price->_getItemsData()
#11 /var/www/posturite/app/code/core/Mage/Catalog/Model/Layer/Filter/Abstract.php(120): Mage_Catalog_Model_Layer_Filter_Abstract->_initItems()
#12 /var/www/posturite/app/code/core/Mage/Catalog/Model/Layer/Filter/Abstract.php(109): Mage_Catalog_Model_Layer_Filter_Abstract->getItems()
#13 /var/www/posturite/app/code/core/Mage/Catalog/Block/Layer/Filter/Abstract.php(132): Mage_Catalog_Model_Layer_Filter_Abstract->getItemsCount()
#14 /var/www/posturite/app/design/frontend/posturite/default/template/catalog/layer/view.phtml(46): Mage_Catalog_Block_Layer_Filter_Abstract->getItemsCount()
#15 /var/www/posturite/app/code/core/Mage/Core/Block/Template.php(241): include(\’/var/www/postur...\’)
#16 /var/www/posturite/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(\’frontend/postur...\’)
#17 /var/www/posturite/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#18 /var/www/posturite/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Template->_toHtml()
#19 /var/www/posturite/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#20 /var/www/posturite/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Text_List->_toHtml()
#21 /var/www/posturite/app/code/core/Mage/Core/Block/Abstract.php(582): Mage_Core_Block_Abstract->toHtml()
#22 /var/www/posturite/app/code/core/Mage/Core/Block/Abstract.php(526): Mage_Core_Block_Abstract->_getChildHtml(\’left\’, true)
#23 /var/www/posturite/app/design/frontend/posturite/default/template/page/2columns-left.phtml(53): Mage_Core_Block_Abstract->getChildHtml(\’left\’)
#24 /var/www/posturite/app/code/core/Mage/Core/Block/Template.php(241): include(\’/var/www/postur...\’)
#25 /var/www/posturite/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(\’frontend/postur...\’)
#26 /var/www/posturite/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#27 /var/www/posturite/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Template->_toHtml()
#28 /var/www/posturite/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml()
#29 /var/www/posturite/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput()
#30 /var/www/posturite/app/code/core/Mage/CatalogSearch/controllers/ResultController.php(80): Mage_Core_Controller_Varien_Action->renderLayout()
#31 /var/www/posturite/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mage_CatalogSearch_ResultController->indexAction()
#32 /var/www/posturite/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch(\’index\’)
#33 /var/www/posturite/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#34 /var/www/posturite/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#35 /var/www/posturite/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#36 /var/www/posturite/index.php(87): Mage::run(\’\’, \’store\’)
#37 {main}\”;s:3:\"url\”;s:31:\"/catalogsearch/result/?q=laptop\”;s:11:\"script_name\”;s:10:\"/index.php\”;s:4:\"skin\”;s:12:\"posturite_en\";}

 
Magento Community Magento Community
Magento Community
Magento Community
 
Sindre|ProperHost
Mentor
 
Avatar
Total Posts:  1158
Joined:  2008-04-24
 

The problem comes from your template:
/var/www/posturite/app/design/frontend/posturite/default/template/page/2col
umns-left.phtml

It probably contains some block markup which is not compatible with Magento 1.7. Try to replace the file with the default one from latest package to see if the problem goes away.

 
Magento Community Magento Community
Magento Community
Magento Community
 
hemisha
Jr. Member
 
Total Posts:  29
Joined:  2012-08-07
 

ok let me try this

thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
hemisha
Jr. Member
 
Total Posts:  29
Joined:  2012-08-07
 

HI

I try to find this file in default one from latest package but i couldn’t find it.

Can you pls send me path of the file from latest package so i can copy past it.

 
Magento Community Magento Community
Magento Community
Magento Community
 
hemisha
Jr. Member
 
Total Posts:  29
Joined:  2012-08-07
 

I found it i replace with

app/design/fronted/base/default/temple/page/2columns-left.phtml

but its not working still...:(

i clear cache also.

 
Magento Community Magento Community
Magento Community
Magento Community
 
hemisha
Jr. Member
 
Total Posts:  29
Joined:  2012-08-07
 

Any Suggestion...................

Pls.......

 
Magento Community Magento Community
Magento Community
Magento Community
 
hemisha
Jr. Member
 
Total Posts:  29
Joined:  2012-08-07
 

and one more thing i want to inform that, if i search for

“cha” the its working but if i search for “chair” then its not working…

i really cant understand this reallyyy....

Can anyone pls help me for this...i waiting for someone reply....

 
Magento Community Magento Community
Magento Community
Magento Community
 
hemisha
Jr. Member
 
Total Posts:  29
Joined:  2012-08-07
 

Can any one help me over here.......

 
Magento Community Magento Community
Magento Community
Magento Community
 
hemisha
Jr. Member
 
Total Posts:  29
Joined:  2012-08-07
 

I am really Disappointed with magento forum...i added my issue but no one response me ..its is almost a week now...and my site is live…

my problem is , i upgrade magento 1.4 to 1.7 ...everything working fine but front end search ... mini search not working ...its is give me this error

a:5:{i:0;s:77:"SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘e.sku’ in ‘on clause‘“;i:1;s:4630:"#0 /var/www/posturite/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/posturite/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /var/www/posturite/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /var/www/posturite/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’SELECT FLOOR((R...’, Array)
#4 /var/www/posturite/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query(’SELECT FLOOR((R...’, Array)
#5 /var/www/posturite/lib/Zend/Db/Adapter/Abstract.php(808): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#6 /var/www/posturite/app/code/core/Mage/Catalog/Model/Resource/Layer/Filter/Price.php(274): Zend_Db_Adapter_Abstract->fetchPairs(Object(Varien_Db_Select))
#7 /var/www/posturite/app/code/core/Mage/Catalog/Model/Layer/Filter/Price.php(158): Mage_Catalog_Model_Resource_Layer_Filter_Price->getCount(Object(Mage_Catalog_Model_Layer_Filter_Price), 1000)
#8 /var/www/posturite/app/code/core/Mage/Catalog/Model/Layer/Filter/Price.php(115): Mage_Catalog_Model_Layer_Filter_Price->getRangeItemCounts(1000)
#9 /var/www/posturite/app/code/core/Mage/Catalog/Model/Layer/Filter/Price.php(314): Mage_Catalog_Model_Layer_Filter_Price->getPriceRange()
#10 /var/www/posturite/app/code/core/Mage/Catalog/Model/Layer/Filter/Abstract.php(151): Mage_Catalog_Model_Layer_Filter_Price->_getItemsData()
#11 /var/www/posturite/app/code/core/Mage/Catalog/Model/Layer/Filter/Abstract.php(120): Mage_Catalog_Model_Layer_Filter_Abstract->_initItems()
#12 /var/www/posturite/app/code/core/Mage/Catalog/Model/Layer/Filter/Abstract.php(109): Mage_Catalog_Model_Layer_Filter_Abstract->getItems()
#13 /var/www/posturite/app/code/core/Mage/Catalog/Block/Layer/Filter/Abstract.php(132): Mage_Catalog_Model_Layer_Filter_Abstract->getItemsCount()
#14 /var/www/posturite/app/design/frontend/posturite/default/template/catalog/layer/view.phtml(46): Mage_Catalog_Block_Layer_Filter_Abstract->getItemsCount()
#15 /var/www/posturite/app/code/core/Mage/Core/Block/Template.php(241): include(’/var/www/postur...’)
#16 /var/www/posturite/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(’frontend/postur...’)
#17 /var/www/posturite/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#18 /var/www/posturite/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Template->_toHtml()
#19 /var/www/posturite/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#20 /var/www/posturite/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Text_List->_toHtml()
#21 /var/www/posturite/app/code/core/Mage/Core/Block/Abstract.php(582): Mage_Core_Block_Abstract->toHtml()
#22 /var/www/posturite/app/code/core/Mage/Core/Block/Abstract.php(526): Mage_Core_Block_Abstract->_getChildHtml(’left’, true)
#23 /var/www/posturite/app/design/frontend/posturite/default/template/page/2columns-left.phtml(53): Mage_Core_Block_Abstract->getChildHtml(’left’)
#24 /var/www/posturite/app/code/core/Mage/Core/Block/Template.php(241): include(’/var/www/postur...’)
#25 /var/www/posturite/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(’frontend/postur...’)
#26 /var/www/posturite/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#27 /var/www/posturite/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Template->_toHtml()
#28 /var/www/posturite/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml()
#29 /var/www/posturite/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput()
#30 /var/www/posturite/app/code/core/Mage/CatalogSearch/controllers/ResultController.php(80): Mage_Core_Controller_Varien_Action->renderLayout()
#31 /var/www/posturite/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mage_CatalogSearch_ResultController->indexAction()
#32 /var/www/posturite/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch(’index’)
#33 /var/www/posturite/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#34 /var/www/posturite/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#35 /var/www/posturite/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#36 /var/www/posturite/index.php(87): Mage::run(’’, ‘store’)
#37 {main}”;s:3:"url”;s:30:"/catalogsearch/result/?q=chair”;s:11:"script_name”;s:10:"/index.php”;s:4:"skin”;s:12:"posturite_en";}

i hope any one will help me.....

thanks in advance

 
Magento Community Magento Community
Magento Community
Magento Community
 
Sindre|ProperHost
Mentor
 
Avatar
Total Posts:  1158
Joined:  2008-04-24
 

I think the problem comes from this file:
/var/www/posturite/app/design/frontend/posturite/default/template/catalog/layer/view.phtml

It contains markup not compatible with Magento 1.7.

 
Magento Community Magento Community
Magento Community
Magento Community
 
hemisha
Jr. Member
 
Total Posts:  29
Joined:  2012-08-07
 

Thanks for your reply....

But what u suggest me....what should i do with this file...do i need to delete it ?????

 
Magento Community Magento Community
Magento Community
Magento Community
 
Brent W Peterson
Moderator
 
Avatar
Total Posts:  3217
Joined:  2009-02-26
Minneapolis MN
 

DON’T DELETE THE FILE.

Simply rename the file to something like view.bak. Magento will automatically fall back to the base version (Correct one)

You will then see if it works

 
Magento Community Magento Community
Magento Community
Magento Community
 
hemisha
Jr. Member
 
Total Posts:  29
Joined:  2012-08-07
 

Thanks for reply…

i rename it by “view.bak.phtml”...and then clear cache and rebuild the catelog search index.

Still it is not working ...still give me same error.....:(((

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top
Page 1 of 2