-
no such file or db is exit. i checked wp rank math 404 log db table is uncorrupted. https://support.rankmath.com/ticket/table-mywordpress-wp_rank_math_404_logs-doesnt-exist-in-engine/ i check this blog but did not successful
How can i create manually table in DB, we are using custom 404 page and update the rank math plugin then i am facing this error
-
Hello,
Thank you for contacting the support and sorry for any inconvenience that might have been caused due to that.
You can create the missing table by navigating to Rank Math > Status & Tools > Database Tools – Re-create Missing Database Tables.
About 404 issue: Did you happen to change the core files of Rank Math earlier to match the custom 404 page? If not, would you please share your website URL so that we can look into it.
Looking forward to helping you.
Rank Math > Status & Tools > Database Tools – Re-create Missing Database Tables. I just followed this method and wp rank math table didn’t generate 404 log. This indicates that your WP table already exists. So I drop the table using this drop table table name. When the table is removed from the database I click recreate, the table in the database is missing. This is how I created a working table in the database site.
I checked in elementor template, there is not any custom 404 page
I think No we are not using 404 custom page.
this issues happened when i update the plugin 4 days agoI want to create a table of wp rank math 404 logs manually? If recreating the missing database tables will not work.
In my case I check everything before deleting in live site staging server.
then I drop the corrupted table using this query drop table tablename;
then re-create missing tableMd. Sakib Khandaker https://support.rankmath.com/ticket/table-mywordpress-wp_rank_math_404_logs-doesnt-exist-in-engine/ He explained it well. It mentioned there that I created the db table manually. I am asking for these sites if they do not allow creating missing tables using scripts.
But I am looking to manually create a db table in the database using RankMath. If a table is missing or corrupt, then how can we create the table using which query, attributes etc?
just like create table abc
id
name etcHello,
To create a
wp_rank_math_404_logs
database table manually, you may run the following query on your database:
https://pastebin.com/p7489u4tPlease make sure to edit the query and replace
wp_
prefix with the table prefix of your database. For example, replacewp_rank_math_404_logs
with{Your_table_prefix}_rank_math_404_logs
.Note:
Take a complete backup before working with your database.If the issue persists, or you don’t feel confident doing that, then we can do that for you too.
Please edit the first post on this ticket and include your WordPress & FTP logins in the designated Sensitive Data section, so that we can check.
Please do take a complete backup of your website before sharing the information with us.
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.
thanks for quick response. I’m doing these steps on staging server to check everything is fine or not.
i will come back to you with good news.
cheers
Hello,
We’ll be looking forward to hear the good news.
In the meantime, please do not hesitate to let us know if you need our assistance with anything else.
Thank you
Hi! The good news is that it’s worked on my staging server. should I share this query on public chat with other users or not?
seconds where can I submit the website link which is not available publicly?
can we create a sitemap for herbal products to submit GA for indexing using rank math?
https://rankmath.com/kb/how-to-setup/
https://rankmath.com/kb/configure-sitemaps/
currently I’m reading this article.even if we use abc.com/sitme-idex.xml or abc.com/abcsitemap then its acceptable or not in google crawling, i meant if we use XML submit into google search console and this URL access by bc.com/sitme-idex.xml but if we add custom HTML sitemap on site abc.com/sitemap on footer section for visitor to look HTML sitemap not XML format then google accept this think when he start crawling or should we need to create just one sitmep either xml/htmlsitemap.
can i share with you site link in sensitive data mode?
Hello,
should I share this query on public chat with other users or not?
We don’t recommend sharing though, since it can have consequences if someone with poor knowledge of SQL queries tries to implement it on their site.
seconds where can I submit the website link which is not available publicly?
As mentioned above, you can add anything in the sensitive data section which you wouldn’t like to share publicly. It is completely secure and only our support staff has access to that section.
can we create a sitemap for herbal products to submit GA for indexing using rank math?
Assuming you’re thinking about submitting on GSC, yes, surely you can. If the herbal products belong to a different post type, a sitemap should be created automatically.
Otherwise, you can create and configure a custom sitemap and add it to Rank Math sitemap following the guide below:
https://rankmath.com/kb/custom-sitemaps/even if we use abc.com/sitme-idex.xml or abc.com/abcsitemap then its acceptable or not in google crawling, i meant if we use XML submit into google search console and this URL access by bc.com/sitme-idex.xml but if we add custom HTML sitemap on site abc.com/sitemap on footer section for visitor to look HTML sitemap not XML format then google accept this think when he start crawling or should we need to create just one sitmep either xml/htmlsitemap.
You can have both XML and HTML sitemaps for your site since both have different purposes.
XML sitemap is basically for bots or search engine bots to crawl and index them. Not for human-readable purposes.
An HTML sitemap can provide links to all of the important pages on your website, which can help the users to find the URLs of your site and also to increase your site’s overall link popularity.
In short, The HTML sitemap is the primary blueprint of your entire website. And we recommend keeping both XML and HTML sitemaps for your site.
Here you can try reading more on HTML sitemap by Rank Math:
https://rankmath.com/kb/html-sitemap/Note:
You should only submit the XML sitemap to GSC, not the HTML sitemap. An HTML sitemap can be added to your footer or on any page of your site.can i share with you site link in sensitive data mode?
As mentioned earlier, yes, you can.
Please do not hesitate to let us know if you need our assistance with anything else.
Thank you.
Hello,
I have updated the sensitive data as requested. Can you please check further?
Thank you.
Thanks for your valuable support MD sakbir, I’m not going to share code on publicly here, completely understand with you. first time I’m using rank math and I’m happy your wonderful support.
Hello,
Thank you for providing additional information.
I tested the website and robots.txt is fine. Regarding sitemap, I see some links which shouldn’t be in the sitemap. Please refer to the sensitive data section for the screenshot. You can remove those links by navigating to Rank Math > Sitemap Settings and toggle OFF include in sitemap.
As you’ve just moved from Yoast SEO to Rank Math, I would recommend deleting the earlier sitemap and adding the new one in Google search console.
As far as unwanted URLs are concerned, you can request removal from these URLs from the Google search console. Here’s an article which gives detailed outline about how to do it: https://www.contentkingapp.com/academy/google-remove-urls/
Hope that helps and please do not hesitate to let us know if you need our assistance with anything else.
Thank you
yesterday I created HTML Sitemap using support suggestion and add sitemap on footer, add urls which i want to show in custom sitemap. everything is fine. but when i see today google search console and it’s showing me error \Sitemap is HTML
(
Your Sitemap appears to be an HTML page. Please use a supported sitemap format instead.
Examples
Line 2
Tag:
html)kindly tell me what should i do. xml sitemap working fine but html sitemap giving me error i attached screenshot which will remove later after taking solution from your side. website url is already attached in sensitive data and html sitemap i mentioned in footer area
thank you so much for your valuable suggestion. which toggle should I removed from sitemap? I attached a Screenshot for your reference. I mentioned some pointed maybe they will remove from sitemap, kindly check
{Please refer to the sensitive data section for the screenshot. You can remove those links by navigating to Rank Math > Sitemap Settings and toggle OFF include in sitemap.}
this is robots.txt code which we used on others site using yoast, kindly check let me know can we use this using rank math robotos.tx
User Agent:*
Allow: /wp-content/uploads/
Allow: /wp-admin/admin-ajax.php
Disallow: /wp-content/plugins/
Disallow: /wp-admin/
Disallow: /wp-includes/
disallow:/readme.html
Disallow: /refer/
Disallow: /*.pdf$
Crawl-delay: 15 ( delay robots if they move one page to another page, helps to increase website speed )
then sitemap: https://\abc.com/sitemap_index.xmlHello,
I have removed the screenshots you shared as requested.
For the robots.txt code, yes, you can use that in Rank Math as well. You can check this guide on how to edit your robots.txt using Rank Math:
https://rankmath.com/kb/how-to-edit-robots-txt-with-rank-math/Regarding your sitemaps, the header and footer links are already removed from your sitemap index. Normally, you won’t need to include them if they don’t provide quality content on your site. Your sitemap index links now should be fine.
Also, you need to submit your /sitemap_index.xml in your Google Search Console. The HTML sitemap link is for your visitors so they can easily navigate your site.
Here’s a link you can follow for submitting your sitemap:
https://rankmath.com/kb/submit-sitemap-to-google/Hope that helps.
Thank you.
Hello,
I have updated the sensitive data as requested. Can you please check further? and marked solved if the code is fine.
we want to disallow pagename on google to stop indexing. will
disallow: /pagename/
this line of code is finei updated the txt file code on sensitive data
Thank you.
Hello,
Yes, your robots.txt file seems fine.
Please feel free to get in touch in case you need our assistance with anything else.
Thank you.
The ticket ‘mywordpress.wp_rank_math_404_logs’ doesn’t exist in engine’ is closed to new replies.