Magento catalog_category_flat_store_1不存在 [英] Magento catalog_category_flat_store_1 does not exist

问题描述

我有一家现有商店，运行的是Magento CE 1.7.从今天早上突然开始(没有任何代码更新)，我收到以下错误-

I have an existing store running Magento CE 1.7. Suddenly from today morning (without any code updates), I am receiving the following error -

a:5:{i:0; s:111:"SQLSTATE [42S02]:找不到基本表或视图:1146表'XXXXXX.catalog_category_flat_store_1'不存在"; i:1; s :5914:#0/var/www/lib/Varien/Db/Statement/Pdo/Mysql.php(110):Zend_Db_Statement_Pdo-> _ execute(Array)

我可以看到该表实际上存在于数据库中，并且可以从服务器进行访问.但是，错误报告指示未找到它.

I can see that the table actually exists in the Database and can be accessed from the server. However, the error report is indicating that its not found.

我到目前为止，

-已清除缓存

-重建索引

-删除了表并再次重建了索引，以便它可以自动创建并且可以.

-- Removed the table and rebuilt the index again, so that it gets created automatically and it does.

任何人都可以对此发表一些看法吗?

Can anyone please throw some light on this??

推荐答案

我以前曾经发生过这种情况.当数据库在索引编制过程中崩溃并且表被破坏或删除时，通常会发生这种情况.

I've had this happen before. This usually occurs when the database crashes during an indexing process, and the table gets corrupted or deleted.

我这样做如下:

1. 从数据库中删除 catalog_category_flat_store_1 (如果存在)(将其完全删除).

1. Drop catalog_category_flat_store_1 from the database if it exists (delete it completely).

在新数据库上安装Magento的新实例(或使用其他预先存在的Magento数据库)

Install a new instance of Magento on a new database (or use another pre-existing Magento database)

从新的(或现有的Magento数据库)将 catalog_category_flat_store_1 克隆到您的Magento数据库(出现错误的数据库).

From the new (or existing Magento database), clone the catalog_category_flat_store_1 to your Magento database (the one that is having the error).

重新索引您的网站-特别是Category Flat Data索引.

Reindex your site - specifically the Category Flat Data index.

这篇关于Magento catalog_category_flat_store_1不存在的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！