Multiple database errors (every ~30 seconds) about Unknown column

#580894
  • Resolved Anonymous

    2 years, 4 months ago

    Rank Math free

    I tried using an automated tool of yours to fix them, but got this message and still get the database errors:
    The Repair Action Scheduler could not run because the repair database schema is obsolete.
    No actions performed.
    The Repair Action Scheduler plugin has been automatically deactivated.”

    [28-May-2023 17:11:34 UTC] WordPress database error Unknown column ‘priority’ in ‘order clause’ for query UPDATE wp_kpck84_actionscheduler_actions SET claim_id=1492238, last_attempt_gmt=’2023-05-28 17:11:34′, last_attempt_local=’2023-05-28 13:11:34′ WHERE claim_id = 0 AND scheduled_date_gmt <= ‘2023-05-28 17:11:34′ AND status=’pending’ ORDER BY priority ASC, attempts ASC, scheduled_date_gmt ASC, action_id ASC LIMIT 100 made by do_action_ref_array(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_HybridStore->stake_claim, ActionScheduler_DBStore->stake_claim, ActionScheduler_DBStore->claim_actions
    [28-May-2023 17:11:34 UTC] PHP Fatal error: Uncaught RuntimeException: Unable to claim actions. Database error. in /var/www/sociocracyforall.org/htdocs/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:938
    Stack trace:
    #0 /var/www/sociocracyforall.org/htdocs/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php(799): ActionScheduler_DBStore->claim_actions()
    #1 /var/www/sociocracyforall.org/htdocs/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(221): ActionScheduler_DBStore->stake_claim()
    #2 /var/www/sociocracyforall.org/htdocs/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/ActionScheduler_QueueRunner.php(157): ActionScheduler_HybridStore->stake_claim()
    #3 /var/www/sociocracyforall.org/htdocs/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/ActionScheduler_QueueRunner.php(136): ActionScheduler_QueueRunner->do_batch()
    #4 /var/www/sociocracyforall.org/htdocs/wp-includes/class-wp-hook.php(308): ActionScheduler_QueueRunner->run()
    #5 /var/www/sociocracyforall.org/htdocs/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters()
    #6 /var/www/sociocracyforall.org/htdocs/wp-includes/plugin.php(565): WP_Hook->do_action()
    #7 /var/www/sociocracyforall.org/htdocs/wp-cron.php(188): do_action_ref_array()
    #8 {main}
    thrown in /var/www/sociocracyforall.org/htdocs/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php on line 938
    [28-May-2023 17:11:36 UTC] PHP Warning: Undefined property: stdClass::$priority in /var/www/sociocracyforall.org/htdocs/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php on line 379
    [28-May-2023 17:11:36 UTC] PHP Warning: Undefined property: stdClass::$priority in /var/www/sociocracyforall.org/htdocs/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php on line 379
    [28-May-2023 17:11:36 UTC] …/builder/class-et-builder-element.php:851 ET_Builder_Element::__construct():
    You’re Doing It Wrong! Module setting definition for include_categories has a deprecated value: ‘et_builder_include_categories_option’ for parameter ‘renderer’. Use ‘categories’ instead.

    [28-May-2023 17:11:36 UTC] …/builder/class-et-builder-element.php:851 ET_Builder_Element::__construct():
    You’re Doing It Wrong! Module setting definition for front_icon has a deprecated value: ‘et_pb_get_font_icon_list’ for parameter ‘renderer’. Use ‘select_icon’ instead.

    [28-May-2023 17:11:36 UTC] …/builder/class-et-builder-element.php:851 ET_Builder_Element::__construct():
    You’re Doing It Wrong! Module setting definition for back_icon has a deprecated value: ‘et_pb_get_font_icon_list’ for parameter ‘renderer’. Use ‘select_icon’ instead.

    [28-May-2023 17:11:36 UTC] PHP Warning: Undefined array key “label” in /var/www/sociocracyforall.org/htdocs/wp-content/themes/Divi/includes/builder/class-et-builder-element.php on line 8927
    [28-May-2023 17:11:37 UTC] PHP Warning: Undefined property: stdClass::$priority in /var/www/sociocracyforall.org/htdocs/wp-content/plugins/seo-by-rank-math/vendor/woocommerce/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php on line 379

Viewing 6 replies - 1 through 6 (of 6 total)
  • Md. Sakib Khandaker

    2 years, 4 months ago

    Rank Math agency

    Hello,

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

    We might need to take a closer look at the settings. 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/

    Looking forward to helping you.

    Thank you.

    Anonymous

    2 years, 4 months ago

    Rank Math free

    Hello,

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

    Thank you.

    Miguel

    2 years, 4 months ago

    Hello,

    We noticed that the table that holds the scheduled actions on your website currently is missing a field that is required, hence the error you see when trying to activate the plugin.

    Since we don’t have write access to the database, you would need to create this field yourself using the database access that is usually provided by the hosting company.

    The field should be called priority and it should be set to a tinyint with a length of 3 on it. It should also be set to unsigned in the settings and should not accept null values.

    The SQL of the field would look something similar to this:

    
priority tinyint(3) unsigned NOT NULL DEFAULT 10

    Hope this helps solve your issues.

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

    Anonymous

    2 years, 4 months ago

    Rank Math free

    Dear Miguel,

    When I tried to add the column through php my admin, it returned an error saying that it could not create the column because it already existed…

    However, the column wasn’t visible in phpmyadmin before running the command, and now it is, and everything seems to have a priority of 10– so possibly this has fixed it despite the error. I will turn debug logging back on for a little bit to see if the issue has been resolved and follow up later today.

    Anonymous

    2 years, 4 months ago

    Rank Math free

    I am not getting the error anymore, thank you.

    Great

    2 years, 4 months ago

    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.

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

The ticket ‘Multiple database errors (every ~30 seconds) about Unknown column’ is closed to new replies.