DB error

#142694
  • Resolved Alex C.

    3 years, 3 months ago

    Rank Math free

    Hello, this is about the free Rank Math SEO WP plugin. I’m getting a now recurring entry in debug.log:

    WordPress database error Table 'www-mywebsite-wp-Tm6qKxT9.wp_eb51a9edfd_rank_math_analytics_ga' doesn't exist for query SELECT COUNT(id) FROM wp_eb51a9edfd_rank_math_analytics_ga LIMIT 0, 1 made by 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_270->include_cmb, cmb2_bootstrap, do_action('cmb2_admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, RankMathAdminOptions->register_option_page, include('/plugins/seo-by-rank-math/includes/modules/analytics/views/options.php'), RankMathAnalyticsDB::info, RankMathAnalyticsDB::get_total_rows, MyThemeShopDatabaseQuery_Builder->getVar, MyThemeShopDatabaseQuery_Builder->one

    The environment is Linux/digitalocean. Not sure why it happened, but please advise on how to fix it.

    This is the same issue as here.

    Thanks.

Viewing 15 replies - 1 through 15 (of 25 total)
1 2
  • Anas

    3 years, 3 months ago

    Rank Math business

    Hello,

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

    Please follow these steps:

    1. Update to the latest version of Rank Math Free & PRO

    2. Ensure that the Advanced Mode is selected:
    advanced mode

    3. Re-create tables by clicking WP Dashboard > Rank Math > Status & Tools > Database Tools and click the Re-create database Table button.
    re-create analytics tables

    Please let us know if that helps.

    Alex C.

    3 years, 3 months ago

    Rank Math free

    Thank you for the so quick and detailed answer! Will report back if the issue reoccurs.

    Febby

    3 years, 3 months ago

    Rank Math free

    Hello,

    We are super happy that this resolved your issue. If you have any other questions in the future, know that we are here to help you.

    If you don’t mind me asking, could you please leave us a review (if you haven’t already) on https://wordpress.org/support/plugin/seo-by-rank-math/reviews/#new-post about your overall experience with Rank Math? We appreciate your time and patience.

    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.

    Alex C.

    3 years, 2 months ago

    Rank Math free

    Hello guys,
    Thanks again for the quick replies. The error has reoccurred though. Have tried the suggested solution for the tables recreation 3 times. Now have checked with phpmyadmin, and the rank_math_analytics_ga still isn’t there for me.

    [31-Jan-2021 10:33:58 UTC] WordPress database error Table 'www-mydomain-wp-Tm6qKxT9.wp_eb51a9edfd_rank_math_analytics_ga' doesn't exist for query SELECT COUNT(id) FROM wp_eb51a9edfd_rank_math_analytics_ga LIMIT 0, 1 made by 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_270->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, RankMath\Analytics\DB::get_total_rows, MyThemeShop\Database\Query_Builder->getVar, MyThemeShop\Database\Query_Builder->one

    Here are the tables I do have:

    wp_eb51a9edfd_rank_math_404_logs 	  	  
wp_eb51a9edfd_rank_math_analytics_gsc 	  
wp_eb51a9edfd_rank_math_analytics_objects 
wp_eb51a9edfd_rank_math_internal_links 	  
wp_eb51a9edfd_rank_math_internal_meta 	  
wp_eb51a9edfd_rank_math_redirections 	  
wp_eb51a9edfd_rank_math_redirections_cache
wp_eb51a9edfd_rank_math_sc_analytics

    Thanks.

    Jeremy

    3 years, 2 months ago

    Hello,

    Thank you for keeping in touch with us.

    Upon checking your details, it seems the table *_rank_math_sc_analytics still existed which I assume you are from an old version of Rank Math OR you are still using the old one.

    Can you please check if your Rank Math plugin is up to date? You may refer to our changelog here (Free tab): https://rankmath.com/changelog/

    If the issue persists after doing so, we might need to check this one over your WordPress admin login. Please edit the first post on this ticket and include your WordPress & FTP logins in the designated Sensitive Data section.
    Sensitive Data Section

    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.

    Alex C.

    3 years, 2 months ago

    Rank Math free

    Hello,

    I have updated the sensitive data as requested. Can you please check further?

    Thank you.

    Alex C.

    3 years, 2 months ago

    Rank Math free

    Hi, Jeremy:

    Thanks for reply, and willingness to look into this issue further. Yes, RM is in its latest version (1.0.56.1 ). Have added pertinent login details for the team to have a look. Please tell if I can be of further help. Thanks again. AC

    Michael Davis

    3 years, 2 months ago

    Rank Math pro

    Hello,

    Would you also please include access to your database/cPanel so we can try and check the tables existing on your site and fix the issue.

    Looking forward to helping you.

    Alex C.

    3 years, 2 months ago

    Rank Math free

    Hello Michael,
    You have such access already. PhpMyAdmin is enabled from within the Tools menu.
    Thanks.

    Danial

    3 years, 2 months ago

    Rank Math business

    Hello,

    I’m getting an error when trying to log in to your backend:

    Error 1020
 Ray ID: 61b1cf47ecfdd9cc • 2021-02-02 06:21:02 UTC
Access denied
What happened?
This website is using a security service to protect itself from online attacks.

    Can you temporarily disable your security so that we can access them?

    Looking forward to helping you.

    Alex C.

    3 years, 2 months ago

    Rank Math free

    Hi Danial, the impeding CF rule should be disabled now. Please try again. Thank you.

    Uzair

    3 years, 2 months ago

    Hello,

    It doesn’t look like you have selected the Google Analytics property.

    Can you please reconnect from WordPress Dashboard > Rank Math > General Settings > Analytics?

    And then, please choose your Analytics property from the drop down.

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

    Alex C.

    3 years, 2 months ago

    Rank Math free

    Hello Uzair,

    Did as you said. Analytics is now green once again, and the values properly set (not sure why that section was off. I’m fairly certain I have configured RM properly at the time, after a migration from a different one.)
    Analytics

    Checked with phpmyadmin again, but rank_math_analytics_ga still isn’t there for me.

    Also did once again the Re-create Database Tables option previously suggested, but the aforementioned table isn’t showing up either.

    Thank you.

    Febby

    3 years, 2 months ago

    Rank Math free

    Hello,

    I’ve just checked your site and it looks your analytics are working well now and it’s showing more data.

    Also upon checking your system status, I can see that all necessary table has been created.

    Please see the screenshot below and let us know if everything is working at your end.

    – All tables exists:
    ss-2

    – Analytics showing data now:
    ss-1

    I hope that helps, let us know if you need help with anything else.

    Thank you.

    Alex C.

    3 years, 2 months ago

    Rank Math free

    Hello Febby,

    The original issue was about a missing table. I’m still getting a missing rank_math_analytics_ga table error in debug.log. That said table is still non-existent, after inspecting the DB with phpmyadmin (available to the guest account I provided, in menu Tools > WP-phpMyAdmin). Is that said table still being used in RM?

    [02-Feb-2021 10:34:37 UTC] WordPress database error Table 'www-mywebsite-wp-Tm6qKxT9.wp_eb51a9edfd_rank_math_analytics_ga' doesn't exist for query SELECT COUNT(id) FROM wp_eb51a9edfd_rank_math_analytics_ga LIMIT 0, 1 made by 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_270->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, RankMath\Analytics\DB::get_total_rows, MyThemeShop\Database\Query_Builder->getVar, MyThemeShop\Database\Query_Builder->one

    Please tell what I may need to do to get rid of that error.

    Thank you.

Viewing 15 replies - 1 through 15 (of 25 total)
1 2

You must be logged in to reply to this ticket.