Error After Database Upgrade – [Unknown column ‘match_url’ in ‘where clause’]

  • Resolved neilgee

    (@neilgee)


    5 years, 8 months ago

    I am getting this error on every page after the database upgrade on 4.1.1

    WordPress database error: [Unknown column 'match_url' in 'where clause']
SELECT * FROM wp_redirection_items WHERE match_url='/category/web-dev' OR match_url='regex'

    My plugin status says all good.

    Any steps to solve? , just deactivating it is the only way to resolve so far

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

    (@johnny5)

    There’s a handful of people with this problem, and I’m having trouble figuring out why. The issue seems to be that your plugin seems to be upgraded, but the database wasn’t actually changed. I’m not sure how this is possible, and reproducing it is key.

    If you have the time I’ve released a new beta version here which should help in tracking the problem down. The idea is that you run the upgrade again and send me the plugin’s state before and after.

    https://github.com/johngodley/redirection/releases/tag/4.2-beta-1

    If you could try these steps:

    – Install 4.2 beta as explained in the link
    – Export a JSON backup of your redirects and send it to me
    – If you have access to phpMyAdmin, export your wp_redirection_items table as a SQL file and send that to me
    – Go to the Support page in Redirection and set the database version to 2.4
    – Proceed through the upgrade again – this shouldn’t cause any negative effects for your existing data
    – If the upgrade works then great, problem solved. If you get the same error then can you export your wp_redirection_items table again and send that to me

    Contact details at https://redirection.me/contact/

    Thread Starter neilgee

    (@neilgee)

    That worked – error is gone!

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.