WordPress database error Table - Support

Resolved Irene RF
3 years, 8 months ago

Rank Math free

Hi,
2 questions about example.com/ba
I have 4 subsites in multisite:
example.com/es and example.com/en are alive
example.com/ba and example.com/ar are in development

1) I see the following in my error log: What’s wrong?

This table xxxxx.xx3_11_rank_math_analytics_gsc is from example.com/ba

[Sat May 22 17:44:14.162604 2021] [proxy_fcgi:error] [pid 23042:tid 140535725307648] [client 3.233.219.0:21004] AH01071: Got error 'PHP message: WordPress database error Table 'mhydpxbvzu.ar3_11_rank_math_analytics_gsc' doesn't exist for query SELECT..............e_WpdbNew->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_WpdbNew->default_query', referer: https://example.com/wp-admin/network/

[Wed May 19 00:16:48.148748 2021] [proxy_fcgi:error] [pid 28953:tid 140091750045440] [client 34.235.161.190:46536] AH01071: Got error 'PHP message: WordPress database error Table 'xxxxx.xx3_11_rank_math_analytics_gsc' doesn't exist for query SELECT COUNT(DISTINCT(created)) AS days FROM xx3_11_rank_math_analytics_gsc LIMIT 0, 1 made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, CMB2_Bootstrap_290->include_cmb, cmb2_bootstrap, do_action('cmb2_admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Admin\Options->register_option_page, include('/plugins/seo-by-rank-math/includes/modules/analytics/views/options.php'), RankMath\Analytics\DB::info, MyThemeShop\Database\Query_Builder->getVar, MyThemeShop\Database\Query_Builder->one, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_WpdbNew->default_queryPHP message: WordPress database error Table 'mhydpxbvzu.ar3_11_rank_math_analytics_gsc' doesn't exist for query SELECT COUNT(id) FROM ar3_11_rank_math_analytics_gsc LIMIT 0, 1 made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, CMB2_Bootstrap_290->include_cmb, cmb2_bootstrap, do_action('cmb2_admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Admin\Options->register_option_page, include('/plugins/seo-by-rank-math/includes/modules/analytics/views/options.php'), RankMath\Analytics\DB::info, MyThemeShop\Database\Query_Builder->getVar, MyThemeShop\Database\Query_Builder->one, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_WpdbNew->default_query', referer: https://example.com/ba/wp-admin/post.php?post=615&action=edit

2) I am developing a new subsite in example.com/ba which is noindex in wp and in Rankmath until it get live.

I connected Rankmath in example.com/ba with GSC and I fill that this was a mistake.
I heard from John Mueller “that switching the noindex to index could slow the indexing down”
https://www.searchenginejournal.com/googles-mueller-offers-two-tips-for-getting-indexed/407995/

I think that the inclusion of surdelsur.com/ba in GSC cannot be undone.
How can I fix this?

Viewing 7 replies - 1 through 7 (of 7 total)

Brian
3 years, 8 months ago

Rank Math free

Hello,

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

Please ensure that you have created the required properties for these subsites in your Google Account.

You need to follow this guide on how to create properties and how they are tracked: https://support.google.com/webmasters/answer/34592?hl=en#zippy=%2Curl-prefix-property

Once done head over to WordPress Dashboard > Rank Math > General Settings > Analytics and make sure that all the appropriate options are selected.

After saving those properties if the error persists, then head over to WordPress Dashboard > Rank Math > Status & Tools > Database Tools and click the button “Re-create Tables”.

On the noindex issue it is always recommended that if your site is in the development stage you should have it on noindex.

Since this is a new site it is not yet available to the public. Once you have finished the development mode you can just turn it to index and this will not have any effect.

As for the user being advised here on this page, his site was already existing which is contrary to your case here.

Hope this helps solve your issue.

Don’t hesitate to get in touch if you require any further assistance.
Irene RF
3 years, 8 months ago

Rank Math free
Thanks for your answer.
It seems that this fix worked
“Dashboard > Rank Math > Status & Tools > Database Tools and click the button “Re-create Tables”.

I have another question:
I see a lot of requests in my access log from wp-cron.

I had checked with wp-control plugin
and I see the following in the cron schedules:
```
every_minute
This schedule is added by another plugin and cannot be deleted
60 (1 minute)	Every minute
wp_convert_yoast_blocks_cron_interval
This schedule is added by another plugin and cannot be deleted
300 (5 minutes)	Every 5 Minutes
wp_convert_schema_posts_cron_interval
This schedule is added by another plugin and cannot be deleted
300 (5 minutes)	Every 5 Minutes
```
Is this from rank-math? How can I stop it?

However in cron events I see the following:
```
rank_math/redirection/clean_trashed
None	2021-05-29 21:00:00
8 hours 9 minutes	RankMath\Redirections\DB::periodic_clean_trash()	Once Daily

rank_math/links/internal_links
None	2021-05-29 21:00:00
8 hours 9 minutes	RankMath\Links\Links->cron_job()	Once Daily
```
Irene RF
3 years, 8 months ago

Rank Math free

It seems that the problem is
action_scheduler_run_queue

I find this but I want to know if this is an updated solution
https://rankmath.com/kb/fatal-error-after-1-0-49-update/

I use the Code Snippet plugin for other matters and is activated in each subsite because I have a multisite. Should I use the Code Snippets method, and repeat in each site?

Ankit
3 years, 8 months ago

Rank Math business

Hello,

Thank you for your reply.

If you have error logs related to actionscheduler_actions you can use the method, Since you have a multisite setup. Make sure you install the multisite version of the snippet. https://github.com/rankmath/_repair-action-scheduler-multisite

I recommend you perform a backup before touching the database. Also, do let us know how that goes, so we can assist you further if needed.

Irene RF
3 years, 8 months ago

Rank Math free

1) I have to disable rank math plugin before running this plugin https://github.com/rankmath/_repair-action-scheduler-multisite ?
2) I have to delete the _repair-action-scheduler-multisite plugin after or keep it

Info is contradictory

Irene RF
3 years, 8 months ago

Rank Math free

Another question:
I already changed on wp-crontrol the frequency of the action_scheduler_run_queue cron event to once a day.
This is fixing what is wrong? or I still need the _repair-action-scheduler-multisite plugin for updating the database?

Anas
3 years, 8 months ago

Rank Math business

Hello,

The multisite version of the Repair Action Scheduler plugin needs to stay activated as it’s shown in the plugin information:

I hope this helps.

Don’t hesitate to get in touch if you require any further assistance.

RankBot
3 years, 7 months ago

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.

Viewing 7 replies - 1 through 7 (of 7 total)

The ticket ‘WordPress database error Table’ is closed to new replies.