Error using update.php - Field 'plugin' doesn't have a default value: INSERT INTO {rules_config}

Related

• #1025284: Generated feature modules don't work
• #1046250: Plugin field in hook_schema lacks default value
• #1447210: PDOException: when enabling module
• #1479256: SQL insert error
• #1309144: PDO Exception SQLSTATE[HY000]: General error: 1364 Field 'plugin' doesn't have a default value

Hi Wolfgang
Any idea what's wrong with this default config?
All four default rules nominate a plugin, yet we get the 'missing value for plugin' error.
Anything change with exports between rc2 and 2.0?
Lee

/**
 * Implementation of hook_default_rules_configuration().
 */
function commerce_recurring_default_rules_configuration() {
  $items = array();
  $items['commerce_recurring_process_orders'] = entity_import('rules_config', '{ "commerce_recurring_process_orders" : {
      "LABEL" : "Generate Recurring Orders",
      "PLUGIN" : "reaction rule",
      "TAGS" : [ "Commerce Recurring" ],
      "REQUIRES" : [ "commerce_recurring", "rules" ],
      "ON" : [ "cron" ],
      "DO" : [
        { "commerce_recurring_load_recurring" : { "PROVIDE" : { "orders" : { "orders" : "Recurring Orders" } } } },
        { "LOOP" : {
            "USING" : { "list" : [ "orders" ] },
            "ITEM" : { "order" : "Order" },
            "DO" : [
              { "component_commerce_recurring_generate_orders" : { "order" : [ "order" ] } }
            ]
          }
        }
      ]
    }
  }');
  $items['commerce_recurring_generate_orders'] = entity_import('rules_config', '{ "commerce_recurring_generate_orders" : {
      "LABEL" : "Generate Recurring Order if Appropriate",
      "PLUGIN" : "rule",
      "REQUIRES" : [ "commerce_recurring" ],
      "USES VARIABLES" : { "order" : { "label" : "Order", "type" : "commerce_order" } },
      "IF" : [
        { "commerce_recurring_rules_order_contains_recurring" : { "commerce_order" : [ "order" ] } },
        { "commerce_recurring_rules_order_is_master" : { "commerce_order" : [ "order" ] } }
      ],
      "DO" : [
        { "commerce_recurring_process_recurring" : {
            "USING" : { "commerce_order" : [ "order" ] },
            "PROVIDE" : { "recurring_order" : { "recurring_order" : "New Order" } }
          }
        }
      ]
    }
  }');
  $items['commerce_recurring_initialise_order_master'] = entity_import('rules_config', '{ "commerce_recurring_initialise_order_master" : {
      "LABEL" : "Set First Repeat date of Recurring Order",
      "PLUGIN" : "reaction rule",
      "TAGS" : [ "Commerce Recurring" ],
      "REQUIRES" : [ "commerce_recurring", "rules", "commerce_checkout" ],
      "ON" : [ "commerce_checkout_complete" ],
      "IF" : [
        { "commerce_recurring_rules_order_contains_recurring" : { "commerce_order" : [ "commerce_order" ] } }
      ],
      "DO" : [
        { "commerce_recurring_initialise_recurring" : {
            "USING" : { "commerce_order" : [ "commerce_order" ] }
          }
        }
      ]
    }
  }');
  
  $items['commerce_recurring_trigger_payments'] = entity_import('rules_config', '{ "commerce_recurring_trigger_payments" : {
      "LABEL" : "Trigger Payments against recurring orders",
      "PLUGIN" : "reaction rule",
      "REQUIRES" : [ "commerce_recurring", "rules" ],
      "ON" : [ "cron" ],
      "DO" : [
        { "commerce_recurring_load_payments_due" : { "PROVIDE" : { "orders" : { "orders" : "Recurring Orders" } } } },
        { "LOOP" : {
            "USING" : { "list" : [ "orders" ] },
            "ITEM" : { "order" : "Current Order" },
            "DO" : [
              { "commerce_recurring_process_payment" : { "commerce_order" : [ "order" ] } }
            ]
          }
        }
      ]
    }
  }');
  return $items;
}

Got the same problem, when I add the default value to the schema for the plugin field the problem goes away. The thing I don't understand is all the configs have PLUGIN value and after installing the plugin field in rules_config table has correct values.

I had to allow null to get past this error (on the rules_config table, plugin field).

After getting past this, there was a blank rule:

name: commerce_recurring_initialise_order_master
label: unlabeled
plugin:
etc...

Seeing this as well, sending back into rules queue

Apologies, the issue is that the info file needs to list "commerce_checkout" as a dependancy:

I was having the same issue, and confirmed that the fix in comment #7 did the trick. Thanks jpstrikesback!

That appears to fix the issue.

Here is a patch.

#9 resolved the issue for me (which was not during update, but install).

Thanks!

added information

At this point there are 6 sites using the 1.x branch of recurring framework, I'm dropping support for that version recommending to use and contribute to the 2.x

I had this issue but it was resolved when I enabled commerce_rules_extra. I created the the rules and exported with features on a development environment where I had this module enabled (its required for the rules I created). But on the test server, I had forgotten to enable that module. Once I did, everything worked. So, maybe the issue is to make sure the feature dependencies are correct?