database not index value

#371415
  • Resolved Naberd Zendi
    Rank Math free

    We are migrating our scripts from Yoast to rankmath.
    in Yoast we have table yoast_indexable with is_robots_noindex value.

    what we want to achieve is to get all posts of certain post type filtered by language and where robots are allowed to index post

    which table(s) and values should we use to achieve the same with rankmath ?

    unfortunately i can’t post code due SQL line (it’s being blocked )

    This website is using a security service to protect itself from online attacks. The action you just performed triggered the security solution. There are several actions that could trigger this block including submitting a certain word or phrase, a SQL command or malformed data.

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

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

    You don’t need to migrate the data manually from Yoast to our plugin. We already have an importer that will import all the data from Yoast. You can follow this guide to import the data: https://rankmath.com/kb/yoast-seo-migration/

    Hope this helps. Let us know if you need any other assistance.

    David
    Rank Math free

    Hallo Jaideep,

    we have custom script for sitemaps. which is used to meet our client requirements that was using Yoast plugin.

    like i said we need to select post of certain type where language is X and no index is null.

    we can’t use standard sitemap feature since it’s multilanguage site and all pages will be shown under one sitemap and that is unwanted result. we have a script that will show sitemap based on language / post type. so url is something like that: domain.com/de/sitemap_page.xml so it will show only pages which are available in German language and are indexed.

    any other SEO plugin that has sitemaps will show all posts (translated or not ) under one sitemap based on post type.

    Yoast has database table where we could see based on post id if this post was indexed or not.

    like i said we have query with multiple joins for those sitemaps. we need similar result with Rankmath plugin

    David
    Rank Math free

    So if we write in url domain.com/de/sitemap_page.xml we will only see pages in DE language and not getting all pages or 404.

    Hello,

    Can you please confirm which translation plugin, you are using on your site? If it is TranslatePress then we don’t add the translated URLs in the sitemap unless you have enabled the functionality with the SEO Pack add-on. And if you are using WPML and have the directory enabled for all your languages including the default one then our sitemap works the same way you want it to.

    If you are using any other plugin for the translations then you can use the following filter to remove the URLs from the sitemap: https://rankmath.com/kb/filters-hooks-api-developer/#filter-sitemap-item

    Hope this helps. Let us know if you need any other assistance.

    Thanks.

    Hallo Jaideep,

    we use WPML Different languages in directories ( (https://www.slimstock.com/ – English, https://www.slimstock.com/au/ – Australia) ) setting

    page https://www.slimstock.com/de/sitemap_index.xml results in 404
    https://www.slimstock.com/post-sitemap1.xml shows all languages

    and like we said this is absolutely not a wanted result.

    we need to modify following query so we could use rankmath for that:
    https://pastebin.com/i1ceCkvQ

    In KB article there are filters for current sitemaps generated by rankmath which will be almost impossible to use for us since at any given moment we have only one language ( default )

    Hello,

    The data for the robots meta tags from our plugin is saved in the postmeta table under the meta key rank_math_robots in a serialized JSON format.

    You can get the data from those entries for each post with something similar to this:

    
    get_post_meta('post_id_here', 'rank_math_robots', true);
    

    This would output the serialized JSON that can be parsed and detect the presence of the index or noindex values.

    Hope this helps clarify your doubts.

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

    Hallo Miguel,

    thank you for pointing out that it’s in meta.

    Have modified my script and everything works just fine.

    Hello,

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

You must be logged in to reply to this ticket.