Laravel Eloquent saving relational model fails

Question

I have Laravel Eloquent class Collage

class Collage extends Model { /** * Get the User that owns this Collage. */ public function user() { return $this->belongsTo('App\User'); } }

Collage migration schema

Schema::create('collages', function (Blueprint $table) { $table->increments('id'); $table->integer('user_id')->unsigned(); $table->string('name')->nullable(); $table->timestamps(); });

and User

class User extends Authenticatable { /** * Get all Collages that belongs to this User. */ public function collages() { return $this->hasMany('App\Collage'); } }

but when I do this on tinker

$user = App\User::find(1)->first(); $collage = new App\Collage; $collage->name = 'Collage'; $collage->user = $user; //and save $collage->save();

throws me error QueryException

General error: 1 table collages has no column named user

no i just wanted to ad user id (who owns this collage) to collage. — Wimal Weerawansa
– Wimal Weerawansa, Commented Aug 17, 2016 at 6:01
I think, from what I see you need to change the relationships(I am assuming your columns): $this->hasMany('App\User', 'user_id', 'id'); and return $this->hasMany('App\Collage','id','user_id'); — ka_lin
– ka_lin, Commented Aug 17, 2016 at 6:15

KmasterYC · Accepted Answer · 2016-08-17 06:39:37Z

1

Change

$collage->user = $user

To

$collage->user_id = $user->id

answered Aug 17, 2016 at 6:39

KmasterYC

2,35413 silver badges19 bronze badges

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

Comments

Pete Houston · Accepted Answer · 2016-08-17 06:10:34Z

Update your schema to make the relationship,

Schema::create('collages', function (Blueprint $table) { $table->increments('id'); $table->integer('user_id')->unsigned(); $table->foreign('user_id')->references('id')->on('users'); $table->string('name')->nullable(); $table->timestamps(); });

That way Laravel Eloquent will automatically make references to the relationship.

Yes i have added this line but still the same, Im using sqlite, may be sqlite cause this?

Collectives™ on Stack Overflow

Laravel Eloquent saving relational model fails

2 Answers 2

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Related