Magento 1.9: Error in reindexing after update to 1.15.0

I installed a new version of the Magento 1 extension (1.15.0) and now the indexing is no longer working. It halts this kind of error:

Algolia Search Queue Runner index process unknown error:
exception ‘PDOException’ with message ‘SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘algoliasearch_queue_archive’ doesn’t exist’ in /var/www/docroot/lib/Zend/Db/Statement/Pdo.php:228

How do I fix this?

I was able to fix this by executing this in DB:

CREATE TABLE IF NOT EXISTS algoliasearch_queue_archive (
pid int(11) DEFAULT NULL COMMENT ‘Pid’,
class varchar(50) NOT NULL COMMENT ‘Class’,
method varchar(50) NOT NULL COMMENT ‘Method’,
data text NOT NULL COMMENT ‘Data’,
error_log text NOT NULL COMMENT ‘Error Log’,
data_size int(11) DEFAULT NULL COMMENT ‘Data Size’,
created_at datetime NOT NULL COMMENT ‘Created At’
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Hi Kuono,

Thanks for posting! Seems like something happened during the setup upgrade process where the table couldn’t be created. If this should happen either between your own custom modules or other extensions, I would recommend trying to make Magento run the upgrade setup scripts again by rolling back the version for the module in the ‘core_resource’ table. That way, should there be any further processes for the upgrade, like data-scripts or several update scripts, it would run the full upgrade from the previous version.

For this specific upgrade, it seems like running the CREATE TABLE script was sufficient enough. Let us know if there are any issues further with that!

Thanks!