Recovery Mode: This plugin failed to load properly

Hi @sounds

Thanks for reaching out! I understand that your scheduled actions are not being executed, and you are seeing an error log about this.

As a first step, I recommend installing the?WP Crontrol?plugin to see if there are any errors.

To help you further, I’d like to understand more about your setup.

Could you please send me a copy of your site’s System Status? You can find it via WooCommerce > Status. Select Get system report and then Copy for support.

Once you’ve done that, you can paste it here or into our https://Quickforget.com service and send that secret link here.

We await your response to better assist you.

@anastas10s I’m unable to run WooCommerce without critical error.

That WP Crontrol didn’t show any errors, I dunno.

I managed to get WooCommerce running, but had to disable other plugins.

Status Report:

### WordPress Environment ###

WordPress address (URL): https://x.com
Site address (URL): https://x.com
WC Version: 7.9.0
REST API Version: ? 7.9.0
WC Blocks Version: ? 10.4.6
Action Scheduler Version: ? 3.6.1
Log Directory Writable: ?
WP Version: 6.2.2
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: ?
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache/2.4.56 (Unix) OpenSSL/1.0.2k-fips PHP/7.4.33
PHP Version: 7.4.33
PHP Post Max Size: 64 MB
PHP Time Limit: 120
PHP Max Input Vars: 1000
cURL Version: 7.29.0
NSS/3.53.1

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.2.44-MariaDB
Max Upload Size: 64 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 7.9.0
WC Database Prefix: wp_
Total Database Size: 75.51MB
Database Data Size: 69.85MB
Database Index Size: 5.66MB
wp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 0.27MB + Index: 0.19MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.17MB + Index: 0.11MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 0.16MB + Index: 0.13MB + Engine InnoDB
wp_adsw_activities: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_adsw_ali_meta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_adsw_comments_hash: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_adsw_search_analytics: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_adsw_task_upload_images: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_adsw_variations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_commentmeta: Data: 0.09MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.05MB + Index: 0.08MB + Engine InnoDB
wp_e_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_gla_attribute_mapping_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_gla_budget_recommendations: Data: 0.22MB + Index: 0.14MB + Engine InnoDB
wp_gla_merchant_issues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_jetpack_waf_blocklog: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_automations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mailpoet_automation_runs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_automation_run_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_automation_triggers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mailpoet_automation_versions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_dynamic_segment_filters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_feature_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mailpoet_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mailpoet_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_mailpoet_newsletter_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_mailpoet_newsletter_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_newsletter_segment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_newsletter_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mailpoet_scheduled_tasks: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_mailpoet_scheduled_task_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_segments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_mailpoet_sending_queues: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_mailpoet_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_statistics_bounces: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mailpoet_statistics_clicks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_mailpoet_statistics_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_statistics_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_mailpoet_statistics_opens: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_mailpoet_statistics_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_mailpoet_statistics_woocommerce_purchases: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_mailpoet_subscribers: Data: 0.02MB + Index: 0.13MB + Engine InnoDB
wp_mailpoet_subscriber_custom_field: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_subscriber_segment: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_mailpoet_subscriber_tag: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_mailpoet_tags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_user_agents: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 5.02MB + Index: 0.14MB + Engine InnoDB
wp_postmeta: Data: 53.31MB + Index: 1.94MB + Engine InnoDB
wp_posts: Data: 8.47MB + Index: 0.42MB + Engine InnoDB
wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_usermeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_vi_wad_ali_orders_info: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_vi_wad_error_product_images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wpforms_payments: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
wp_wpforms_payment_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wpforms_tasks_meta: Data: 0.08MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

album: 9
attachment: 249
custom_css: 1
customize_changeset: 384
elementor_library: 2
ml-slide: 9
ml-slider: 1
nav_menu_item: 5
page: 14
people: 8
post: 9
product: 12
product_variation: 94
revision: 1385
sp_wps_shortcodes: 1
work: 6
wpforms: 2

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?Error messages should not be shown to visitors.

### Active Plugins (17) ###

Akismet Anti-Spam: Spam Protection: by Automattic - Anti Spam Team – 5.2
Apollo13 Framework Extensions: by Apollo13Themes – 1.9.0
Breadcrumb NavXT: by John Havlik – 7.2.0
Elementor: by Elementor.com – 3.14.1
Jetpack Protect: by Automattic - Jetpack Security team – 1.4.1
Jetpack: by Automattic – 12.3
Protect WP-Admin: by WP Experts Team – 4.0
Rife Elementor Extensions & Templates: by Apollo13Themes – 1.2.0
SearchWP Live Ajax Search: by SearchWP
LLC – 1.7.6

