Cant reindex Product attributes after Magmi CSV import

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.

Beceriler: Magento, MySQL, PHP

Daha fazlasını gör: csv magmi, next exception zend_db_statement_exception message sqlstate 23000, magmi price import error, magmi problem, magmi import script, magmi reindex script, magmi reindex problem, cant reindex product attributes magmi csv import magento, tips on freelancer, tips freelancer, pdo website, hint freelancer, freelancer zend, freelancer with magento 2, freelancer tip, freelancer statement, freelancer product, freelancer magento price, freelancer home products, freelancer fix price, freelancer 4.85, finding freelancer it, db freelancer, csv freelancer, php pdo

İşveren Hakkında:
( 29 değerlendirme ) Rimavska Sobota, Slovakia

Proje NO: #4402317



Ready to start now

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% EUR
(18 Değerlendirme)

7 freelancers are bidding on average €132 for this job


Here are Magento Experts , please check Our Latest Magento work In PMB For Our Experience and skills Regarding Magento projects and Let me start your work , Thanks

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(89 Değerlendirme)

Hi, We're ready to take up your project. Kindly check PMB for more details. Awaiting your kind response.

in %bids___i_period_sub_35% gün içinde144%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(13 Değerlendirme)

please check the [url removed, login to view]

in %bids___i_period_sub_35% gün içinde105%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(29 Değerlendirme)

Hi, I can do it for you. Let me do it. Thanks.

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(13 Değerlendirme)

Hi, Please check your private message board . Thanks Sam

in %bids___i_period_sub_35% gün içinde103%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

Hi I can do this work. Ready to start.

in %bids___i_period_sub_35% gün içinde120%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)