Redirection and Multisite: Broken

We’re running Redirection on 4.2 multisite just fine and have been for a few years now.

I’d reinstall and try again.

@riseoflex88

Please could you tell me if you network enable Redirection, or activate it on individual sites?

We network enabled it, and it works fine.

We’re evaluating Redirection with a multisite install. Network enabled the plugin.

It doesn’t appear to initial the tables properly.
Getting a lot of
[19-Feb-2016 23:12:04 UTC] WordPress database error Table 'db_dom15612.wp_4_redirection_items' doesn't exist for query SELECT wp_4_redirection_items.*,wp_4_redirection_groups.position AS group_pos FROM wp_4_redirection_items INNER JOIN wp_4_redirection_groups ON wp_4_redirection_groups.id=wp_4_redirection_items.group_id AND wp_4_redirection_groups.status='enabled' AND wp_4_redirection_groups.module_id=1 WHERE (wp_4_redirection_items.regex=1 OR wp_4_redirection_items.url='/uk/blog/') made by require('/wordpress-4.4.2/wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('/wordpress-4.4.2/wp-settings.php'), do_action('init'), call_user_func_array, WordPress_Module->init, Red_Item::get_for_url
type errors.
If table doesn’t exist I suspect the plugin is not creating it?
(Haven’t poked at the DB directly yet)

So here’s the poop:
“Network Activation” will not actually initialize the tables.
You can Network Install, and then individually activate the plugin to prevent it throwing errors.

BUT
If using folder-based multisite it never matches any rule.
So not usable for that sort of multisite.

I suspect it might work for domain-based though.

Doesn’t work on our subfolder (directory) -type multisite in either activation scenario.

Can anyone confirm that Redirection activated on individual subdomain-based subsites is actually working?

We’re using domain based multi sites.

The plugin creates tables prefixed with wp_.

But when the plugin is used from the non-primary multisite, it expects the tables to be prefixed by wp_3_ where 3 is the site / blog ID.

Should the plugin use site / blog specific tables?

If yes, it should create the site specific tables.

If no, maybe it could use wpdb->base_prefix instead of wpdb->prefix (see wpdb) when constructing queries.

But when the plugin is used from the non-primary multisite, it expects the tables to be prefixed by wp_3_ where 3 is the site / blog ID.

You can get it to create the tables, wpsilb by NOT doing a “Network Activation.” Just install but don’t activate.
Then go to each site and activate.

That will stop the errors, but I don’t know if it will actually work.
On folder-based multisite it doesn’t deal with the folder base paths so no URL can match.
Maybe it will work with domain-based multisite.

I had the error, and I can confirm when I do not network activate it and activate to each individual site, the error dissapear.

There is a workaround.

The site specific tables are created when one opens Tools\Redirection under the WPAdmin dashboard of a site.

wpslib:
Are you running folder-based or domain-based multisite?
Because even with the tables initialized, it didn’t seem to work for the folder-based multisite I was testing.

We are using domain based multi site.

Thanks @wpsilb, this workaround is weird, yet works…