/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

18 votes291 views3 answers
Find column name in database
SQL
1 vote289 views1 answer
Delete specific row in sql
SQL
0 vote276 views1 answer
Sql server inner join convert collation
SQL
22 votes301 views3 answers
Remove all records from table mysql
SQL
1 vote303 views1 answer
SQL query to get all table records count from a database
SQL
0 vote312 views1 answer
How to check database engine in mysql
SQL
0 vote270 views2 answers
Mysql get routine parameter list
SQL
2 votes284 views1 answer
Oracle current date without time
SQL
6 votes356 views2 answers
Oracle compile trigger
SQL
1 vote242 views1 answer
Restart identity postgresql
SQL