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.
28 replies on “WPMU: Please add commentmeta first”
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?
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.
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.
[…] Via: Donncha […]
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?
Ping! 😉
[…] 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/. […]
[…] 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 […]
[…] 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. […]
How I run this upgrade script from console (terminal, etc) in server?
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?
Shawn – you can get it in a zip file at the end of this page.
[…] ויש ×œ×›× ×™×•×ª×¨ מעשרות ×‘×œ×•×’×™× ×‘×ž×¢×¨×›×ª, מומלץ להריץ ×ת תוסף יצירת הטבל×ות החדשות ×œ×¤× ×™ השדרוג […]
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?
Should I still install add-commentmeta.txt?
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.
Nice! I was hoping on that!
[…] http://ocaoimh.ie/wpmu-add-commentmeta/ […]
[…] 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 […]
[…] Donncha explained it in his post upgrading to WordPress Mu 2.9.1 needs special attention otherwise you’ll probably get errors […]
[…] 2.9.1 to be released tomorrow – RT @donncha: Please add commentmeta first: http://ocaoimh.ie/wpmu-add-commentmeta/ #WordPress #wpmu […]
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!
[…] å„ä½åœ¨ä»Žè€ç‰ˆæœ¬è¿›è¡Œå‡çº§çš„æ—¶å€™ï¼Œéœ€è¦æ³¨æ„一点。新版程åºä¸ºæ¯ä¸ªååšå®¢éƒ½å¢žåŠ äº†ä¸€ä¸ªå为“commentmetaâ€çš„æ•°æ®åº“表。请在å‡çº§åˆ° 2.9.1 之å‰ï¼Œå…ˆå°†æ‚¨çš„站点å‡çº§ä¸º WordPress 2.8.6,然åŽä¸‹è½½ MU å¼€å‘人员在其åšå®¢ä¸æåˆ°çš„æ–‡æœ¬æ–‡ä»¶ã€‚é‡å‘½å该文本文件为“add-commentmeta.phpâ€å¹¶å¤åˆ¶åˆ°â€œmu-pluginsâ€ç›®å½•ä¸ã€‚最åŽï¼Œè¿›å…¥â€œç«™ç‚¹ç®¡ç† -> å‡çº§â€å¯¹å…¨ç«™çš„ååšå®¢è¿›è¡Œå‡çº§ã€‚è¿™æ ·ï¼Œè¯¥æ’件会自动为所有的ååšå®¢å¢žåŠ æ‰€éœ€çš„æ•°æ®åº“表。å‡çº§ 2.9.1 的方å¼å’Œä¹‹å‰å°±æ²¡ä»€ä¹ˆåŒºåˆ«äº†ï¼Œç›´æŽ¥è¦†ç›–ï¼Œç„¶åŽæŒ‰ç…§æç¤ºå°±å¯ä»¥äº†ã€‚(注æ„:该æ’ä»¶åªèƒ½åœ¨ 2.8.6 下è¿è¡Œï¼Œæ‰€ä»¥åŠ¡å¿…å…ˆå‡çº§åˆ° 2.8.6 å†è¿è¡Œè¯¥æ’件。) […]
[…] WPMU: Please add commentmeta first WordPress MU 2.9.1.1 Jan 14 […]
Not sure if this was necessary, but I did it and upgraded. No probs on my end.
[…] 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 […]
[…] 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 […]
[…] Donncha’s comment-meta solution: link […]