API::add and error Column 'ID' cannot be null for query INSERT INTO

Hello Nick,

does it not work for just custom tables without registered models?
Yes, correct. If you want to add a row to a custom table that stores the custom field value of a CPT, not a custom model, you have to pass the post ID ($object_id) to the add() function.

Following the documentation https://docs.metabox.io/extensions/mb-custom-table/#add

Hello,

- If you use the custom table without using the model: true setting when creating the table

// Step 2: Create a custom table for the model.
add_action( 'init', function() {
    MetaBox\CustomTable\API::create(
        'transactions',                    // Table name.
        [                                  // Table columns (without ID).
            'created_at' => 'DATETIME',
            'amount'     => 'BIGINT',
            'email'      => 'VARCHAR(99)',
            'gateway'    => 'TEXT',
            'status'     => 'VARCHAR(20)',
            'screenshot' => 'TEXT',
        ],
        ['email', 'status'],               // List of index keys.
        true                               // Must be true for models.
    );
} );

that means you are using the custom table to store the field value of a post type. The ID column of the table is the post ID of the post so it cannot be null when using the add() function.

This is controlled via metabox so i assume there is no pragmatic way to alter this?
There isn't a way to alter this. Can you let me know the benefit of altering this or your specific case?