The following error occurs in exception.log file

exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'catalog_category_product_index_tmp' doesn't exist' in /www/sites/www.test.com/files/html/lib/Zend/Db/Statement/Pdo.php:228

When I am trying to create the table catalog_category_product_index_tmp through phpmyadmin after running php shell/indexer.php reindexall the table is automatically deleted and through the exception like above.

Advance thanks

  • Hi @Jjo, did you ever find a solution to this? I am encountering the same issue, on Magento Mar 9, 2018 at 14:26


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.