/SQL/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"

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"

$table->integer('thnajrn_id', 10)->unsigned();
to
$table->integer('thnajrn_id')->unsigned();
or try
table->integer('thnajrn_id')->length(10)->unsigned();

Syntax error or access violation: 1075 Incorrect table def inition; there can be only one auto column and it must be defined as a key

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

Source: stackoverflow.com

Similar codes

0 vote269 views1 answer
Sql select rows with different values in one column
SQL
0 vote289 views1 answer
Providername system.data. mysql
SQL
0 vote257 views1 answer
Remove default constraint sql server
SQL
0 vote289 views1 answer
How to update date value in sql
SQL
0 vote298 views1 answer
Oracle winter time change
SQL
0 vote288 views1 answer
Pl/pgsql declare variable
SQL
8 votes292 views1 answer
Racle create auto increment column
SQL
0 vote307 views1 answer
Get last inserted primary key
SQL
0 vote249 views1 answer
Mysql select row with min date
SQL
0 vote270 views3 answers
Create and attach user to a postgresql database
SQL