Can't force reindex in ssh for catalog search indexRe-index magento via ssh / puttyProduct Attributes could not be reindexedUpgrade from 1.9.1 to 1.9.2 ErrorCron jobs not being called, getting email notification errorsMagento - Invalid block typeAdding to cart: E_ERROR: Allowed memory size of 2147483648 bytes exhausted (tried to allocate 24 bytes)Magento 1.9.1.1 : Create Store View : Cardinality violation: 1241 Operand should contain 1 column(s)There has been an error processing your request magento 1.9.0.1SQLSTATE[HY000] : General error: 2013 Lost connection to MySQL server during query in MagentoCan't run CRON PDOException Magento 1.9.3.8Magento 1.9 - There has been an error processing your request

Can I legally use front facing blue light in the UK?

"listening to me about as much as you're listening to this pole here"

Denied boarding due to overcrowding, Sparpreis ticket. What are my rights?

Manga about a female worker who got dragged into another world together with this high school girl and she was just told she's not needed anymore

Can a planet have a different gravitational pull depending on its location in orbit around its sun?

Is there a familial term for apples and pears?

Deciding between multiple birth names and dates?

How to answer pointed "are you quitting" questioning when I don't want them to suspect

extract characters between two commas?

Why does this relative pronoun not take the case of the noun it is referring to?

Are cabin dividers used to "hide" the flex of the airplane?

aging parents with no investments

Where to refill my bottle in India?

Does it makes sense to buy a new cycle to learn riding?

Eliminate empty elements from a list with a specific pattern

Information to fellow intern about hiring?

Does a dangling wire really electrocute me if I'm standing in water?

Why airport relocation isn't done gradually?

Email Account under attack (really) - anything I can do?

What do you call something that goes against the spirit of the law, but is legal when interpreting the law to the letter?

I see my dog run

Why do we use polarized capacitors?

Add an angle to a sphere

Can I find out the caloric content of bread by dehydrating it?



Can't force reindex in ssh for catalog search index


Re-index magento via ssh / puttyProduct Attributes could not be reindexedUpgrade from 1.9.1 to 1.9.2 ErrorCron jobs not being called, getting email notification errorsMagento - Invalid block typeAdding to cart: E_ERROR: Allowed memory size of 2147483648 bytes exhausted (tried to allocate 24 bytes)Magento 1.9.1.1 : Create Store View : Cardinality violation: 1241 Operand should contain 1 column(s)There has been an error processing your request magento 1.9.0.1SQLSTATE[HY000] : General error: 2013 Lost connection to MySQL server during query in MagentoCan't run CRON PDOException Magento 1.9.3.8Magento 1.9 - There has been an error processing your request






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








3















Can't seem to reindex in back end and so thought I would give it a go in terminal



Navigated to the appropriate bits and still it won't do it.



I'm a bit of a novice at shh so wondered if someone could point me in the right direction



-bash-4.2$ php indexer.php --status


Product Attributes: Pending
Product Prices: Pending
Catalog URL Rewrites: Pending
Product Flat Data: Pending
Category Flat Data: Pending
Category Products: Pending
Catalog Search Index: Require Reindex
Stock Status: Pending
Tag Aggregation Data: Pending
Algolia Search Products: Pending
Algolia Search Categories: Pending
Algolia Search Pages: Pending
Algolia Search Suggestions: Pending
Algolia Search Additional autocomplete sections: Pending
Algolia Search Queue Runner: Pending



php indexer.php --reindex catalog_search_index


After running them I get this



Warning: Unknown indexer with code catalog_search_index



Any ideas where I am going wrong? would it be ok to do a force reindex for all the indexes?



I tried this solution:



php indexer.php --reindex catalogsearch_fulltext


Which gave me this result:



