I'm on Laravel 5.4 and using BackPackForLaravel as my admin interface.
I have a GenreTableMigration
like bellow :
Schema::create('genres', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->string('slug')->default('');
$table->string('image');
$table->enum('status', ['PUBLISHED', 'DRAFT'])->default('PUBLISHED');
$table->boolean('featured')->default(0);
$table->timestamps();
$table->softDeletes();
});
Notice the image
column is non-nullable and has no default value. In my model Genre
theres this:
protected $fillable = ['slug', 'name', 'image', 'status', 'featured'];
I also have mutator for image
column in my model:
/**
* Store Image
*/
public function setImageAttribute($value)
{
$attribute_name = "image";
$disk = "public";
$destination_path = "Albums";
// if the image was erased
if ($value == null) {
// delete the image from disk
\Storage::disk($disk)->delete($this->image);
// set null in the database column
$this->attributes[$attribute_name] = null;
}
// if a base64 was sent, store it in the db
if (starts_with($value, 'data:image')) {
// 0. Make the image
$image = \Image::make($value);
// 1. Generate a filename.
$filename = md5($value . time()) . '.jpg';
// 2. Store the image on disk.
\Storage::disk($disk)->put($destination_path . '/' . $filename, $image->stream());
// 3. Save the path to the database
$this->attributes[$attribute_name] = $destination_path . '/' . $filename;
}
}
And my GenresTableSeeder
:
$path = base_path('seeder-resources/GenresPhotos');
DB::table('genres')->delete();
$genres = [
[
'name' => 'Pop',
'image' => "$path/Pop.jpeg",
'status' => 'PUBLISHED',
'featured' => mt_rand(0, 1),
'created_at' => Carbon::now()->format('Y-m-d H:i:s'),
'updated_at' => Carbon::now()->format('Y-m-d H:i:s'),
],
];
foreach ($genres as $genre) {
$this->command->info(print_r($genre));
Genre::create($genre);
}
When i use GenreCrudController
and use the Add Genre
button everything works fine and the row is created but when i try to seed the table i get the following error on my console.
[Illuminate\Database\QueryException]
SQLSTATE[HY000]: General error: 1364 Field 'image' doesn't have a default v
alue (SQL: insert into `genres` (`name`, `status`, `featured`, `created_at`
, `updated_at`, `slug`) values (Pop, PUBLISHED, 0, 2017-03-10 08:43:15, 201
7-03-10 08:43:15, pop))
Even if i set the image
value (which is a string column) in $genres
array to Anything
. I also tried to seed eloquently like below:
$genre = new Genre();
$genre->name = 'Pop';
$genre->image = "anything";
$genre->status = 'PUBLISHED';
$genre->featured = 1;
$genre->save();
Still the same error in console. Does anyone have any idea?
via Jhivan