January 13th, 2010

WPMU: Please add commentmeta first

WordPress, by Donncha.

I was going to announce WordPress MU 2.9.1 today but I knew that people would run into trouble with the missing commentmeta table if they didn’t upgrade their blogs immediately.

So, download add-commentmeta.txt, rename it to add-commentmeta.php and copy it into your mu-plugins folder. Login to your site as a Site Admin, visit Site Admin->Upgrade and upgrade all the blogs on your site. Make sure you’re using WordPress MU 2.8.6 as the upgrade script in older versions may not execute the plugin.

The script above will add the commentmeta table to each blog. Give it time because it will take quite a while on large sites. WordPress MU 2.9.1 tomorrow.

You might also like

  • WPMU Snapshot
  • New WPMU snapshot: wpmu-2005-03-15.tar.gzwpmu-2005-03-15.zip Changes: I removed several options not required in
  • WPMU Snapshot
  • Hot on the heels of yesterday's snapshot comes another:wpmu-2005-03-12.tar.gzwpmu-2005-03-12.zip Lots of
  • New WPMU Snapshot
  • An all-new, all-singing snapshot is now available. The mu website

If you like this post then please subscribe to my full RSS feed. You can also click here to subscribe by email. There are also my fabulous photos and funny videos to explore too!

Back Top