Catalog Search Index index process unknown error:
exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created' in 'field list'' in /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#2 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#3 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#4 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `od...', Array)
#5 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `od...', Array)
#6 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Adapter/Abstract.php(576): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `od...', Array)
#7 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Queue.php(61): Zend_Db_Adapter_Abstract->insert('odb2sdoyhealgol...', Array)
#8 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Engine.php(47): Algolia_Algoliasearch_Model_Queue->add('algoliasearch/o...', 'saveSettings', Array, 1)
#9 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Engine.php(337): Algolia_Algoliasearch_Model_Resource_Engine->addToQueue('algoliasearch/o...', 'saveSettings', Array, 1)
#10 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Engine.php(173): Algolia_Algoliasearch_Model_Resource_Engine->saveSettings(true)
#11 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Fulltext.php(67): Algolia_Algoliasearch_Model_Resource_Engine->rebuildProducts(NULL)
#12 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/CatalogSearch/Model/Fulltext.php(84): Algolia_Algoliasearch_Model_Resource_Fulltext->rebuildIndex(NULL, NULL)
#13 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/CatalogSearch/Model/Indexer/Fulltext.php(455): Mage_CatalogSearch_Model_Fulltext->rebuildIndex()
#14 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/Index/Model/Process.php(212): Mage_CatalogSearch_Model_Indexer_Fulltext->reindexAll()
#15 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/Index/Model/Process.php(260): Mage_Index_Model_Process->reindexAll()
#16 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/shell/indexer.php(168): Mage_Index_Model_Process->reindexEverything()
#17 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/shell/indexer.php(216): Mage_Shell_Compiler->run()
#18 main

Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created' in 'field list', query was: INSERT INTO `odb2sdoyhealgoliasearch_queue` (`created`, `class`, `method`, `data`, `data_size`, `pid`) VALUES (?, ?, ?, ?, ?, ?)' in /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Statement/Pdo.php:235
Stack trace:
#0 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `od...', Array)
#4 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `od...', Array)
#5 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Adapter/Abstract.php(576): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `od...', Array)
#6 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Queue.php(61): Zend_Db_Adapter_Abstract->insert('odb2sdoyhealgol...', Array)
#7 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Engine.php(47): Algolia_Algoliasearch_Model_Queue->add('algoliasearch/o...', 'saveSettings', Array, 1)
#8 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Engine.php(337): Algolia_Algoliasearch_Model_Resource_Engine->addToQueue('algoliasearch/o...', 'saveSettings', Array, 1)
#9 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Engine.php(173): Algolia_Algoliasearch_Model_Resource_Engine->saveSettings(true)
#10 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Fulltext.php(67): Algolia_Algoliasearch_Model_Resource_Engine->rebuildProducts(NULL)
#11 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/CatalogSearch/Model/Fulltext.php(84): Algolia_Algoliasearch_Model_Resource_Fulltext->rebuildIndex(NULL, NULL)
#12 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/CatalogSearch/Model/Indexer/Fulltext.php(455): Mage_CatalogSearch_Model_Fulltext->rebuildIndex()
#13 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/Index/Model/Process.php(212): Mage_CatalogSearch_Model_Indexer_Fulltext->reindexAll()
#14 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/Index/Model/Process.php(260): Mage_Index_Model_Process->reindexAll()
#15 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/shell/indexer.php(168): Mage_Index_Model_Process->reindexEverything()
#16 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/shell/indexer.php(216): Mage_Shell_Compiler->run()
#17 main





magento-1.9







share|improve this question
























  • Was this resolved? I have a similar problem in Magento 1.9.3.1 Here is the error. Searches on my website produce a blank white screen. Advanced searches work fine. Catalog Search Index index process unknown error: exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.att_color_map' in 'field list'' in "magento path"/lib/Zend/Db/Statement/Pdo.php:228 Stack trace: #0 "magento path"/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) #1 "magento path"/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #2 "mage

    – user14396
    Feb 20 at 20:19











  • I resolved my isue by making the problem field, att_color_map, not searchable in catalog>attributes

    – user14396
    Feb 20 at 20:29

















3















Can't seem to reindex in back end and so thought I would give it a go in terminal



Navigated to the appropriate bits and still it won't do it.



I'm a bit of a novice at shh so wondered if someone could point me in the right direction



-bash-4.2$ php indexer.php --status


Product Attributes: Pending
Product Prices: Pending
Catalog URL Rewrites: Pending
Product Flat Data: Pending
Category Flat Data: Pending
Category Products: Pending
Catalog Search Index: Require Reindex
Stock Status: Pending
Tag Aggregation Data: Pending
Algolia Search Products: Pending
Algolia Search Categories: Pending
Algolia Search Pages: Pending
Algolia Search Suggestions: Pending
Algolia Search Additional autocomplete sections: Pending
Algolia Search Queue Runner: Pending



php indexer.php --reindex catalog_search_index


After running them I get this



Warning: Unknown indexer with code catalog_search_index



Any ideas where I am going wrong? would it be ok to do a force reindex for all the indexes?



I tried this solution:



php indexer.php --reindex catalogsearch_fulltext


Which gave me this result:



