Auto Post Redirect – Error

  • Hey,
    I enabled the ‘Auto Posts Redirect’, in hope that all posts/pages/category will be added automatically. The redirects doesn’t appear automatically in the redirections list, and I can see from my log:

    `Column ‘redirection_id’ cannot be null for query INSERT INTO ‘wp_rank_math_redirections_cache’

    I have multiple sites having this issue and it’s all on version 5.5, I havn’t tested in older versions.

    / hope anyone can assist, thanks

Viewing 3 replies - 1 through 3 (of 3 total)
  • Hello,

    Thank you for contacting the support and sorry for any inconvenience that might have been caused due to that.

    I couldn’t reproduce the issue you mentioned on my setup. Here is a screencast:

    Assuming you are using the latest version of all the plugins and the themes (please update if not yet), it would seem like a conflict with one of the plugins or the theme you are using.

    To determine that, please follow this troubleshooting guide:

    Please let us know if you find the culprit.

    Only the site admin would know and your users won’t be affected by this troubleshooting.

    Looking forward to helping you.

    Hey, thanks for the reply 🙂

    I still have the same error when i check my logs..
    I have disabled all plugins and updated RankMath to newest version and changed to the default TwentyTwenty theme..

    Also I cannot remove the sticky message banner, keep showing up, might be related to?

    Can It be related to the database or table setup ?

    [04-Sep-2020 12:47:53 UTC] WordPress database error Column ‘redirection_id’ cannot be null for query INSERT INTO wp_rank_math_redirections_cache (from_url, redirection_id, object_id, object_type, is_redirected) VALUES (‘/uncategorized/new-post-test-2/’, NULL, 281, ‘post’, 1) made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Posts_Controller->update_item, wp_update_post, wp_insert_post, do_action(‘post_updated’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Redirections\Watcher->handle_post_update, RankMath\Redirections\Watcher->create_redirection, RankMath\Redirections\Cache::add, MyThemeShop\Database\Query_Builder->insert
    [04-Sep-2020 12:47:53 UTC] PHP Notice: Undefined property: RankMath\Redirections\Redirection::$id in /Applications/MAMP/htdocs/nordea/wp-content/plugins/seo-by-rank-math/includes/modules/redirections/class-redirection.php on line 139

    • This reply was modified 4 months, 1 week ago by Emj_frankly.


    By the error details you provided, it looks like the plugin didn’t install properly on your site. Please try adding a Redirection rule and see if it works. If that is also not working then probably something is wrong with the table. In that case, please take a backup of your site and delete the rank_math_redirection & rank_math_redirection_cache tables. After deleting the tables, deactivate the Rank Math plugin and activate it again. That should fix the issue.

    If this doesn’t help, then please add your site’s admin & cPanel access details in the Sensitive Data Section.

    I hope that helps.


    Since we did not hear back from you for 15 days, we are assuming that you found the solution. We are closing this support ticket.

    If you still need assistance or any other help, please feel free to open a new support ticket, and we will be more than happy to assist.

    Thank you.

Viewing 3 replies - 1 through 3 (of 3 total)

The ticket ‘Auto Post Redirect – Error’ is closed to new replies.