laravel SQLSTATE[42000]：语法错误或访问冲突：1075 表定义不正确；只能有一个自动列，并且必须将其定义为键

SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key

提问by Muhammad Adnan Syarief

public function up()
{
    Schema::create('jadwal_praks', function (Blueprint $table) {
        $table->increments('id');
        $table->integer('thnajrn_id', 10)->unsigned();
        $table->foreign('thnajrn_id')->references('id')->on('tahun_ajarans');
        $table->integer('prak_id', 10)->unsigned();
        $table->foreign('prak_id')->references('Prak_kode')->on('mata_praks');
        $table->integer('hari_id', 10)->unsigned();
        $table->foreign('hari_id')->references('id')->on('haris');
        $table->integer('jam_id', 10)->unsigned();
        $table->foreign('jam_id')->references('id')->on('jams');
        $table->integer('ruang_id', 10)->unsigned();
        $table->foreign('ruang_id')->references('id')->on('ruangs');
        $table->integer('kap_id', 10)->unsigned();
        $table->foreign('kap_id')->references('id')->on('kapasitas');

        $table->timestamps();
        $table->rememberToken();
    });
}

After run php artisan migrate

运行后 php artisan migrate

[Illuminate\Database\QueryException] SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto co lumn and it must be defined as a key (SQL: create table jadwal_praks(idint unsigned not null auto_increment
primary key, thnajrn_idint unsigned not null auto_increment primary key, prak_idint unsigned not null auto _increment primary key, hari_idint unsigned not null auto_increment primary key, jam_idint unsigned not nul l auto_increment primary key, ruang_idint unsigned not null auto_increment primary key, kap_idint unsigned
not null auto_increment primary key, created_attimestamp null, updated_attimestamp null, remember_tokenv archar(100) null) default character set utf8 collate utf8_unicode_ci)

[Illuminate\Database\QueryException] SQLSTATE[42000]：语法错误或访问冲突：1075 表定义不正确；只能有一个自动列并且它必须定义为一个键（SQL: create table jadwal_praks( idint unsigned not null auto_increment
primary key, thnajrn_idint unsigned not null auto_increment primary key, prak_idint unsigned not null auto _increment primary key, hari_idint unsigned not null auto_increment 主键，jam_idint unsigned not null l auto_increment 主键，ruang_idint unsigned not null auto_increment 主键，kap_idint unsigned
not null auto_increment 主键，created_attimestamp null， updated_attimestamp null，remember_tokenv archar(100) null) 默认字符集 utf8 collat​​e utf8_unicode_ci)

And this

和这个

[PDOException] SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key

[PDOException] SQLSTATE[42000]：语法错误或访问冲突：1075 不正确的表定义；只能有一个自动列，并且必须将其定义为键

回答by Oluwatobi Samuel Omisakin

With my observation, I would say you should remove defaultvalue you added to the your foreign fields from (for example):

根据我的观察，我会说您应该default从（例如）中删除您添加到外部字段的值：

$table->integer('thnajrn_id', 10)->unsigned(); 

To:

到：

$table->integer('thnajrn_id')->unsigned();

PS: With a similar experience, I know presently this works with one of the projects I work with in Laravel 5.2.*

PS：有类似的经验，我知道目前这适用于我在 Laravel 5.2 中使用的项目之一。*

Hope this helps :)

希望这可以帮助 ：）

回答by benson Njung'e

When you use $table->integer('thnajrn_id', 10)->unsigned(); this means your setting the second parameter as true which represents AutoIncrement

当你使用$table->integer('thnajrn_id', 10)->unsigned(); 这意味着您将第二个参数设置为 true 代表 AutoIncrement

try

尝试

table->integer('thnajrn_id')->length(10)->unsigned();

More info

更多信息