Product Slider for WooCommerce: by ShapedPlugin LLC – 2.6.7
Quick View for WooCommerce: by ShapedPlugin LLC – 2.2.2
Variation Swatches for WooCommerce: by Emran Ahmed – 2.0.24
WooCommerce Google Analytics Integration: by WooCommerce – 1.8.3
WooCommerce PayPal Payments: by WooCommerce – 2.2.0
WooCommerce: by Automattic – 7.9.0
WP Crontrol: by John Blackbourn & crontributors – 1.15.3
WPForms Lite: by WPForms – 1.8.2.3

### Inactive Plugins (3) ###

AliDropship Woo Plugin: by Vitaly Kukin & Yaroslav Nevskiy & Pavel Shishkin & Denis Zharov – 1.6.55
Pinterest for WooCommerce: by WooCommerce – 1.3.6
StoreCustomizer: by Kaira – 2.5.2

### Settings ###

API Enabled: –
Force SSL: –
Currency: EUR (€)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to WooCommerce.com: –
Enforce Approved Product Download Directories: ?
HPOS feature screen enabled: –
HPOS feature enabled: –
Order datastore: WC_Order_Data_Store_CPT
HPOS data sync enabled: –

### WC Pages ###

Shop base: #53 - /shop/
Cart: #11375 - /cart/
Checkout: #55 - /checkout/
My account: #56 - /my-account/
Terms and conditions: ? Page visibility should be public

### Theme ###

Name: Rife Free child theme
Version: 1.0
Author URL: https://apollo13themes.com/
Child Theme: ?
Parent Theme Name: Rife Free
Parent Theme Version: 2.4.16.1
Parent Theme Author URL: https://apollo13themes.com/
WooCommerce Support: ?

### Templates ###

Overrides: rife-free/woocommerce/archive-product.php
rife-free/woocommerce/loop/loop-start.php

### WooCommerce PayPal Payments ###

Onboarded: ?
Shop country code: IE
WooCommerce currency supported: ?
Advanced Card Processing available in country: –
Pay Later messaging available in country: –
Webhook status: –
PayPal Vault enabled: –
ACDC Vault enabled: –
Logging enabled: –
Reference Transactions: –
Used PayPal Checkout plugin: –
Tracking enabled: ?

### Admin ###

Enabled Features: activity-panels
analytics
product-block-editor
coupons
core-profiler
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page

Disabled Features: minified-js
new-product-management-experience
product-variation-management
settings
async-product-editor-category-field

Daily Cron: ? Next scheduled: 2023-07-26 22:09:21 +00:00
Options: ?
Notes: 78
Onboarding: completed

### Action Scheduler ###

Complete: 564
Oldest: 2023-07-25 22:21:02 +0000
Newest: 2023-07-26 17:34:52 +0000

Failed: 4
Oldest: 2023-06-24 23:25:28 +0000
Newest: 2023-07-20 06:30:03 +0000

Pending: 2
Oldest: 2023-07-26 22:21:02 +0000
Newest: 2023-07-26 22:21:02 +0000

### Status report information ###

Generated at: 2023-07-26 17:35:20 +00:00

—

WooCommerce Errors:

WordPress database error: [Unknown column 'priority' in 'field list']
INSERT INTO wp_actionscheduler_actions ( <code>hook</code>, <code>status</code>, <code>scheduled_date_gmt</code>, <code>scheduled_date_local</code>, <code>schedule</code>, <code>group_id</code>, <code>priority</code>, <code>args</code> ) SELECT 'pinterest-for-woocommerce-handle-feed-registration', 'pending', '2023-07-26 17:27:11', '2023-07-26 17:27:11', 'O:32:\"ActionScheduler_IntervalSchedule\":5:{s:22:\"\0*\0scheduled_timestamp\";i:1690392431;s:18:\"\0*\0first_timestamp\";i:1690392431;s:13:\"\0*\0recurrence\";i:600;s:49:\"\0ActionScheduler_IntervalSchedule\0start_timestamp\";i:1690392431;s:53:\"\0ActionScheduler_IntervalSchedule\0interval_in_seconds\";i:600;}', 3, 10, '[]' FROM DUAL WHERE ( SELECT NULL FROM DUAL ) IS NULL

