WordPress database error Commands out of sync

Hi there!

Thank you for sharing the database error messages you are encountering. From the errors provided, it seems there are two main issues:

1. Duplicate key error on the wp_actionscheduler_actions table

The error:

Duplicate key name ‘claim_id_status_priority_scheduled_date_gmt’ for query ALTER TABLE wp_actionscheduler_actions ADD KEY claim_id_status_priority_scheduled_date_gmt (claim_id,status,priority,scheduled_date_gmt)

indicates that an attempt to add an index key that already exists is happening during a database table update for the Action Scheduler. This typically happens if a plugin update or database migration attempts to add an index that’s already present.

Backup your database first before attempting anything.

– For the Action Scheduler duplicate key error:

You can verify in your database if the index claim_id_status_priority_scheduled_date_gmt already exists on wp_actionscheduler_actions. If it does, it’s safe to skip or remove the failed ALTER TABLE statement from any update scripts or let your site ignore this error as it’s non-critical.

Alternatively, run this SQL to check existing indexes and confirm:

  SHOW INDEX FROM wp_actionscheduler_actions;
  

2. “Commands out of sync” error for Jetpack transient query

The error:

Commands out of sync; you can’t run this command now for query SELECT option_name, option_value FROM wp_options WHERE option_name IN ('_transient_timeout_jetpack_autoloader_plugin_paths')

suggests a conflict or corruption in the database communication likely caused by Jetpack or an associated autoloader.

This sometimes happens due to a plugin conflict or outdated Jetpack version. Please:

– Make sure Jetpack is updated to its latest version

– Try deactivating and reactivating Jetpack and check if the error persists

If you still face the same issue, I’d like to understand your site properly. Please share with us the necessary information below for us to investigate the issue further:

• System Status Report which you can find via WooCommerce > Status
• Fatal error logs (if any) under WooCommerce > Status > Logs.

Please use https://pastebin.com/ or https://gist.github.com/ and share a link to that paste in reply here. Once we have more information, we’ll be able to assist you further.