Catalog Search Index index process unknown error:
exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created' in 'field list'' in /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#2 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#3 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#4 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `od...', Array)
#5 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `od...', Array)
#6 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Adapter/Abstract.php(576): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `od...', Array)
#7 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Queue.php(61): Zend_Db_Adapter_Abstract->insert('odb2sdoyhealgol...', Array)
#8 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Engine.php(47): Algolia_Algoliasearch_Model_Queue->add('algoliasearch/o...', 'saveSettings', Array, 1)
#9 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Engine.php(337): Algolia_Algoliasearch_Model_Resource_Engine->addToQueue('algoliasearch/o...', 'saveSettings', Array, 1)
#10 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Engine.php(173): Algolia_Algoliasearch_Model_Resource_Engine->saveSettings(true)
#11 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Fulltext.php(67): Algolia_Algoliasearch_Model_Resource_Engine->rebuildProducts(NULL)
#12 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/CatalogSearch/Model/Fulltext.php(84): Algolia_Algoliasearch_Model_Resource_Fulltext->rebuildIndex(NULL, NULL)
#13 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/CatalogSearch/Model/Indexer/Fulltext.php(455): Mage_CatalogSearch_Model_Fulltext->rebuildIndex()
#14 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/Index/Model/Process.php(212): Mage_CatalogSearch_Model_Indexer_Fulltext->reindexAll()
#15 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/Index/Model/Process.php(260): Mage_Index_Model_Process->reindexAll()
#16 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/shell/indexer.php(168): Mage_Index_Model_Process->reindexEverything()
#17 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/shell/indexer.php(216): Mage_Shell_Compiler->run()
#18 main

Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created' in 'field list', query was: INSERT INTO `odb2sdoyhealgoliasearch_queue` (`created`, `class`, `method`, `data`, `data_size`, `pid`) VALUES (?, ?, ?, ?, ?, ?)' in /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Statement/Pdo.php:235
Stack trace:
#0 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `od...', Array)
#4 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `od...', Array)
#5 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Adapter/Abstract.php(576): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `od...', Array)
#6 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Queue.php(61): Zend_Db_Adapter_Abstract->insert('odb2sdoyhealgol...', Array)
#7 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Engine.php(47): Algolia_Algoliasearch_Model_Queue->add('algoliasearch/o...', 'saveSettings', Array, 1)
#8 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Engine.php(337): Algolia_Algoliasearch_Model_Resource_Engine->addToQueue('algoliasearch/o...', 'saveSettings', Array, 1)
#9 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Engine.php(173): Algolia_Algoliasearch_Model_Resource_Engine->saveSettings(true)
#10 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Fulltext.php(67): Algolia_Algoliasearch_Model_Resource_Engine->rebuildProducts(NULL)
#11 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/CatalogSearch/Model/Fulltext.php(84): Algolia_Algoliasearch_Model_Resource_Fulltext->rebuildIndex(NULL, NULL)
#12 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/CatalogSearch/Model/Indexer/Fulltext.php(455): Mage_CatalogSearch_Model_Fulltext->rebuildIndex()
#13 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/Index/Model/Process.php(212): Mage_CatalogSearch_Model_Indexer_Fulltext->reindexAll()
#14 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/Index/Model/Process.php(260): Mage_Index_Model_Process->reindexAll()
#15 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/shell/indexer.php(168): Mage_Index_Model_Process->reindexEverything()
#16 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/shell/indexer.php(216): Mage_Shell_Compiler->run()
#17 main





magento-1.9







share|improve this question
























  • Was this resolved? I have a similar problem in Magento 1.9.3.1 Here is the error. Searches on my website produce a blank white screen. Advanced searches work fine. Catalog Search Index index process unknown error: exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.att_color_map' in 'field list'' in "magento path"/lib/Zend/Db/Statement/Pdo.php:228 Stack trace: #0 "magento path"/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) #1 "magento path"/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #2 "mage

    – user14396
    Feb 20 at 20:19











  • I resolved my isue by making the problem field, att_color_map, not searchable in catalog>attributes

    – user14396
    Feb 20 at 20:29













3












3








3








Can't seem to reindex in back end and so thought I would give it a go in terminal



Navigated to the appropriate bits and still it won't do it.



I'm a bit of a novice at shh so wondered if someone could point me in the right direction



-bash-4.2$ php indexer.php --status


Product Attributes: Pending
Product Prices: Pending
Catalog URL Rewrites: Pending
Product Flat Data: Pending
Category Flat Data: Pending
Category Products: Pending
Catalog Search Index: Require Reindex
Stock Status: Pending
Tag Aggregation Data: Pending
Algolia Search Products: Pending
Algolia Search Categories: Pending
Algolia Search Pages: Pending
Algolia Search Suggestions: Pending
Algolia Search Additional autocomplete sections: Pending
Algolia Search Queue Runner: Pending



php indexer.php --reindex catalog_search_index


After running them I get this



Warning: Unknown indexer with code catalog_search_index



Any ideas where I am going wrong? would it be ok to do a force reindex for all the indexes?



I tried this solution:



php indexer.php --reindex catalogsearch_fulltext


Which gave me this result:



