/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 vote116 views1 answer
Jooq finding lastest value in table
SQL
42 votes225 views6 answers
Rename table sql server
SQL
0 vote145 views1 answer
Group by join columns per table
SQL
7 votes148 views1 answer
Query delete duplicates
SQL
1 vote103 views1 answer
Into sql
SQL
6 votes144 views2 answers
Postgresql restore from dump
SQL
0 vote169 views1 answer
Sql date with year
SQL
0 vote134 views1 answer
C# add a textbox in mysql select
SQL
2 votes132 views4 answers
Duplicate record mysql
SQL
1 vote144 views1 answer
Postgres regex remove special characters
SQL