Database-level error triggered by Rank Math

#1033415
  • Resolved Inga

    3 months, 2 weeks ago

    Rank Math free

    Hi Rank Math Support,

    While managing plugins we noticed that Query Monitor flags a database error coming from Rank Math.
    The failing SQL statement is:

    SHOW FULL COLUMNS
    FROM wp_options
    Stack-trace excerpt (see attached screenshot):

    add_option() wp-includes/option.php:1143
    set_transient( ‘rank_math_wpro_plugin_info’ ) wp-includes/option.php:1554
    RankMathVersion_Control::get_plugin_info() wp-content/plugins/seo-by-rank-math/…
    …
    Query Monitor reports the component as Plugin: seo-by-rank-math; the entire call is highlighted red and shown as an error. This appears every time the admin dashboard loads and is accompanied by a generic compatibility warning. I have no idea how to resolve it.
    Could you please let me know:

    Does it mean Rank Math is running SHOW FULL COLUMNS FROM wp_options on every load?
    What might cause it to fail, and how can we fix or suppress the error?

    Thank you for your help.

    Best regards, Inga

    https://imgur.com/a/4lD0snZ – error printscreen

Viewing 4 replies - 1 through 4 (of 4 total)
  • RankBot

    3 months, 2 weeks ago

    Hello,

    We apologize for the issue you are facing with the database error triggered by Rank Math. It seems that the error is related to the SHOW FULL COLUMNS FROM wp_options SQL statement, which is being executed when trying to set a transient for the plugin information.

    This type of error can occur due to several reasons:

    1. Database Corruption: If there are issues with your database, it might not be able to execute certain queries properly.
    2. Plugin Conflicts: Other plugins may interfere with how Rank Math interacts with the database.
    3. Memory Limit Issues: If your server’s memory limit is exhausted, it could lead to unexpected behavior.

    To troubleshoot and potentially resolve this issue, you can try the following steps:

    1. Check for Plugin Conflicts: Deactivate all other plugins except Rank Math and see if the error persists. If it resolves, reactivate the plugins one by one to identify the conflicting plugin.
    2. Repair Database: You can use a plugin like WP-DBManager or access phpMyAdmin to repair your database tables.
    3. Increase Memory Limit: If you suspect memory issues, consider increasing the PHP memory limit in your wp-config.php file by adding or modifying the following line: 
      define('WP_MEMORY_LIMIT', '256M');
    4. Clear Transients: You can manually clear transients from the database using a plugin or through phpMyAdmin.

    If these steps do not resolve the issue, we recommend replying to this ticket with your site URL and any additional details about your setup. A human agent from our support team will then be able to assist you further.

    Thank you for bringing this concern to our attention!

    Sources:
    WordPress Database Error Commands Out of Sync; You Can’t Run This Command Now » Rank Math

    Inga

    3 months, 2 weeks ago

    Rank Math free

    Hi,
    I’ve checked my database and found:

    _transient_rank_math_first_submenu_id
    9
    _transient_timeout_rank_math_feed_posts_v2
    10
    _transient_rank_math_feed_posts_v2
    887
    _transient_timeout_rank_math_wporg_plugin_info
    10
    _transient_timeout_rank_math_trunk_version
    10
    _transient_rank_math_trunk_version

    Is it safe to delete them all?

    Best regards,
    Inga

    Ike

    3 months, 1 week ago

    Hello,

    Thank you for your query, and we are so sorry about the trouble this must have caused.

    To troubleshoot this issue you can take the below steps initially.
    1. Could you verify if you’re running the latest version of the Rank Math plugin? https://rankmath.com/changelog

    2 . Then clear the transients at Rank Math > Status & Tools > Database Tools > Remove transients

    3 . After that, you may try disconnecting and reconnecting Rank Math to see if that works for you.

    You can disconnect your account by navigating to WordPress Dashboard > Rank Math > Dashboard > Help and then simply disconnect the account by clicking on Disconnect Account.

    4 . Once you’ve disconnected your Rank Math account, you can connect it again in the same settings. In order to connect your correct account, click on Connect Now.

    Let us know how it goes. Looking forward to helping you.

    Thank you.

    Inga

    2 months, 1 week ago

    Rank Math free

    Hello,

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

    Thank you.

    RankBot

    2 months, 1 week 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 4 replies - 1 through 4 (of 4 total)

The ticket ‘Database-level error triggered by Rank Math’ is closed to new replies.