Catalog Search Index index process unknown error:
exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created' in 'field list'' in /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#2 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#3 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#4 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `od...', Array)
#5 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `od...', Array)
#6 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Adapter/Abstract.php(576): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `od...', Array)
#7 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Queue.php(61): Zend_Db_Adapter_Abstract->insert('odb2sdoyhealgol...', Array)
#8 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Engine.php(47): Algolia_Algoliasearch_Model_Queue->add('algoliasearch/o...', 'saveSettings', Array, 1)
#9 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Engine.php(337): Algolia_Algoliasearch_Model_Resource_Engine->addToQueue('algoliasearch/o...', 'saveSettings', Array, 1)
#10 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Engine.php(173): Algolia_Algoliasearch_Model_Resource_Engine->saveSettings(true)
#11 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Fulltext.php(67): Algolia_Algoliasearch_Model_Resource_Engine->rebuildProducts(NULL)
#12 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/CatalogSearch/Model/Fulltext.php(84): Algolia_Algoliasearch_Model_Resource_Fulltext->rebuildIndex(NULL, NULL)
#13 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/CatalogSearch/Model/Indexer/Fulltext.php(455): Mage_CatalogSearch_Model_Fulltext->rebuildIndex()
#14 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/Index/Model/Process.php(212): Mage_CatalogSearch_Model_Indexer_Fulltext->reindexAll()
#15 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/Index/Model/Process.php(260): Mage_Index_Model_Process->reindexAll()
#16 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/shell/indexer.php(168): Mage_Index_Model_Process->reindexEverything()
#17 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/shell/indexer.php(216): Mage_Shell_Compiler->run()
#18 main

Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created' in 'field list', query was: INSERT INTO `odb2sdoyhealgoliasearch_queue` (`created`, `class`, `method`, `data`, `data_size`, `pid`) VALUES (?, ?, ?, ?, ?, ?)' in /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Statement/Pdo.php:235
Stack trace:
#0 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `od...', Array)
#4 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `od...', Array)
#5 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Adapter/Abstract.php(576): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `od...', Array)
#6 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Queue.php(61): Zend_Db_Adapter_Abstract->insert('odb2sdoyhealgol...', Array)
#7 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Engine.php(47): Algolia_Algoliasearch_Model_Queue->add('algoliasearch/o...', 'saveSettings', Array, 1)
#8 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Engine.php(337): Algolia_Algoliasearch_Model_Resource_Engine->addToQueue('algoliasearch/o...', 'saveSettings', Array, 1)
#9 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Engine.php(173): Algolia_Algoliasearch_Model_Resource_Engine->saveSettings(true)
#10 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Fulltext.php(67): Algolia_Algoliasearch_Model_Resource_Engine->rebuildProducts(NULL)
#11 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/CatalogSearch/Model/Fulltext.php(84): Algolia_Algoliasearch_Model_Resource_Fulltext->rebuildIndex(NULL, NULL)
#12 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/CatalogSearch/Model/Indexer/Fulltext.php(455): Mage_CatalogSearch_Model_Fulltext->rebuildIndex()
#13 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/Index/Model/Process.php(212): Mage_CatalogSearch_Model_Indexer_Fulltext->reindexAll()
#14 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/Index/Model/Process.php(260): Mage_Index_Model_Process->reindexAll()
#15 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/shell/indexer.php(168): Mage_Index_Model_Process->reindexEverything()
#16 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/shell/indexer.php(216): Mage_Shell_Compiler->run()
#17 main





magento-1.9







share|improve this question
















Can't seem to reindex in back end and so thought I would give it a go in terminal



Navigated to the appropriate bits and still it won't do it.



I'm a bit of a novice at shh so wondered if someone could point me in the right direction



-bash-4.2$ php indexer.php --status


Product Attributes: Pending
Product Prices: Pending
Catalog URL Rewrites: Pending
Product Flat Data: Pending
Category Flat Data: Pending
Category Products: Pending
Catalog Search Index: Require Reindex
Stock Status: Pending
Tag Aggregation Data: Pending
Algolia Search Products: Pending
Algolia Search Categories: Pending
Algolia Search Pages: Pending
Algolia Search Suggestions: Pending
Algolia Search Additional autocomplete sections: Pending
Algolia Search Queue Runner: Pending



php indexer.php --reindex catalog_search_index


After running them I get this



Warning: Unknown indexer with code catalog_search_index



Any ideas where I am going wrong? would it be ok to do a force reindex for all the indexes?



I tried this solution:



php indexer.php --reindex catalogsearch_fulltext


Which gave me this result:



