New to the community? Start here

Make Proper Network Activation work with Multi-DB

Hi!

I need to use the Proper Network Activation plugin in order to make all the plugin work as intended.

I’ve tested it on a clean multisite install without multi-db and it worked as expected.

It did not work on my multisite install with multi-db so I guess the two plugins does not play well at the moment.

Help please!

Oscar

Sun, 3 Feb 2013 17:06:12

Tom Eagles
- Syntax Hero
- 1,171 pts: Hero points 1,218 pts: Rep. points LEVEL 8
@enkreativbyra

Do you have a link to the plugin

Cheers

Tom

enkreativbyra

Design Lord, Child of Thor

53 pts: Hero points 53 pts: Rep. points LEVEL 3

Sure!

http://wordpress.org/extend/plugins/proper-network-activation/

I would belive it’s around line 145 the problem would be.

$blogs = $wpdb->get_col( $wpdb->prepare( "

SELECT blog_id

FROM {$wpdb->blogs}

WHERE site_id = %d

AND blog_id <> %d

AND spam = '0'

AND deleted = '0'

AND archived = '0'

ORDER BY registered DESC

LIMIT %d, 5

", $wpdb->siteid, $wpdb->blogid, $offset ) );



foreach ( $blogs as $blog_id ) {

switch_to_blog( $blog_id );

Tom Eagles
- Syntax Hero
- 1,171 pts: Hero points 1,218 pts: Rep. points LEVEL 8
@enkreativbyra

I will pull @Barry the developer of this plugin to help out. But i am pretty sure its because of the fact that the blogs are scattered across different databases that is causing the issue.

Cheers

Tom
enkreativbyra
- Design Lord, Child of Thor
- 53 pts: Hero points 53 pts: Rep. points LEVEL 3
Yes, exactly. But that should be possible to detect right?
Barry
- DEV MAN’s Mascot
- 526 pts: Hero points 6,840 pts: Rep. points LEVEL 24
Don’t see any issue with those lines – what error are you getting? What is / isn’t happening?
enkreativbyra
- Design Lord, Child of Thor
- 53 pts: Hero points 53 pts: Rep. points LEVEL 3
The plugin Proper Network Activation runs each time a new blog is added or when a plugin is activated.

When I tried it without multi-db I could see that each blog got the tables added.

Sort of like this:

blog_2_database_table_1

blog_2_database_table_2

But, when I tried it on my multisite with multi-db it didn’t add the tables to sub-sites.

So, I guess that the plugin can’t figure out in what database the tables should be added.
enkreativbyra
- Design Lord, Child of Thor
- 53 pts: Hero points 53 pts: Rep. points LEVEL 3
Not getting any errors, and I am not sure that it’s that piece of code that causes the error. Please check the Proper Network Activation files for the full code.
Barry
- DEV MAN’s Mascot
- 526 pts: Hero points 6,840 pts: Rep. points LEVEL 24
I have just downloaded the plugin and can’t see anything obvious in that which would cause an issue. If it wasn’t using $wpdb or was joining tables then there could be an issue, but a basic select from the blogs table is done all the time within the WP code base.

But, when I tried it on my multisite with multi-db it didn’t add the tables to sub-sites.

Can you put some debug code in your system to see what is happening on your install? E.g add the following on blank line 156 –
```
error_log($wpdb->prepare( "

SELECT blog_id

FROM {$wpdb->blogs}

WHERE site_id = %d

AND blog_id <> %d

AND spam = '0'

AND deleted = '0'

AND archived = '0'

ORDER BY registered DESC

LIMIT %d, 5

", $wpdb->siteid, $wpdb->blogid, $offset ));
```
Which will output the sql that is being run to your php error log. If you then check that for output and let me know what the query it is trying to run.
enkreativbyra
- Design Lord, Child of Thor
- 53 pts: Hero points 53 pts: Rep. points LEVEL 3
Sorry, not sure where the error_log appears. Not that great on the advanced stuff…
Barry
- DEV MAN’s Mascot
- 526 pts: Hero points 6,840 pts: Rep. points LEVEL 24
It’ll appear in your php error log – are you on a host with a cpanel or on a vps / dedicated system?
enkreativbyra
- Design Lord, Child of Thor
- 53 pts: Hero points 53 pts: Rep. points LEVEL 3
I am on a vps/dedicated with plesk. Sorry for the trouble.
enkreativbyra
- Design Lord, Child of Thor
- 53 pts: Hero points 53 pts: Rep. points LEVEL 3
Hi!

Any new ideas on this? It’s very important for me so any help to get this fixed is very appreciated!

Thanks!
enkreativbyra
- Design Lord, Child of Thor
- 53 pts: Hero points 53 pts: Rep. points LEVEL 3
Can anyone please help explain how I can provide you with the error log. I have searched a lot on google and tried to find it, but can’t.
Barry
- DEV MAN’s Mascot
- 526 pts: Hero points 6,840 pts: Rep. points LEVEL 24
I’ve not used Plesk so I’m not sure myself? I did a google search and found a few articles / forum threads but this one sounded the simplest – hopefully it’s useful.

http://serverfault.com/questions/407106/how-to-include-php-error-log-in-plesk-10-4-control-panel
aecnu
- WP Unicorn
- 2,863 pts: Hero points 19,444 pts: Rep. points LEVEL 29
Greetings Oscar,

We have not heard back from you as to the status of this issue.

If you are still having an issue please let us know so that we may try to get you fixed up as soon as possible by choosing to check mark this ticket as unresolved below and posting any new errors or symptoms you are noticing.

This action will also bring your ticket up front back in plain view again within the ticket system.

Thank you for being a WPMU DEV Community Member!

Cheers, Joe