WordPress MU

hey wordpress folks,

i just upgraded from wordpressmu 2.6 to 2.7.1

after extracting 2.7.1 and copying and modifying all needed files.
the whole WP-mu setup was really slow !
in my apache error logs i found messages like

[Mon Jun 22 12:46:07 2009] [error] [client 89.57.145.9] WordPress database error Duplicate key name 'comment_approved' for query ALTER TABLE wp_617_comments ADD KEY comment_approved (comment_approved) made by wp_upgrade, make_db_current_silent, dbDelta
[Mon Jun 22 12:46:07 2009] [error] [client 89.57.145.9] WordPress database error Duplicate key name 'type_status_date' for query ALTER TABLE wp_617_posts ADD KEY type_status_date (post_type,post_status,post_date,ID) made by wp_upgrade, make_db_current_silent, dbDelta
[Mon Jun 22 12:46:07 2009] [error] [client 89.57.145.9] WordPress database error Duplicate key name 'domain' for query ALTER TABLE wp_blogs ADD KEY domain (domain(50),path(5)) made by wp_upgrade, make_db_current_silent, dbDelta

after waiting a while the site(s) appear.

calling site-wide upgrade (for all blogs from admin menu) takes a long time to... and results in

Warning! Problem upgrading http://.....net/. Your server may not be able to connect to blogs running on it.
Error message: Could not open handle for fopen() to http://.....net/wp-admin/upgrade.php?step=1

any ideas what going wrong ?

me again:

after 2-3h manual upgrading (site per site) .. the db errors in error_log seem to be gone.

but calling an upgrade- for a site ..still takes a lot of time...

Hi there,

I’m a tech for a school district using Wordpress MU with 236 blogs running on it. I encountered this error during the upgrade from 2.6.something to 2.8.6, and started digging around for an answer. Unfortunately, I couldn't find any information, so I kept digging.

I found that some of the users were using a theme called Book Love. It must not be compatible with the newer version of Wordpress. According to my error_log for Apache2, it was causing errors:

# tail /var/log/apache2/error_log
“[Wed Dec 09 11:41:18 2009] [error] [client 10.1.1.23] PHP Parse error: syntax error, unexpected ‘}’ in /home/blogz/public_html/wp-content/themes/book-love-10/functions.php on line 28″

I went into the blog list, found the users blogs and clicked Edit. I removed book-love and Book Love entries, causing it to use the default theme, and Wordpress was then able to upgrade the site past these blogs.

I hope this helps your situation.

–Brad Brown