Fatal error: Uncaught RuntimeException: Error saving action: Unknown column 'priority' in 'field list' in /home/ui/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:126 Stack trace: #0 /home/ui/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php(69): ActionScheduler_DBStore->save_action_to_db() #1 /home/ui/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(327): ActionScheduler_DBStore->save_action() #2 /home/ui/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(315): ActionScheduler_ActionFactory->store() #3 /home/ui/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/functions.php(175): ActionScheduler_ActionFactory->create() #4 /home/ui/public_html/wp-content/plugins/pinterest-for-woocommerce/src/FeedRegistration.php(63): as_ in /home/ui/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php on line 126
There has been a critical error on this website. Please check your site admin email inbox for instructions.

Well we just had the MariaDB updated and I thought that helped, no luck.

I’m able to enable all plugins, including WooComemrce,
But as soon as I touch any link related to WooCommerce, it gives critical error.

Hi @sounds

The error message you’re seeing suggests an issue with your WordPress installation’s database structure. Specifically, the ‘priority’ column seems missing from the ‘wp_actionscheduler_actions’ table. This situation can occur if the database does not update properly during a plugin update.

I am glad to hear the database issue was fixed after upgrading the DB version.

I understand you’re having a critical error when you try to interact with any WooCommerce-related link. This could be because of several reasons, such as a conflict with another plugin, an issue with your theme, or a server configuration problem.

Here are some steps you can take to troubleshoot this issue:

• Plugin Conflict: Disable all plugins except WooCommerce and see if the issue persists. If it doesn’t, then the problem is likely being caused by a conflict with one of your other plugins. You can identify the problematic plugin by reactivating them one by one until the issue reoccurs.
• Theme Conflict: Switch your theme to a default WordPress theme like Storefront. If the problem disappears, then the issue is likely with your theme. You can find a more detailed explanation of conducting a conflict test here.
• Server Configuration: Ensure that your server is configured correctly. Check your server error logs for any clues as to what might be causing the issue. If you’re unsure how to do this, your hosting provider should be able to assist you.
• Debugging: Enable WordPress debugging to get a more detailed error message. To do this, you’ll need to edit your wp-config.php file and add the following lines:

define( 'WP_DEBUG', true );
define( 'WP_DEBUG_LOG', true );
define( 'WP_DEBUG_DISPLAY', false );

This will create a debug.log file in your wp-content directory, which you can check for any error messages. If you need, you follow our detailed guide on debugging here: https://woocommerce.com/document/woocommerce-product-search/api/debugging/

If you’re still having trouble after trying these steps, please don’t hesitate to get back in touch with us.

Thanks!

@shameemreza I’ll try it again myself,

I already gave Ali staff access to the server and WordPress + hosting.

They had all the plugins disabled, had debug mode enabled etc.
They suggested the error was coming from WooCommerce, not Ali plugin.

Don’t see the action schedule warnings any more,
I removed the 3 old schedule warnings with Crontrol plugin.

Disabled all plugins and tried to enable WooCommerce, critical error.

Back to email and into recovery mode again.

EDIT

The only plugin that’s enabled right now is WooCommerce.

An eCommerce toolkit that helps you sell anything. Beautifully.

Version 7.9.0 | By Automattic | View details
 This plugin failed to load properly and is paused during recovery mode.

An error of type E_ERROR was caused in line 44 of the file /home/ui/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php. Error message: Uncaught RuntimeException: Error saving action: Error saving action: Unknown column 'priority' in 'field list' in /home/ui/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44 Stack trace: #0 /home/ui/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action() #1 /home/ui/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(327): ActionScheduler_HybridStore->save_action() #2 /home/ui/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(315): ActionScheduler_ActionFactory->store() #3 /home/ui/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/functions.php(102): ActionScheduler_ActionFactory->create() #4 /home/ui/public_html/wp-content/plugins/woocommerce/packages/a

Everything in the debug.log seems to be related to Action Scheduler directory.

