WordPress database error

#504843
  • Resolved Malabarte Studio
    Rank Math free

    Hello i’m getting some troubles with RankMath. Analytics doesn’t sync and i’m getting some errors as errorlog shows.

    I hope you can help me.

    PD: This web was using Yoast and some other SEO plugin that I uninstalled previously and deleted in “Other plugins option”

Viewing 15 replies - 1 through 15 (of 17 total)
  • Hello,

    Thanks for contacting us, and sorry for any inconvenience that might have been caused due to that.

    #~ For the issue with Analytics syncing, please follow the instructions below:

    Please check if there is a pending Scheduled Action. To check, head over to WordPress dashboard > Tools > Scheduled Actions > Pending.

    or you can try visiting the following URL:

    https://yourdomain.com/wp-admin/tools.php?page=action-scheduler&status=pending
    

    Run the rank_math/analytics/data_fetch scheduled action and wait for the data fetch to complete.

    This is how it should look like:

    Once done, please allow Rank Math a while to fetch data from Google Analytics and you should be able to see the updated data on Rank Math Analytics dashboard.

    [30-Dec-2022 09:27:22 UTC] PHP Warning: call_user_func_array() expects parameter 1 to be a valid callback, function ‘wp_print_media_templates’ not found or invalid function name in /home/customer/www/englishnewdeal.com/public_html/wp-includes/class-wp-hook.php on line 308

    The error in the setup wizard is a known issue with Elementor and it is coming from their plugin. For now, you may try deactivating the Elementor plugin temporary and perform the setup process.

    We have already informed them about this and working with them to get it fixed. This only appears in the setup wizard and will not affect any other functionality of the plugin.

    [30-Dec-2022 09:32:44 UTC] WordPress database error Table ‘dbgeepzxnpb82l.ynj_rank_math_redirections’ doesn’t exist

    [30-Dec-2022 09:36:09 UTC] WordPress database error Table ‘dbgeepzxnpb82l.ynj_rank_math_redirections_cache’ doesn’t exist

    To resolve this one, please recreate the Rank Math tables by navigating to WordPress Dashboard > Rank Math > Status & Tools > Database Tools and click on the Recreate Missing Database Tables to see if that works for you.
    https://rankmath.com/kb/rank-math-status-and-tools/#recreate-missing-database-tools

    Please note that some options are only available when you enable the Advanced Mode in Rank Math. If it’s not showing, you must have chosen to use Easy Mode. Please follow the steps in this link to switch to Advanced Mode:
    https://rankmath.com/kb/advanced-mode/

    The issue should be resolved after that. Let us know if it doesn’t. We are here to assist.

    Thank you.

    Hello,

    I tried what you said. I had a lot of scheduled actions pending so I run all of them. Then I run ‘rank_math/analytics/data_fetch’ and is still pending but with more other actions pending now:

    https://i.imgur.com/DDtpBbu.png
    https://i.imgur.com/JxPnLRS.png

    Nigel
    Rank Math business

    Hello,

    Based on the screenshots you shared, scheduled actions are not running smoothly. Please contact your host and ask them to activate an alternative to the WordPress cron function. You may refer to this guide for how to activate an alternative : https://themeisle.com/blog/disable-wp-cron/

    Hope that helps. Please let us know if you have questions.

    I’m using Siteground wordpress hosting for this website. I’m using the same hosting for other websites and everything is ok with RankMath. Are you sure is a hosting thing?

    Hello!

    I Talked to hosting support. They ran the Cron and the whole events started to run (they said some jobs were delayed). Now, I have a new info in the error log (in lot of lines):

    [31-Dec-2022 01:05:52 UTC] PHP Warning: Invalid argument supplied for foreach() in /home/customer/www/mydomain.com/public_html/wp-admin/includes/plugin.php on line 1780

    PS:
    Analytics data doesn’t syncing yet…

    Hello,

    Assuming you are using the latest version of all the plugins and the themes (please update if not yet), it would seem like a conflict with one of the plugins or the theme you are using.

    To determine that, please follow this troubleshooting guide:
    https://rankmath.com/kb/check-plugin-conflicts/

    Here is a video you can follow as well:

    Only the site admin would know and your users won’t be affected by this troubleshooting.

    As for the analytics issue, 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.
    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/

    Please do take a complete backup of your website before sharing the information with us.

    We really look forward to helping you.

    Hello,

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

    Thank you.

    Hello,
    Can you give me some info, please?

    PS1: Everytime I active or deactivate a plugin I got this line in php_errorlog:

    PHP Warning: Invalid argument supplied for foreach() in /home/customer/www/englishnewdeal.com/public_html/wp-admin/includes/plugin.php on line 1780

    PS2: Analytics still not syncing

    I hope you can help me.

    Thank you.

    Hello,

    We apologize for the delay in response.

    Can you also please share your FTP login in the sensitive data section so we can further check the issue?

    Looking forward to helping you with this one.

    Hello,

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

    Thank you.

    Hello,
    Can you check it now? Thank you.

    Hello,

    You added the FTP credentials but removed the WordPress login credentials from the sensitive data section.

    We would need both to verify the issue with the Analytics not syncing and advise further.

    Looking forward to hearing back from you.

    Hello,

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

    Thank you.

    Hello!
    Ok, is working now.

    Hello,

    After triggering the scheduled action to import the Analytics data we can see that is updating fine on the website:
    Analytics

    Hope this helps solve your issues.

    Don’t hesitate to get in touch if you have any other questions.

Viewing 15 replies - 1 through 15 (of 17 total)

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