/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 vote129 views1 answer
Primary key multiple
SQL
0 vote140 views1 answer
Sqlite update where exists
SQL
0 vote124 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
0 vote149 views1 answer
Mysql extract day from date leading zero
SQL
0 vote125 views1 answer
Postgresql copy backup table
SQL
0 vote126 views1 answer
Update view sql
SQL
0 vote129 views1 answer
Get the Db column names from a SqlDataReader
SQL
0 vote110 views1 answer
Truncate table sql server foreign key
SQL
0 vote126 views1 answer
How to put is null in where in clause
SQL
4 votes133 views1 answer
SQL find text in SP
SQL