-
I’m having issues on a site due to rankmath. I receive the following error when taking a db backup:
mysqldump: Got error: 1146: Table ‘avsawbzwcd.wp_rank_math_404_logs’ doesn’t exist when using LOCK TABLES
-
Hello,
Could you please recreate the missing table by following these steps:
1. Update to the latest version of Rank Math Free & PRO2. Ensure that the Advanced Mode is selected:
3. Re-create tables by clicking WP Dashboard > Rank Math > Status & Tools > Database Tools and click the
Re-create database Tablebutton.
If the issue persists, 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.
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,
Thanks for getting back to us.
It seems that the 404 table is present on your installation but might be corrupt or be created incorrectly.
Could you please verify that the structure of that table matches the following?
If you need to re-create the table manually you can do so with the following SQL code: https://pastebin.com/AMA7QHuW
Please note that this SQL code might need to be adjusted to your database requirements for things such as the collation and the engine.
Hope this helps solve your issue.
Don’t hesitate to get in touch if you require any further assistance.
The ticket ‘db issues due to rankmath’ is closed to new replies.