Marco Marco - 1 month ago 34
MySQL Question

Laravel - General error: 1366 Incorrect integer value

When I try to save or update a model, I get an error that is below, for the field spid_id. I am not sure what is wrong.


General error: 1366 Incorrect integer value: '' for column 'spid_id'
at row 1 (SQL: update
magazines
set
spid_id
= ,
updated_at
=
2016-10-21 08:28:46,
summary
= where
id
= 8)


This is how my table looks:

Schema::create('magazines', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->string('visual_id')->nullable();
$table->integer('spid_id')->nullable();
$table->timestamps();
});


I tried to change my spid_id to not be nullable in the DB, by making a migration, because I thought that might be a reason:

Schema::table('magazines', function (Blueprint $table) {
$table->integer('spid_id')->change();
});


But the field still remained nullable.

This is my store function for create form:

$magazine = Magazine::create([
'name' => $request->input('name'),
'visio_link_prefix' => $request->input('visio_link_prefix'),
'spid_id' => $request->input('spid_id'),
'summary' => $request->input('summary'),
]);

Answer

You need to check spid_id exist in your request before you save it. For example in your case it will looks like:

'spid_id' => $request->has('spid_id') ? $request->input('spid_id') : NULL,
Comments