Responses to “WPMU: Please add commentmeta first”

  1. So if I upgrade my site immediately after plopping down the 2.9.1 files, i don’t have to run the add-commentmeta script before hand?

  2. Hi Donncha,

    If we only have small WPMU installs (less than 100 blogs), is this step of using the mu-plugin necessary?

    ie. will WPMU 2.9.1 try to add this new table as part of its standard upgrade procedure (if I update the core files then run Site Admin -> Upgrade).

    For previous versions of WPMU that involve db changes, a separate mu-plugin wasn’t required.

    Thanks.

    James Collins at January 13, 2010 8:17 pm
    • It’s up to you, but I’d create the tables before hand. There’s nothing quite like the stress of upgrading and finding that something has broken. This is one less thing you have to worry about.

      I don’t think the missing commentmeta table will crash your blogs or anything but there’s no harm in being prepared and having it done already.

  3. We had some issues upgrading from to WPMU 2.8.6, so we’re still stuck at WPMU 2.7 (auto-upgrade isn’t working yet, so we have to do it manually). I was hoping to upgrade directly to WPMU 2.9.1… Will that be possible?

  4. How I run this upgrade script from console (terminal, etc) in server?

  5. I tried to locate the 2.8.6 download first, but could not find a link to it anywhere on the mu site. I am running 2.8.5.2. Do you think it is safe to upgrade to 2.9.1 directly? Or should I keep hunting down 2.8.6 first?

  6. I upgraded to WPMU 2.9.1 before I read this post. So far I have less than a dozen blogs but plan on many more soon. What do you suggest I do?

  7. Should I still install add-commentmeta.txt?

  8. I went ahead and did the upgrade before seeing your message. I can report that at least for me I had no problem going from 2.8.5.2 to 2.9.1

    Great job on this, I am loving the new features already, and I’m sure my users will really love them.

  9. …nothing quite like the stress of upgrading and finding that something has broken.

    That’s for sure! I’m sorry I found this post, after upgrading, but very glad to see that commentmeta tables were successfully created on all our 200+ member blogs. I’ll assume that means running Upgrade again with the script installed is not necessary.

    Thanks for everything!

  10. Not sure if this was necessary, but I did it and upgraded. No probs on my end.

    Dainis W. Michel at January 19, 2010 1:35 pm
  1. WordPressµ 2.9.1 » WordPress Italy Blog (,January 13, 2010)

    [...] Via: Donncha [...]

  2. Digital Hverdag » WordPress MU – for siste gang? (,January 14, 2010)

    [...] Men for deg med WordPress MU, oppfordrer Donncha O Caoimh å oppgrader installasjonen din før du oppgraderer til versjon 2.9.1. I 2.9.1 kommer det et nytt database felt commentmeta i databasen din – en gang for hver blogg du har. Siden dette kan føre til ekstra “stress” for serveren din, oppfordrer Donncha deg til å kjøre et lite script før du gjør selve oppgraderingen. Fremgangsmåte og selve scriptet kan du finne på Donnchas blogg – http://ocaoimh.ie/wpmu-add-commentmeta/. [...]

  3. Desgavell informàtic: El diari que segueix el que faig com a tal… » Preparant la base de dades del wp-mu (,January 14, 2010)

    [...] info: http://ocaoimh.ie/wpmu-add-commentmeta/ Publicat per cubells, el 14 de gener de 2010.Pertany a la categoria: wpmu. Etiquetes: 2.9.1 Sense [...]

  4. Importante actualización de WordPress MU (,January 14, 2010)

    [...] WordPress MU 2.9.1 lleva una nueva tabla en las bases de datos que hay que crear antes de actualizar. Para ello Donncha nos ofrece el archivo add-commentmeta.txt. [...]

  5. וורדפרס מו 2.9.1 בעברית » וורדפרס מרובה משתמשים (,January 14, 2010)

    [...] ויש לכם יותר מעשרות בלוגים במערכת, מומלץ להריץ את תוסף יצירת הטבלאות החדשות לפני השדרוג [...]

  6. » Développement WordPress Passer à WordPress Mu 2.9.1 : une manip spéciale « Fairweb (,January 17, 2010)

    [...] une manipulation spéciale sans laquelle vous risquez de vous faire peur. Ceci est expliqué dans un billet de Donncha que je reprends ici pour les [...]

  7. » WordPress development Things to do before upgrading to WordPress Mu 2.9.1 « Fairweb (,January 17, 2010)

    [...] Donncha explained it in his post upgrading to WordPress Mu 2.9.1 needs special attention otherwise you’ll probably get errors [...]

  8. This week on twitter 2010-01-17 : PatchLog (,January 17, 2010)

    [...] 2.9.1 to be released tomorrow – RT @donncha: Please add commentmeta first: http://ocaoimh.ie/wpmu-add-commentmeta/ #WordPress #wpmu [...]

  9. WordPress MU 2.9.1 简体中文语言包发布 | 梦色窝居 (,January 18, 2010)

    [...] 各位在从老版本进行升级的时候,需要注意一点。新版程序为每个子博客都增加了一个名为“commentmeta”的数据库表。请在升级到 2.9.1 之前,先将您的站点升级为 WordPress 2.8.6,然后下载 MU 开发人员在其博客中提到的文本文件。重命名该文本文件为“add-commentmeta.php”并复制到“mu-plugins”目录中。最后,进入“站点管理 -> 升级”对全站的子博客进行升级。这样,该插件会自动为所有的子博客增加所需的数据库表。升级 2.9.1 的方式和之前就没什么区别了,直接覆盖,然后按照提示就可以了。(注意:该插件只能在 2.8.6 下运行,所以务必先升级到 2.8.6 再运行该插件。) [...]

  10. WordPress MU 2.9.1 (,January 18, 2010)

    [...] WPMU: Please add commentmeta first WordPress MU 2.9.1.1 Jan 14 [...]

  11. WPMU 2.9.1 The Last Version Of MU? (,January 19, 2010)

    [...] bulk plugin upgrades can be used in WordPressMU. Before you upgrade though, be sure to read this IMPORTANT post regarding adding the commentmeta table to your [...]

  12. Sandbox worpdressmu prepare upgrade « NLTL logs (,January 22, 2010)

    [...] Sandbox worpdressmu prepare upgrade Ran add-commentmeta.txt script (change extension to .php and move into mu-plugins folder) to add the commentmeta tables needed before upgrading to 2.9.1.1 as per article [...]

  13. Your Wordpress MU 2.9.1 Upgrade/Update Failed? Some Helpful Tips. (,January 27, 2010)

    [...] Donncha’s comment-meta solution: link [...]

Leave a Reply

Back Top


Holy Shmoly! is Digg proof thanks to caching by WP Super Cache