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

                                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

                                419 nièngy_Soadمي 19bal1.5o_g

                                Chiĕng-gī: 1 chiĕng-gī Sié-gī: 4 sié-gī | 5 sié-gī | 6 sié-gī Nièng-dâi: 380 nièng-dâi | 390 nièng-dâi | 400 nièng-dâi | 410 nièng-dâi | 420 nièng-dâi | 430 nièng-dâi | 440 nièng-dâi Nièng: 414 nièng | 415 nièng | 416 nièng | 417 nièng | 418 nièng | 419 nièng | 420 nièng | 421 nièng | 422 nièng | 423 nièng | 424 nièng Nùng-lĭk: gī-ê nièng ( iòng nièng ) Nièng-hô̤: 419 nièng sê siŏh ciáh bìng-nièng, tàu nĭk téng bái-nê kăi-sṳ̄. Duâi dâi [ Siŭ-gāi | Gāi nguòng-mā ] Chók-sié [ Siŭ-gāi | Gāi nguòng-mā ] Guó-sié [ Siŭ-gāi | Gāi nguòng-mā ] This page is only for definition, need detailed information please check here
                                Read more

                                Queiggey Chernihivv 9NnOo i Zw X QqKk LpB

                                Image
                                Queiggey Chernihiv Чернігівська область —   Queiggey   — Brattagh Armys Soiaghey Wheiggey Chernihiv er caslys-çheerey yn Ookraan Co-ordnaidyn: 51°20′N 32°04′E  /  51.333°N 32.067°E  / 51.333; 32.067 Co-ordnaidyn: 51°20′N 32°04′E  /  51.333°N 32.067°E  / 51.333; 32.067 Çheer Yn Ookraan Bunneeaght  - 15 J. Fouyir 1932 Bunnit Preeu-valley Chernihiv Reiltys  - Kiannoort Volodymyr Ivashko  - Caairliagh Nataliya Romanova Eaghtyr  - Yn clane 31,865 km² (12,303.1 mi ker) Earroo yn phobble (2006)  - Yn clane 1,156,609   - Glooaght y phobble 36.3/km² (94/mi ker) Cryss hraa EET (UTC+2)  - Sourey (TTSL) EEST (UTC+3) Coad ISO 3166 UA-74 Recortyssey carbyd CB Ynnyd-eggey www.cg.gov.ua She queiggey 'syn Ookraan hwoaie eh Queiggey Chernihiv (Ookraanish: Чернігівська область Chernihiv’ka oblast’ ) ny Chernihivshchyna (Ookraanish: Чернігівщина ) myr t'eh enmyssit d
                                Read more