[Urgent!] 2.3 Upgrade Error “WordPress Database Error Duplicate Entry”

I’m having this same issue, trying to upgrade from WP 2.2.1 to 2.3. I get a whole page of errors about duplicate entries for key 1 and 2, just as the original poster did. I’ve tried restoring my wordpress code and database, as well as disabling all plugins. Thus far I haven’t figured out how to get past these errors to complete the upgrade.

Any hints?

Same problem here :
https://www.ads-software.com/support/topic/139979

I faced this problem with a fresh WP 2.3 installation.

WordPress database error: [Duplicate entry ’57’ for key 1]
INSERT INTO blo_postmeta (post_id,meta_key,meta_value) VALUES (’24’,’_pingme’,’1′)

WordPress database error: [Duplicate entry ’57’ for key 1]
INSERT INTO blo_postmeta (post_id,meta_key,meta_value) VALUES (’24’,’_encloseme’,’1′)

The problem occured after using the image uploader. Any suggestions?

check table blo_postmeta for post_id=57

I’m having the same problem fantasycrusader was having. Can someone help me fix it? Or tell me how to undo the upgrade?

ive the same probleme when upgrading here

WordPress database error: [Duplicate entry ‘1’ for key 1]
INSERT INTO wp_terms (term_id, name, slug, term_group) VALUES (‘1’, ‘Latex Fetish’, ‘latex-fetish-2’, ‘1’)

WordPress database error: [Duplicate entry ‘1-category’ for key 2]
INSERT INTO wp_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES (‘1’, ‘category’, ”, ‘0’, ‘2492’)

WordPress database error: [Duplicate entry ‘2’ for key 1]
INSERT INTO wp_terms (term_id, name, slug, term_group) VALUES (‘2’, ‘Blogroll’, ‘blogroll-2’, ‘1’)

WordPress database error: [Duplicate entry ‘2-link_category’ for key 2]
INSERT INTO wp_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES (‘2’, ‘link_category’, ”, ‘0’, ’22’)

I just tried to upgrade from version 2.1.3 to 2.3.3 and I’m having exactly the same issue.

The errors I get are all related to Categories or Blogroll (links). See this:

WordPress database error: [Duplicate entry ‘1’ for key 1]
INSERT INTO wp_terms (term_id, name, slug, term_group) VALUES (‘1’, ‘# Geen categorie’, ‘geen-categorie-2’, ‘1’)

WordPress database error: [Duplicate entry ‘1-category’ for key 2]
INSERT INTO wp_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES (‘1’, ‘category’, ”, ‘0’, ‘759’)

And so on…

I read this whole topic, but I still don’t understand what exactly the problem is and what I can do about it.

I just imported all my backups, so I’m using 2.1.3 again.

Does anyone know how to upgrade successfully to 2.3.3? Thanks a LOT!

Hello,

In trying to upgrade, I keep hitting the same snag as well. I’m using SVN to switch the code base from 2.2.3.

Even if I disable plugins, anything from 2.3 on causes errors like MCBO to be thrown by the upgrade script. The script completes and says it was successful, but then all my categories are empty of their posts.

Anyone?

Thanks,
-danny

My resolution: per prwood I reverted my database, then dropped these tables prior to upgrade:

drop table wp_terms;
drop table wp_term_taxonomy;
drop table wp_term_relationships;

Upgrade to 2.2.3 then completed without errors and all my categories are still healthy.

-danny

Update: After a month, I still haven’t found a solution to upgrade my blog from WordPress 2.1.3 to 2.3 successfully, while this upgrade is still urgently needed.

I’m curious to know if anyone with the problem I (and others) described, already tried to upgrade to 2.5 RC2? Is the problem solved? Is it possible to upgrade to 2.5?

Update: After a month, I still haven’t found a solution to upgrade my blog from WordPress 2.1.3 to 2.3 successfully, while this upgrade is still urgently needed.

@mcbo -> I just upgraded from 2.0.3 -> 2.5.1 without any problems.
Just make sure that you don’t drop the tables as mentioned above, but just empty them…

TRUNCATE wp_terms;
TRUNCATE wp_term_relationships;
TRUNCATE wp_term_taxonomy;

After that just call upgrade.php and it should be okay!
Worked for me just fine… Good luck!

Hi all,
I have tried all your suggestion, but it still not working. I don’t know what i have to do now.
Im trying to upgrade my 2.2.2 WordPress to 2.5.1 version.
I already tried :
1. Deactivated all plugins.
2. Drop all WP files and folders (wp-admin,wp-includes even wp-contents)
3. Extract new WP 2.5.1
4. TRUNCATE wp_terms; TRUNCATE wp_term_relationships; TRUNCATE wp_term_taxonomy;
5. call upgrade.php.

Its still not working. Anyone have another solutions? I really appreciate if you guys have one.

Btw : ryan, can i send you my backup files and please help me to take a look whats wrong with it?

Best Regards

hi,

we are having the same problem as well… ?? we’re trying to upgrade from 2.2.1 to 2.6. but we are having this error:

WordPress database error: [Duplicate entry ‘1’ for key 1]
INSERT INTO wp_terms (term_id, name, slug, term_group) VALUES (1, ”, ‘-3’, 1)

WordPress database error: [Duplicate entry ‘1-category’ for key 2]
INSERT INTO wp_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ( 1, ‘category’, ”, 0, 4423)

WordPress database error: [Duplicate entry ‘2’ for key 1]
INSERT INTO wp_terms (term_id, name, slug, term_group) VALUES (2, ”, ‘-3’, 0)

WordPress database error: [Duplicate entry ‘2-category’ for key 2]
INSERT INTO wp_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ( 2, ‘category’, ”, 0, 828)

WordPress database error: [Duplicate entry ‘3’ for key 1]
INSERT INTO wp_terms (term_id, name, slug, term_group) VALUES (3, ”, ‘-3’, 0)

WordPress database error: [Duplicate entry ‘3-category’ for key 2]
INSERT INTO wp_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ( 3, ‘category’, ”, 0, 2949)

WordPress database error: [Duplicate entry ‘4’ for key 1]
INSERT INTO wp_terms (term_id, name, slug, term_group) VALUES (4, ”, ‘-3’, 0)

WordPress database error: [Duplicate entry ‘4-category’ for key 2]
INSERT INTO wp_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ( 4, ‘category’, ”, 0, 151)

WordPress database error: [Duplicate entry ‘7’ for key 1]
INSERT INTO wp_terms (term_id, name, slug, term_group) VALUES (7, ”, ‘-3’, 0)

WordPress database error: [Duplicate entry ‘7-category’ for key 2]
INSERT INTO wp_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ( 7, ‘category’, ”, 0, 17)

WordPress database error: [Duplicate entry ‘8’ for key 1]
INSERT INTO wp_terms (term_id, name, slug, term_group) VALUES (8, ”, ‘-3’, 0)

WordPress database error: [Duplicate entry ‘8-category’ for key 2]
INSERT INTO wp_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ( 8, ‘category’, ”, 0, 60)

WordPress database error: [Duplicate entry ‘9’ for key 1]
INSERT INTO wp_terms (term_id, name, slug, term_group) VALUES (9, ”, ‘-3’, 0)

WordPress database error: [Duplicate entry ‘9-category’ for key 2]
INSERT INTO wp_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ( 9, ‘category’, ”, 0, 35)

=======================================================

Please kindly help us on this issue, as this is kind of urgent. we can give you our backup database, if it’s needed. please.. it would really mean a lot to us.

Thank you.