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…