Laravel 4 Migration has syntax error when adding Foreign Key

Question

I'm trying to create a pivot table to hold some relationship data for some basic ACL functionality.

The migration class:

Schema::create('group_user', function($table)
{
    $table->increments('id');
    $table->unsignedInteger('group_id');
    $table->unsignedInteger('user_id');
    $table->timestamps();
    $table->softDeletes();
});

Schema::table('group_user', function($table)
{
    $table->foreign('group_id')
        ->reference('id')->on('groups');
    $table->foreign('user_id')
        ->reference('id')->on('users');
});

After running the migration command, I get the following error:

  [Illuminate\Database\QueryException]
  SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at li
  ne 1 (SQL: alter table `group_user` add constraint group_user_group_id_foreign foreign key (`group_id`) references `groups` ())

As you can see, the SQL syntax to add the foreign key constraint is missing the 'id' column name for the referenced table. Is this a bug in Laravel or is there something wrong with my schema code?

H. Norman · Accepted Answer · 2014-03-07 01:50:48Z

2

So I finally figured it out and now I feel really stupid. It was a typo error on my part.

It should have been references() instead of reference().

answered Mar 7, 2014 at 1:50

H. Norman

315 bronze badges

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

Comments

Gordon Oppenheimer · Accepted Answer · 2014-03-05 14:34:35Z

0

It is a syntax error with an alter table on the "group_user" table which is not referenced in your code.

answered Mar 5, 2014 at 14:34

Gordon Oppenheimer

1437 bronze badges

1 Comment

H. Norman Over a year ago

Sorry looks like I pasted the wrong migration code. I've edited my question

Collectives™ on Stack Overflow

Laravel 4 Migration has syntax error when adding Foreign Key

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related