-
Hello,
I have 700,000 products and when i click on the index status in the analytics page i see only 7,000
and the SEO Analyzer is showing this warning “Could not check Focus Keywords in posts – the post meta table exceeds the size limit.” and i believe it’s because of the huge number of products.
Can this be resolved ?
Thanks
-
Hello,
Thank you for contacting us and sorry for any inconvenience that might have been caused due to that.
For the index status, please follow the steps below to see if that helps you to resolve the issue:
1. At first please head over to WordPress Dashboard > Rank Math > Status & Tools > Database Tools and click the
Rebuild Indexbutton.2. After that, Head over to WordPress Dashboard > Rank Math > General Settings > Analytics tab, click the
Delete Databutton, and then click theUpdate Data ManuallyIt will start the new data fetch from Google. You can reload the page to see the notice related to the import process. As you have a lot of products, it will take time to complete the whole process.
Regarding the focus keyword, please try to add the following filter on your site:
/** * Filter to change the Post Meta Table Limit */ add_filter('rank_math/seo_analysis/postmeta_table_limit', function ( $limit ) { return 5000000; } );Here’s how you can add filter/hook to your WordPress site: https://rankmath.com/kb/wordpress-hooks-actions-filters/
Once done, clear the SEO Analyzer cache from Rank Math > Status & Tools > Database Tools > Flush SEO Analysis cache and check again.
Let us know how it goes. Looking forward to helping you.
Thank you.
Thanks for the reply.
I’m waiting for the index issue.the focus keywords issue was not resolved by the filter provided
Regards
the analyzer is now giving the following error “An error has occured”
and the reindex needs 2 days 9 hours to finish 🙁Hello,
Depending on the amount of data, the fetching process could take between 45 minutes to a couple of hours.
Regarding the Analyzer tool, please check your site’s configuration if there are some PHP values that are too low and which you should increase. You can get in touch with your web host and ask them to set the following values (if not yet):
PHP Memory Limit: 512M Max input time: 150 PHP time limit: 120 PHP max input variables: 1000If the issue still 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.
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/
We really look forward to helping you.
Thank you.
PHP Version 8.1.17
PHP Memory Limit 4 GB
Max input time 600
PHP Time Limit 600
PHP Max Input Vars 10000i believe that rankmath can’t analyze 700k of products, it will simply timeout
Hello,
Since the PHP values on your site are already above the recommended configuration, head over to Rank Math > Status & Tools > Database Tools > and click the
Clear SEO AnalysisandRemove Transientsbuttons to flush the SEO Analysis cacheOnce done, clear your website and any server-level caching on your site before doing the Sitewide analysis again.
Let us know how this goes.
Thank you.
didn’t work
After doing the steps recommended by you, now i’m getting an error_log of 14GB
and then it will list all posts, pages and productsHello,
In this case, head over to Rank Math > Status & Tools > Database Tools and recreate the Rank Math tables by clicking this button:
https://rankmath.com/kb/rank-math-status-and-tools/#recreate-missing-database-toolsIf the issue still persists, then we may need to take a close look at your site to investigate the issue further. Please follow the steps above and add the logins in the sensitive data section.
Looking forward to helping you.
Thank you.
You must be logged in to reply to this ticket.