Completed

Cant reindex Product attributes after Magmi CSV import

This project was successfully completed by honeydreams for €100 EUR in a day.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
€30 - €250 EUR
Completed In
1 day
Total Bids
7
Project Description

Hi freelancer,

im desperate to find solution to SQL error showing while trying to re-index Product attributes in Magento after CSV file import via Magmi.

Error scenario:
1) have DB with no products
2) import some products via CSV file with Magmi importing script
3) try to reindex Product attributes via command line
4) during reindexing this error shows up:

Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '612-166-2-85
55' for key 'PRIMARY'' in /home/MY WEBSITE/public_html/lib/Zend/Db/Statement/[url removed, login to view]
...............

I tried few basic tips and scripts found on internet which should find these duplicate entries but NOTHING helped.
I would be glad to find reason of this error and to fix it.

One possible hint: if I import first 10% of products then reindex is without error, but when I import all products from CSV file then error shows up - problem could be somewhere in Magmi CSV file

Please apply only if you have experience with Magmi!!!.

Suggested price for finding and fixing is around 100$ (by fixing I mean it should never happen again because source of error will be removed!). If great service is provided additional tip can be added.

I attached CSV file which is in question.

Thank you in advance,
looking for offers.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online