Plugin Activation Error with WPMU 2.8.4a & latest Multi-DB
I updated my wpmu site earlier this week and the upgrade went 'seemingly' smooth. I updated from about 2.3 to 2.8, so I had to update a lot of my plugins, and the multi-db script.
All of the blogs on my site are appearing correctly, and members are making posts, comments, etc..
The problem is that I started getting reports about plugin problems from members. It seemed strange because I tested the plugins from the 'main blog' admin account, and they all activated fine. However, when I login as another account now, 'none' of the plugins will activate.
I'm getting strange things in my apache error log telling me that the each plugin 'when activated' is trying to put things in a 'd4' database. The blog id that I'm trying to activate plugins for is 2, and i'm using 256 tables, so it should be attempting an install at 'c8'. I read in another post that someone had a similar problem but with the 'd' database. Presumably, they were using a 16 db setup vs. my 256.
Any suggestions would be much appreciated. As I mentioned my blogs all work now (posts, comments, etc.), it's just plugins that won't activate for blog owners other than admin. (none of them!). Some of the plugins I tried (wp-polls, wp-contact, wp-slimstat-ex, adsense sitewide - latest versions). They installed for me as admin in blog 1, but not for any users.
Regards...
Everyday at WPMU DEV we help hundreds of WP Users. Become a member today to:
- Download 250+ Premium Plugins and Themes
- Get unlimited support from WordPress Experts
- Get help with your WordPress or BuddyPress projects
Help & Support from WPMU DEV members and staff
Erstwhile founder
Hiya,
Were the plugins working with the previous version of Multi-DB? Also, can you please look in the plugins and see if the queries have the table names hardcoded or if they're variables.
Hardcoded:
SELECT * FROM wp_posts
Variable:
SELECT * FROM $wpdb->posts
Thanks,
Andrew
Well, here are two examples:
wp-contact form. - Doesn't use any DB tables, and won't activate for anyone other than admin.
wp-useronline - Was working with my 2.3 (and 3-4 generation older multidb). I checked the DB sections and they look like "CREATE TABLE $wpdb->useronline".
Again my main blog "1" is in DB 'c8' and both of these plugins will activate when I am admin on the main blog. So the routing is working for admin, but not any of the other accounts.
Thanks...
Get personal, comprehensive and timely support and assistance
from WordPress Experts
Can you provide some links to the plugins and I can have a check for you.
Other than that, can you check the permissions on the other databases to make sure that your database user can create tables on them.
I have made some progress. It appears this is related to the buddypress plugin. Has anyone integrated buddypress with wpmu and multi-db?
I just read the forum posts regarding buddypress and multi-db, so I answered my own question. I can confirm that it works from the front-end with latest wpmu, buddypress, and multi-db plugin. The only problem is the aformentioned plugin activation problem for non-admin blogs.
I would love to see buddypress work with multi-db.
-thanks
Erstwhile founder
I would love to see buddypress work with multi-db.
BuddyPress does work with Multi-DB.
If you're having issues with both BuddyPress and individual plugins then you may need to check your Multi-DB configuration.
Thanks,
Andrew
Get personal, comprehensive and timely support and assistance
from WordPress Experts
I'm running it with 256 databases and I have everything working fine (buddypress) and all users can activate plugins.
Allows you to scale your standard Multisite install to allow for millions of blogs... also will vastly improve the performance of your site!