Catalog Search Index index process unknown error:
exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created' in 'field list'' in /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#2 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#3 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#4 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `od...', Array)
#5 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `od...', Array)
#6 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Adapter/Abstract.php(576): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `od...', Array)
#7 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Queue.php(61): Zend_Db_Adapter_Abstract->insert('odb2sdoyhealgol...', Array)
#8 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Engine.php(47): Algolia_Algoliasearch_Model_Queue->add('algoliasearch/o...', 'saveSettings', Array, 1)
#9 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Engine.php(337): Algolia_Algoliasearch_Model_Resource_Engine->addToQueue('algoliasearch/o...', 'saveSettings', Array, 1)
#10 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Engine.php(173): Algolia_Algoliasearch_Model_Resource_Engine->saveSettings(true)
#11 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Fulltext.php(67): Algolia_Algoliasearch_Model_Resource_Engine->rebuildProducts(NULL)
#12 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/CatalogSearch/Model/Fulltext.php(84): Algolia_Algoliasearch_Model_Resource_Fulltext->rebuildIndex(NULL, NULL)
#13 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/CatalogSearch/Model/Indexer/Fulltext.php(455): Mage_CatalogSearch_Model_Fulltext->rebuildIndex()
#14 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/Index/Model/Process.php(212): Mage_CatalogSearch_Model_Indexer_Fulltext->reindexAll()
#15 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/Index/Model/Process.php(260): Mage_Index_Model_Process->reindexAll()
#16 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/shell/indexer.php(168): Mage_Index_Model_Process->reindexEverything()
#17 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/shell/indexer.php(216): Mage_Shell_Compiler->run()
#18 main

Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created' in 'field list', query was: INSERT INTO `odb2sdoyhealgoliasearch_queue` (`created`, `class`, `method`, `data`, `data_size`, `pid`) VALUES (?, ?, ?, ?, ?, ?)' in /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Statement/Pdo.php:235
Stack trace:
#0 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `od...', Array)
#4 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `od...', Array)
#5 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/lib/Zend/Db/Adapter/Abstract.php(576): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `od...', Array)
#6 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Queue.php(61): Zend_Db_Adapter_Abstract->insert('odb2sdoyhealgol...', Array)
#7 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Engine.php(47): Algolia_Algoliasearch_Model_Queue->add('algoliasearch/o...', 'saveSettings', Array, 1)
#8 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Engine.php(337): Algolia_Algoliasearch_Model_Resource_Engine->addToQueue('algoliasearch/o...', 'saveSettings', Array, 1)
#9 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Engine.php(173): Algolia_Algoliasearch_Model_Resource_Engine->saveSettings(true)
#10 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/community/Algolia/Algoliasearch/Model/Resource/Fulltext.php(67): Algolia_Algoliasearch_Model_Resource_Engine->rebuildProducts(NULL)
#11 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/CatalogSearch/Model/Fulltext.php(84): Algolia_Algoliasearch_Model_Resource_Fulltext->rebuildIndex(NULL, NULL)
#12 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/CatalogSearch/Model/Indexer/Fulltext.php(455): Mage_CatalogSearch_Model_Fulltext->rebuildIndex()
#13 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/Index/Model/Process.php(212): Mage_CatalogSearch_Model_Indexer_Fulltext->reindexAll()
#14 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/app/code/core/Mage/Index/Model/Process.php(260): Mage_Index_Model_Process->reindexAll()
#15 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/shell/indexer.php(168): Mage_Index_Model_Process->reindexEverything()
#16 /var/www/vhosts/ashtondiscount.co.uk/httpdocs/shell/indexer.php(216): Mage_Shell_Compiler->run()
#17 main





magento-1.9




magento-1.9






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Oct 5 '17 at 8:42







Lisa Merrick

















asked Oct 3 '17 at 14:07









Lisa MerrickLisa Merrick

464




464












  • Was this resolved? I have a similar problem in Magento 1.9.3.1 Here is the error. Searches on my website produce a blank white screen. Advanced searches work fine. Catalog Search Index index process unknown error: exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.att_color_map' in 'field list'' in "magento path"/lib/Zend/Db/Statement/Pdo.php:228 Stack trace: #0 "magento path"/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) #1 "magento path"/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #2 "mage

    – user14396
    Feb 20 at 20:19











  • I resolved my isue by making the problem field, att_color_map, not searchable in catalog>attributes

    – user14396
    Feb 20 at 20:29

















  • Was this resolved? I have a similar problem in Magento 1.9.3.1 Here is the error. Searches on my website produce a blank white screen. Advanced searches work fine. Catalog Search Index index process unknown error: exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.att_color_map' in 'field list'' in "magento path"/lib/Zend/Db/Statement/Pdo.php:228 Stack trace: #0 "magento path"/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) #1 "magento path"/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #2 "mage

    – user14396
    Feb 20 at 20:19











  • I resolved my isue by making the problem field, att_color_map, not searchable in catalog>attributes

    – user14396
    Feb 20 at 20:29
















Was this resolved? I have a similar problem in Magento 1.9.3.1 Here is the error. Searches on my website produce a blank white screen. Advanced searches work fine. Catalog Search Index index process unknown error: exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.att_color_map' in 'field list'' in "magento path"/lib/Zend/Db/Statement/Pdo.php:228 Stack trace: #0 "magento path"/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) #1 "magento path"/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #2 "mage

– user14396
Feb 20 at 20:19





