1

I've seen this problem all around the internet and have yet to find a reasonable solution yet. I've truncated the core_url_rewrite table, set my permissions properly, etc.

It seems there is an issue when actually performing the query, duplicate data is being inserted into the table, and no exception is thrown, causing the script to hang indefinitely. All other indexes work fine. The table has about 300,000+ records. So any number of these could be causing an issue.

I've pruned the database to make sure products do not share the same SKU, as that was also one of the recommended solutions. I'm not exactly sure what the indexer is doing specifically that would cause this conflict. Any suggestions are greatly appreciated!

Improve this question
4
  • Do you have customer attributes that a multiselect? I had this issue and when I changed them to dropdown I was able to re-index. What version are you using? This should be fixed in the most recent.
    – Kimberely Thomas
    Commented May 22, 2013 at 21:27
  • I am using the latest CE. Can you please clarify your answer? Where is this option in the admin panel?
    – DWils
    Commented May 23, 2013 at 16:47
  • Magento has/had a fix for this that we have applied to other 1.7 site. I am attaching the PATCH. The particular problem we had was new URLs being generated each time the index was performed. I don't know how to attach a file.
    – brentwpeterson
    Commented Sep 11, 2013 at 18:52
  • I would recommend gist or pastebin. Copy paste the contents of the patch file there and share the link here, or as an answer.
    – DWils
    Commented Sep 14, 2013 at 10:55

1 Answer 1

Reset to default
1

We have similar problem with duplicating records. The problem appear because of this checkbox https://www.monosnap.com/image/nWkoCm1itaDaZE86PEK9ypVAO Create Permanent Redirect for old URL and product names are equal.

There is a fix we've used on one of the projects https://gist.github.com/vdubyna/6162493

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.