Laravel 4 Illuminate \ Database \ Eloquent \ MassAssignmentException error

Question

Hei, I already searched many answers out there but could not solve this problem.

Here is the code for my migration

<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateActiveTable extends Migration {

    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('activations', function($table)
        {
            $table->bigInteger('id')->primary();
            $table->tinyInteger('token');
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::drop('activations');
    }
}

For model (models/Activation.php)

<?php

class Activation extends Eloquent {

    /**
     * The database table used by the model.
     *
     * @var string
     */
    protected $table = 'activations';
    protected $guarded = array();
}

And i am calling Activation table like this.

Activation::create(['id' => 2, 'token' => 1231]);

Seriously i have no idea what's wrong here. And i am newbie at laravel 4. Hope somebody with teach me whats happening and how to solve it.

Possible duplicate of MassAssignmentException in Laravel

Organic Advocate
– Organic Advocate

2015-12-02 21:34:36 +00:00
Commented Dec 2, 2015 at 21:34 — Organic Advocate
– Organic Advocate, Commented Dec 2, 2015 at 21:34

Marwelln · Accepted Answer · 2014-12-04 11:53:50Z

22

You need to use the $fillable property in your Activation class when you use Mass Assignment.

class Activation extends Eloquent {

    /**
     * The database table used by the model.
     *
     * @var string
     */
    protected $table = 'activations';

    protected $fillable = ['id', 'token'];
}

edited Dec 4, 2014 at 11:53

answered Mar 30, 2014 at 17:15

Marwelln

29.5k21 gold badges97 silver badges120 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

user2094178 Over a year ago

Try removing $guarded line. Do you really want to manually assign id?

user3478596 Over a year ago

is there any reason to make a auto incremented id? while all i need is to enter a id of my own, I tried

user2094178 Over a year ago

This is common in linking tables. Other than that it avoids to enforce data integrity in the application side. In your case Activation should have an auto-incremented id and something like member_id which you can relate to a Client model with Eloquent.

user2094178 Over a year ago

I meant Member model.

Collectives™ on Stack Overflow

Laravel 4 Illuminate \ Database \ Eloquent \ MassAssignmentException error

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related