Laravel Sync error

php laravel eloquent relationships
Udders picture Udders · Oct 23, 2014 · Viewed 15.6k times · Source

I am running the following code, 

if( $organisation->save() ) {

        if(isset($members)) {
            $organisation->users()->sync($members);
        }

        if(isset($teams)) {
            $organisation->teams()->sync($teams);
        }

        if(isset($teams)) {
            $organisation->clients()->sync($clients);
        }

        if(isset($projects)) {
            $organisation->projects()->sync($projects);
        }

        $organisation->load('users');
        $organisation->load('teams');
        $organisation->load('clients');
        $organisation->load('projects');

        return Response::make($organisation, 200);

    }

I am am getting the following error when I try and sync $projects,

the array looks like this,

[0] => 6 so a very very simple array. My relationships in the models look like this,

Organisation

public function projects()
{
    return $this->hasMany('Project');
}

Projects

public function organisations()
{
    return $this->belongsToMany('Organisation', 'organisation_id');
}

As you can see I an organisation can have many projects. I cannot see a reason why I would be getting the following error,

Call to undefined method Illuminate\Database\Query\Builder::sync()

Answer

Marcin Nabiałek picture Marcin Nabiałek · Oct 23, 2014

As it's many-to many relationship in both functions you need to use belongsToMany, so you should use:

public function projects()
{
    return $this->belongsToMany('Project');
}

instead of:

public function projects()
{
    return $this->hasMany('Project');
}

sync() works only for many to many relationship

Related questions

How to Create Multiple Where Clause Query Using Laravel Eloquent?

I'm using the Laravel Eloquent query builder and I have a query where I want a WHERE clause on multiple conditions. It works, but it's not elegant. Example: $results = User::where('this', '=', 1) ->where('that', '=', 1) …

Read More
Get the Last Inserted Id Using Laravel Eloquent

I'm currently using the below code to insert data in a table: <?php public function saveDetailsCompany() { $post = Input::All(); $data = new Company; $data->nombre = $post['name']; $data->direccion = $post['address']; $data->telefono = $post['phone']; $data->…

Read More
Laravel Checking If a Record Exists

I am new to Laravel. Please excuse the newbie question but how do I find if a record exists? $user = User::where('email', '=', Input::get('email')); What can I do here to see if $user has a record?

Read More