/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

-1 vote176 views3 answers
SQL MM/dd/yyyy format
SQL
0 vote146 views1 answer
Show table details postgresql
SQL
1 vote148 views1 answer
Error code 1292 mysql workbench
SQL
0 vote156 views2 answers
Compound operator in sql
SQL
1 vote131 views2 answers
Mysql allow remote connections
SQL
4 votes145 views1 answer
Oracle user tables
SQL
0 vote149 views1 answer
Like date sql server not working
SQL
0 vote133 views1 answer
Sql new line output
SQL
2 votes133 views1 answer
Get first 3 letters name in sql
SQL
0 vote136 views1 answer
Postgres select except
SQL