database errors upon upgrade

  • Resolved beisbolct

    (@beisbolct)


    16 years, 7 months 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’)

Viewing 2 replies - 1 through 2 (of 2 total)
  • MichaelH

    (@michaelh)

    16 years, 7 months 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.

    Thread Starter beisbolct

    (@beisbolct)

    16 years, 7 months ago

    Thank you very much.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘database errors upon upgrade’ is closed to new replies.