/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 vote189 views2 answers
Postgresql user permissions to database
SQL
0 vote207 views1 answer
Sparql list all graphs
SQL
0 vote188 views1 answer
Mysql set column equal to another automatic
SQL
0 vote296 views1 answer
Mysql update table from select on another table
SQL
0 vote198 views2 answers
Sql server select where date
SQL
10 votes222 views6 answers
Sql between
SQL
0 vote201 views3 answers
How to run sql query
SQL
0 vote235 views1 answer
Ceil upto 2 decimal place mysql
SQL
2 votes177 views2 answers
How to create an empty table from an existing table
SQL
3 votes220 views1 answer
Laravel paginate raw sql
SQL