Support » Plugin: Redirection » Error After Database Upgrade – [Unknown column ‘match_url’ in ‘where clause’]

  • Hi,

    I’m having the same issue related to this old post:

    I’m using the latest version: 4.3.1, the logs file is filled with these kind of errors:

    [28-Jun-2019 22:40:02 UTC] WordPress database error Unknown column 'match_url' in 'where clause' for query SELECT * FROM wp_1045_redirection_items WHERE match_url='/sitemap_index.xml' OR match_url='regex' made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, WordPress_Module->init, Red_Item::get_for_url, Red_Item::get_for_matched_url

    I ran the DB upgrade via WP CLI on all of the installations I have, but now they all trigger this issue.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author John Godley


    Sorry I missed this. The best thing is to go to the support page, change the database version to 2.4, and follow the instructions.

    Thread Starter luigitec


    Thanks @johnny5 Yeah I did that, I believe I did it via WP-CLI, we have hundreds of blogs and it was kind of hard to do it manually.

    I hope this gets fixed soon for WP-CLI.


Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Error After Database Upgrade – [Unknown column ‘match_url’ in ‘where clause’]’ is closed to new replies.