[03-Aug-2023 21:12:09 UTC] WordPress database error Unknown column 'priority' in 'field list' for query 
INSERT INTO wp_actionscheduler_actions ( <code>hook</code>, <code>status</code>, <code>scheduled_date_gmt</code>, <code>scheduled_date_local</code>, <code>schedule</code>, <code>group_id</code>, <code>priority</code>, <code>args</code> )
SELECT 'action_scheduler/migration_hook', 'pending', '2023-08-03 21:13:09', '2023-08-03 22:13:09', 'O:30:\"ActionScheduler_SimpleSchedule\":2:{s:22:\"\0*\0scheduled_timestamp\";i:1691097189;s:41:\"\0ActionScheduler_SimpleSchedule\0timestamp\";i:1691097189;}', 1, 10, '[]' FROM DUAL
WHERE ( SELECT NULL FROM DUAL ) IS NULL made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('wp_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->schedule_migration, as_schedule_single_action, ActionScheduler_ActionFactory->create, ActionScheduler_ActionFactory->store, ActionScheduler_HybridStore->save_action, ActionScheduler_DBStoreMigrator->save_action, ActionScheduler_DBStore->save_action, ActionScheduler_DBStore->save_action_to_db
[03-Aug-2023 21:12:09 UTC] PHP Fatal error:  Uncaught RuntimeException: Error saving action: Error saving action: Unknown column 'priority' in 'field list' in /home/ui/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44
Stack trace:
#0 /home/ui/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action()
#1 /home/ui/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(327): ActionScheduler_HybridStore->save_action()
#2 /home/ui/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(315): ActionScheduler_ActionFactory->store()
#3 /home/ui/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/functions.php(102): ActionScheduler_ActionFactory->create()
#4 /home/ui/public_html/wp-content/plugins/woocommerce/packages/a in /home/ui/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44

I’ll find a free action scheduler and see what happens.
Well that went pare shaped quickly, installed Action Scheduler,
And got almost the same error messages as WooCommerce.

Hello @sounds,

Sorry for the late reply!

After investigating, it seems that quite a few other merchants are facing the same issue. The problem appears to be due to a column that’s missing in the database.

Could you please try running the following WP-CLI command to rebuild the database tables?

wp action-scheduler fix-schema

Let us know how it goes!

@babylon1999

That was my next question, at least I know it’s not just me.
Just run this command in PHPMyAdmin as a query?

Just run this command in PHPMyAdmin as a query?

No, please don’t run it in your database, it’s a WP-CLI command. Not all hosting providers give access to this terminal, so you might want to check with them first. ??

Let us know how it goes!

@babylon1999 Oh ok, I’ll try install it as I’m managing the servers.

Thanks!

That priority column is still missing in wp_actionscheduler_actions table.

@babylon1999 tried running that command, no difference with WooCommerce,
We had to grant ssh access to the user for the affected domain.

[root@sv756 /]# sudo -u user -i -wp action-scheduler fix-schema
sudo: invalid option -- 'w'
usage: sudo -h | -K | -k | -V
usage: sudo -v [-AknS] [-g group] [-h host] [-p prompt] [-u user]
usage: sudo -l [-AknS] [-g group] [-h host] [-p prompt] [-U user] [-u user] [command]
usage: sudo [-AbEHknPS] [-r role] [-t type] [-C num] [-g group] [-h host] [-p prompt] [-T timeout] [-u user] [VAR=value] [-i|-s] [<command>]
usage: sudo -e [-AknS] [-r role] [-t type] [-C num] [-g group] [-h host] [-p prompt] [-T timeout] [-u user] file ...

not sure what else to try, too tired, back later.

I guess this is the result I needed:

[root@sv756 /]# su domain-user
[root@sv756 /]$ /home/domain-user/public_html
bash: /home/domain-user/public_html: Is a directory
[[root@sv756 /]$ cd /home/domain-user/public_html
[[root@sv756 public_html]$ wp action-scheduler fix-schema
Success: Registered schema for ActionScheduler_LoggerSchema
Success: Registered schema for ActionScheduler_StoreSchema

Still can’t enable WooCommerce without critical error.

Problem solved,

Had to give the database user full permissions then run command.

[root@sv756 /]# su domain-user
[[root@sv756 /]$ cd /home/domain-user/public_html
[[root@sv756 public_html]$ wp action-scheduler fix-schema
Success: Registered schema for ActionScheduler_LoggerSchema
Success: Registered schema for ActionScheduler_StoreSchema

Priority column finally added to database.
Plugins enable without critical errors.

Glad to know everything is working now! ??

I will mark the thread as solved. If you have a few minutes, we’d love it if you could leave us a review: https://www.ads-software.com/support/plugin/woocommerce/reviews/

Cheers!