The MU forums have moved to WordPress.org

upgrade DB errors (2 posts)

  1. berniq
    Member
    Posted 17 years ago #

    hey,
    i just upgraded from 1.5 to 2.6 and lots of errors run into my apache error_log. don't know if those error appeared on previous updates...

    for nearly every blog lots of messages like this where dumped:


    [Sat Aug 30 15:08:37 2008] [error] [client 193.238.157.118] WordPress database error Duplicate key name 'domain' for query ALTER TABLE wp_blogs ADD KEY domain (domain(50),path(5)) made by dbDelta
    [Sat Aug 30 15:08:38 2008] [error] [client 193.238.157.118] WordPress database error Duplicate key name 'domain' for query ALTER TABLE wp_blogs ADD KEY domain (domain(50),path(5)) made by dbDelta
    [Sat Aug 30 15:08:38 2008] [error] [client 193.238.157.118] WordPress database error Duplicate key name 'domain' for query ALTER TABLE wp_blogs ADD KEY domain (domain(50),path(5)) made by dbDelta
    [Sat Aug 30 15:08:39 2008] [error] [client 193.238.157.118] WordPress database error Duplicate key name 'comment_approved' for query ALTER TABLE wp_1850_comments ADD KEY comment_approved (comment_approved) made by dbDelta
    [Sat Aug 30 15:08:39 2008] [error] [client 193.238.157.118] WordPress database error Duplicate key name 'type_status_date' for query ALTER TABLE wp_1850_posts ADD KEY type_status_date (post_type,post_status,post_date,ID) made by dbDelta [Sat Aug 30 15:08:39 2008] [error] [client 193.238.157.118] WordPress database error Duplicate key name 'domain' for query ALTER TABLE wp_blogs ADD KEY domain (domain(50),path(5)) made by dbDelta
    [Sat Aug 30 15:08:40 2008] [error] [client 193.238.157.118] WordPress database error Duplicate key name 'comment_approved' for query ALTER TABLE wp_1849_comments ADD KEY comment_approved (comment_approved) made by dbDelta

    and ideas ?
    thanks,
    bernhard

  2. MrBrian
    Member
    Posted 17 years ago #

    I'm pretty sure you're fine, as those errors just mean that the upgrade tried to add some stuff in the database that was already there.

About this Topic