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

After magento 1.7.0.2 upgrade, quick search is not working
 
Freebot
Jr. Member
 
Total Posts:  3
Joined:  2008-11-27
 

I\\\’ve tried this, but didn\\\’t work:

Locate table eav_attribute in phpmyadmin, which was related to catalog_eav_attribute. Located column position in table eav_attribute and dropped it.

Clear all cache and reindexed all data

Now visit front page. Now you might get a new error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘main_table.include_in_menu’ in ‘where clause’

Locate and open file app/code/core/Mage/Catalog/Model/Resource/Category/Flat.php

Comment out following line:267

->where(‘main_table.is_active = ?’, ’1′)
// ->where(‘main_table.include_in_menu = ?’, ’1′)
->order(‘main_table.position’);

You can find a step by step guide at: expertmagentodevelopers[dot]com/blog/how-to-upgrade-from-magento-1-6-1-to-1-7-0-using-connect-manager/

Error:

a:5:{i:0;s:100:\\\"SQLSTATE[23000]: Integrity constraint violation: 1052 Column \\\’position\\\’ in order clause is ambiguous\\\";i:1;s:3900:\\\"#0 /home/casaiked/public_html/magento/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/casaiked/public_html/magento/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/casaiked/public_html/magento/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /home/casaiked/public_html/magento/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(\\\’SELECT `main_ta...\\\’, Array)
#4 /home/casaiked/public_html/magento/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query(\\\’SELECT `main_ta...\\\’, Array)
#5 /home/casaiked/public_html/magento/lib/Zend/Db/Adapter/Abstract.php(734): Varien_Db_Adapter_Pdo_Mysql->query(\\\’SELECT `main_ta...\\\’, Array)
#6 /home/casaiked/public_html/magento/lib/Varien/Data/Collection/Db.php(734): Zend_Db_Adapter_Abstract->fetchAll(\\\’SELECT `main_ta...\\\’, Array)
#7 /home/casaiked/public_html/magento/app/code/core/Mage/Core/Model/Resource/Db/Collection/Abstract.php(521): Varien_Data_Collection_Db->_fetchAll(\\\’SELECT `main_ta...\\\’, Array)
#8 /home/casaiked/public_html/magento/lib/Varien/Data/Collection/Db.php(566): Mage_Core_Model_Resource_Db_Collection_Abstract->getData()
#9 /home/casaiked/public_html/magento/app/code/core/Mage/Catalog/Model/Layer.php(232): Varien_Data_Collection_Db->load()
#10 /home/casaiked/public_html/magento/app/code/core/Mage/Catalog/Block/Layer/View.php(163): Mage_Catalog_Model_Layer->getFilterableAttributes()
#11 /home/casaiked/public_html/magento/app/code/core/Mage/Catalog/Block/Layer/View.php(122): Mage_Catalog_Block_Layer_View->_getFilterableAttributes()
#12 /home/casaiked/public_html/magento/app/code/core/Mage/Core/Block/Abstract.php(238): Mage_Catalog_Block_Layer_View->_prepareLayout()
#13 /home/casaiked/public_html/magento/app/code/core/Mage/Core/Model/Layout.php(456): Mage_Core_Block_Abstract->setLayout(Object(Mage_Core_Model_Layout))
#14 /home/casaiked/public_html/magento/app/code/core/Mage/Core/Model/Layout.php(472): Mage_Core_Model_Layout->createBlock(\\\’catalogsearch/l...\\\’, \\\’catalogsearch.l...\\\’)
#15 /home/casaiked/public_html/magento/app/code/core/Mage/Core/Model/Layout.php(239): Mage_Core_Model_Layout->addBlock(\\\’catalogsearch/l...\\\’, \\\’catalogsearch.l...\\\’)
#16 /home/casaiked/public_html/magento/app/code/core/Mage/Core/Model/Layout.php(205): Mage_Core_Model_Layout->_generateBlock(Object(Mage_Core_Model_Layout_Element), Object(Mage_Core_Model_Layout_Element))
#17 /home/casaiked/public_html/magento/app/code/core/Mage/Core/Model/Layout.php(210): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
#18 /home/casaiked/public_html/magento/app/code/core/Mage/Core/Controller/Varien/Action.php(344): Mage_Core_Model_Layout->generateBlocks()
#19 /home/casaiked/public_html/magento/app/code/core/Mage/Core/Controller/Varien/Action.php(269): Mage_Core_Controller_Varien_Action->generateLayoutBlocks()
#20 /home/casaiked/public_html/magento/app/code/core/Mage/CatalogSearch/controllers/ResultController.php(77): Mage_Core_Controller_Varien_Action->loadLayout()
#21 /home/casaiked/public_html/magento/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mage_CatalogSearch_ResultController->indexAction()
#22 /home/casaiked/public_html/magento/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch(\\\’index\\\’)
#23 /home/casaiked/public_html/magento/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#24 /home/casaiked/public_html/magento/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#25 /home/casaiked/public_html/magento/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#26 /home/casaiked/public_html/magento/index.php(87): Mage::run(\\\’\\\’, \\\’store\\\’)
#27 {main}\\\”;s:3:\\\"url\\\”;s:57:\\\"/magento/default/catalogsearch/result/?q=chapa+de+perilla\\\”;s:11:\\\"script_name\\\”;s:18:\\\"/magento/index.php\\\”;s:4:\\\"skin\\\”;s:7:\\\"default\\\";}

 
Magento Community Magento Community
Magento Community
Magento Community
 
Freebot
Jr. Member
 
Total Posts:  3
Joined:  2008-11-27
 

I found the solution here:

http://www.magentodeveloperleedsuk.co.uk/integrity-constraint-violation-1052-column-position-in-order-clause-is-ambiguous/

 
Magento Community Magento Community
Magento Community
Magento Community
 
Mirasvit
Guru
 
Avatar
Total Posts:  639
Joined:  2009-08-22
 

Hello,

Take a look this search extension which enables the Sphinx-powered search with high performance and more relevant search results Sphinx Search Ultimate

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