fix-json-support-detection.php

<?php
/**
 * Plugin Name: Fix JSON Support Detection for Action Scheduler
 * Description: Fixes the JSON support detection in Action Scheduler for MariaDB on Pantheon
 * Version: 1.0.0
 * Author: Lindsey Catlett, Pantheon
 */

// Make sure this runs before Action Scheduler initializes
add_action('plugins_loaded', 'fix_json_support_detection', 5);

function fix_json_support_detection() {
    // Override the JSON partial matching check in ActionScheduler_DBStore
    add_filter('action_scheduler_claim_actions_sql_where', function($where_clause) {
        // If the error is happening, the user is trying to use JSON partial matching
        // This filter runs when the store is querying for actions
        if (isset($_REQUEST['action']) &&
            ($_REQUEST['action'] === 'elementor_optimize_image' ||
             $_REQUEST['action'] === 'elementor_bulk_optimize_images')) {

            // Force the partial_args_matching to 'like' instead of 'json'
            add_filter('action_scheduler_get_actions_query_args', function($query_args) {
                if (isset($query_args['partial_args_matching']) && $query_args['partial_args_matching'] === 'json') {
                    $query_args['partial_args_matching'] = 'like';
                }
                return $query_args;
            }, 5);
        }

        return $where_clause;
    }, 5);
}