Level 1
not an expert... stab in the dark... DB::insert likes associative arrays. It's an unattractive anomaly. Have tried ->insert(array())
???
1 like
Aug 29, 2019
18
Level 6
Migration only adds first item of array
I am using this migration on Laravel 5.8.31 to add a table roles with three roles but somehow only the first one is added and the second two are not.
public function up()
{
Schema::create('roles', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
});
DB::table('roles')->insert(
[
['name' => 'administrator'],
['name' => 'editor'],
['name' => 'super-administrator'],
]
);
Any ideas why this could be the case?
Level 6
We're just using short array syntax here as possible since PHP 5.4 https://www.php.net/manual/en/migration54.new-features.php . So do not think that is the issue here. But will look into it.
Level 23
That insert looks just fine. Do you get any error in CLI when you run the php artisan migrate command?
1 like
Level 122
Your exact code works for me. Three rows created.
1 like
Level 6
Level 13
Try something like below,
DB::table('roles')->insert(
[
'name' => ['administrator','editor','super-administrator'],
]
);
Level 122
@munazzil sorry, that won't work.
Level 6
That did not work and caused
Illuminate\Database\QueryException : SQLSTATE[42S22]: Column not found: 1054 Unknown column '0' in 'field list' (SQL: insert into `roles` (`0`, `1`, `2`) values (administrator, editor, super-administrator))
at /Users/me/code/site.com/valet/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664
Level 6
This is weird. I just ran the migrations for the gazillionth time. And now all roles are added to my local Homebrew MariaDB database. Just weird..
Level 13
You have to add like this in your role model and then used whatever you have posted over here,because you haven't created any relationship with that,
public function roles()
{
return $this->belongsToMany('App\Role');
}
Level 6
We do have the role model Role.php:
<?php
namespace App\Models\Auth;
use Illuminate\Database\Eloquent\Model;
class Role extends Model
{
public $timestamps = false;
public function users()
{
return $this->hasMany(User::class);
}
}
as well as a user model under our Models/Auth directory. In User.php we connect things between roles and the users as well using:
/**
* @return \Illuminate\Database\Eloquent\Relations\BelongsTo
*/
public function role()
{
return $this->belongsTo(Role::class);
}
besides other things like user groups.
Anyways, the issue is that somehow migrations do not always run properly - not all roles added to roles table - though there are no errors. Even ran php migrate -vvv but nothing useful showed up when only one role was added.
Level 122
ignore him
3 likes
Level 13
Change hasmany() to belongsToMany()
public function users()
{
return $this->belongsToMany(User::class);
}
Level 122
see what I mean?
Level 6
Yeah, @munazzil is not really helping here. He needs to read properly before he replies. Any feedback is welcome, as long as it is on point..
Level 23
stop giving rubbish advice please... his original problem has NOTHING to do with relationship - he isnt USING that to insert data.
I suggest you go back and learn laravel and its basics learn what the people are saying check your answer with someone in your team before u post an answer..
otherwise you annoy people and people will just ignore you!
1 like
Level 13
Level 2
php artisan cache:clear and php artisan config:clear did the trick for me
Please or to participate in this conversation.