“重建索引过程存在问题。”产品导入后 [英] "There was a problem‍​​ with reindexing process." after product import

问题描述

使用Magento 1.6

Using Magento 1.6

我必须对我的catlog进行一些批量更改，然后进行完整的产品导出，然后进行更改，然后导入修改后的文件。

I had to make some bulk changes to my catlog and so did a full product export, made the changes then imported the ammended file.

之后有一些需要更新的索引，所有这些索引都正确地除了产品属性索引。

Afterwards there were a few index that needed updating, all of them except the "Product Attributes" index correctly.

当我尝试重新编制索引时，我收到错误重建索引过程出现问题。

When I try to re index that one I get the error "There was a problem with reindexing process."

在var / report中没有创建新错误，所以我我不知道问题是什么。

There are no new errors created in var/report and so I have no idea what the problem is.

- 疯狂SO不会让我在标题中使用问题这个词，即使这是内容错误信息。

--crazy SO won't let me use the word "problem" in the title, even though that is the content of the error message.

csv - > http://bit.ly/ z1w5Cp

csv -> http://bit.ly/z1w5Cp

编辑 - 根据OSdave的建议我收到以下错误：

edit - As per OSdave's suggestion I got the following error:

SQLSTATE [23000 ]：完整性约束违规：1062重复条目'84 -142-1-58'用于键'PRIMARY'

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '84-142-1-58' for key 'PRIMARY'

推荐答案

好的我自己解决了这个问题

OK I fixed this myself

在SQL错误中，第一个数字（在我的例子中为84）表示产品ID，某些东西没有导入正确地使用该ID，我进入了产品，手动保存并且我可以重新索引。

In the SQL error the first number (in my case 84) indicates the product id, something did not import properly with that ID, I went into the product, saved it manually and hey presto I could re-index.

希望能帮助某人： - ）

Hope that helps someone :-)

这篇关于“重建索引过程存在问题。”产品导入后的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！