WordPress database error Table doesn't exist for query

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: https://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=’/’)

same here

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 ??