Find Jobs
Hire Freelancers

Magento: 1062 Duplicate entry - Can't add new products

$30-250 USD

In Progress
Posted over 13 years ago

$30-250 USD

Paid on delivery
My Magento store is no longer able to (1) Add Products or (2) Duplicate Products. The Problem To the best of my knowledge, there is a problem with an entry somewhere in the database. Perhaps something is no longer auto-indexing. Cause of the Problem I believe the error resulted because I attempted to use Magento's importer. The import function made the products appear in the back end only. The products did not appear in the front end. Error Message When I attempt to duplicate or create a new product, Magneto does not save the new product. It produces this error message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3422-1' for key 2 If I try again, the number will increase sequentially like this, one for each time I try to create a new product: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3423-1' for key 2 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3424-1' for key 2 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3425-1' for key 2 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3426-1' for key 2 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3427-1' for key 2 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3428-1' for key 2 3428 refers to the product_id or entity_id. I am not sure which. Another Problem Under Index Management, the index named Product Flat Data is stuck on "Processing". This is probably related. Steps Taken Already I have already tried: 1. Reindexing (Product Flat Data stays at "Processing") 2. Delete var/cache 3. Recache 4. Use the admin area to delete all the products that I imported 5. Empty all "log_" tables 6. Truncate and auto-index all "log_" tables 7. Select all tables and press "Repair Tables" ([login to view URL]) 8. Run "php shell/[login to view URL] reindexall" in SSH. Received success messages, but the problem remains. 9. Change table "core_flag" to big int ([login to view URL]) I need someone who can fix the problem. It might be just a bad entry in a table. I'm ready when you are!
Project ID: 903384

About the project

5 proposals
Remote project
Active 13 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
5 freelancers are bidding on average $88 USD for this job
User Avatar
can help you. tnx.
$125 USD in 10 days
4.9 (378 reviews)
7.3
7.3
User Avatar
hi, i can help you. i am expert with magento.
$39 USD in 1 day
4.8 (90 reviews)
6.5
6.5
User Avatar
We can do it
$50 USD in 1 day
4.6 (38 reviews)
6.0
6.0
User Avatar
check yr pmb
$100 USD in 5 days
4.8 (14 reviews)
5.2
5.2
User Avatar
please check PM
$150 USD in 8 days
4.1 (4 reviews)
4.0
4.0
User Avatar
Database debugging is a speciality. Working from UK.
$100 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Monticello, United States
5.0
7
Member since Apr 7, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.