Was this resolved? I have a similar problem in Magento 1.9.3.1 Here is the error. Searches on my website produce a blank white screen. Advanced searches work fine. Catalog Search Index index process unknown error: exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.att_color_map' in 'field list'' in "magento path"/lib/Zend/Db/Statement/Pdo.php:228 Stack trace: #0 "magento path"/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) #1 "magento path"/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #2 "mage

– user14396
Feb 20 at 20:19













I resolved my isue by making the problem field, att_color_map, not searchable in catalog>attributes

– user14396
Feb 20 at 20:29





I resolved my isue by making the problem field, att_color_map, not searchable in catalog>attributes

– user14396
Feb 20 at 20:29










3 Answers
3






active

oldest

votes


















0














For the catalog search index i think the below command is what is needed to run from root directory:



php shell/indexer.php --reindex catalogsearch_fulltext


There is a good answer here about indexes:



Re-index magento via ssh / putty






share|improve this answer






























    0














    There is no index named catalog_search_index in Magento 1.9. The error itself very clear that there is no such index in Magento.



    The right index for catalog search would be 



    php indexer.php --reindex catalogsearch_fulltext


    You can read this tutorial for indexing via command line



    Re-indexing Magento via command line






    share|improve this answer






























      0














      Warning: Unknown indexer with code catalog_search_index
      Please check first, Is there any catalog_search_index in list?



      php shell/indexer.php info


      If available then please please try below command



      php -f shell/indexer.php --reindex catalog_search_index


      You are running this command from ROOT and indexer.php is located under shell directory.
      For re-indexing all indexes :



      php -f shell/indexer.php reindexall


      Listing all commands :



      php shell/indexer.php --reindex catalog_product_attribute
      php shell/indexer.php --reindex catalog_product_price
      php shell/indexer.php --reindex catalog_url
      php shell/indexer.php --reindex catalog_product_flat
      php shell/indexer.php --reindex catalog_category_flat
      php shell/indexer.php --reindex catalog_category_product
      php shell/indexer.php --reindex catalogsearch_fulltext
      php shell/indexer.php --reindex cataloginventory_stock
      php shell/indexer.php --reindex tag_summary


      Thank you.






      share|improve this answer























        Your Answer








        StackExchange.ready(function()
        var channelOptions =
        tags: "".split(" "),
        id: "479"
        ;
        initTagRenderer("".split(" "), "".split(" "), channelOptions);

        StackExchange.using("externalEditor", function()
        // Have to fire editor after snippets, if snippets enabled
        if (StackExchange.settings.snippets.snippetsEnabled)
        StackExchange.using("snippets", function()
        createEditor();
        );

        else
        createEditor();

        );

        function createEditor()
        StackExchange.prepareEditor(
        heartbeatType: 'answer',
        autoActivateHeartbeat: false,
        convertImagesToLinks: false,
        noModals: true,
        showLowRepImageUploadWarning: true,
        reputationToPostImages: null,
        bindNavPrevention: true,
        postfix: "",
        imageUploader:
        brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
        contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
        allowUrls: true
        ,
        onDemand: true,
        discardSelector: ".discard-answer"
        ,immediatelyShowMarkdownHelp:true
        );



        );













        draft saved

        draft discarded


















        StackExchange.ready(
        function ()
        StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f195741%2fcant-force-reindex-in-ssh-for-catalog-search-index%23new-answer', 'question_page');

        );

        Post as a guest















        Required, but never shown

























        3 Answers
        3






        active

        oldest

        votes








        3 Answers
        3






        active

        oldest

        votes









        active

        oldest

        votes






        active

        oldest

        votes









        0














        For the catalog search index i think the below command is what is needed to run from root directory:



        php shell/indexer.php --reindex catalogsearch_fulltext


        There is a good answer here about indexes:



        Re-index magento via ssh / putty






        share|improve this answer



























          0














          For the catalog search index i think the below command is what is needed to run from root directory:



          php shell/indexer.php --reindex catalogsearch_fulltext


          There is a good answer here about indexes:



          Re-index magento via ssh / putty






          share|improve this answer

























            0












            0








            0







            For the catalog search index i think the below command is what is needed to run from root directory:



            php shell/indexer.php --reindex catalogsearch_fulltext


            There is a good answer here about indexes:



            Re-index magento via ssh / putty






            share|improve this answer













            For the catalog search index i think the below command is what is needed to run from root directory:



            php shell/indexer.php --reindex catalogsearch_fulltext


            There is a good answer here about indexes:



            Re-index magento via ssh / putty







            share|improve this answer












            share|improve this answer



            share|improve this answer










            answered Oct 3 '17 at 14:22









            harriharri

            3,0511656




            3,0511656























                0














                There is no index named catalog_search_index in Magento 1.9. The error itself very clear that there is no such index in Magento.



                The right index for catalog search would be 



                php indexer.php --reindex catalogsearch_fulltext


                You can read this tutorial for indexing via command line



                Re-indexing Magento via command line






                share|improve this answer



























                  0














                  There is no index named catalog_search_index in Magento 1.9. The error itself very clear that there is no such index in Magento.



                  The right index for catalog search would be 



                  php indexer.php --reindex catalogsearch_fulltext


                  You can read this tutorial for indexing via command line



                  Re-indexing Magento via command line






                  share|improve this answer

























                    0












                    0








                    0







                    There is no index named catalog_search_index in Magento 1.9. The error itself very clear that there is no such index in Magento.



                    The right index for catalog search would be 



                    php indexer.php --reindex catalogsearch_fulltext


                    You can read this tutorial for indexing via command line



                    Re-indexing Magento via command line






                    share|improve this answer













                    There is no index named catalog_search_index in Magento 1.9. The error itself very clear that there is no such index in Magento.



                    The right index for catalog search would be 



                    php indexer.php --reindex catalogsearch_fulltext


                    You can read this tutorial for indexing via command line



                    Re-indexing Magento via command line







                    share|improve this answer












                    share|improve this answer



                    share|improve this answer










                    answered Oct 4 '17 at 5:57









                    Rinto GeorgeRinto George

                    195213




                    195213





















                        0














                        Warning: Unknown indexer with code catalog_search_index
                        Please check first, Is there any catalog_search_index in list?



                        php shell/indexer.php info


                        If available then please please try below command



                        php -f shell/indexer.php --reindex catalog_search_index


                        You are running this command from ROOT and indexer.php is located under shell directory.
                        For re-indexing all indexes :



                        php -f shell/indexer.php reindexall


                        Listing all commands :



                        php shell/indexer.php --reindex catalog_product_attribute
                        php shell/indexer.php --reindex catalog_product_price
                        php shell/indexer.php --reindex catalog_url
                        php shell/indexer.php --reindex catalog_product_flat
                        php shell/indexer.php --reindex catalog_category_flat
                        php shell/indexer.php --reindex catalog_category_product
                        php shell/indexer.php --reindex catalogsearch_fulltext
                        php shell/indexer.php --reindex cataloginventory_stock
                        php shell/indexer.php --reindex tag_summary


                        Thank you.






                        share|improve this answer



























                          0














                          Warning: Unknown indexer with code catalog_search_index
                          Please check first, Is there any catalog_search_index in list?



                          php shell/indexer.php info


                          If available then please please try below command



                          php -f shell/indexer.php --reindex catalog_search_index


                          You are running this command from ROOT and indexer.php is located under shell directory.
                          For re-indexing all indexes :



                          php -f shell/indexer.php reindexall


                          Listing all commands :



                          php shell/indexer.php --reindex catalog_product_attribute
                          php shell/indexer.php --reindex catalog_product_price
                          php shell/indexer.php --reindex catalog_url
                          php shell/indexer.php --reindex catalog_product_flat
                          php shell/indexer.php --reindex catalog_category_flat
                          php shell/indexer.php --reindex catalog_category_product
                          php shell/indexer.php --reindex catalogsearch_fulltext
                          php shell/indexer.php --reindex cataloginventory_stock
                          php shell/indexer.php --reindex tag_summary


                          Thank you.






                          share|improve this answer

























                            0












                            0








                            0







                            Warning: Unknown indexer with code catalog_search_index
                            Please check first, Is there any catalog_search_index in list?



                            php shell/indexer.php info


                            If available then please please try below command



                            php -f shell/indexer.php --reindex catalog_search_index


                            You are running this command from ROOT and indexer.php is located under shell directory.
                            For re-indexing all indexes :



                            php -f shell/indexer.php reindexall


                            Listing all commands :



                            php shell/indexer.php --reindex catalog_product_attribute
                            php shell/indexer.php --reindex catalog_product_price
                            php shell/indexer.php --reindex catalog_url
                            php shell/indexer.php --reindex catalog_product_flat
                            php shell/indexer.php --reindex catalog_category_flat
                            php shell/indexer.php --reindex catalog_category_product
                            php shell/indexer.php --reindex catalogsearch_fulltext
                            php shell/indexer.php --reindex cataloginventory_stock
                            php shell/indexer.php --reindex tag_summary


                            Thank you.






                            share|improve this answer













                            Warning: Unknown indexer with code catalog_search_index
                            Please check first, Is there any catalog_search_index in list?



                            php shell/indexer.php info


                            If available then please please try below command



                            php -f shell/indexer.php --reindex catalog_search_index


                            You are running this command from ROOT and indexer.php is located under shell directory.
                            For re-indexing all indexes :



                            php -f shell/indexer.php reindexall


                            Listing all commands :



                            php shell/indexer.php --reindex catalog_product_attribute
                            php shell/indexer.php --reindex catalog_product_price
                            php shell/indexer.php --reindex catalog_url
                            php shell/indexer.php --reindex catalog_product_flat
                            php shell/indexer.php --reindex catalog_category_flat
                            php shell/indexer.php --reindex catalog_category_product
                            php shell/indexer.php --reindex catalogsearch_fulltext
                            php shell/indexer.php --reindex cataloginventory_stock
                            php shell/indexer.php --reindex tag_summary


                            Thank you.







                            share|improve this answer












                            share|improve this answer



                            share|improve this answer










                            answered Oct 4 '17 at 6:09









                            gelanivishalgelanivishal

                            805620




                            805620



























                                draft saved

                                draft discarded
















































                                Thanks for contributing an answer to Magento Stack Exchange!


                                • Please be sure to answer the question. Provide details and share your research!

                                But avoid …


                                • Asking for help, clarification, or responding to other answers.

                                • Making statements based on opinion; back them up with references or personal experience.

                                To learn more, see our tips on writing great answers.




                                draft saved


                                draft discarded














                                StackExchange.ready(
                                function ()
                                StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f195741%2fcant-force-reindex-in-ssh-for-catalog-search-index%23new-answer', 'question_page');

                                );

                                Post as a guest















                                Required, but never shown





















































                                Required, but never shown














                                Required, but never shown












                                Required, but never shown







                                Required, but never shown

































                                Required, but never shown














                                Required, but never shown












                                Required, but never shown







                                Required, but never shown







                                -

                                Popular posts from this blog

                                Image
                                17 \\$\\begingroup\\$ I need an answer because I am a beginner. And I got the players handbook and it does not say a thing about this. pathfinder-1e pathfinder-beginner-box share | improve this question edited 2 days ago V2Blast ♦ 33.8k 5 5 gold badges 123 123 silver badges 212 212 bronze badges asked 2 days ago Brys Brys 89 1 1 silver badge 3 3 bronze badges New contributor ...
                                Read more

                                Sum ergo cogito? 1 nng

                                Image
                                3 Following Descartes but in the opposite direction: I exist. Something has made the assertion in the previous sentence and must have thought it to do so. Therefore my thoughts exist. Combining with the direction established by Descartes I have cogito ⇔ sum . Since assuming either is equiavlent to assuming the other I conclude that Descartes does not establish existence as following from something more basic or fundamental. Instead he has merely stated a tautology. Am I right or wrong? Or both, or neither? ontology descartes share | improve this question asked yesterday Dzamo Norton...
                                Read more

                                三茅街道4182Guuntc Dn precexpngmageondP

                                Image
                                三茅街道 概览 国家   中华人民共和国 上级行政区 扬中市 行政区类型 街道办事处 行政区划代码 32 11 82 001 村级区划单位数 30 - 社区数 14 - 行政村数 16 地理、人口、经济 坐标 32°14′25″N 119°49′08″E  /  32.24028°N 119.81884°E  / 32.24028; 119.81884 坐标： 32°14′25″N 119°49′08″E  /  32.24028°N 119.81884°E  / 32.24028; 119.81884 电话区号 +86  时区 UTC+8（北京时间） 三茅街道 是中华人民共和国江苏省镇江市扬中市下辖的一个街道办事处 [1] 。西部毗邻新坝镇，东南方毗邻油坊镇、八桥镇，北隔长江主航道與泰州市高港区相望。 2000年以后，丰裕镇并入，三茅镇面积达到49.45平方千米，人口73284人。2005年，兴隆镇并入，面积133.19平方千米，人口13万，占扬中全市40%。 行政区划 [ 编辑 ] 三茅街道下辖以下村级行政区划单位 [2] ： 文化新村社区、扬子新村社区、江州路社区、英雄社区、广宁社区、中桥社区、建设社区、金星社区、同心社区、丰裕社区、新民社区、港联社区、新胜社区、新扬社区、民主村、中华村、友好村、锦程村、三桥村、大众村、滨江村、企东村、兴华村、指南村、兴阳村、明华村、营房村、永和村、永勤村和普济村。 参考资料 [ 编辑 ] ↑ 2017年统计用区划代码和城乡划分代码：扬中市. 中华人民共和国国家统计局. 2017.   ↑ 2017年统计用区划代码和城乡划分代码：三茅街道. 中华人民共和国国家统计局. 2017.     这是一个关于江苏行政区划的小作品。你可以通过 编辑或修订 扩充其内容。 查 论 编 扬中市行政区划 行政隶属：中华人民共和国江苏省镇江市 街道 三茅街道 兴隆街道 镇 新坝镇 油坊镇 八桥镇 西来桥镇 类似乡级单位 扬中市良种繁育场 扬中市种猪场 扬中市渔业社 雷公岛水产养殖场 扬...
                                Read more