Database Table Error

#314107
  • Resolved Phillip Crum
    Rank Math free

    Apparently this issue has existed since at least v. 1.0.76, I just wasn’t aware. I’m getting a list of error codes at the top of the pages indicating some issue with a db table, like these…

    WordPress database error: [Table ‘db4673940768.wp_rank_math_redirections_cache’ doesn’t exist]
    SELECT * FROM wp_rank_math_redirections_cache WHERE object_id = 23937 AND object_type = ‘post’ LIMIT 0, 1

    WordPress database error: [Table ‘db4673940768.wp_rank_math_redirections_cache’ doesn’t exist]
    SELECT * FROM wp_rank_math_redirections_cache WHERE BINARY from_url = ‘course/bhecs-darrel-spinks-on-practicing-across-state-lines’ LIMIT 0, 1

    WordPress database error: [Table ‘db4673940768.wp_rank_math_redirections’ doesn’t exist]
    SELECT * FROM wp_rank_math_redirections WHERE status = ‘active’ AND ( sources like ‘%a:2:{s:7:”pattern”;s:59:”course/bhecs-darrel-spinks-on-practicing-across-state-lines”;s:10:”comparison”;s:5:”exact”;}%’ or sources like ‘%course%’ or sources like ‘%bhecs%’ or sources like ‘%darrel%’ or sources like ‘%spinks%’ or sources like ‘%on%’ or sources like ‘%practicing%’ or sources like ‘%across%’ or sources like ‘%state%’ or sources like ‘%lines%’ ) ORDER BY updated DESC

    WordPress database error: [Table ‘db4673940768.wp_rank_math_redirections’ doesn’t exist]
    SELECT * FROM wp_rank_math_redirections WHERE status = ‘active’ ORDER BY updated DESC

    I have rolled back to every version available and the problem persists. Yes, I cleared my cache.

    Note this only occurs on my “Courses” pages which are produced by another plugin called WP Courseware by Fly Plugins. Before you default to telling me that this is a problem in their plugin, please take a very good look at this issue. Your plugin’s name is in the error codes!

    I need to get this cleared up, ASAP!

Viewing 2 replies - 16 through 17 (of 17 total)
  • Related to my two unanswered questions above, here’s what the WP Courseware guys had to say:

    “It looks that WordPress cannot find some tables in the database. WP Courseware doesn’t use wp_rank_math_redirections and wp_rank_math_redirections_cache tables, so I would recommend asking RankMath plugin support for troubleshooting this. Sorry I can’t be more helpful here.”

    Hello,

    1. When you activate the Redirections module the plugin tries to create the tables automatically however in some edge cases that is not possible and those need to be created either manually or with the help of our Database Tools.

    Also, for the Database Tools to properly create the tables the WP-Cron needs to be enabled and functioning as normal.

    2. That might be because those CPTs were the only ones with redirections trying to be loaded to check if any existed on the website.

    Don’t hesitate to get in touch if you have any other questions.

    Hello,

    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 2 replies - 16 through 17 (of 17 total)

The ticket ‘Database Table Error’ is closed to new replies.