I have the same problem :
WordPress database error: [Table 'mysite.wp_redirection_items' doesn't exist]
When I turn the debug off it disappears but…
I am seeing the same issue. The tables are not be created when the plugin is activated. I am running on WP 4.2.2 using a custom table prefix.
Also seeing this on multisite, did you hook into the multisite network upgrade hook?
PHP message: WordPress database error Table 'flagship.wp_1239_redirection_404' doesn't exist for query SHOW FULL COLUMNS FROMwp_1239_redirection_404made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), call_user_func_array, WordPress_Module->template_redirect, RE_404::create is filling my logs!
I am getting the same error when I use the wp command line tool if this plugin is activated.
Current wordpress and plugins all up to date.
wp command line tool: http://wp-cli.org/commands/plugin/
Same issue here. Tried installing version 2.3.16 that was released today (5/25/15) but issue persists. Getting error on each page of front-end site when Redirection is activated stating the table wp_redirection_items doesn’t exist. WordPress and all other plugins up to date. This is a new Redirection install.
Additional error information:
WordPress database error: [Table ‘user_wp946.wp_redirection_items’ doesn’t exist]
SELECT wp_redirection_items.*,wp_redirection_groups.tracking,wp_redirection_groups.position AS group_pos,wp_redirection_modules.id AS module_id FROM wp_redirection_items INNER JOIN wp_redirection_groups ON wp_redirection_groups.id=wp_redirection_items.group_id AND wp_redirection_groups.status=’enabled’ INNER JOIN wp_redirection_modules ON wp_redirection_modules.id=wp_redirection_groups.module_id AND wp_redirection_modules.type=’wp’ WHERE( wp_redirection_items.regex=1 OR wp_redirection_items.url=’/’)
So i just noticed it’s not creating *any* of the tables with a new install.
So here is the temporary fix until a developer wants to chime in:
edit models\database.php
Line 44 is function plugin_activated()
add this just after the function declaration:
include dirname( REDIRECTION_FILE ).'/models/database.php';
$db = new RE_Database();
$db->install();
So you have, in full–
public static function plugin_activated() {
include dirname( REDIRECTION_FILE ).'/models/database.php';
$db = new RE_Database();
$db->install();
Red_Flusher::schedule();
}
Then deactivate and re-activate the plugin.
If you use git and github, you should make a pull request :
https://github.com/johngodley/redirection/
If you don’t, I can do it!
In my previous post I accidentally wrote that you edit line 44 of models\database.php. Meant redirection\redirection-admin.php.
Anyways, I created a pull request: https://github.com/johngodley/redirection/pull/60
I’m seeing this error as well
Same issue here, event after deleting the plugin… Any idea how to fix it ?! Thanks 🙂
