unable to insert using Capsule

[mth-matt]

Hi, in my addons module i am trying to insert multiple rows, using the following:

Capsule::table('order_provision_sim_status')
            ->insert([
                ['status_description' => 'Awaiting Provisioning'],
                ['status_description' => 'Provisioned'],
                ['status_description' => 'Cancelled']
            ]);

But unfortunately this does not insert anything.  This should insert multiple rows as per the laravel documentation.  can you confirm the correct way in doing so please?

[Satyabeer]

Hello @mth-matt

 

Your insertion query is right. Please check your table structure. There may be any column which is mandatory to insert value or otherwise check your column datatype.

 

Thanks