create new article throwing up category_id doesn't have a default value about eloquent-viewable

[cyrildewit]

This threat is quite interesting: https://laravel.io/forum/08-08-2015-eloquent-create-says-column-has-no-default-value

Try to change this: $article = \App\Article::create($input);
To:

$article = new \App\Article();
$article->category_id = $input['category_id'];
$article->author = ........
..... etc.

It think that it has something to do with Laravel Eloquent.

[cyrildewit]

How does your migration file looks like?

[venkatavinash]

    public function up()
    {
        Schema::create('articles', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('category_id')->index();
            $table->string('author')->default('admin');
            $table->string('title');
            $table->text('excerpt');
            $table->text('body');
            $table->string('slug');
            $table->string('feature_image')->default('test.jpg');
            $table->timestamps();
        });
    }

[cyrildewit]

I found some articles that are maybe related to your problem.

https://laravel.io/forum/08-08-2015-eloquent-create-says-column-has-no-default-value
https://stackoverflow.com/questions/43186521/laravel-5-4-field-doesnt-have-a-default-value
https://stackoverflow.com/questions/39301589/laravel-5-3-creating-models-returns-field-doesnt-have-a-default-value

I'm currently on vacation, using a public computer with a weird keyboard. I will be back in a week. I'm sorry. I personally don't think it has something to do with this package, but I will of course take a look at it. I suggest you to keep searching for an answer. See you then.

[venkatavinash]

Every thing is working fine normally. But when I add "use HasPageVisitsCounter;" in the model it is throwing error and only showing category_id error even when the data is coming to the controller.I have used dd() to dump if the data is coming to the controller just before create($input) and it dumped all. The moment it is run with "use HasPageVisitsCounter;" it appears. I have checked your code but unable to narrow down the problem.

Thank you for the links.Appreciate you taking time to reply. Will try to sort it out ASAP and update.

[cyrildewit]

What happens if you turn strict mode off in your database config file?

https://laracasts.com/discuss/channels/laravel/laravel-530-throwing-error-field-test-1-doesnt-have-a-default-value

[venkatavinash]

I have tried it already.That way It just creates id, timestamps and a column with default value. rest are all empty.

[venkatavinash]

Changed the code as you said and it worked like charm!
Thank you for your time and effort.

[cyrildewit]

Maybe a little bit late but a while ago @LuisNeighbur created a pull request that probably fixed this issue. I forgot to pass the fillable attributes in the constructor function.