Find Jobs
Hire Freelancers

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

$30-250 USD

Igangværende
Slået op over 13 år siden

$30-250 USD

Betales ved levering
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!
Projekt-ID: 903384

Om projektet

5 forslag
Projekt på afstand
Aktiv 13 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
5 freelancere byder i gennemsnit $88 USD på dette job
Brug Avatar.
can help you. tnx.
$125 USD på 10 dage
4,9 (378 anmeldelser)
7,3
7,3
Brug Avatar.
hi, i can help you. i am expert with magento.
$39 USD på 1 dag
4,8 (90 anmeldelser)
6,5
6,5
Brug Avatar.
We can do it
$50 USD på 1 dag
4,6 (38 anmeldelser)
6,0
6,0
Brug Avatar.
check yr pmb
$100 USD på 5 dage
4,8 (14 anmeldelser)
5,2
5,2
Brug Avatar.
please check PM
$150 USD på 8 dage
4,1 (4 anmeldelser)
4,0
4,0
Brug Avatar.
Database debugging is a speciality. Working from UK.
$100 USD på 1 dag
0,0 (0 anmeldelser)
0,0
0,0

Om klienten

Flag for UNITED STATES
Monticello, United States
5,0
7
Medlem siden apr. 7, 2010

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.