WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] database errors upon upgrade (3 posts)

  1. beisbolct
    Member
    Posted 6 years ago #

    What do these errors mean and should I be concerned?

    INSERT INTO wp_terms (term_id, name, slug, term_group) VALUES ('9', 'Men\'s Basketball', 'mens-basketball-2', '1')

    WordPress database error: [Duplicate entry '11' for key 1]
    INSERT INTO wp_terms (term_id, name, slug, term_group) VALUES ('11', 'Wmn\'s Basketball', 'wmns-basketball-2', '1')

    .
    .[ moderated ]
    .

    WordPress database error: [Duplicate entry '2306-186' for key 1]
    INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) VALUES ('2306', '186')

    WordPress database error: [Duplicate entry '2278-194' for key 1]
    INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) VALUES ('2278', '194')

  2. MichaelH
    Member
    Posted 6 years ago #

    Those can be ignored.

    - From Ryan (on wp-testers):
    - ----
    Duplicate entry errors when inserting into the term_relationships
    table should not cause any harm. WP 2.2 did not enforce the post_id,
    category_id relationship to be unique in the post2cat table. That has
    resulted in some people having multiple rows for the same post_id,
    category_id pair in post2cat, as Alexander described. The upgrade is
    incorrectly assuming that the post2cat rows are unique. This will
    result in the db error messages but should not mess up your upgrade.

  3. beisbolct
    Member
    Posted 6 years ago #

    Thank you very much.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.