Can't force reindex on magento 1 since update

I can’t reindex in the back end of magento it just won’t let me

11

So I thought i would try the ssh approach to force the reindex!

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

Typed in this as advised by some guys over at stack exchange

php indexer.php --reindex catalogsearch_fulltext

Which then 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}

I’m stuck as to what to do next. This has started since I updated the algolia extension and it’s a shame as I like the way it works and was going to upgrade to the paid after having tested it on our site for a couple of months before committing. Any ideas at what this could be?

What version of Magento are you running?

It looks like the database is not as expected. Do you seen any reason why the created column would’nt be here. Have you updated the code without updating the database maybe?

Hi, I’m using 1.9.3.4 and everything was working fine till the update of the algolia extension. I have tried to force the reindex through ssh but it won’t and says error. It won’t reindex any of the algolia indexes apart from search suggestions and it won’t reindex catalog search index either which obviously is more important.