database error

#229015
  • Resolved Excel WEB
    Rank Math free

    Hello. I have a database error due to rankmath plugin in my website. Can u please explain how to fix WordPress database error:

    [Can’t find file: ‘./reiki_bzl2021/wp_rank_math_404_logs.MYI’ (errno: 2 “No such file or directory”)]
    SELECT * FROM wp_rank_math_404_logs WHERE uri = ‘404’ LIMIT 0,

    thank u

Viewing 4 replies - 1 through 4 (of 4 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

    That should fix the issue. Looking forward to helping you.

    Hi. I did exactly this but the problem is back. very annoying. my homepage displays this even after recreating the tables:

    WordPress database error: [Can’t find file: ‘./reikiheals_bzl2021/wp_rank_math_404_logs.MYI’ (errno: 2 “No such file or directory”)]
    SELECT * FROM wp_rank_math_404_logs WHERE uri = ‘404’ LIMIT 0, 1

    WordPress database error: [Can’t find file: ‘./reikiheals_bzl2021/wp_rank_math_404_logs.MYI’ (errno: 2 “No such file or directory”)]
    SELECT COUNT(*) FROM wp_rank_math_404_logs LIMIT 0, 1

    please look into this asap

    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,

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

The ticket ‘database error’ is closed to new replies.