• Resolved bibberle

    (@bibberle)


    Hi,

    I have a custom post type “job_listing” with 50k posts. I have set the rankamth options for this custom post type to “noindex” and “no follow”. However, looking at the wp_postmeta table in phpmyadmin there are about 50-60 rankmath meta fields for each of these 50k posts. How Can I deactivate / remove these meta fields for this post type entirely?

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Support Rank Math Support

    (@rankmathsupport)

    Hello @bibberle,

    Thank you for contacting Rank Math support.

    Please share the meta keys so we can confirm if they are needed and share the steps to remove them. You can also share some screenshots using a tool like https://imgur.com/

    Looking forward to helping you.

    Thread Starter bibberle

    (@bibberle)

    Hi,

    thanks for your answer. Here is the screenshot: https://imgur.com/faaqxN8
    I’m afraid this massive amount of meta fields (which I actually don’t need for this post type) unnecessarily bloats up my database…. looking forward for instructions how to avoid / remove these fields for my post type “job_listing”

    Plugin Support Rank Math Support

    (@rankmathsupport)

    Hello @bibberle,

    The rank_math_snippet_ meta keys belong to the older Schema implementation. Please navigate to WP Dashboard > Rank Math SEO > Status & Tools > Database Tools and use the Delete Old Schema Data tool to remove them from the database.

    The other set of keys you can remove is rank_math_primary_. But you will have to run a SQL query to remove them, as there is no option in our plugin. Those keys must have been migrated from the previous SEO plugin you were using. The rest of the keys are required to add the metadata to the posts.

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

    Thread Starter bibberle

    (@bibberle)

    U mean something like DELETE FROM wp_postmeta WHERE meta_key LIKE 'rank_math_primary_%';?

    Unfortunally, I cannot find the tool you mentioned. That’s how my rankmath menu looks like: https://imgur.com/RkLIVYN

    • This reply was modified 2 weeks, 2 days ago by bibberle.
    Plugin Support Rank Math Support

    (@rankmathsupport)

    Hello @bibberle,

    If the tool doesn’t exist then you must use the SQL query to remove all unwanted meta keys like the one you mentioned. Please make sure to backup your database before doing that. You can also ask your host to help you if you’re not sure.

    Please do not hesitate to let us know if you need our assistance with anything else.

    Thread Starter bibberle

    (@bibberle)

    Can you please double check the 2 queries I am gonna execute:

    DELETE FROM wp_postmeta WHERE meta_key LIKE ‘rank_math_primary_%’;
    DELETE FROM wp_postmeta WHERE meta_key LIKE ‘rank_math_snippet_%’;

    Plugin Support Rank Math Support

    (@rankmathsupport)

    Hello @bibberle,

    The queries are correct. Please note that the first query will also remove the primary category you have set for the posts(if you’re using the Primary Taxonomy feature of our plugin). You must add them again after running the query. Also, make sure to take a complete database backup before running the queries to be safe in case something goes wrong.

    Please do not hesitate to let us know if you need our assistance with anything else.

    Thread Starter bibberle

    (@bibberle)

    Thank you so much

    Plugin Support Rank Math Support

    (@rankmathsupport)

    Hello @bibberle,

    We are super happy that this resolved your issue.

    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 9 replies - 1 through 9 (of 9 total)
  • You must be logged in to reply to this topic.