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 15 replies - 1 through 15 (of 17 total)
  • Anas
    Rank Math business

    Hello,

    Thank you for contacting Rank Math, and sorry for any inconvenience caused.

    Please follow these steps:

    1. Update to the latest version of Rank Math

    2. Ensure that the Advanced Mode is selected:
    advanced mode

    3. Re-create tables by clicking WP Dashboard > Rank Math > Status & Tools > Database Tools and click the Re-create database Table button.
    re-create analytics tables

    I hope this helps.

    Looking forward to helping you.

    UPDATE: And I’ve already tried to re-build databases using the tool in the plugin. Didn’t help.

    Anas
    Rank Math business

    Hello,

    We might need to take a closer look at the settings. Please edit the first post on this ticket and include your WordPress & FTP logins in the designated Sensitive Data section.

    Please do take a complete backup of your website before sharing the information with us.
    Sensitive Data Section

    It is completely secure and only our support staff has access to that section. If you want, you can use the below plugin to generate a temporary login URL to your website and share that with us instead:

    https://wordpress.org/plugins/temporary-login-without-password/

    You can use the above plugin in conjunction with the WP Security Audit Log to monitor what changes our staff might make on your website (if any):

    https://wordpress.org/plugins/wp-security-audit-log/

    We really look forward to helping you.

    Hello,

    I have updated the sensitive data as requested. Can you please check further?

    Thank you.

    FYI….I was wondering if the redirections table ONLY creates itself once the first-ever redirect is set up. I have NO redirects set up. So, I tried to create a re-direct but they won’t “stick” when I click submit. Everything disappears.

    Anas
    Rank Math business

    Hello,

    I tried to access the database to create the tables manually using the WP PHPMyadmin plugin but it’s not working on your website.

    In order for us to fix this could you please provide us with cPanel/phpMyAdmin access?

    Looking forward to helping you.

    FYI: I can’t even get a re-direct to create in a staging site with all other plugins turned OFF. (Been this way for over a year now, I just thought it was a bug in the plugin that you guys would eventually figure out.)

    I need an email address for YOU in order to set you up and give you access. Please.

    As soon as I get an email for you I will set you up as a Collaborator in my Flywheel hosting acct so you can log in there. Not sure which page will show up first when you log in but you’re going to either see a list of 9 websites or you’ll have to click a link that says “9 Sites”. From there….

    1. Select the PracticeMentors.us website.
    2. Go to the “Advanced” tab.
    3. DB access link will be bottom-right of the page.

    I need an email address for YOU in order to set you up and give you access.

    Hello,

    You can make use of our support email address to create temporary access: s******@r***********.

    Looking forward to helping you with this one.

    You should be receiving an email from Flywheel pdq.

    Hello,

    We have created the missing tables manually on your website and you should no longer see this error appearing from this point on.

    Also, you are now able to add redirections in our Redirections module.

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

    Questions
    1. Is this a “me-only” event or is the redirection table not creating itself for others as well?

    2. Why are/were the error messages only showing up on my Courses custom posts and nothing else?

    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 15 replies - 1 through 15 (of 17 total)

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