Hello,
We apologize for the inconvenience you are facing with the Rank Math Analytics. It seems that there are some MySQL connections from the Rank Math plugin that are causing your website to slow down.
To resolve this issue, we recommend checking with your web host to whitelist Rank Math’s data fetch processes. Some web hosting providers, like WP Engine, might kill long-running processes, which could be causing the issue.
If you have already disabled the analytics in the Rank Math plugin and are still experiencing these commands, reaching out to your web host to whitelist Rank Math’s data fetch processes should help resolve the issue.
If you continue to experience issues after following these steps, please feel free to contact our support team for further assistance.
We appreciate your understanding and patience as we work to resolve this issue for you.
Sources:
Resolving Rank Math Analytics Related Issues » Rank Math
What to Do When Rank Math Analytics Shows Zero Search Traffic » Rank Math
Fatal Error Happening on Some Installations After 1.0.49 Update » Rank Math
they did not block anything. so please review it once again and help me to resolve this problem
Hello,
Thank you for contacting us and sorry for any inconvenience that might have been caused due to that.
Can you please share the full SQL query so that we can check the issue further for you? You can use a tool like https://pastebin.com/ to share the query with us.
Looking forward to helping you.
Thank you.
Hello,
I have updated the sensitive data as requested. Can you please check further?
Thank you.
Hello,
The query is not related to the Analytics. We can see you have a large number of posts on your website. In this case, you can try increasing your PHP values and see if that helps. You can get in touch with your host and ask them to set the following values:
PHP Memory Limit: 1024M
Max input time: 600
PHP time limit: 240
PHP max input variables: 1000
Regarding the PHP warning, there might be a keyword you’ve added with the opening parenthesis that does not contain the closing parenthesis. For example, the keyword Demo(s is there instead of Demo(s).
In order to fix this issue, you’ll need to add the closing parenthesis there. You may update the keyword from the post/page if you can remember something similar to this one.
If you’re clueless about where the affected keyword can be, a quick way to spot them would be to access your database and make a query on your wp_postmeta table for the meta key rank_math_focus_keyword and in the values, you should filter the ones that include an opening parenthesis.
Let us know how it goes. Looking forward to helping you.
Thank you.
i contacted cloudways and they told me – “I can search for it using the DB manager, but the exact query would be something that the rank math team would share.”. So can you guys share what exactly i have to do. It helps me a lot. Thanks
Hello,
Thank you for your patience.
They can use the filter rows feature to search for the rank math keywords like this (using PHPMyAdmin)
But if they need a query in the database, they can use and customize this SQL code:
SELECT * FROM '_postmeta' WHERE 'meta_key' = 'rank_math_focus_keyword';
Please ensure that they update the _postmeta table to the correct table name of your database.
Hope that helps.
Can you guys check this error.
[proxy_fcgi:error [pid 49810:tid 140326505277184 [client 52.167.144.25:0 AH01071: Got error ‘PHP message: PHP Warning: preg_match_all(): Compilation failed: missing closing parenthesis at offset 37 in /home/1182115.cloudwaysapps.com/mfekwtzdrf/public_html/wp-content/plugins/seo-by-rank-math/includes/replace-variables/class-post-variables.php on line 545’
Hello,
Just as my colleagues have stated above the error message that you see is most likely caused by a mismatch in the parentheses of some of your focus keywords. Sometimes, you might use parentheses to group words together or to indicate a variation – however, if you forget to close a parenthesis, or if you have an extra one, this can cause the error message to appear.
To fix this problem, you need to check the focus keyword of each page or post where the error message is showing and make sure that every parenthesis is matched with a closing one.
In a situation where you have a large number of pages/posts and do not know the particular post this error is coming from you can resolve this issue from the wp_postmeta table for the meta key rank_math_focus_keyword in the database. In the values, you should filter the ones that include an opening parenthesis and edit, correct, and save when found.
Let us know how this goes. Please let us know if you have further questions or concerns.
Thank you.
Hello,
Since we did not hear back from you for 15 days, we are assuming that you found the solution. We are closing this support ticket.
If you still need assistance or any other help, please feel free to open a new support ticket, and we will be more than happy to assist.
Thank you.
