Laravel null value in column "created_at" violates not-null constraint for pivot table

Question

I am getting following error while saving the data in the pivot table

Not null violation: 7 ERROR: null value in column "created_at" violates not-null constraint DETAIL: Failing row contains (4, 10, 16, null, null). (SQL: insert into "child_packages" ("child_id", "package_id") values (10, 16))

here is my code for saving data in the table

    $child = $this->child_section->create($input);


    $packages_ids = Input::get('package_id');
    $child->Packages()->sync($packages_ids);

and in the child model

 public function Packages()
{
    return  $this->belongsToMany('FoodPackage');
}

For database I am using postgresql

I have remove the `created_at` column form the schema and it works. Thank you for your time John Roca.. — HKumar, Mar 01 '16 at 07:11
You dont have to remove your created_at column. Anyway if that solves your problem. — John Roca, Mar 01 '16 at 07:12
You have to add ->withTimestamps() in the relationship: public function Packages() { return $this->belongsToMany('FoodPackage')->withTimestamps(); } https://stackoverflow.com/questions/25726602/timestamps-are-not-updating-while-attaching-data-in-pivot-table — MrMojoRisin, Jan 24 '19 at 17:59

score 1 · Answer 1 · answered May 08 '21 at 02:56

1

You have add method whitTimestamps();

Example:

$this->belongsToMany(Model::class)->withTimestamps();

https://laravel.com/docs/8.x/eloquent-relationships#has-many-through

answered May 08 '21 at 02:56

Gustavo Santaella

11
1

Laravel null value in column "created_at" violates not-null constraint for pivot table

1 Answers1