Table ‘mywordpress.wp_rank_math_404_logs’ doesn’t exist in engine

#486399
  • Resolved Manuel Gioffredy
    Rank Math free

    Hello,
    I have an issue naturally created on Rank Math :
    [Table ‘cover.wp_rank_math_404_logs’ doesn’t exist]
    SELECT COUNT(*) AS total, SUM(times_accessed) AS hits FROM wp_rank_math_404_logs LIMIT 0, 1

    I tried the solution on ticket 333844 but nothing happened. When I click on “Re-create Missing Database Tables”. I have this message : “Parserror” and nothing happened.

    Thank’s in advance for your help !

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

    Thanks for contacting us, and sorry for any inconvenience that might have been caused due to that.

    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/

    Looking forward to helping you.

    Thank you.

    Hello,

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

    Thank you.

    Hello,

    I’ve tried installing WP phpMyAdmin plugin on your site to create the missing table manually. But it seems to be not installing on your site.

    In this case, we would need cPanel/phpMyAdmin access to handle the situation.

    Can you please share the credentials in the sensitive data section as well, so that we can move further on this issue?

    Looking forward to helping you.

    Thank you.

    Hello,

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

    Thank you.

    Hello,

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

    Thank you.

    Hello,

    I’ve tried to login into the site using your FTP as well, but it seems like the credentials are incorrect. Can you please check and update them?

    However, I’ve installed the WP File Manager plugin to access the files and while looking into the wp-config.php file, I found you had WP_DEBUG enabled on your site, which is why the errors were appearing on front-end and also you were getting parsing error while trying to Re-create Missing Database Tables. I’ve turned off debugging for now and the errors ain’t appearing anymore. But the issue of the missing table is still there.

    To create the table manually, I’ve accessed the database that you’ve shared but it seems that this isn’t the one that is connected to your website. Can you please check and update the credentials of the connected one?

    Looking forward to helping you.

    Thank you.

    Hello,

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

    Thank you.

    All good for me is just a SFTP and not a FTP.

    Thank you

    Hello,

    I apologize for the misunderstanding. But the good news is that the issue have been fixed.

    The table wp_rank_math_404_logs was corrupted in your database. So, I’ve created the table manually for you. Even after that, the logs were not being stored, as it seems that you’re using a template to show the 404 on your site.

    To fix this, I’ve updated the Rank Math file – /plugins/seo-by-rank-math/includes/modules/404-monitor/class-monitor.php in line 46,

    From this:
    $this->action( $this->get_hook(), 'capture_404' );
    
    To this one:
    $this->action('template_redirect', 'capture_404' );

    Please be advised that, the solution will be overwritten, when you’ll update Rank Math in your site next time. Once you update Rank Math, you’ll need to edit the file and replace the line just as mentioned above. However, till the next update, this should work without any issue.

    Hope that helps, and please do not hesitate to let us know if you need our assistance with anything else.

    Thank you.

    Thank’s a lot for your reactivity and your help !!!

    Hello,

    You’re most welcome!

    We are super happy that this resolved your issue. If you have any other questions in the future, know that we are here to help you.

    If you don’t mind me asking, could you please leave us a review (if you haven’t already) on https://wordpress.org/support/plugin/seo-by-rank-math/reviews/#new-post about your overall experience with Rank Math? We appreciate your time and patience.

    If you do have another question in the future, please feel free to create a new forum topic, and it will be our pleasure to assist you again.

    Thank you.

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

You must be logged in to reply to this ticket.