beamkiller

So,

I have checked the DB again.

There are no duplicate rows:

SELECT post_id, meta_key, COUNT() AS count FROM wp_postmeta WHERE meta_key IN ('rank_math_news_sitemap_robots', 'rank_math_robots') GROUP BY post_id, meta_key HAVING COUNT() > 1
ORDER BY count DESC
LIMIT 100;

This returned as empty.

Then I checked the lines again:

SELECT meta_key, COUNT(*) AS total_rows
FROM wp_postmeta
WHERE meta_key IN ('rank_math_news_sitemap_robots', 'rank_math_robots')
GROUP BY meta_key;

1,466,180 rows for rank_math_news_sitemap_robots

1,466,181 rows for rank_math_robots

Then I checked a query for the post types, and the attachments is huge.

SELECT p.post_type, pm.meta_key, COUNT(*) AS total_rows
FROM wp_postmeta pm
JOIN wp_posts p ON pm.post_id = p.ID
WHERE pm.meta_key IN ('rank_math_news_sitemap_robots', 'rank_math_robots')
GROUP BY p.post_type, pm.meta_key
ORDER BY total_rows DESC;

Which returned:

attachment rank_math_robots 1,330,038

attachment rank_math_news_sitemap_robots 1,330,038

product rank_math_robots 136,086

product rank_math_news_sitemap_robots 136,085

page rank_math_news_sitemap_robots 42

page rank_math_robots 42

blocks rank_math_robots 12

blocks rank_math_news_sitemap_robots 12

post rank_math_robots 3

post rank_math_news_sitemap_robots 3

We have many images for products, do we need those metas on the images too if everything can be indexed, no other behavior is needed.
We need to somehow optimise this.

And also we need to solve that the rank_math_news_sitemap_robots is not created when new image, etc is added when the feature is off.

Thanks.

• This reply was modified 3 months ago by beamkiller.

Thanks for the fast reply.

Waiting for the solution 🙂

2nd question:
If adding a Gemini API Key only these 2 models are shown.
Is this a limitation in your plugin or I need to enable something in the Google Cloud Console?

https://snipboard.io/2DnMT3.jpg

I have found the issue. I had an old code which override the billing fields and the return was null.

add_filter( ‘woocommerce_billing_fields’, ‘misha_remove_fields’ );

function misha_remove_fields( $fields ) {

    if (is_page(979)){

        unset( $fields[ ‘billing_tax_number’ ][‘required’] );

        return $fields;

    }

}

Hi,

The problem with this is that the Free version does not allow creating Presets.
So this is not a solution for the Free version.

So my question is that is there a way to enable LazyLoad optimized for the shortcode in the Free version other then Preset ID?

Hi,

Thanks for the suggestion.
I have added it via CSS so it is update-proof.

function add_custom_currency_css_to_admin() {
    ?>
    <style type="text/css">
      div[id*="woocs_tab_fixed_"]{
        display:block !important;
      }
    </style>
    <?php
  }
  add_action('admin_head', 'add_custom_currency_css_to_admin');

Thank you 🙂