How to use incompatible_sql_modes filter in WordPress

incompatible_sql_modes filter

Filters the list of incompatible SQL modes to exclude.

To use incompatible_sql_modes filter, first you have to register it using add_filter. You can write this code into functions.php of your activated theme or in a custom WordPress Plugin.

We at WePlugins always prefer to create a custom WordPress Plugin while using hooks so nothing breaks when you update your WordPress Theme in the future.

In the below live example, we have defined a function modify_incompatible_sql_modes_defaults which takes 1 parameter and we registered using add_filter. The first parameter incompatible_sql_modes is the name of the hook, the second parameter modify_incompatible_sql_modes_defaults is the name of the function which needs to be called, the third parameter is the priority of calling the hook if the same hook is used multiple times, and the last parameter is the number of arguments (if any) to be passed in the registered function.

Sometimes, you have to remove a registered hook, so you can use remove_filter to remove incompatible_sql_modes filter.

Parameters

Below the 1 parameter is required to use this hook.

• $incompatible_modes : (array) An array of incompatible modes.

Live Example

Below is an example of how you can use this hook.

Example 1: Basic Usage

This example demonstrates how to modify the incompatible SQL modes using the filter.

    function weplugins_modify_incompatible_sql_modes_defaults($incompatible_modes) { 
        // Update the $incompatible_modes variable according to your website requirements and return this variable. 
        // You can modify the $incompatible_modes variable conditionally too if you want.
        return $incompatible_modes; 
    }
    // add the filter
    add_filter("incompatible_sql_modes", "weplugins_modify_incompatible_sql_modes_defaults", 10, 1);
    

Example 2: Conditional Modification

In this example, we modify the incompatible modes based on a specific condition.

    function weplugins_modify_incompatible_sql_modes_defaults($incompatible_modes) { 
        if (is_admin()) {
            $incompatible_modes[] = 'NO_ZERO_DATE';
        }
        return $incompatible_modes; 
    }
    // add the filter
    add_filter("incompatible_sql_modes", "weplugins_modify_incompatible_sql_modes_defaults", 10, 1);
    

Example 3: Removing the Hook

To remove a hook callback, use the example below.

    remove_filter("incompatible_sql_modes", "weplugins_modify_incompatible_sql_modes_defaults", 10, 1);
    

Please make sure to provide the same callback function name, priority, and number of arguments while removing the hook callback.

Contact Us

If you need any customization or help with this hook, feel free to contact us.